xormhelper

Documentation

Index

• Constants
• Variables
• func Close(params ...string) (err error)
• func Register(poolName, dsn string, params ...string) error
• func Using(params ...string) (*xorm.Session, error)
• type Model
  • func (m *Model) AllCols() *Model
  • func (m *Model) And(column string, args ...interface{}) *Model
  • func (m *Model) Asc(colNames ...string) *Model
  • func (m *Model) Cols(columns ...string) *Model
  • func (m *Model) Count(bean ...interface{}) (int64, error)
  • func (m *Model) Delete(bean interface{}) (int64, error)
  • func (m *Model) Desc(colNames ...string) *Model
  • func (m *Model) Distinct(columns ...string) *Model
  • func (m *Model) Exist(bean ...interface{}) (bool, error)
  • func (m *Model) FilterID(id interface{}) *Model
  • func (m *Model) FindAll(rowsSlicePtr interface{}, condiBean ...interface{}) error
  • func (m *Model) FindAndCount(rowsSlicePtr interface{}, condiBean ...interface{}) (int64, error)
  • func (m *Model) FindOne(bean interface{}) (bool, error)
  • func (m *Model) GroupBy(keys string) *Model
  • func (m *Model) Having(conditions string) *Model
  • func (m *Model) IN(column string, args ...interface{}) *Model
  • func (m *Model) LastSQL() (string, []interface{})
  • func (m *Model) Limit(limit int, start ...int) *Model
  • func (m *Model) NotIn(column string, args ...interface{}) *Model
  • func (m *Model) Or(column string, args ...interface{}) *Model
  • func (m *Model) OrderBy(order string) *Model
  • func (m *Model) Pagination(page, pagesize int, data interface{}) (currentPage, currentPagesize, totalRecords, totalPages int, err error)
  • func (m *Model) Rows(bean interface{}) (*xorm.Rows, error)
  • func (m *Model) SQL(query interface{}, args ...interface{}) *Model
  • func (m *Model) Save() (int64, error)
  • func (m *Model) SessionInit(session *xorm.Session, tableNameOrBean interface{})
  • func (m *Model) Update() (int64, error)
  • func (m *Model) Where(query interface{}, args ...interface{}) *Model
• type XormSession
  • func (xc *XormSession) Close() error
  • func (xc *XormSession) Connect() (err error)
  • func (xc *XormSession) Register() error
• type Xorms

Constants

const (
	SnakeMapper = "snake"
	SameMapper  = "same"
	GonicMapper = "gonic"
)

Variables

var ConnMaxLifetimeDefault time.Duration = 30 * time.Second

var MaxIdleConnsDefault int = 16

var MaxOpenConnsDefault int = 32

Functions

func Close

func Close(params ...string) (err error)

 Close 关闭连接
 范例：
	Close() 关闭名字为default的连接
	Close("my") 关闭名字为my的连接
	Close("my","your") 关闭多个连接
	Close("__all__") 关闭所有的连接。

func Register

func Register(poolName, dsn string, params ...string) error

Register 注册一个mysql连接池 范例:

给连接池取个名称
Register("default","test:test@(127.0.0.1:3306)/db?charset=utf8mb4&parseTime=True&loc=Local")
指定表前缀
Register("default","test:test@(127.0.0.1:3306)/db?charset=utf8mb4&parseTime=True&loc=Local","prefix_")
设置调试模式，会打印sql语句
Register("default","test:test@(127.0.0.1:3306)/db?charset=utf8mb4&parseTime=True&loc=Local","prefix_","true")
指定xorm的mapper规则
Register("default","test:test@(127.0.0.1:3306)/db?charset=utf8mb4&parseTime=True&loc=Local","prefix_","true","gonic)

func Using

func Using(params ...string) (*xorm.Session, error)

Using 使用指定的名字的连接池， 不指定默认为default

Types

type Model

type Model struct {
	// contains filtered or unexported fields
}

func (*Model) AllCols

func (m *Model) AllCols() *Model

func (*Model) And

func (m *Model) And(column string, args ...interface{}) *Model

func (*Model) Asc

func (m *Model) Asc(colNames ...string) *Model

func (*Model) Cols

func (m *Model) Cols(columns ...string) *Model

func (*Model) Count

func (m *Model) Count(bean ...interface{}) (int64, error)

func (*Model) Delete

func (m *Model) Delete(bean interface{}) (int64, error)

func (*Model) Desc

func (m *Model) Desc(colNames ...string) *Model

func (*Model) Distinct

func (m *Model) Distinct(columns ...string) *Model

func (*Model) Exist

func (m *Model) Exist(bean ...interface{}) (bool, error)

func (*Model) FilterID

func (m *Model) FilterID(id interface{}) *Model

func (*Model) FindAll

func (m *Model) FindAll(rowsSlicePtr interface{}, condiBean ...interface{}) error

func (*Model) FindAndCount

func (m *Model) FindAndCount(rowsSlicePtr interface{}, condiBean ...interface{}) (int64, error)

func (*Model) FindOne

func (m *Model) FindOne(bean interface{}) (bool, error)

func (*Model) GroupBy

func (m *Model) GroupBy(keys string) *Model

func (*Model) Having

func (m *Model) Having(conditions string) *Model

func (*Model) IN

func (m *Model) IN(column string, args ...interface{}) *Model

func (*Model) LastSQL

func (m *Model) LastSQL() (string, []interface{})

func (*Model) Limit

func (m *Model) Limit(limit int, start ...int) *Model

func (*Model) NotIn

func (m *Model) NotIn(column string, args ...interface{}) *Model

func (*Model) Or

func (m *Model) Or(column string, args ...interface{}) *Model

func (*Model) OrderBy

func (m *Model) OrderBy(order string) *Model

func (*Model) Pagination

func (m *Model) Pagination(page, pagesize int, data interface{}) (currentPage, currentPagesize, totalRecords, totalPages int, err error)

func (*Model) Rows

func (m *Model) Rows(bean interface{}) (*xorm.Rows, error)

func (*Model) SQL

func (m *Model) SQL(query interface{}, args ...interface{}) *Model

func (*Model) Save

func (m *Model) Save() (int64, error)

func (*Model) SessionInit

func (m *Model) SessionInit(session *xorm.Session, tableNameOrBean interface{})

func (*Model) Update

func (m *Model) Update() (int64, error)

func (*Model) Where

func (m *Model) Where(query interface{}, args ...interface{}) *Model

type XormSession

type XormSession struct {
	Name            string
	DSN             string
	Prefix          string
	Mapper          string
	ConnMaxLifetime time.Duration
	MaxIdleConns    int
	MaxOpenConns    int
	Debug           bool
	// contains filtered or unexported fields
}

func (*XormSession) Close

func (xc *XormSession) Close() error

func (*XormSession) Connect

func (xc *XormSession) Connect() (err error)

func (*XormSession) Register

func (xc *XormSession) Register() error

Register

type Xorms

type Xorms struct {
	Engine map[string]*XormSession
	sync.RWMutex
}

var PublicXorms Xorms = Xorms{Engine: make(map[string]*XormSession)}