sql

Documentation

Index

• type OauthTokenByUserIdQuery
  • func OauthTokenByUserId(UserID int32) *OauthTokenByUserIdQuery
• type OauthTokenByUserIdRow
• type OrgByOauthIdQuery
  • func OrgByOauthId(ID int32) *OrgByOauthIdQuery
• type OrgByOauthIdRow
• type TrapCountByLocationIDQuery
  • func TrapCountByLocationID(OrganizationID int32, LocID []string) *TrapCountByLocationIDQuery
• type TrapCountByLocationIDRow
• type TrapDataByLocationIDRecentQuery
  • func TrapDataByLocationIDRecent(OrganizationID int32, LocID []string) *TrapDataByLocationIDRecentQuery
• type TrapDataByLocationIDRecentRow
• type TrapLocationBySourceIDQuery
  • func TrapLocationBySourceID(OrganizationID int32, Globalid string) *TrapLocationBySourceIDQuery
• type TrapLocationBySourceIDRow
• type UpdateOauthTokenOrgQuery
  • func UpdateOauthTokenOrg(ArcgisID string, ArcgisLicenseTypeID string, RefreshToken string) *UpdateOauthTokenOrgQuery
• type UserByUsernameQuery
  • func UserByUsername(Username string) *UserByUsernameQuery
• type UserByUsernameRow

Types

type OauthTokenByUserIdQuery

type OauthTokenByUserIdQuery = orm.ModQuery[*dialect.SelectQuery, oauthTokenByUserId, OauthTokenByUserIdRow, []OauthTokenByUserIdRow, oauthTokenByUserIdTransformer]

func OauthTokenByUserId

func OauthTokenByUserId(UserID int32) *OauthTokenByUserIdQuery

type OauthTokenByUserIdRow

type OauthTokenByUserIdRow = struct {
	ID                  int32               `db:"id"`
	AccessToken         string              `db:"access_token"`
	AccessTokenExpires  time.Time           `db:"access_token_expires"`
	RefreshToken        string              `db:"refresh_token"`
	Username            string              `db:"username"`
	UserID              int32               `db:"user_id"`
	ArcgisID            null.Val[string]    `db:"arcgis_id"`
	ArcgisLicenseTypeID null.Val[string]    `db:"arcgis_license_type_id"`
	RefreshTokenExpires time.Time           `db:"refresh_token_expires"`
	InvalidatedAt       null.Val[time.Time] `db:"invalidated_at"`
}

type OrgByOauthIdQuery

type OrgByOauthIdQuery = orm.ModQuery[*dialect.SelectQuery, orgByOauthId, OrgByOauthIdRow, []OrgByOauthIdRow, orgByOauthIdTransformer]

func OrgByOauthId

func OrgByOauthId(ID int32) *OrgByOauthIdQuery

type OrgByOauthIdRow

type OrgByOauthIdRow = struct {
	OrganizationID int32            `db:"organization_id"`
	ArcgisID       null.Val[string] `db:"arcgis_id"`
	FieldseekerURL null.Val[string] `db:"fieldseeker_url"`
}

type TrapCountByLocationIDQuery

type TrapCountByLocationIDQuery = orm.ModQuery[*dialect.SelectQuery, trapCountByLocationID, TrapCountByLocationIDRow, []TrapCountByLocationIDRow, trapCountByLocationIDTransformer]

func TrapCountByLocationID

func TrapCountByLocationID(OrganizationID int32, LocID []string) *TrapCountByLocationIDQuery

type TrapCountByLocationIDRow

type TrapCountByLocationIDRow = struct {
	TrapdataGlobalid string          `db:"trapdata_globalid"`
	TrapdataEnddate  null.Val[int64] `db:"trapdata_enddate"`
	TotalFemales     decimal.Decimal `db:"total_females"`
	TotalMales       int64           `db:"total_males"`
	Total            decimal.Decimal `db:"total"`
}

type TrapDataByLocationIDRecentQuery

type TrapDataByLocationIDRecentQuery = orm.ModQuery[*dialect.SelectQuery, trapDataByLocationIDRecent, TrapDataByLocationIDRecentRow, []TrapDataByLocationIDRecentRow, trapDataByLocationIDRecentTransformer]

func TrapDataByLocationIDRecent

func TrapDataByLocationIDRecent(OrganizationID int32, LocID []string) *TrapDataByLocationIDRecentQuery

type TrapDataByLocationIDRecentRow

type TrapDataByLocationIDRecentRow = struct {
	Enddatetime int64  `db:"enddatetime"`
	Globalid    string `db:"globalid"`
	LocID       string `db:"loc_id"`
}

type TrapLocationBySourceIDQuery

type TrapLocationBySourceIDQuery = orm.ModQuery[*dialect.SelectQuery, trapLocationBySourceID, TrapLocationBySourceIDRow, []TrapLocationBySourceIDRow, trapLocationBySourceIDTransformer]

func TrapLocationBySourceID

func TrapLocationBySourceID(OrganizationID int32, Globalid string) *TrapLocationBySourceIDQuery

type TrapLocationBySourceIDRow

type TrapLocationBySourceIDRow = struct {
	TrapLocationGlobalid string `db:"trap_location_globalid"`
	Distance             string `db:"distance"`
}

type UpdateOauthTokenOrgQuery

type UpdateOauthTokenOrgQuery = orm.ModExecQuery[*dialect.UpdateQuery, updateOauthTokenOrg]

func UpdateOauthTokenOrg

func UpdateOauthTokenOrg(ArcgisID string, ArcgisLicenseTypeID string, RefreshToken string) *UpdateOauthTokenOrgQuery

type UserByUsernameQuery

type UserByUsernameQuery = orm.ModQuery[*dialect.SelectQuery, userByUsername, UserByUsernameRow, []UserByUsernameRow, userByUsernameTransformer]

func UserByUsername

func UserByUsername(Username string) *UserByUsernameQuery

type UserByUsernameRow

type UserByUsernameRow = struct {
	ID                        int32                             `db:"id"`
	ArcgisAccessToken         null.Val[string]                  `db:"arcgis_access_token"`
	ArcgisLicense             null.Val[enums.Arcgislicensetype] `db:"arcgis_license"`
	ArcgisRefreshToken        null.Val[string]                  `db:"arcgis_refresh_token"`
	ArcgisRefreshTokenExpires null.Val[time.Time]               `db:"arcgis_refresh_token_expires"`
	ArcgisRole                null.Val[string]                  `db:"arcgis_role"`
	DisplayName               string                            `db:"display_name"`
	Email                     null.Val[string]                  `db:"email"`
	OrganizationID            null.Val[int32]                   `db:"organization_id"`
	Username                  string                            `db:"username"`
	PasswordHashType          enums.Hashtype                    `db:"password_hash_type"`
	PasswordHash              string                            `db:"password_hash"`
}