sql

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

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 = orm.ModQuery[*dialect.SelectQuery, orgByOauthId, OrgByOauthIdRow, []OrgByOauthIdRow, orgByOauthIdTransformer]

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

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

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 = orm.ModQuery[*dialect.SelectQuery, trapDataByLocationIDRecent, TrapDataByLocationIDRecentRow, []TrapDataByLocationIDRecentRow, trapDataByLocationIDRecentTransformer]

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

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

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

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

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

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"`
}