users

Documentation

Index

• Constants
• Variables
• func Count(where interface{}, args ...interface{}) (int, error)
• func Delete(where ...interface{}) (result sql.Result, err error)
• func FindCount(where ...interface{}) (int, error)
• func FindValue(fieldsAndWhere ...interface{}) (gdb.Value, error)
• func Insert(data ...interface{}) (result sql.Result, err error)
• func Replace(data ...interface{}) (result sql.Result, err error)
• func Save(data ...interface{}) (result sql.Result, err error)
• func Scan(requestPage *api.RequestPage, pointer interface{}, where interface{}, ...) error
• func Update(dataAndWhere ...interface{}) (result sql.Result, err error)
• type Entity
  • func FindAll(where ...interface{}) ([]*Entity, error)
  • func FindOne(where ...interface{}) (*Entity, error)
  • func (r *Entity) Delete() (result sql.Result, err error)
  • func (r *Entity) Insert() (result sql.Result, err error)
  • func (r *Entity) OmitEmpty() *arModel
  • func (r *Entity) Replace() (result sql.Result, err error)
  • func (r *Entity) Save() (result sql.Result, err error)
  • func (r *Entity) Update() (result sql.Result, err error)

Constants

const (
	// ColumnID - the id column of entity.
	ColumnID = "id"
	// ColumnSeasonID - the season_id column of entity.
	ColumnSeasonID = "seasonId"
	// ColumnName - the name column of entity.
	ColumnName = "name"
	// ColumnEmail - the email column of entity.
	ColumnEmail = "email"
	// ColumnPhone - the phone column of entity.
	ColumnPhone = "phone"
	// ColumnPassword - the password column of entity.
	ColumnPassword = "password"
	// ColumnRating - the rating column of entity.
	ColumnRating = "rating"
)

Variables

var (
	// Table is the table name of users.
	Table = "users"
	// Model is the model object of users.
	Model = &arModel{g.DB("default").Table(Table).Safe()}
)

var (
	// AllQueryColumns - all columns used for query, which doesn't include sensitive columns (e.g. password).
	AllQueryColumns = gset.NewFrom([]string{
		ColumnID, ColumnSeasonID, ColumnName, ColumnEmail, ColumnPhone, ColumnRating})
)

Functions

func Count

func Count(where interface{}, args ...interface{}) (int, error)

Count - count the query results by applying default filter about current season id.

func Delete

func Delete(where ...interface{}) (result sql.Result, err error)

Delete is a convenience method for Model.Delete.

func FindCount

func FindCount(where ...interface{}) (int, error)

FindCount is a convenience method for Model.FindCount. See Model.FindCount.

func FindValue

func FindValue(fieldsAndWhere ...interface{}) (gdb.Value, error)

FindValue is a convenience method for Model.FindValue. See Model.FindValue.

func Insert

func Insert(data ...interface{}) (result sql.Result, err error)

Insert is a convenience method for Model.Insert.

func Replace

func Replace(data ...interface{}) (result sql.Result, err error)

Replace is a convenience method for Model.Replace.

func Save

func Save(data ...interface{}) (result sql.Result, err error)

Save is a convenience method for Model.Save.

func Scan

func Scan(requestPage *api.RequestPage, pointer interface{}, where interface{}, args ...interface{}) error

Scan - scan the table to specific result, and apply default filter about current season id.

func Update

func Update(dataAndWhere ...interface{}) (result sql.Result, err error)

Update is a convenience method for Model.Update.

Types

type Entity

type Entity struct {
	Id       int64  `orm:"id,primary"      json:"id"`        //
	SeasonId int64  `orm:"season_id"       json:"season_id"` //
	Name     string `orm:"name,unique"     json:"name"`      //
	Email    string `orm:"email,unique"    json:"email"`     //
	Phone    string `orm:"phone,unique"    json:"phone"`     //
	Password string `orm:"password,unique" json:"password"`  //
	Rating   int    `orm:"rating"          json:"rating"`    //
}

Entity is the golang structure for table users.

func FindAll

func FindAll(where ...interface{}) ([]*Entity, error)

FindAll is a convenience method for Model.FindAll. See Model.FindAll.

func FindOne

func FindOne(where ...interface{}) (*Entity, error)

FindOne is a convenience method for Model.FindOne. See Model.FindOne.

func (*Entity) Delete

func (r *Entity) Delete() (result sql.Result, err error)

Delete does "DELETE FROM...WHERE..." statement for deleting current object from table.

func (*Entity) Insert

func (r *Entity) Insert() (result sql.Result, err error)

Inserts does "INSERT...INTO..." statement for inserting current object into table.

func (*Entity) OmitEmpty

func (r *Entity) OmitEmpty() *arModel

OmitEmpty sets OPTION_OMITEMPTY option for the model, which automatically filers the data and where attributes for empty values.

func (*Entity) Replace

func (r *Entity) Replace() (result sql.Result, err error)

Replace does "REPLACE...INTO..." statement for inserting current object into table. If there's already another same record in the table (it checks using primary key or unique index), it deletes it and insert this one.

func (*Entity) Save

func (r *Entity) Save() (result sql.Result, err error)

Save does "INSERT...INTO..." statement for inserting/updating current object into table. It updates the record if there's already another same record in the table (it checks using primary key or unique index).

func (*Entity) Update

func (r *Entity) Update() (result sql.Result, err error)

Update does "UPDATE...WHERE..." statement for updating current object from table. It updates the record if there's already another same record in the table (it checks using primary key or unique index).