database

package
v2.2.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Dec 10, 2018 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var DBTest = sqlx.NewDatabase("test")

Functions

This section is empty.

Types

type Gender 

type Gender int
const (
	GenderMale Gender = iota + 1
	GenderFemale
)

func (Gender) String 

func (g Gender) String() string

type GeomString 

type GeomString struct {
	V string
}

func (GeomString) DataType 

func (GeomString) DataType(driverName string) string

func (*GeomString) Scan 

func (g *GeomString) Scan(src interface{}) error

func (GeomString) Value 

func (g GeomString) Value() (driver.Value, error)

func (GeomString) ValueEx 

func (GeomString) ValueEx() string

type User 

type User struct {
	ID uint64 `db:"F_id,autoincrement"`
	// 姓名
	Name      string                   `db:"F_name,default=''"`
	Username  string                   `db:"F_username,default=''"`
	Nickname  string                   `db:"F_nickname,default=''"`
	Gender    Gender                   `db:"F_gender,default='0'"`
	Boolean   bool                     `db:"F_boolean,default=false"`
	Geom      GeomString               `db:"F_geom"`
	CreatedAt datatypes.MySQLTimestamp `db:"F_created_at,default='0'"`
	UpdatedAt datatypes.MySQLTimestamp `db:"F_updated_at,default='0'"`
	Enabled   datatypes.Bool           `db:"F_enabled,default='0'"`
}

@def primary ID @def index I_nickname/BTREE Nickname @def index I_username Username @def index I_geom/SPATIAL Geom @def unique_index I_name Name

func (*User) BatchFetchByGeomList 

func (m *User) BatchFetchByGeomList(db *github_com_go_courier_sqlx_v2.DB, values []GeomString) ([]User, error)

func (*User) BatchFetchByIDList 

func (m *User) BatchFetchByIDList(db *github_com_go_courier_sqlx_v2.DB, values []uint64) ([]User, error)

func (*User) BatchFetchByNameList 

func (m *User) BatchFetchByNameList(db *github_com_go_courier_sqlx_v2.DB, values []string) ([]User, error)

func (*User) BatchFetchByNicknameList 

func (m *User) BatchFetchByNicknameList(db *github_com_go_courier_sqlx_v2.DB, values []string) ([]User, error)

func (*User) BatchFetchByUsernameList 

func (m *User) BatchFetchByUsernameList(db *github_com_go_courier_sqlx_v2.DB, values []string) ([]User, error)

func (User) Comments 

func (User) Comments() map[string]string

func (*User) ConditionByStruct 

func (m *User) ConditionByStruct() *github_com_go_courier_sqlx_v2_builder.Condition

func (*User) Count 

func (m *User) Count(db *github_com_go_courier_sqlx_v2.DB, condition *github_com_go_courier_sqlx_v2_builder.Condition, additions ...github_com_go_courier_sqlx_v2_builder.Addition) (int, error)

func (*User) Create 

func (m *User) Create(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) CreateOnDuplicateWithUpdateFields 

func (m *User) CreateOnDuplicateWithUpdateFields(db *github_com_go_courier_sqlx_v2.DB, updateFields []string) error

func (User) D 

func (User) D() *github_com_go_courier_sqlx_v2.Database

func (*User) DeleteByID 

func (m *User) DeleteByID(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) DeleteByName 

func (m *User) DeleteByName(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) DeleteByStruct 

func (m *User) DeleteByStruct(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) FetchByID 

func (m *User) FetchByID(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) FetchByIDForUpdate 

func (m *User) FetchByIDForUpdate(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) FetchByName 

func (m *User) FetchByName(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) FetchByNameForUpdate 

func (m *User) FetchByNameForUpdate(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) FieldBoolean 

func (m *User) FieldBoolean() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldCreatedAt 

func (m *User) FieldCreatedAt() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldEnabled 

func (m *User) FieldEnabled() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldGender 

func (m *User) FieldGender() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldGeom 

func (m *User) FieldGeom() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldID 

func (m *User) FieldID() *github_com_go_courier_sqlx_v2_builder.Column

func (User) FieldKeyBoolean 

func (User) FieldKeyBoolean() string

func (User) FieldKeyCreatedAt 

func (User) FieldKeyCreatedAt() string

func (User) FieldKeyEnabled 

func (User) FieldKeyEnabled() string

func (User) FieldKeyGender 

func (User) FieldKeyGender() string

func (User) FieldKeyGeom 

func (User) FieldKeyGeom() string

func (User) FieldKeyID 

func (User) FieldKeyID() string

func (User) FieldKeyName 

func (User) FieldKeyName() string

func (User) FieldKeyNickname 

func (User) FieldKeyNickname() string

func (User) FieldKeyUpdatedAt 

func (User) FieldKeyUpdatedAt() string

func (User) FieldKeyUsername 

func (User) FieldKeyUsername() string

func (*User) FieldName 

func (m *User) FieldName() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldNickname 

func (m *User) FieldNickname() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldUpdatedAt 

func (m *User) FieldUpdatedAt() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) FieldUsername 

func (m *User) FieldUsername() *github_com_go_courier_sqlx_v2_builder.Column

func (*User) IndexFieldNames 

func (m *User) IndexFieldNames() []string

func (User) Indexes 

func (User) Indexes() github_com_go_courier_sqlx_v2_builder.Indexes

func (*User) List 

func (m *User) List(db *github_com_go_courier_sqlx_v2.DB, condition *github_com_go_courier_sqlx_v2_builder.Condition, additions ...github_com_go_courier_sqlx_v2_builder.Addition) ([]User, error)

func (User) PrimaryKey 

func (User) PrimaryKey() []string

func (*User) SoftDeleteByID 

func (m *User) SoftDeleteByID(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) SoftDeleteByName 

func (m *User) SoftDeleteByName(db *github_com_go_courier_sqlx_v2.DB) error

func (*User) T 

func (m *User) T() *github_com_go_courier_sqlx_v2_builder.Table

func (User) TableName 

func (User) TableName() string

func (User) UniqueIndexes 

func (User) UniqueIndexes() github_com_go_courier_sqlx_v2_builder.Indexes

func (*User) UpdateByIDWithMap 

func (m *User) UpdateByIDWithMap(db *github_com_go_courier_sqlx_v2.DB, fieldValues github_com_go_courier_sqlx_v2_builder.FieldValues) error

func (*User) UpdateByIDWithStruct 

func (m *User) UpdateByIDWithStruct(db *github_com_go_courier_sqlx_v2.DB, zeroFields ...string) error

func (*User) UpdateByNameWithMap 

func (m *User) UpdateByNameWithMap(db *github_com_go_courier_sqlx_v2.DB, fieldValues github_com_go_courier_sqlx_v2_builder.FieldValues) error

func (*User) UpdateByNameWithStruct 

func (m *User) UpdateByNameWithStruct(db *github_com_go_courier_sqlx_v2.DB, zeroFields ...string) error

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.