database

package
v2.23.13 Latest Latest
Warning

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

 Go to latest Published: Jun 12, 2023 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var DBTest = sqlx.NewDatabase("test")
View Source 
var OrgTable *github_com_go_courier_sqlx_v2_builder.Table
View Source 
var UserTable *github_com_go_courier_sqlx_v2_builder.Table

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 Org added in v2.3.0 

type Org struct {
	ID   uint64 `db:"f_id,autoincrement"`
	Name string `db:"f_name,default=''"`
	// @rel User.ID
	// 关联用户
	// xxxxx
	UserID string `db:"user_id"`
}

@def primary ID organization

func (*Org) BatchFetchByIDList added in v2.3.0 

func (m *Org) BatchFetchByIDList(db github_com_go_courier_sqlx_v2.DBExecutor, values []uint64) ([]Org, error)

func (Org) ColDescriptions added in v2.3.0 

func (Org) ColDescriptions() map[string][]string

func (Org) ColRelations added in v2.3.0 

func (Org) ColRelations() map[string][]string

func (Org) Comments added in v2.3.0 

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

func (*Org) ConditionByStruct added in v2.3.0 

func (m *Org) ConditionByStruct(db github_com_go_courier_sqlx_v2.DBExecutor) github_com_go_courier_sqlx_v2_builder.SqlCondition

func (*Org) Count added in v2.3.0 

func (m *Org) Count(db github_com_go_courier_sqlx_v2.DBExecutor, condition github_com_go_courier_sqlx_v2_builder.SqlCondition, additions ...github_com_go_courier_sqlx_v2_builder.Addition) (int, error)

func (*Org) Create added in v2.3.0 

func (m *Org) Create(db github_com_go_courier_sqlx_v2.DBExecutor) error

func (*Org) DeleteByID added in v2.3.0 

func (m *Org) DeleteByID(db github_com_go_courier_sqlx_v2.DBExecutor) error

func (*Org) DeleteByStruct added in v2.3.0 

func (m *Org) DeleteByStruct(db github_com_go_courier_sqlx_v2.DBExecutor) error

func (*Org) FetchByID added in v2.3.0 

func (m *Org) FetchByID(db github_com_go_courier_sqlx_v2.DBExecutor) error

func (*Org) FetchByIDForUpdate added in v2.3.0 

func (m *Org) FetchByIDForUpdate(db github_com_go_courier_sqlx_v2.DBExecutor) error

func (*Org) FieldID added in v2.3.0 

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

func (Org) FieldKeyID added in v2.3.0 

func (Org) FieldKeyID() string

func (Org) FieldKeyName added in v2.3.0 

func (Org) FieldKeyName() string

func (Org) FieldKeyUserID added in v2.3.0 

func (Org) FieldKeyUserID() string

func (*Org) FieldName added in v2.3.0 

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

func (*Org) FieldUserID added in v2.3.0 

func (m *Org) FieldUserID() *github_com_go_courier_sqlx_v2_builder.Column

func (*Org) IndexFieldNames added in v2.3.0 

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

func (*Org) List added in v2.3.0 

func (m *Org) List(db github_com_go_courier_sqlx_v2.DBExecutor, condition github_com_go_courier_sqlx_v2_builder.SqlCondition, additions ...github_com_go_courier_sqlx_v2_builder.Addition) ([]Org, error)

func (Org) PrimaryKey added in v2.3.0 

func (Org) PrimaryKey() []string

func (Org) TableDescription added in v2.4.0 

func (Org) TableDescription() []string

func (Org) TableName added in v2.3.0 

func (Org) TableName() string

func (*Org) UpdateByIDWithMap added in v2.3.0 

func (m *Org) UpdateByIDWithMap(db github_com_go_courier_sqlx_v2.DBExecutor, fieldValues github_com_go_courier_sqlx_v2_builder.FieldValues) error

func (*Org) UpdateByIDWithStruct added in v2.3.0 

func (m *Org) UpdateByIDWithStruct(db github_com_go_courier_sqlx_v2.DBExecutor, zeroFields ...string) error

type OrgIterator added in v2.12.3 

type OrgIterator struct {
}

func (OrgIterator) New added in v2.12.3 

func (OrgIterator) New() interface{}

func (OrgIterator) Resolve added in v2.12.3 

func (OrgIterator) Resolve(v interface{}) *Org

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.Timestamp `db:"f_created_at,default='0'"`
	UpdatedAt datatypes.Timestamp `db:"f_updated_at,default='0'"`
	DeletedAt datatypes.Timestamp `db:"f_deleted_at,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) BatchFetchByIDList 

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

func (*User) BatchFetchByNameList 

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

func (*User) BatchFetchByNicknameList 

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

func (*User) BatchFetchByUsernameList 

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

func (User) ColDescriptions added in v2.3.0 

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

func (User) ColRelations added in v2.3.0 

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

func (User) Comments 

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

func (*User) ConditionByStruct 

func (m *User) ConditionByStruct(db github_com_go_courier_sqlx_v2.DBExecutor) github_com_go_courier_sqlx_v2_builder.SqlCondition

func (*User) Count 

func (m *User) Count(db github_com_go_courier_sqlx_v2.DBExecutor, condition github_com_go_courier_sqlx_v2_builder.SqlCondition, 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.DBExecutor) error

func (*User) CreateOnDuplicateWithUpdateFields 

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

func (*User) DeleteByID 

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

func (*User) DeleteByName 

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

func (*User) DeleteByStruct 

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

func (*User) FetchByID 

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

func (*User) FetchByIDForUpdate 

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

func (*User) FetchByName 

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

func (*User) FetchByNameForUpdate 

func (m *User) FetchByNameForUpdate(db github_com_go_courier_sqlx_v2.DBExecutor) 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) FieldDeletedAt added in v2.6.0 

func (m *User) FieldDeletedAt() *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) FieldKeyDeletedAt added in v2.6.0 

func (User) FieldKeyDeletedAt() 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.DBExecutor, condition github_com_go_courier_sqlx_v2_builder.SqlCondition, 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.DBExecutor) error

func (*User) SoftDeleteByName 

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

func (User) TableName 

func (User) TableName() string

func (User) UniqueIndexIName added in v2.8.1 

func (User) UniqueIndexIName() 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.DBExecutor, fieldValues github_com_go_courier_sqlx_v2_builder.FieldValues) error

func (*User) UpdateByIDWithStruct 

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

func (*User) UpdateByNameWithMap 

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

func (*User) UpdateByNameWithStruct 

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

type UserIterator added in v2.12.3 

type UserIterator struct {
}

func (UserIterator) New added in v2.12.3 

func (UserIterator) New() interface{}

func (UserIterator) Resolve added in v2.12.3 

func (UserIterator) Resolve(v interface{}) *User

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.