db

Documentation

Index

• Constants
• Variables
• func ExecuteSQL(sqlOrArgs ...interface{}) (int64, error)
• func GetMySQLClient(c conf.MySQLConfig) *xorm.Engine
• func GetRedisClient(c conf.RedisConfig) *redis.Pool
• func InitClient()

Constants

const BasicDateFormat = "2006-01-02"

BasicDateFormat for time format layout

const BasicDatetimeFormat = "2006-01-02 15:04:05"

BasicDatetimeFormat for time format layout

const DefaultPage = 1

DefaultPage value

const DefaultPageSize = 10

DefaultPageSize value

const MaxPage = 100

MaxPage limit

const MaxPageSize = 1000

MaxPageSize limit

const StatusActive = 1

StatusActive for data status active

const StatusDelete = 0

StatusDelete for data status delete

const StatusDisable = 4

StatusDisable for data status disabled

const StatusInitialize = 0

StatusInitialize for data status init

Variables

var MySQL *xorm.Engine

MySQL client in global

var Redis *redis.Pool

Redis client in global

Functions

func ExecuteSQL

func ExecuteSQL(sqlOrArgs ...interface{}) (int64, error)

ExecuteSQL TL;DR return affected count

func GetMySQLClient

func GetMySQLClient(c conf.MySQLConfig) *xorm.Engine

GetMySQLClient init connection once

func GetRedisClient

func GetRedisClient(c conf.RedisConfig) *redis.Pool

GetRedisClient of redis pool

func InitClient

func InitClient()

InitClient db connections call this func after conf.Config loaded after InitClient success, db.Redis / db.MySQL can use in global context