Files
Zane Walker 7e940c83a7
Some checks failed
Build & Test / build-test (push) Has been cancelled
Build & Test / swagger-codegen-cli (push) Has been cancelled
CodeQL / Analyze (go) (push) Has been cancelled
(Feat): Initial Commit
2026-07-03 19:41:31 +05:30

1987 lines
54 KiB
Go

// Code generated by SQLBoiler 4.19.5 (https://github.com/aarondl/sqlboiler). DO NOT EDIT.
// This file is meant to be re-generated in place and/or deleted at any time.
package models
import (
"context"
"database/sql"
"fmt"
"reflect"
"strconv"
"strings"
"sync"
"time"
"github.com/aarondl/null/v8"
"github.com/aarondl/sqlboiler/v4/boil"
"github.com/aarondl/sqlboiler/v4/queries"
"github.com/aarondl/sqlboiler/v4/queries/qm"
"github.com/aarondl/sqlboiler/v4/queries/qmhelper"
"github.com/aarondl/sqlboiler/v4/types"
"github.com/aarondl/strmangle"
"github.com/friendsofgo/errors"
)
// User is an object representing the database table.
type User struct {
ID string `boil:"id" json:"id" toml:"id" yaml:"id"`
Username null.String `boil:"username" json:"username,omitempty" toml:"username" yaml:"username,omitempty"`
Password null.String `boil:"password" json:"password,omitempty" toml:"password" yaml:"password,omitempty"`
IsActive bool `boil:"is_active" json:"is_active" toml:"is_active" yaml:"is_active"`
Scopes types.StringArray `boil:"scopes" json:"scopes" toml:"scopes" yaml:"scopes"`
LastAuthenticatedAt null.Time `boil:"last_authenticated_at" json:"last_authenticated_at,omitempty" toml:"last_authenticated_at" yaml:"last_authenticated_at,omitempty"`
CreatedAt time.Time `boil:"created_at" json:"created_at" toml:"created_at" yaml:"created_at"`
UpdatedAt time.Time `boil:"updated_at" json:"updated_at" toml:"updated_at" yaml:"updated_at"`
RequiresConfirmation bool `boil:"requires_confirmation" json:"requires_confirmation" toml:"requires_confirmation" yaml:"requires_confirmation"`
R *userR `boil:"-" json:"-" toml:"-" yaml:"-"`
L userL `boil:"-" json:"-" toml:"-" yaml:"-"`
}
var UserColumns = struct {
ID string
Username string
Password string
IsActive string
Scopes string
LastAuthenticatedAt string
CreatedAt string
UpdatedAt string
RequiresConfirmation string
}{
ID: "id",
Username: "username",
Password: "password",
IsActive: "is_active",
Scopes: "scopes",
LastAuthenticatedAt: "last_authenticated_at",
CreatedAt: "created_at",
UpdatedAt: "updated_at",
RequiresConfirmation: "requires_confirmation",
}
var UserTableColumns = struct {
ID string
Username string
Password string
IsActive string
Scopes string
LastAuthenticatedAt string
CreatedAt string
UpdatedAt string
RequiresConfirmation string
}{
ID: "users.id",
Username: "users.username",
Password: "users.password",
IsActive: "users.is_active",
Scopes: "users.scopes",
LastAuthenticatedAt: "users.last_authenticated_at",
CreatedAt: "users.created_at",
UpdatedAt: "users.updated_at",
RequiresConfirmation: "users.requires_confirmation",
}
// Generated where
type whereHelpernull_String struct{ field string }
func (w whereHelpernull_String) EQ(x null.String) qm.QueryMod {
return qmhelper.WhereNullEQ(w.field, false, x)
}
func (w whereHelpernull_String) NEQ(x null.String) qm.QueryMod {
return qmhelper.WhereNullEQ(w.field, true, x)
}
func (w whereHelpernull_String) LT(x null.String) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.LT, x)
}
func (w whereHelpernull_String) LTE(x null.String) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.LTE, x)
}
func (w whereHelpernull_String) GT(x null.String) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.GT, x)
}
func (w whereHelpernull_String) GTE(x null.String) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.GTE, x)
}
func (w whereHelpernull_String) LIKE(x null.String) qm.QueryMod {
return qm.Where(w.field+" LIKE ?", x)
}
func (w whereHelpernull_String) NLIKE(x null.String) qm.QueryMod {
return qm.Where(w.field+" NOT LIKE ?", x)
}
func (w whereHelpernull_String) ILIKE(x null.String) qm.QueryMod {
return qm.Where(w.field+" ILIKE ?", x)
}
func (w whereHelpernull_String) NILIKE(x null.String) qm.QueryMod {
return qm.Where(w.field+" NOT ILIKE ?", x)
}
func (w whereHelpernull_String) SIMILAR(x null.String) qm.QueryMod {
return qm.Where(w.field+" SIMILAR TO ?", x)
}
func (w whereHelpernull_String) NSIMILAR(x null.String) qm.QueryMod {
return qm.Where(w.field+" NOT SIMILAR TO ?", x)
}
func (w whereHelpernull_String) IN(slice []string) qm.QueryMod {
values := make([]interface{}, 0, len(slice))
for _, value := range slice {
values = append(values, value)
}
return qm.WhereIn(fmt.Sprintf("%s IN ?", w.field), values...)
}
func (w whereHelpernull_String) NIN(slice []string) qm.QueryMod {
values := make([]interface{}, 0, len(slice))
for _, value := range slice {
values = append(values, value)
}
return qm.WhereNotIn(fmt.Sprintf("%s NOT IN ?", w.field), values...)
}
func (w whereHelpernull_String) IsNull() qm.QueryMod { return qmhelper.WhereIsNull(w.field) }
func (w whereHelpernull_String) IsNotNull() qm.QueryMod { return qmhelper.WhereIsNotNull(w.field) }
type whereHelperbool struct{ field string }
func (w whereHelperbool) EQ(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.EQ, x) }
func (w whereHelperbool) NEQ(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.NEQ, x) }
func (w whereHelperbool) LT(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.LT, x) }
func (w whereHelperbool) LTE(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.LTE, x) }
func (w whereHelperbool) GT(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.GT, x) }
func (w whereHelperbool) GTE(x bool) qm.QueryMod { return qmhelper.Where(w.field, qmhelper.GTE, x) }
type whereHelpertypes_StringArray struct{ field string }
func (w whereHelpertypes_StringArray) EQ(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.EQ, x)
}
func (w whereHelpertypes_StringArray) NEQ(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.NEQ, x)
}
func (w whereHelpertypes_StringArray) LT(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.LT, x)
}
func (w whereHelpertypes_StringArray) LTE(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.LTE, x)
}
func (w whereHelpertypes_StringArray) GT(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.GT, x)
}
func (w whereHelpertypes_StringArray) GTE(x types.StringArray) qm.QueryMod {
return qmhelper.Where(w.field, qmhelper.GTE, x)
}
var UserWhere = struct {
ID whereHelperstring
Username whereHelpernull_String
Password whereHelpernull_String
IsActive whereHelperbool
Scopes whereHelpertypes_StringArray
LastAuthenticatedAt whereHelpernull_Time
CreatedAt whereHelpertime_Time
UpdatedAt whereHelpertime_Time
RequiresConfirmation whereHelperbool
}{
ID: whereHelperstring{field: "\"users\".\"id\""},
Username: whereHelpernull_String{field: "\"users\".\"username\""},
Password: whereHelpernull_String{field: "\"users\".\"password\""},
IsActive: whereHelperbool{field: "\"users\".\"is_active\""},
Scopes: whereHelpertypes_StringArray{field: "\"users\".\"scopes\""},
LastAuthenticatedAt: whereHelpernull_Time{field: "\"users\".\"last_authenticated_at\""},
CreatedAt: whereHelpertime_Time{field: "\"users\".\"created_at\""},
UpdatedAt: whereHelpertime_Time{field: "\"users\".\"updated_at\""},
RequiresConfirmation: whereHelperbool{field: "\"users\".\"requires_confirmation\""},
}
// UserRels is where relationship names are stored.
var UserRels = struct {
AppUserProfile string
AccessTokens string
ConfirmationTokens string
PasswordResetTokens string
PushTokens string
RefreshTokens string
}{
AppUserProfile: "AppUserProfile",
AccessTokens: "AccessTokens",
ConfirmationTokens: "ConfirmationTokens",
PasswordResetTokens: "PasswordResetTokens",
PushTokens: "PushTokens",
RefreshTokens: "RefreshTokens",
}
// userR is where relationships are stored.
type userR struct {
AppUserProfile *AppUserProfile `boil:"AppUserProfile" json:"AppUserProfile" toml:"AppUserProfile" yaml:"AppUserProfile"`
AccessTokens AccessTokenSlice `boil:"AccessTokens" json:"AccessTokens" toml:"AccessTokens" yaml:"AccessTokens"`
ConfirmationTokens ConfirmationTokenSlice `boil:"ConfirmationTokens" json:"ConfirmationTokens" toml:"ConfirmationTokens" yaml:"ConfirmationTokens"`
PasswordResetTokens PasswordResetTokenSlice `boil:"PasswordResetTokens" json:"PasswordResetTokens" toml:"PasswordResetTokens" yaml:"PasswordResetTokens"`
PushTokens PushTokenSlice `boil:"PushTokens" json:"PushTokens" toml:"PushTokens" yaml:"PushTokens"`
RefreshTokens RefreshTokenSlice `boil:"RefreshTokens" json:"RefreshTokens" toml:"RefreshTokens" yaml:"RefreshTokens"`
}
// NewStruct creates a new relationship struct
func (*userR) NewStruct() *userR {
return &userR{}
}
func (o *User) GetAppUserProfile() *AppUserProfile {
if o == nil {
return nil
}
return o.R.GetAppUserProfile()
}
func (r *userR) GetAppUserProfile() *AppUserProfile {
if r == nil {
return nil
}
return r.AppUserProfile
}
func (o *User) GetAccessTokens() AccessTokenSlice {
if o == nil {
return nil
}
return o.R.GetAccessTokens()
}
func (r *userR) GetAccessTokens() AccessTokenSlice {
if r == nil {
return nil
}
return r.AccessTokens
}
func (o *User) GetConfirmationTokens() ConfirmationTokenSlice {
if o == nil {
return nil
}
return o.R.GetConfirmationTokens()
}
func (r *userR) GetConfirmationTokens() ConfirmationTokenSlice {
if r == nil {
return nil
}
return r.ConfirmationTokens
}
func (o *User) GetPasswordResetTokens() PasswordResetTokenSlice {
if o == nil {
return nil
}
return o.R.GetPasswordResetTokens()
}
func (r *userR) GetPasswordResetTokens() PasswordResetTokenSlice {
if r == nil {
return nil
}
return r.PasswordResetTokens
}
func (o *User) GetPushTokens() PushTokenSlice {
if o == nil {
return nil
}
return o.R.GetPushTokens()
}
func (r *userR) GetPushTokens() PushTokenSlice {
if r == nil {
return nil
}
return r.PushTokens
}
func (o *User) GetRefreshTokens() RefreshTokenSlice {
if o == nil {
return nil
}
return o.R.GetRefreshTokens()
}
func (r *userR) GetRefreshTokens() RefreshTokenSlice {
if r == nil {
return nil
}
return r.RefreshTokens
}
// userL is where Load methods for each relationship are stored.
type userL struct{}
var (
userAllColumns = []string{"id", "username", "password", "is_active", "scopes", "last_authenticated_at", "created_at", "updated_at", "requires_confirmation"}
userColumnsWithoutDefault = []string{"is_active", "scopes", "created_at", "updated_at"}
userColumnsWithDefault = []string{"id", "username", "password", "last_authenticated_at", "requires_confirmation"}
userPrimaryKeyColumns = []string{"id"}
userGeneratedColumns = []string{}
)
type (
// UserSlice is an alias for a slice of pointers to User.
// This should almost always be used instead of []User.
UserSlice []*User
userQuery struct {
*queries.Query
}
)
// Cache for insert, update and upsert
var (
userType = reflect.TypeOf(&User{})
userMapping = queries.MakeStructMapping(userType)
userPrimaryKeyMapping, _ = queries.BindMapping(userType, userMapping, userPrimaryKeyColumns)
userInsertCacheMut sync.RWMutex
userInsertCache = make(map[string]insertCache)
userUpdateCacheMut sync.RWMutex
userUpdateCache = make(map[string]updateCache)
userUpsertCacheMut sync.RWMutex
userUpsertCache = make(map[string]insertCache)
)
var (
// Force time package dependency for automated UpdatedAt/CreatedAt.
_ = time.Second
// Force qmhelper dependency for where clause generation (which doesn't
// always happen)
_ = qmhelper.Where
)
// One returns a single user record from the query.
func (q userQuery) One(ctx context.Context, exec boil.ContextExecutor) (*User, error) {
o := &User{}
queries.SetLimit(q.Query, 1)
err := q.Bind(ctx, exec, o)
if err != nil {
if errors.Is(err, sql.ErrNoRows) {
return nil, sql.ErrNoRows
}
return nil, errors.Wrap(err, "models: failed to execute a one query for users")
}
return o, nil
}
// All returns all User records from the query.
func (q userQuery) All(ctx context.Context, exec boil.ContextExecutor) (UserSlice, error) {
var o []*User
err := q.Bind(ctx, exec, &o)
if err != nil {
return nil, errors.Wrap(err, "models: failed to assign all query results to User slice")
}
return o, nil
}
// Count returns the count of all User records in the query.
func (q userQuery) Count(ctx context.Context, exec boil.ContextExecutor) (int64, error) {
var count int64
queries.SetSelect(q.Query, nil)
queries.SetCount(q.Query)
err := q.Query.QueryRowContext(ctx, exec).Scan(&count)
if err != nil {
return 0, errors.Wrap(err, "models: failed to count users rows")
}
return count, nil
}
// Exists checks if the row exists in the table.
func (q userQuery) Exists(ctx context.Context, exec boil.ContextExecutor) (bool, error) {
var count int64
queries.SetSelect(q.Query, nil)
queries.SetCount(q.Query)
queries.SetLimit(q.Query, 1)
err := q.Query.QueryRowContext(ctx, exec).Scan(&count)
if err != nil {
return false, errors.Wrap(err, "models: failed to check if users exists")
}
return count > 0, nil
}
// AppUserProfile pointed to by the foreign key.
func (o *User) AppUserProfile(mods ...qm.QueryMod) appUserProfileQuery {
queryMods := []qm.QueryMod{
qm.Where("\"user_id\" = ?", o.ID),
}
queryMods = append(queryMods, mods...)
return AppUserProfiles(queryMods...)
}
// AccessTokens retrieves all the access_token's AccessTokens with an executor.
func (o *User) AccessTokens(mods ...qm.QueryMod) accessTokenQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"access_tokens\".\"user_id\"=?", o.ID),
)
return AccessTokens(queryMods...)
}
// ConfirmationTokens retrieves all the confirmation_token's ConfirmationTokens with an executor.
func (o *User) ConfirmationTokens(mods ...qm.QueryMod) confirmationTokenQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"confirmation_tokens\".\"user_id\"=?", o.ID),
)
return ConfirmationTokens(queryMods...)
}
// PasswordResetTokens retrieves all the password_reset_token's PasswordResetTokens with an executor.
func (o *User) PasswordResetTokens(mods ...qm.QueryMod) passwordResetTokenQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"password_reset_tokens\".\"user_id\"=?", o.ID),
)
return PasswordResetTokens(queryMods...)
}
// PushTokens retrieves all the push_token's PushTokens with an executor.
func (o *User) PushTokens(mods ...qm.QueryMod) pushTokenQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"push_tokens\".\"user_id\"=?", o.ID),
)
return PushTokens(queryMods...)
}
// RefreshTokens retrieves all the refresh_token's RefreshTokens with an executor.
func (o *User) RefreshTokens(mods ...qm.QueryMod) refreshTokenQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"refresh_tokens\".\"user_id\"=?", o.ID),
)
return RefreshTokens(queryMods...)
}
// LoadAppUserProfile allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-1 relationship.
func (userL) LoadAppUserProfile(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`app_user_profiles`),
qm.WhereIn(`app_user_profiles.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load AppUserProfile")
}
var resultSlice []*AppUserProfile
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice AppUserProfile")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results of eager load for app_user_profiles")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for app_user_profiles")
}
if len(resultSlice) == 0 {
return nil
}
if singular {
foreign := resultSlice[0]
object.R.AppUserProfile = foreign
if foreign.R == nil {
foreign.R = &appUserProfileR{}
}
foreign.R.User = object
}
for _, local := range slice {
for _, foreign := range resultSlice {
if local.ID == foreign.UserID {
local.R.AppUserProfile = foreign
if foreign.R == nil {
foreign.R = &appUserProfileR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// LoadAccessTokens allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-M or N-M relationship.
func (userL) LoadAccessTokens(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`access_tokens`),
qm.WhereIn(`access_tokens.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load access_tokens")
}
var resultSlice []*AccessToken
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice access_tokens")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results in eager load on access_tokens")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for access_tokens")
}
if singular {
object.R.AccessTokens = resultSlice
for _, foreign := range resultSlice {
if foreign.R == nil {
foreign.R = &accessTokenR{}
}
foreign.R.User = object
}
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.ID == foreign.UserID {
local.R.AccessTokens = append(local.R.AccessTokens, foreign)
if foreign.R == nil {
foreign.R = &accessTokenR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// LoadConfirmationTokens allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-M or N-M relationship.
func (userL) LoadConfirmationTokens(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`confirmation_tokens`),
qm.WhereIn(`confirmation_tokens.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load confirmation_tokens")
}
var resultSlice []*ConfirmationToken
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice confirmation_tokens")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results in eager load on confirmation_tokens")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for confirmation_tokens")
}
if singular {
object.R.ConfirmationTokens = resultSlice
for _, foreign := range resultSlice {
if foreign.R == nil {
foreign.R = &confirmationTokenR{}
}
foreign.R.User = object
}
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.ID == foreign.UserID {
local.R.ConfirmationTokens = append(local.R.ConfirmationTokens, foreign)
if foreign.R == nil {
foreign.R = &confirmationTokenR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// LoadPasswordResetTokens allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-M or N-M relationship.
func (userL) LoadPasswordResetTokens(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`password_reset_tokens`),
qm.WhereIn(`password_reset_tokens.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load password_reset_tokens")
}
var resultSlice []*PasswordResetToken
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice password_reset_tokens")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results in eager load on password_reset_tokens")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for password_reset_tokens")
}
if singular {
object.R.PasswordResetTokens = resultSlice
for _, foreign := range resultSlice {
if foreign.R == nil {
foreign.R = &passwordResetTokenR{}
}
foreign.R.User = object
}
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.ID == foreign.UserID {
local.R.PasswordResetTokens = append(local.R.PasswordResetTokens, foreign)
if foreign.R == nil {
foreign.R = &passwordResetTokenR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// LoadPushTokens allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-M or N-M relationship.
func (userL) LoadPushTokens(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`push_tokens`),
qm.WhereIn(`push_tokens.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load push_tokens")
}
var resultSlice []*PushToken
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice push_tokens")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results in eager load on push_tokens")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for push_tokens")
}
if singular {
object.R.PushTokens = resultSlice
for _, foreign := range resultSlice {
if foreign.R == nil {
foreign.R = &pushTokenR{}
}
foreign.R.User = object
}
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.ID == foreign.UserID {
local.R.PushTokens = append(local.R.PushTokens, foreign)
if foreign.R == nil {
foreign.R = &pushTokenR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// LoadRefreshTokens allows an eager lookup of values, cached into the
// loaded structs of the objects. This is for a 1-M or N-M relationship.
func (userL) LoadRefreshTokens(ctx context.Context, e boil.ContextExecutor, singular bool, maybeUser interface{}, mods queries.Applicator) error {
var slice []*User
var object *User
if singular {
var ok bool
object, ok = maybeUser.(*User)
if !ok {
object = new(User)
ok = queries.SetFromEmbeddedStruct(&object, &maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", object, maybeUser))
}
}
} else {
s, ok := maybeUser.(*[]*User)
if ok {
slice = *s
} else {
ok = queries.SetFromEmbeddedStruct(&slice, maybeUser)
if !ok {
return errors.New(fmt.Sprintf("failed to set %T from embedded struct %T", slice, maybeUser))
}
}
}
args := make(map[interface{}]struct{})
if singular {
if object.R == nil {
object.R = &userR{}
}
args[object.ID] = struct{}{}
} else {
for _, obj := range slice {
if obj.R == nil {
obj.R = &userR{}
}
args[obj.ID] = struct{}{}
}
}
if len(args) == 0 {
return nil
}
argsSlice := make([]interface{}, len(args))
i := 0
for arg := range args {
argsSlice[i] = arg
i++
}
query := NewQuery(
qm.From(`refresh_tokens`),
qm.WhereIn(`refresh_tokens.user_id in ?`, argsSlice...),
)
if mods != nil {
mods.Apply(query)
}
results, err := query.QueryContext(ctx, e)
if err != nil {
return errors.Wrap(err, "failed to eager load refresh_tokens")
}
var resultSlice []*RefreshToken
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice refresh_tokens")
}
if err = results.Close(); err != nil {
return errors.Wrap(err, "failed to close results in eager load on refresh_tokens")
}
if err = results.Err(); err != nil {
return errors.Wrap(err, "error occurred during iteration of eager loaded relations for refresh_tokens")
}
if singular {
object.R.RefreshTokens = resultSlice
for _, foreign := range resultSlice {
if foreign.R == nil {
foreign.R = &refreshTokenR{}
}
foreign.R.User = object
}
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.ID == foreign.UserID {
local.R.RefreshTokens = append(local.R.RefreshTokens, foreign)
if foreign.R == nil {
foreign.R = &refreshTokenR{}
}
foreign.R.User = local
break
}
}
}
return nil
}
// SetAppUserProfile of the user to the related item.
// Sets o.R.AppUserProfile to related.
// Adds o to related.R.User.
func (o *User) SetAppUserProfile(ctx context.Context, exec boil.ContextExecutor, insert bool, related *AppUserProfile) error {
var err error
if insert {
related.UserID = o.ID
if err = related.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"app_user_profiles\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, appUserProfilePrimaryKeyColumns),
)
values := []interface{}{o.ID, related.UserID}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
related.UserID = o.ID
}
if o.R == nil {
o.R = &userR{
AppUserProfile: related,
}
} else {
o.R.AppUserProfile = related
}
if related.R == nil {
related.R = &appUserProfileR{
User: o,
}
} else {
related.R.User = o
}
return nil
}
// AddAccessTokens adds the given related objects to the existing relationships
// of the user, optionally inserting them as new records.
// Appends related to o.R.AccessTokens.
// Sets related.R.User appropriately.
func (o *User) AddAccessTokens(ctx context.Context, exec boil.ContextExecutor, insert bool, related ...*AccessToken) error {
var err error
for _, rel := range related {
if insert {
rel.UserID = o.ID
if err = rel.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"access_tokens\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, accessTokenPrimaryKeyColumns),
)
values := []interface{}{o.ID, rel.Token}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.UserID = o.ID
}
}
if o.R == nil {
o.R = &userR{
AccessTokens: related,
}
} else {
o.R.AccessTokens = append(o.R.AccessTokens, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &accessTokenR{
User: o,
}
} else {
rel.R.User = o
}
}
return nil
}
// AddConfirmationTokens adds the given related objects to the existing relationships
// of the user, optionally inserting them as new records.
// Appends related to o.R.ConfirmationTokens.
// Sets related.R.User appropriately.
func (o *User) AddConfirmationTokens(ctx context.Context, exec boil.ContextExecutor, insert bool, related ...*ConfirmationToken) error {
var err error
for _, rel := range related {
if insert {
rel.UserID = o.ID
if err = rel.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"confirmation_tokens\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, confirmationTokenPrimaryKeyColumns),
)
values := []interface{}{o.ID, rel.Token}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.UserID = o.ID
}
}
if o.R == nil {
o.R = &userR{
ConfirmationTokens: related,
}
} else {
o.R.ConfirmationTokens = append(o.R.ConfirmationTokens, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &confirmationTokenR{
User: o,
}
} else {
rel.R.User = o
}
}
return nil
}
// AddPasswordResetTokens adds the given related objects to the existing relationships
// of the user, optionally inserting them as new records.
// Appends related to o.R.PasswordResetTokens.
// Sets related.R.User appropriately.
func (o *User) AddPasswordResetTokens(ctx context.Context, exec boil.ContextExecutor, insert bool, related ...*PasswordResetToken) error {
var err error
for _, rel := range related {
if insert {
rel.UserID = o.ID
if err = rel.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"password_reset_tokens\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, passwordResetTokenPrimaryKeyColumns),
)
values := []interface{}{o.ID, rel.Token}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.UserID = o.ID
}
}
if o.R == nil {
o.R = &userR{
PasswordResetTokens: related,
}
} else {
o.R.PasswordResetTokens = append(o.R.PasswordResetTokens, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &passwordResetTokenR{
User: o,
}
} else {
rel.R.User = o
}
}
return nil
}
// AddPushTokens adds the given related objects to the existing relationships
// of the user, optionally inserting them as new records.
// Appends related to o.R.PushTokens.
// Sets related.R.User appropriately.
func (o *User) AddPushTokens(ctx context.Context, exec boil.ContextExecutor, insert bool, related ...*PushToken) error {
var err error
for _, rel := range related {
if insert {
rel.UserID = o.ID
if err = rel.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"push_tokens\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, pushTokenPrimaryKeyColumns),
)
values := []interface{}{o.ID, rel.ID}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.UserID = o.ID
}
}
if o.R == nil {
o.R = &userR{
PushTokens: related,
}
} else {
o.R.PushTokens = append(o.R.PushTokens, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &pushTokenR{
User: o,
}
} else {
rel.R.User = o
}
}
return nil
}
// AddRefreshTokens adds the given related objects to the existing relationships
// of the user, optionally inserting them as new records.
// Appends related to o.R.RefreshTokens.
// Sets related.R.User appropriately.
func (o *User) AddRefreshTokens(ctx context.Context, exec boil.ContextExecutor, insert bool, related ...*RefreshToken) error {
var err error
for _, rel := range related {
if insert {
rel.UserID = o.ID
if err = rel.Insert(ctx, exec, boil.Infer()); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"refresh_tokens\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"user_id"}),
strmangle.WhereClause("\"", "\"", 2, refreshTokenPrimaryKeyColumns),
)
values := []interface{}{o.ID, rel.Token}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, updateQuery)
fmt.Fprintln(writer, values)
}
if _, err = exec.ExecContext(ctx, updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.UserID = o.ID
}
}
if o.R == nil {
o.R = &userR{
RefreshTokens: related,
}
} else {
o.R.RefreshTokens = append(o.R.RefreshTokens, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &refreshTokenR{
User: o,
}
} else {
rel.R.User = o
}
}
return nil
}
// Users retrieves all the records using an executor.
func Users(mods ...qm.QueryMod) userQuery {
mods = append(mods, qm.From("\"users\""))
q := NewQuery(mods...)
if len(queries.GetSelect(q)) == 0 {
queries.SetSelect(q, []string{"\"users\".*"})
}
return userQuery{q}
}
// FindUser retrieves a single record by ID with an executor.
// If selectCols is empty Find will return all columns.
func FindUser(ctx context.Context, exec boil.ContextExecutor, iD string, selectCols ...string) (*User, error) {
userObj := &User{}
sel := "*"
if len(selectCols) > 0 {
sel = strings.Join(strmangle.IdentQuoteSlice(dialect.LQ, dialect.RQ, selectCols), ",")
}
query := fmt.Sprintf(
"select %s from \"users\" where \"id\"=$1", sel,
)
q := queries.Raw(query, iD)
err := q.Bind(ctx, exec, userObj)
if err != nil {
if errors.Is(err, sql.ErrNoRows) {
return nil, sql.ErrNoRows
}
return nil, errors.Wrap(err, "models: unable to select from users")
}
return userObj, nil
}
// Insert a single record using an executor.
// See boil.Columns.InsertColumnSet documentation to understand column list inference for inserts.
func (o *User) Insert(ctx context.Context, exec boil.ContextExecutor, columns boil.Columns) error {
if o == nil {
return errors.New("models: no users provided for insertion")
}
var err error
if !boil.TimestampsAreSkipped(ctx) {
currTime := time.Now().In(boil.GetLocation())
if o.CreatedAt.IsZero() {
o.CreatedAt = currTime
}
if o.UpdatedAt.IsZero() {
o.UpdatedAt = currTime
}
}
nzDefaults := queries.NonZeroDefaultSet(userColumnsWithDefault, o)
key := makeCacheKey(columns, nzDefaults)
userInsertCacheMut.RLock()
cache, cached := userInsertCache[key]
userInsertCacheMut.RUnlock()
if !cached {
wl, returnColumns := columns.InsertColumnSet(
userAllColumns,
userColumnsWithDefault,
userColumnsWithoutDefault,
nzDefaults,
)
cache.valueMapping, err = queries.BindMapping(userType, userMapping, wl)
if err != nil {
return err
}
cache.retMapping, err = queries.BindMapping(userType, userMapping, returnColumns)
if err != nil {
return err
}
if len(wl) != 0 {
cache.query = fmt.Sprintf("INSERT INTO \"users\" (\"%s\") %%sVALUES (%s)%%s", strings.Join(wl, "\",\""), strmangle.Placeholders(dialect.UseIndexPlaceholders, len(wl), 1, 1))
} else {
cache.query = "INSERT INTO \"users\" %sDEFAULT VALUES%s"
}
var queryOutput, queryReturning string
if len(cache.retMapping) != 0 {
queryReturning = fmt.Sprintf(" RETURNING \"%s\"", strings.Join(returnColumns, "\",\""))
}
cache.query = fmt.Sprintf(cache.query, queryOutput, queryReturning)
}
value := reflect.Indirect(reflect.ValueOf(o))
vals := queries.ValuesFromMapping(value, cache.valueMapping)
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, cache.query)
fmt.Fprintln(writer, vals)
}
if len(cache.retMapping) != 0 {
err = exec.QueryRowContext(ctx, cache.query, vals...).Scan(queries.PtrsFromMapping(value, cache.retMapping)...)
} else {
_, err = exec.ExecContext(ctx, cache.query, vals...)
}
if err != nil {
return errors.Wrap(err, "models: unable to insert into users")
}
if !cached {
userInsertCacheMut.Lock()
userInsertCache[key] = cache
userInsertCacheMut.Unlock()
}
return nil
}
// Update uses an executor to update the User.
// See boil.Columns.UpdateColumnSet documentation to understand column list inference for updates.
// Update does not automatically update the record in case of default values. Use .Reload() to refresh the records.
func (o *User) Update(ctx context.Context, exec boil.ContextExecutor, columns boil.Columns) (int64, error) {
if !boil.TimestampsAreSkipped(ctx) {
currTime := time.Now().In(boil.GetLocation())
o.UpdatedAt = currTime
}
var err error
key := makeCacheKey(columns, nil)
userUpdateCacheMut.RLock()
cache, cached := userUpdateCache[key]
userUpdateCacheMut.RUnlock()
if !cached {
wl := columns.UpdateColumnSet(
userAllColumns,
userPrimaryKeyColumns,
)
if !columns.IsWhitelist() {
wl = strmangle.SetComplement(wl, []string{"created_at"})
}
if len(wl) == 0 {
return 0, errors.New("models: unable to update users, could not build whitelist")
}
cache.query = fmt.Sprintf("UPDATE \"users\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, wl),
strmangle.WhereClause("\"", "\"", len(wl)+1, userPrimaryKeyColumns),
)
cache.valueMapping, err = queries.BindMapping(userType, userMapping, append(wl, userPrimaryKeyColumns...))
if err != nil {
return 0, err
}
}
values := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(o)), cache.valueMapping)
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, cache.query)
fmt.Fprintln(writer, values)
}
var result sql.Result
result, err = exec.ExecContext(ctx, cache.query, values...)
if err != nil {
return 0, errors.Wrap(err, "models: unable to update users row")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: failed to get rows affected by update for users")
}
if !cached {
userUpdateCacheMut.Lock()
userUpdateCache[key] = cache
userUpdateCacheMut.Unlock()
}
return rowsAff, nil
}
// UpdateAll updates all rows with the specified column values.
func (q userQuery) UpdateAll(ctx context.Context, exec boil.ContextExecutor, cols M) (int64, error) {
queries.SetUpdate(q.Query, cols)
result, err := q.Query.ExecContext(ctx, exec)
if err != nil {
return 0, errors.Wrap(err, "models: unable to update all for users")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: unable to retrieve rows affected for users")
}
return rowsAff, nil
}
// UpdateAll updates all rows with the specified column values, using an executor.
func (o UserSlice) UpdateAll(ctx context.Context, exec boil.ContextExecutor, cols M) (int64, error) {
ln := int64(len(o))
if ln == 0 {
return 0, nil
}
if len(cols) == 0 {
return 0, errors.New("models: update all requires at least one column argument")
}
colNames := make([]string, len(cols))
args := make([]interface{}, len(cols))
i := 0
for name, value := range cols {
colNames[i] = name
args[i] = value
i++
}
// Append all of the primary key values for each column
for _, obj := range o {
pkeyArgs := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(obj)), userPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := fmt.Sprintf("UPDATE \"users\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, colNames),
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), len(colNames)+1, userPrimaryKeyColumns, len(o)))
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, sql)
fmt.Fprintln(writer, args...)
}
result, err := exec.ExecContext(ctx, sql, args...)
if err != nil {
return 0, errors.Wrap(err, "models: unable to update all in user slice")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: unable to retrieve rows affected all in update all user")
}
return rowsAff, nil
}
// Upsert attempts an insert using an executor, and does an update or ignore on conflict.
// See boil.Columns documentation for how to properly use updateColumns and insertColumns.
func (o *User) Upsert(ctx context.Context, exec boil.ContextExecutor, updateOnConflict bool, conflictColumns []string, updateColumns, insertColumns boil.Columns, opts ...UpsertOptionFunc) error {
if o == nil {
return errors.New("models: no users provided for upsert")
}
if !boil.TimestampsAreSkipped(ctx) {
currTime := time.Now().In(boil.GetLocation())
if o.CreatedAt.IsZero() {
o.CreatedAt = currTime
}
o.UpdatedAt = currTime
}
nzDefaults := queries.NonZeroDefaultSet(userColumnsWithDefault, o)
// Build cache key in-line uglily - mysql vs psql problems
buf := strmangle.GetBuffer()
if updateOnConflict {
buf.WriteByte('t')
} else {
buf.WriteByte('f')
}
buf.WriteByte('.')
for _, c := range conflictColumns {
buf.WriteString(c)
}
buf.WriteByte('.')
buf.WriteString(strconv.Itoa(updateColumns.Kind))
for _, c := range updateColumns.Cols {
buf.WriteString(c)
}
buf.WriteByte('.')
buf.WriteString(strconv.Itoa(insertColumns.Kind))
for _, c := range insertColumns.Cols {
buf.WriteString(c)
}
buf.WriteByte('.')
for _, c := range nzDefaults {
buf.WriteString(c)
}
key := buf.String()
strmangle.PutBuffer(buf)
userUpsertCacheMut.RLock()
cache, cached := userUpsertCache[key]
userUpsertCacheMut.RUnlock()
var err error
if !cached {
insert, _ := insertColumns.InsertColumnSet(
userAllColumns,
userColumnsWithDefault,
userColumnsWithoutDefault,
nzDefaults,
)
update := updateColumns.UpdateColumnSet(
userAllColumns,
userPrimaryKeyColumns,
)
if updateOnConflict && len(update) == 0 {
return errors.New("models: unable to upsert users, could not build update column list")
}
ret := strmangle.SetComplement(userAllColumns, strmangle.SetIntersect(insert, update))
conflict := conflictColumns
if len(conflict) == 0 && updateOnConflict && len(update) != 0 {
if len(userPrimaryKeyColumns) == 0 {
return errors.New("models: unable to upsert users, could not build conflict column list")
}
conflict = make([]string, len(userPrimaryKeyColumns))
copy(conflict, userPrimaryKeyColumns)
}
cache.query = buildUpsertQueryPostgres(dialect, "\"users\"", updateOnConflict, ret, update, conflict, insert, opts...)
cache.valueMapping, err = queries.BindMapping(userType, userMapping, insert)
if err != nil {
return err
}
if len(ret) != 0 {
cache.retMapping, err = queries.BindMapping(userType, userMapping, ret)
if err != nil {
return err
}
}
}
value := reflect.Indirect(reflect.ValueOf(o))
vals := queries.ValuesFromMapping(value, cache.valueMapping)
var returns []interface{}
if len(cache.retMapping) != 0 {
returns = queries.PtrsFromMapping(value, cache.retMapping)
}
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, cache.query)
fmt.Fprintln(writer, vals)
}
if len(cache.retMapping) != 0 {
err = exec.QueryRowContext(ctx, cache.query, vals...).Scan(returns...)
if errors.Is(err, sql.ErrNoRows) {
err = nil // Postgres doesn't return anything when there's no update
}
} else {
_, err = exec.ExecContext(ctx, cache.query, vals...)
}
if err != nil {
return errors.Wrap(err, "models: unable to upsert users")
}
if !cached {
userUpsertCacheMut.Lock()
userUpsertCache[key] = cache
userUpsertCacheMut.Unlock()
}
return nil
}
// Delete deletes a single User record with an executor.
// Delete will match against the primary key column to find the record to delete.
func (o *User) Delete(ctx context.Context, exec boil.ContextExecutor) (int64, error) {
if o == nil {
return 0, errors.New("models: no User provided for delete")
}
args := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(o)), userPrimaryKeyMapping)
sql := "DELETE FROM \"users\" WHERE \"id\"=$1"
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, sql)
fmt.Fprintln(writer, args...)
}
result, err := exec.ExecContext(ctx, sql, args...)
if err != nil {
return 0, errors.Wrap(err, "models: unable to delete from users")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: failed to get rows affected by delete for users")
}
return rowsAff, nil
}
// DeleteAll deletes all matching rows.
func (q userQuery) DeleteAll(ctx context.Context, exec boil.ContextExecutor) (int64, error) {
if q.Query == nil {
return 0, errors.New("models: no userQuery provided for delete all")
}
queries.SetDelete(q.Query)
result, err := q.Query.ExecContext(ctx, exec)
if err != nil {
return 0, errors.Wrap(err, "models: unable to delete all from users")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: failed to get rows affected by deleteall for users")
}
return rowsAff, nil
}
// DeleteAll deletes all rows in the slice, using an executor.
func (o UserSlice) DeleteAll(ctx context.Context, exec boil.ContextExecutor) (int64, error) {
if len(o) == 0 {
return 0, nil
}
var args []interface{}
for _, obj := range o {
pkeyArgs := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(obj)), userPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := "DELETE FROM \"users\" WHERE " +
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), 1, userPrimaryKeyColumns, len(o))
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, sql)
fmt.Fprintln(writer, args)
}
result, err := exec.ExecContext(ctx, sql, args...)
if err != nil {
return 0, errors.Wrap(err, "models: unable to delete all from user slice")
}
rowsAff, err := result.RowsAffected()
if err != nil {
return 0, errors.Wrap(err, "models: failed to get rows affected by deleteall for users")
}
return rowsAff, nil
}
// Reload refetches the object from the database
// using the primary keys with an executor.
func (o *User) Reload(ctx context.Context, exec boil.ContextExecutor) error {
ret, err := FindUser(ctx, exec, o.ID)
if err != nil {
return err
}
*o = *ret
return nil
}
// ReloadAll refetches every row with matching primary key column values
// and overwrites the original object slice with the newly updated slice.
func (o *UserSlice) ReloadAll(ctx context.Context, exec boil.ContextExecutor) error {
if o == nil || len(*o) == 0 {
return nil
}
slice := UserSlice{}
var args []interface{}
for _, obj := range *o {
pkeyArgs := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(obj)), userPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := "SELECT \"users\".* FROM \"users\" WHERE " +
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), 1, userPrimaryKeyColumns, len(*o))
q := queries.Raw(sql, args...)
err := q.Bind(ctx, exec, &slice)
if err != nil {
return errors.Wrap(err, "models: unable to reload all in UserSlice")
}
*o = slice
return nil
}
// UserExists checks if the User row exists.
func UserExists(ctx context.Context, exec boil.ContextExecutor, iD string) (bool, error) {
var exists bool
sql := "select exists(select 1 from \"users\" where \"id\"=$1 limit 1)"
if boil.IsDebug(ctx) {
writer := boil.DebugWriterFrom(ctx)
fmt.Fprintln(writer, sql)
fmt.Fprintln(writer, iD)
}
row := exec.QueryRowContext(ctx, sql, iD)
err := row.Scan(&exists)
if err != nil {
return false, errors.Wrap(err, "models: unable to check if users exists")
}
return exists, nil
}
// Exists checks if the User row exists.
func (o *User) Exists(ctx context.Context, exec boil.ContextExecutor) (bool, error) {
return UserExists(ctx, exec, o.ID)
}