dbase

package
v0.1.2 Latest Latest
Warning

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

Go to latest
Published: Jun 29, 2022 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var ErrorFieldsIllegal = errors.New("[dbase]Query fields must be 0 or a multiple of 2")

Functions

func Init

func Init(opts ...Opt) error

Init 初始化orm数据库连接池

Types

type DB

type DB struct {
	orm.Ormer
}

func Orm

func Orm(aliasName ...string) *DB

Orm 获取一个orm,orm本身有缓存

func (*DB) Count

func (d *DB) Count(i interface{}, fields ...interface{}) (count int64, err error)

Count 数量

func (*DB) Delete

func (d *DB) Delete(i interface{}, fields ...string) (rows int64, err error)

Delete 删除数据

func (*DB) Get

func (d *DB) Get(m interface{}, cols ...string) (err error)

Get 用于查询一条数据,以传入数组ptr方式获取查询返回值

func (*DB) Insert

func (d *DB) Insert(i interface{}) (id int64, err error)

Insert 插入一条数据

func (*DB) InsertMulti

func (d *DB) InsertMulti(i interface{}, perIns int) (id int64, err error)

InsertMulti 一次插入多条条数据 perIns 单次插入数量

func (*DB) InsertOrUpdate

func (d *DB) InsertOrUpdate(i interface{}, fields ...string) (rows int64, err error)

InsertOrUpdate 插入或更新一条数据

func (*DB) List

func (d *DB) List(m interface{}, i interface{}, orders *[]string, cols *[]string, fields ...interface{}) (rows int64, err error)

List 用于返回db查询的一组数据,以传入数组ptr方式获取查询返回值 in条件field key自行添加 __in, val为数组

func (*DB) ListRaw

func (d *DB) ListRaw(m interface{}, orders *[]string, fields ...interface{}) (rows int64, data []orm.Params, err error)

ListRaw 用于返回db查询的一组数据,以[]orm.Params形式返回 in条件field key自行添加 __in, val为数组

func (*DB) One

func (d *DB) One(m interface{}, i interface{}, orders *[]string, fields ...interface{}) (err error)

One 用于返回db查询List的第一条数据,以传入数组ptr方式获取查询返回值

func (*DB) Update

func (d *DB) Update(i interface{}, clos ...string) (rows int64, err error)

Update 按字段更新数据

func (*DB) UpgradeFilter

func (d *DB) UpgradeFilter(i interface{}, filters *map[string]interface{}, values *orm.Params) (rows int64, err error)

UpgradeFilter 按字段更新数据 filter 条件

values Set = v 条件
orm.Params{
    "name": "astaxie",
}

orm.Params{
    "nums": orm.ColValue(orm.ColAdd, 100),
}

ColAdd // 加 ColMinus // 减 ColMultiply // 乘 ColExcept // 除

type Opt

type Opt struct {
	AliasName         string
	DriverName        string
	DriverTyp         orm.DriverType
	Host              string //host <must>
	Port              string //default 3306
	User              string //username <must>
	Password          string
	DBName            string         //connect DB name <must>
	SslMode           string         //default disable
	TimeZone          *time.Location //default local
	MaxIdleConnes     int            //default 10
	MaxOpenConnes     int            //default 30
	MaxLifeTimeConnes time.Duration  //default 3600
	SyncDB            bool           //is need orm auto sync DB struct
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL