db_xorm

package
v0.1.2 Latest Latest
Warning

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

Go to latest
Published: Aug 24, 2023 License: Apache-2.0 Imports: 11 Imported by: 0

Documentation

Overview

Package db_xorm

@author: xwc1125

Package db_xorm

@author: xwc1125

Index

Constants

This section is empty.

Variables

View Source
var SysTimeLocation, _ = time.LoadLocation("Asia/Shanghai")

中国时区

Functions

func DeleteByID

func DeleteByID(config database.MysqlConfig, model interface{}, id int64) (count int64, err error)

DeleteByID 根据ID进行删除

func DeleteByIDS

func DeleteByIDS(config database.MysqlConfig, model interface{}, ids []int64) (count int64, err error)

Delete DeleteByIDS 根据ids进行删除

func DeleteByModel

func DeleteByModel(config database.MysqlConfig, model interface{}) (count int64, err error)

DeleteByModel 根据对象进行删除

func DeleteByWhere

func DeleteByWhere(config database.MysqlConfig, model, where interface{}) (count int64, err error)

DeleteByWhere 根据条件删除

func Find

func Find(config database.MysqlConfig, where interface{}, out interface{}, orders ...string) error

Find 查找

func First

func First(config database.MysqlConfig, out interface{}, query interface{}, args ...interface{}) (err error)

First 获取第一个匹配记录 db.Where("name = ?", "jinzhu").First(&user) SELECT * FROM users WHERE name = 'jinzhu' limit 1;

func FirstByID

func FirstByID(config database.MysqlConfig, out interface{}, id int64) (err error)

FirstByID 使用主键获取记录 SELECT * FROM users WHERE id = 10;

func FirstByModel

func FirstByModel(config database.MysqlConfig, out interface{}) (err error)

FirstByModel 根据model查询对象

func Insert

func Insert(config database.MysqlConfig, value interface{}) error

Insert 插入数据

func InsertOne

func InsertOne(config database.MysqlConfig, value interface{}) error

InsertOne 插入单条数据

func MakeCondition

func MakeCondition(dbDrive string, q interface{}) func(db *xorm.Session) *xorm.Session

func MasterEngine

func MasterEngine(config database.MysqlConfig) *xorm.Engine

MasterEngine 主库,单例

func NewEngine

func NewEngine(config database.MysqlConfig) *xorm.Engine

func Paginate

func Paginate(page *response.PageInfo) func(db *xorm.Session) *xorm.Session

func Preload

func Preload(config database.MysqlConfig, model interface{}, out interface{}, foreignKeys string) (err error)
func Related(config database.MysqlConfig, model interface{}, out interface{}, foreignKeys string) (err error)

func SelectPage

func SelectPage(db *xorm.Engine, page *response.PageInfo, wrapper map[string]interface{}, model interface{}) (e error)

func TableFirst

func TableFirst(config database.MysqlConfig, out interface{}) (err error)

TableFirst 获取第一条记录,按主键排序 SELECT * FROM users ORDER BY id LIMIT 1;

func TableLast

func TableLast(config database.MysqlConfig, out interface{}) (err error)

TableLast 获取最后一条记录,按主键排序 SELECT * FROM users ORDER BY id DESC LIMIT 1;

func UpdateById

func UpdateById(config database.MysqlConfig, id interface{}, value interface{}) error

UpdateById 根据ID进行更新

func UpdateByIdAllCols

func UpdateByIdAllCols(config database.MysqlConfig, id interface{}, value interface{}) error

UpdateByIdAllCols 根据ID更新所有字段

func Updates

func Updates(config database.MysqlConfig, where interface{}, value interface{}) error

Updates 根据条件更新

Types

This section is empty.

Jump to

Keyboard shortcuts

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