importer/kmedia/kmodels/servers.go
// Code generated by SQLBoiler (https://github.com/volatiletech/sqlboiler). DO NOT EDIT.
// This file is meant to be re-generated in place and/or deleted at any time.
package kmodels
import (
"bytes"
"database/sql"
"fmt"
"reflect"
"strings"
"sync"
"time"
"github.com/pkg/errors"
"github.com/volatiletech/sqlboiler/boil"
"github.com/volatiletech/sqlboiler/queries"
"github.com/volatiletech/sqlboiler/queries/qm"
"github.com/volatiletech/sqlboiler/strmangle"
"gopkg.in/volatiletech/null.v6"
)
// Server is an object representing the database table.
type Server struct {
Servername string `boil:"servername" json:"servername" toml:"servername" yaml:"servername"`
Httpurl null.String `boil:"httpurl" json:"httpurl,omitempty" toml:"httpurl" yaml:"httpurl,omitempty"`
Created null.Time `boil:"created" json:"created,omitempty" toml:"created" yaml:"created,omitempty"`
Updated null.Time `boil:"updated" json:"updated,omitempty" toml:"updated" yaml:"updated,omitempty"`
Lastuser null.String `boil:"lastuser" json:"lastuser,omitempty" toml:"lastuser" yaml:"lastuser,omitempty"`
Path null.String `boil:"path" json:"path,omitempty" toml:"path" yaml:"path,omitempty"`
ID int `boil:"id" json:"id" toml:"id" yaml:"id"`
R *serverR `boil:"-" json:"-" toml:"-" yaml:"-"`
L serverL `boil:"-" json:"-" toml:"-" yaml:"-"`
}
var ServerColumns = struct {
Servername string
Httpurl string
Created string
Updated string
Lastuser string
Path string
ID string
}{
Servername: "servername",
Httpurl: "httpurl",
Created: "created",
Updated: "updated",
Lastuser: "lastuser",
Path: "path",
ID: "id",
}
// serverR is where relationships are stored.
type serverR struct {
ServernameFileAssets FileAssetSlice
}
// serverL is where Load methods for each relationship are stored.
type serverL struct{}
var (
serverColumns = []string{"servername", "httpurl", "created", "updated", "lastuser", "path", "id"}
serverColumnsWithoutDefault = []string{"httpurl", "created", "updated", "lastuser", "path"}
serverColumnsWithDefault = []string{"servername", "id"}
serverPrimaryKeyColumns = []string{"id"}
)
type (
// ServerSlice is an alias for a slice of pointers to Server.
// This should generally be used opposed to []Server.
ServerSlice []*Server
serverQuery struct {
*queries.Query
}
)
// Cache for insert, update and upsert
var (
serverType = reflect.TypeOf(&Server{})
serverMapping = queries.MakeStructMapping(serverType)
serverPrimaryKeyMapping, _ = queries.BindMapping(serverType, serverMapping, serverPrimaryKeyColumns)
serverInsertCacheMut sync.RWMutex
serverInsertCache = make(map[string]insertCache)
serverUpdateCacheMut sync.RWMutex
serverUpdateCache = make(map[string]updateCache)
serverUpsertCacheMut sync.RWMutex
serverUpsertCache = make(map[string]insertCache)
)
var (
// Force time package dependency for automated UpdatedAt/CreatedAt.
_ = time.Second
// Force bytes in case of primary key column that uses []byte (for relationship compares)
_ = bytes.MinRead
)
// OneP returns a single server record from the query, and panics on error.
func (q serverQuery) OneP() *Server {
o, err := q.One()
if err != nil {
panic(boil.WrapErr(err))
}
return o
}
// One returns a single server record from the query.
func (q serverQuery) One() (*Server, error) {
o := &Server{}
queries.SetLimit(q.Query, 1)
err := q.Bind(o)
if err != nil {
if errors.Cause(err) == sql.ErrNoRows {
return nil, sql.ErrNoRows
}
return nil, errors.Wrap(err, "kmodels: failed to execute a one query for servers")
}
return o, nil
}
// AllP returns all Server records from the query, and panics on error.
func (q serverQuery) AllP() ServerSlice {
o, err := q.All()
if err != nil {
panic(boil.WrapErr(err))
}
return o
}
// All returns all Server records from the query.
func (q serverQuery) All() (ServerSlice, error) {
var o []*Server
err := q.Bind(&o)
if err != nil {
return nil, errors.Wrap(err, "kmodels: failed to assign all query results to Server slice")
}
return o, nil
}
// CountP returns the count of all Server records in the query, and panics on error.
func (q serverQuery) CountP() int64 {
c, err := q.Count()
if err != nil {
panic(boil.WrapErr(err))
}
return c
}
// Count returns the count of all Server records in the query.
func (q serverQuery) Count() (int64, error) {
var count int64
queries.SetSelect(q.Query, nil)
queries.SetCount(q.Query)
err := q.Query.QueryRow().Scan(&count)
if err != nil {
return 0, errors.Wrap(err, "kmodels: failed to count servers rows")
}
return count, nil
}
// Exists checks if the row exists in the table, and panics on error.
func (q serverQuery) ExistsP() bool {
e, err := q.Exists()
if err != nil {
panic(boil.WrapErr(err))
}
return e
}
// Exists checks if the row exists in the table.
func (q serverQuery) Exists() (bool, error) {
var count int64
queries.SetCount(q.Query)
queries.SetLimit(q.Query, 1)
err := q.Query.QueryRow().Scan(&count)
if err != nil {
return false, errors.Wrap(err, "kmodels: failed to check if servers exists")
}
return count > 0, nil
}
// ServernameFileAssetsG retrieves all the file_asset's file assets via servername_id column.
func (o *Server) ServernameFileAssetsG(mods ...qm.QueryMod) fileAssetQuery {
return o.ServernameFileAssets(boil.GetDB(), mods...)
}
// ServernameFileAssets retrieves all the file_asset's file assets with an executor via servername_id column.
func (o *Server) ServernameFileAssets(exec boil.Executor, mods ...qm.QueryMod) fileAssetQuery {
var queryMods []qm.QueryMod
if len(mods) != 0 {
queryMods = append(queryMods, mods...)
}
queryMods = append(queryMods,
qm.Where("\"file_assets\".\"servername_id\"=?", o.Servername),
)
query := FileAssets(exec, queryMods...)
queries.SetFrom(query.Query, "\"file_assets\"")
if len(queries.GetSelect(query.Query)) == 0 {
queries.SetSelect(query.Query, []string{"\"file_assets\".*"})
}
return query
}
// LoadServernameFileAssets allows an eager lookup of values, cached into the
// loaded structs of the objects.
func (serverL) LoadServernameFileAssets(e boil.Executor, singular bool, maybeServer interface{}) error {
var slice []*Server
var object *Server
count := 1
if singular {
object = maybeServer.(*Server)
} else {
slice = *maybeServer.(*[]*Server)
count = len(slice)
}
args := make([]interface{}, count)
if singular {
if object.R == nil {
object.R = &serverR{}
}
args[0] = object.Servername
} else {
for i, obj := range slice {
if obj.R == nil {
obj.R = &serverR{}
}
args[i] = obj.Servername
}
}
query := fmt.Sprintf(
"select * from \"file_assets\" where \"servername_id\" in (%s)",
strmangle.Placeholders(dialect.IndexPlaceholders, count, 1, 1),
)
if boil.DebugMode {
fmt.Fprintf(boil.DebugWriter, "%s\n%v\n", query, args)
}
results, err := e.Query(query, args...)
if err != nil {
return errors.Wrap(err, "failed to eager load file_assets")
}
defer results.Close()
var resultSlice []*FileAsset
if err = queries.Bind(results, &resultSlice); err != nil {
return errors.Wrap(err, "failed to bind eager loaded slice file_assets")
}
if singular {
object.R.ServernameFileAssets = resultSlice
return nil
}
for _, foreign := range resultSlice {
for _, local := range slice {
if local.Servername == foreign.ServernameID.String {
local.R.ServernameFileAssets = append(local.R.ServernameFileAssets, foreign)
break
}
}
}
return nil
}
// AddServernameFileAssetsG adds the given related objects to the existing relationships
// of the server, optionally inserting them as new records.
// Appends related to o.R.ServernameFileAssets.
// Sets related.R.Servername appropriately.
// Uses the global database handle.
func (o *Server) AddServernameFileAssetsG(insert bool, related ...*FileAsset) error {
return o.AddServernameFileAssets(boil.GetDB(), insert, related...)
}
// AddServernameFileAssetsP adds the given related objects to the existing relationships
// of the server, optionally inserting them as new records.
// Appends related to o.R.ServernameFileAssets.
// Sets related.R.Servername appropriately.
// Panics on error.
func (o *Server) AddServernameFileAssetsP(exec boil.Executor, insert bool, related ...*FileAsset) {
if err := o.AddServernameFileAssets(exec, insert, related...); err != nil {
panic(boil.WrapErr(err))
}
}
// AddServernameFileAssetsGP adds the given related objects to the existing relationships
// of the server, optionally inserting them as new records.
// Appends related to o.R.ServernameFileAssets.
// Sets related.R.Servername appropriately.
// Uses the global database handle and panics on error.
func (o *Server) AddServernameFileAssetsGP(insert bool, related ...*FileAsset) {
if err := o.AddServernameFileAssets(boil.GetDB(), insert, related...); err != nil {
panic(boil.WrapErr(err))
}
}
// AddServernameFileAssets adds the given related objects to the existing relationships
// of the server, optionally inserting them as new records.
// Appends related to o.R.ServernameFileAssets.
// Sets related.R.Servername appropriately.
func (o *Server) AddServernameFileAssets(exec boil.Executor, insert bool, related ...*FileAsset) error {
var err error
for _, rel := range related {
if insert {
rel.ServernameID.String = o.Servername
rel.ServernameID.Valid = true
if err = rel.Insert(exec); err != nil {
return errors.Wrap(err, "failed to insert into foreign table")
}
} else {
updateQuery := fmt.Sprintf(
"UPDATE \"file_assets\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, []string{"servername_id"}),
strmangle.WhereClause("\"", "\"", 2, fileAssetPrimaryKeyColumns),
)
values := []interface{}{o.Servername, rel.ID}
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, updateQuery)
fmt.Fprintln(boil.DebugWriter, values)
}
if _, err = exec.Exec(updateQuery, values...); err != nil {
return errors.Wrap(err, "failed to update foreign table")
}
rel.ServernameID.String = o.Servername
rel.ServernameID.Valid = true
}
}
if o.R == nil {
o.R = &serverR{
ServernameFileAssets: related,
}
} else {
o.R.ServernameFileAssets = append(o.R.ServernameFileAssets, related...)
}
for _, rel := range related {
if rel.R == nil {
rel.R = &fileAssetR{
Servername: o,
}
} else {
rel.R.Servername = o
}
}
return nil
}
// SetServernameFileAssetsG removes all previously related items of the
// server replacing them completely with the passed
// in related items, optionally inserting them as new records.
// Sets o.R.Servername's ServernameFileAssets accordingly.
// Replaces o.R.ServernameFileAssets with related.
// Sets related.R.Servername's ServernameFileAssets accordingly.
// Uses the global database handle.
func (o *Server) SetServernameFileAssetsG(insert bool, related ...*FileAsset) error {
return o.SetServernameFileAssets(boil.GetDB(), insert, related...)
}
// SetServernameFileAssetsP removes all previously related items of the
// server replacing them completely with the passed
// in related items, optionally inserting them as new records.
// Sets o.R.Servername's ServernameFileAssets accordingly.
// Replaces o.R.ServernameFileAssets with related.
// Sets related.R.Servername's ServernameFileAssets accordingly.
// Panics on error.
func (o *Server) SetServernameFileAssetsP(exec boil.Executor, insert bool, related ...*FileAsset) {
if err := o.SetServernameFileAssets(exec, insert, related...); err != nil {
panic(boil.WrapErr(err))
}
}
// SetServernameFileAssetsGP removes all previously related items of the
// server replacing them completely with the passed
// in related items, optionally inserting them as new records.
// Sets o.R.Servername's ServernameFileAssets accordingly.
// Replaces o.R.ServernameFileAssets with related.
// Sets related.R.Servername's ServernameFileAssets accordingly.
// Uses the global database handle and panics on error.
func (o *Server) SetServernameFileAssetsGP(insert bool, related ...*FileAsset) {
if err := o.SetServernameFileAssets(boil.GetDB(), insert, related...); err != nil {
panic(boil.WrapErr(err))
}
}
// SetServernameFileAssets removes all previously related items of the
// server replacing them completely with the passed
// in related items, optionally inserting them as new records.
// Sets o.R.Servername's ServernameFileAssets accordingly.
// Replaces o.R.ServernameFileAssets with related.
// Sets related.R.Servername's ServernameFileAssets accordingly.
func (o *Server) SetServernameFileAssets(exec boil.Executor, insert bool, related ...*FileAsset) error {
query := "update \"file_assets\" set \"servername_id\" = null where \"servername_id\" = $1"
values := []interface{}{o.Servername}
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, query)
fmt.Fprintln(boil.DebugWriter, values)
}
_, err := exec.Exec(query, values...)
if err != nil {
return errors.Wrap(err, "failed to remove relationships before set")
}
if o.R != nil {
for _, rel := range o.R.ServernameFileAssets {
rel.ServernameID.Valid = false
if rel.R == nil {
continue
}
rel.R.Servername = nil
}
o.R.ServernameFileAssets = nil
}
return o.AddServernameFileAssets(exec, insert, related...)
}
// RemoveServernameFileAssetsG relationships from objects passed in.
// Removes related items from R.ServernameFileAssets (uses pointer comparison, removal does not keep order)
// Sets related.R.Servername.
// Uses the global database handle.
func (o *Server) RemoveServernameFileAssetsG(related ...*FileAsset) error {
return o.RemoveServernameFileAssets(boil.GetDB(), related...)
}
// RemoveServernameFileAssetsP relationships from objects passed in.
// Removes related items from R.ServernameFileAssets (uses pointer comparison, removal does not keep order)
// Sets related.R.Servername.
// Panics on error.
func (o *Server) RemoveServernameFileAssetsP(exec boil.Executor, related ...*FileAsset) {
if err := o.RemoveServernameFileAssets(exec, related...); err != nil {
panic(boil.WrapErr(err))
}
}
// RemoveServernameFileAssetsGP relationships from objects passed in.
// Removes related items from R.ServernameFileAssets (uses pointer comparison, removal does not keep order)
// Sets related.R.Servername.
// Uses the global database handle and panics on error.
func (o *Server) RemoveServernameFileAssetsGP(related ...*FileAsset) {
if err := o.RemoveServernameFileAssets(boil.GetDB(), related...); err != nil {
panic(boil.WrapErr(err))
}
}
// RemoveServernameFileAssets relationships from objects passed in.
// Removes related items from R.ServernameFileAssets (uses pointer comparison, removal does not keep order)
// Sets related.R.Servername.
func (o *Server) RemoveServernameFileAssets(exec boil.Executor, related ...*FileAsset) error {
var err error
for _, rel := range related {
rel.ServernameID.Valid = false
if rel.R != nil {
rel.R.Servername = nil
}
if err = rel.Update(exec, "servername_id"); err != nil {
return err
}
}
if o.R == nil {
return nil
}
for _, rel := range related {
for i, ri := range o.R.ServernameFileAssets {
if rel != ri {
continue
}
ln := len(o.R.ServernameFileAssets)
if ln > 1 && i < ln-1 {
o.R.ServernameFileAssets[i] = o.R.ServernameFileAssets[ln-1]
}
o.R.ServernameFileAssets = o.R.ServernameFileAssets[:ln-1]
break
}
}
return nil
}
// ServersG retrieves all records.
func ServersG(mods ...qm.QueryMod) serverQuery {
return Servers(boil.GetDB(), mods...)
}
// Servers retrieves all the records using an executor.
func Servers(exec boil.Executor, mods ...qm.QueryMod) serverQuery {
mods = append(mods, qm.From("\"servers\""))
return serverQuery{NewQuery(exec, mods...)}
}
// FindServerG retrieves a single record by ID.
func FindServerG(id int, selectCols ...string) (*Server, error) {
return FindServer(boil.GetDB(), id, selectCols...)
}
// FindServerGP retrieves a single record by ID, and panics on error.
func FindServerGP(id int, selectCols ...string) *Server {
retobj, err := FindServer(boil.GetDB(), id, selectCols...)
if err != nil {
panic(boil.WrapErr(err))
}
return retobj
}
// FindServer retrieves a single record by ID with an executor.
// If selectCols is empty Find will return all columns.
func FindServer(exec boil.Executor, id int, selectCols ...string) (*Server, error) {
serverObj := &Server{}
sel := "*"
if len(selectCols) > 0 {
sel = strings.Join(strmangle.IdentQuoteSlice(dialect.LQ, dialect.RQ, selectCols), ",")
}
query := fmt.Sprintf(
"select %s from \"servers\" where \"id\"=$1", sel,
)
q := queries.Raw(exec, query, id)
err := q.Bind(serverObj)
if err != nil {
if errors.Cause(err) == sql.ErrNoRows {
return nil, sql.ErrNoRows
}
return nil, errors.Wrap(err, "kmodels: unable to select from servers")
}
return serverObj, nil
}
// FindServerP retrieves a single record by ID with an executor, and panics on error.
func FindServerP(exec boil.Executor, id int, selectCols ...string) *Server {
retobj, err := FindServer(exec, id, selectCols...)
if err != nil {
panic(boil.WrapErr(err))
}
return retobj
}
// InsertG a single record. See Insert for whitelist behavior description.
func (o *Server) InsertG(whitelist ...string) error {
return o.Insert(boil.GetDB(), whitelist...)
}
// InsertGP a single record, and panics on error. See Insert for whitelist
// behavior description.
func (o *Server) InsertGP(whitelist ...string) {
if err := o.Insert(boil.GetDB(), whitelist...); err != nil {
panic(boil.WrapErr(err))
}
}
// InsertP a single record using an executor, and panics on error. See Insert
// for whitelist behavior description.
func (o *Server) InsertP(exec boil.Executor, whitelist ...string) {
if err := o.Insert(exec, whitelist...); err != nil {
panic(boil.WrapErr(err))
}
}
// Insert a single record using an executor.
// Whitelist behavior: If a whitelist is provided, only those columns supplied are inserted
// No whitelist behavior: Without a whitelist, columns are inferred by the following rules:
// - All columns without a default value are included (i.e. name, age)
// - All columns with a default, but non-zero are included (i.e. health = 75)
func (o *Server) Insert(exec boil.Executor, whitelist ...string) error {
if o == nil {
return errors.New("kmodels: no servers provided for insertion")
}
var err error
nzDefaults := queries.NonZeroDefaultSet(serverColumnsWithDefault, o)
key := makeCacheKey(whitelist, nzDefaults)
serverInsertCacheMut.RLock()
cache, cached := serverInsertCache[key]
serverInsertCacheMut.RUnlock()
if !cached {
wl, returnColumns := strmangle.InsertColumnSet(
serverColumns,
serverColumnsWithDefault,
serverColumnsWithoutDefault,
nzDefaults,
whitelist,
)
cache.valueMapping, err = queries.BindMapping(serverType, serverMapping, wl)
if err != nil {
return err
}
cache.retMapping, err = queries.BindMapping(serverType, serverMapping, returnColumns)
if err != nil {
return err
}
if len(wl) != 0 {
cache.query = fmt.Sprintf("INSERT INTO \"servers\" (\"%s\") %%sVALUES (%s)%%s", strings.Join(wl, "\",\""), strmangle.Placeholders(dialect.IndexPlaceholders, len(wl), 1, 1))
} else {
cache.query = "INSERT INTO \"servers\" DEFAULT VALUES"
}
var queryOutput, queryReturning string
if len(cache.retMapping) != 0 {
queryReturning = fmt.Sprintf(" RETURNING \"%s\"", strings.Join(returnColumns, "\",\""))
}
if len(wl) != 0 {
cache.query = fmt.Sprintf(cache.query, queryOutput, queryReturning)
}
}
value := reflect.Indirect(reflect.ValueOf(o))
vals := queries.ValuesFromMapping(value, cache.valueMapping)
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, cache.query)
fmt.Fprintln(boil.DebugWriter, vals)
}
if len(cache.retMapping) != 0 {
err = exec.QueryRow(cache.query, vals...).Scan(queries.PtrsFromMapping(value, cache.retMapping)...)
} else {
_, err = exec.Exec(cache.query, vals...)
}
if err != nil {
return errors.Wrap(err, "kmodels: unable to insert into servers")
}
if !cached {
serverInsertCacheMut.Lock()
serverInsertCache[key] = cache
serverInsertCacheMut.Unlock()
}
return nil
}
// UpdateG a single Server record. See Update for
// whitelist behavior description.
func (o *Server) UpdateG(whitelist ...string) error {
return o.Update(boil.GetDB(), whitelist...)
}
// UpdateGP a single Server record.
// UpdateGP takes a whitelist of column names that should be updated.
// Panics on error. See Update for whitelist behavior description.
func (o *Server) UpdateGP(whitelist ...string) {
if err := o.Update(boil.GetDB(), whitelist...); err != nil {
panic(boil.WrapErr(err))
}
}
// UpdateP uses an executor to update the Server, and panics on error.
// See Update for whitelist behavior description.
func (o *Server) UpdateP(exec boil.Executor, whitelist ...string) {
err := o.Update(exec, whitelist...)
if err != nil {
panic(boil.WrapErr(err))
}
}
// Update uses an executor to update the Server.
// Whitelist behavior: If a whitelist is provided, only the columns given are updated.
// No whitelist behavior: Without a whitelist, columns are inferred by the following rules:
// - All columns are inferred to start with
// - All primary keys are subtracted from this set
// Update does not automatically update the record in case of default values. Use .Reload()
// to refresh the records.
func (o *Server) Update(exec boil.Executor, whitelist ...string) error {
var err error
key := makeCacheKey(whitelist, nil)
serverUpdateCacheMut.RLock()
cache, cached := serverUpdateCache[key]
serverUpdateCacheMut.RUnlock()
if !cached {
wl := strmangle.UpdateColumnSet(
serverColumns,
serverPrimaryKeyColumns,
whitelist,
)
if len(whitelist) == 0 {
wl = strmangle.SetComplement(wl, []string{"created_at"})
}
if len(wl) == 0 {
return errors.New("kmodels: unable to update servers, could not build whitelist")
}
cache.query = fmt.Sprintf("UPDATE \"servers\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, wl),
strmangle.WhereClause("\"", "\"", len(wl)+1, serverPrimaryKeyColumns),
)
cache.valueMapping, err = queries.BindMapping(serverType, serverMapping, append(wl, serverPrimaryKeyColumns...))
if err != nil {
return err
}
}
values := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(o)), cache.valueMapping)
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, cache.query)
fmt.Fprintln(boil.DebugWriter, values)
}
_, err = exec.Exec(cache.query, values...)
if err != nil {
return errors.Wrap(err, "kmodels: unable to update servers row")
}
if !cached {
serverUpdateCacheMut.Lock()
serverUpdateCache[key] = cache
serverUpdateCacheMut.Unlock()
}
return nil
}
// UpdateAllP updates all rows with matching column names, and panics on error.
func (q serverQuery) UpdateAllP(cols M) {
if err := q.UpdateAll(cols); err != nil {
panic(boil.WrapErr(err))
}
}
// UpdateAll updates all rows with the specified column values.
func (q serverQuery) UpdateAll(cols M) error {
queries.SetUpdate(q.Query, cols)
_, err := q.Query.Exec()
if err != nil {
return errors.Wrap(err, "kmodels: unable to update all for servers")
}
return nil
}
// UpdateAllG updates all rows with the specified column values.
func (o ServerSlice) UpdateAllG(cols M) error {
return o.UpdateAll(boil.GetDB(), cols)
}
// UpdateAllGP updates all rows with the specified column values, and panics on error.
func (o ServerSlice) UpdateAllGP(cols M) {
if err := o.UpdateAll(boil.GetDB(), cols); err != nil {
panic(boil.WrapErr(err))
}
}
// UpdateAllP updates all rows with the specified column values, and panics on error.
func (o ServerSlice) UpdateAllP(exec boil.Executor, cols M) {
if err := o.UpdateAll(exec, cols); err != nil {
panic(boil.WrapErr(err))
}
}
// UpdateAll updates all rows with the specified column values, using an executor.
func (o ServerSlice) UpdateAll(exec boil.Executor, cols M) error {
ln := int64(len(o))
if ln == 0 {
return nil
}
if len(cols) == 0 {
return errors.New("kmodels: 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)), serverPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := fmt.Sprintf("UPDATE \"servers\" SET %s WHERE %s",
strmangle.SetParamNames("\"", "\"", 1, colNames),
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), len(colNames)+1, serverPrimaryKeyColumns, len(o)))
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, sql)
fmt.Fprintln(boil.DebugWriter, args...)
}
_, err := exec.Exec(sql, args...)
if err != nil {
return errors.Wrap(err, "kmodels: unable to update all in server slice")
}
return nil
}
// UpsertG attempts an insert, and does an update or ignore on conflict.
func (o *Server) UpsertG(updateOnConflict bool, conflictColumns []string, updateColumns []string, whitelist ...string) error {
return o.Upsert(boil.GetDB(), updateOnConflict, conflictColumns, updateColumns, whitelist...)
}
// UpsertGP attempts an insert, and does an update or ignore on conflict. Panics on error.
func (o *Server) UpsertGP(updateOnConflict bool, conflictColumns []string, updateColumns []string, whitelist ...string) {
if err := o.Upsert(boil.GetDB(), updateOnConflict, conflictColumns, updateColumns, whitelist...); err != nil {
panic(boil.WrapErr(err))
}
}
// UpsertP attempts an insert using an executor, and does an update or ignore on conflict.
// UpsertP panics on error.
func (o *Server) UpsertP(exec boil.Executor, updateOnConflict bool, conflictColumns []string, updateColumns []string, whitelist ...string) {
if err := o.Upsert(exec, updateOnConflict, conflictColumns, updateColumns, whitelist...); err != nil {
panic(boil.WrapErr(err))
}
}
// Upsert attempts an insert using an executor, and does an update or ignore on conflict.
func (o *Server) Upsert(exec boil.Executor, updateOnConflict bool, conflictColumns []string, updateColumns []string, whitelist ...string) error {
if o == nil {
return errors.New("kmodels: no servers provided for upsert")
}
nzDefaults := queries.NonZeroDefaultSet(serverColumnsWithDefault, o)
// Build cache key in-line uglily - mysql vs postgres problems
buf := strmangle.GetBuffer()
if updateOnConflict {
buf.WriteByte('t')
} else {
buf.WriteByte('f')
}
buf.WriteByte('.')
for _, c := range conflictColumns {
buf.WriteString(c)
}
buf.WriteByte('.')
for _, c := range updateColumns {
buf.WriteString(c)
}
buf.WriteByte('.')
for _, c := range whitelist {
buf.WriteString(c)
}
buf.WriteByte('.')
for _, c := range nzDefaults {
buf.WriteString(c)
}
key := buf.String()
strmangle.PutBuffer(buf)
serverUpsertCacheMut.RLock()
cache, cached := serverUpsertCache[key]
serverUpsertCacheMut.RUnlock()
var err error
if !cached {
insert, ret := strmangle.InsertColumnSet(
serverColumns,
serverColumnsWithDefault,
serverColumnsWithoutDefault,
nzDefaults,
whitelist,
)
update := strmangle.UpdateColumnSet(
serverColumns,
serverPrimaryKeyColumns,
updateColumns,
)
if len(update) == 0 {
return errors.New("kmodels: unable to upsert servers, could not build update column list")
}
conflict := conflictColumns
if len(conflict) == 0 {
conflict = make([]string, len(serverPrimaryKeyColumns))
copy(conflict, serverPrimaryKeyColumns)
}
cache.query = queries.BuildUpsertQueryPostgres(dialect, "\"servers\"", updateOnConflict, ret, update, conflict, insert)
cache.valueMapping, err = queries.BindMapping(serverType, serverMapping, insert)
if err != nil {
return err
}
if len(ret) != 0 {
cache.retMapping, err = queries.BindMapping(serverType, serverMapping, 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.DebugMode {
fmt.Fprintln(boil.DebugWriter, cache.query)
fmt.Fprintln(boil.DebugWriter, vals)
}
if len(cache.retMapping) != 0 {
err = exec.QueryRow(cache.query, vals...).Scan(returns...)
if err == sql.ErrNoRows {
err = nil // Postgres doesn't return anything when there's no update
}
} else {
_, err = exec.Exec(cache.query, vals...)
}
if err != nil {
return errors.Wrap(err, "kmodels: unable to upsert servers")
}
if !cached {
serverUpsertCacheMut.Lock()
serverUpsertCache[key] = cache
serverUpsertCacheMut.Unlock()
}
return nil
}
// DeleteP deletes a single Server record with an executor.
// DeleteP will match against the primary key column to find the record to delete.
// Panics on error.
func (o *Server) DeleteP(exec boil.Executor) {
if err := o.Delete(exec); err != nil {
panic(boil.WrapErr(err))
}
}
// DeleteG deletes a single Server record.
// DeleteG will match against the primary key column to find the record to delete.
func (o *Server) DeleteG() error {
if o == nil {
return errors.New("kmodels: no Server provided for deletion")
}
return o.Delete(boil.GetDB())
}
// DeleteGP deletes a single Server record.
// DeleteGP will match against the primary key column to find the record to delete.
// Panics on error.
func (o *Server) DeleteGP() {
if err := o.DeleteG(); err != nil {
panic(boil.WrapErr(err))
}
}
// Delete deletes a single Server record with an executor.
// Delete will match against the primary key column to find the record to delete.
func (o *Server) Delete(exec boil.Executor) error {
if o == nil {
return errors.New("kmodels: no Server provided for delete")
}
args := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(o)), serverPrimaryKeyMapping)
sql := "DELETE FROM \"servers\" WHERE \"id\"=$1"
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, sql)
fmt.Fprintln(boil.DebugWriter, args...)
}
_, err := exec.Exec(sql, args...)
if err != nil {
return errors.Wrap(err, "kmodels: unable to delete from servers")
}
return nil
}
// DeleteAllP deletes all rows, and panics on error.
func (q serverQuery) DeleteAllP() {
if err := q.DeleteAll(); err != nil {
panic(boil.WrapErr(err))
}
}
// DeleteAll deletes all matching rows.
func (q serverQuery) DeleteAll() error {
if q.Query == nil {
return errors.New("kmodels: no serverQuery provided for delete all")
}
queries.SetDelete(q.Query)
_, err := q.Query.Exec()
if err != nil {
return errors.Wrap(err, "kmodels: unable to delete all from servers")
}
return nil
}
// DeleteAllGP deletes all rows in the slice, and panics on error.
func (o ServerSlice) DeleteAllGP() {
if err := o.DeleteAllG(); err != nil {
panic(boil.WrapErr(err))
}
}
// DeleteAllG deletes all rows in the slice.
func (o ServerSlice) DeleteAllG() error {
if o == nil {
return errors.New("kmodels: no Server slice provided for delete all")
}
return o.DeleteAll(boil.GetDB())
}
// DeleteAllP deletes all rows in the slice, using an executor, and panics on error.
func (o ServerSlice) DeleteAllP(exec boil.Executor) {
if err := o.DeleteAll(exec); err != nil {
panic(boil.WrapErr(err))
}
}
// DeleteAll deletes all rows in the slice, using an executor.
func (o ServerSlice) DeleteAll(exec boil.Executor) error {
if o == nil {
return errors.New("kmodels: no Server slice provided for delete all")
}
if len(o) == 0 {
return nil
}
var args []interface{}
for _, obj := range o {
pkeyArgs := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(obj)), serverPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := "DELETE FROM \"servers\" WHERE " +
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), 1, serverPrimaryKeyColumns, len(o))
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, sql)
fmt.Fprintln(boil.DebugWriter, args)
}
_, err := exec.Exec(sql, args...)
if err != nil {
return errors.Wrap(err, "kmodels: unable to delete all from server slice")
}
return nil
}
// ReloadGP refetches the object from the database and panics on error.
func (o *Server) ReloadGP() {
if err := o.ReloadG(); err != nil {
panic(boil.WrapErr(err))
}
}
// ReloadP refetches the object from the database with an executor. Panics on error.
func (o *Server) ReloadP(exec boil.Executor) {
if err := o.Reload(exec); err != nil {
panic(boil.WrapErr(err))
}
}
// ReloadG refetches the object from the database using the primary keys.
func (o *Server) ReloadG() error {
if o == nil {
return errors.New("kmodels: no Server provided for reload")
}
return o.Reload(boil.GetDB())
}
// Reload refetches the object from the database
// using the primary keys with an executor.
func (o *Server) Reload(exec boil.Executor) error {
ret, err := FindServer(exec, o.ID)
if err != nil {
return err
}
*o = *ret
return nil
}
// ReloadAllGP refetches every row with matching primary key column values
// and overwrites the original object slice with the newly updated slice.
// Panics on error.
func (o *ServerSlice) ReloadAllGP() {
if err := o.ReloadAllG(); err != nil {
panic(boil.WrapErr(err))
}
}
// ReloadAllP refetches every row with matching primary key column values
// and overwrites the original object slice with the newly updated slice.
// Panics on error.
func (o *ServerSlice) ReloadAllP(exec boil.Executor) {
if err := o.ReloadAll(exec); err != nil {
panic(boil.WrapErr(err))
}
}
// ReloadAllG refetches every row with matching primary key column values
// and overwrites the original object slice with the newly updated slice.
func (o *ServerSlice) ReloadAllG() error {
if o == nil {
return errors.New("kmodels: empty ServerSlice provided for reload all")
}
return o.ReloadAll(boil.GetDB())
}
// ReloadAll refetches every row with matching primary key column values
// and overwrites the original object slice with the newly updated slice.
func (o *ServerSlice) ReloadAll(exec boil.Executor) error {
if o == nil || len(*o) == 0 {
return nil
}
servers := ServerSlice{}
var args []interface{}
for _, obj := range *o {
pkeyArgs := queries.ValuesFromMapping(reflect.Indirect(reflect.ValueOf(obj)), serverPrimaryKeyMapping)
args = append(args, pkeyArgs...)
}
sql := "SELECT \"servers\".* FROM \"servers\" WHERE " +
strmangle.WhereClauseRepeated(string(dialect.LQ), string(dialect.RQ), 1, serverPrimaryKeyColumns, len(*o))
q := queries.Raw(exec, sql, args...)
err := q.Bind(&servers)
if err != nil {
return errors.Wrap(err, "kmodels: unable to reload all in ServerSlice")
}
*o = servers
return nil
}
// ServerExists checks if the Server row exists.
func ServerExists(exec boil.Executor, id int) (bool, error) {
var exists bool
sql := "select exists(select 1 from \"servers\" where \"id\"=$1 limit 1)"
if boil.DebugMode {
fmt.Fprintln(boil.DebugWriter, sql)
fmt.Fprintln(boil.DebugWriter, id)
}
row := exec.QueryRow(sql, id)
err := row.Scan(&exists)
if err != nil {
return false, errors.Wrap(err, "kmodels: unable to check if servers exists")
}
return exists, nil
}
// ServerExistsG checks if the Server row exists.
func ServerExistsG(id int) (bool, error) {
return ServerExists(boil.GetDB(), id)
}
// ServerExistsGP checks if the Server row exists. Panics on error.
func ServerExistsGP(id int) bool {
e, err := ServerExists(boil.GetDB(), id)
if err != nil {
panic(boil.WrapErr(err))
}
return e
}
// ServerExistsP checks if the Server row exists. Panics on error.
func ServerExistsP(exec boil.Executor, id int) bool {
e, err := ServerExists(exec, id)
if err != nil {
panic(boil.WrapErr(err))
}
return e
}