dao

Documentation

Index

• Variables
• func CloseDB(db *sql.DB) (err error)
• func Init()
• func NewDB() (db *sql.DB)
• type PurchaseInfo
• type PurchaseInfoDAO
  • func (p *PurchaseInfoDAO) Add(r *PurchaseInfo) (err error)
  • func (p *PurchaseInfoDAO) Count() (total int64, err error)
  • func (p *PurchaseInfoDAO) Get(start, limit uint64) (res []*PurchaseInfo, err error)
  • func (p *PurchaseInfoDAO) GetAll(start, limit int64) (res []*PurchaseInfo, err error)

Variables

var DB *sql.DB

DB 全局的DB

var PurchaseInfoDao = &PurchaseInfoDAO{
	tableName: "purchase_info",
	cloumes:   "id, user, company, tel, purchase_num, purchase_time, created_time, updated_time",
}

Functions

func CloseDB

func CloseDB(db *sql.DB) (err error)

CloseDB 关闭数据库连接

func Init

func Init()

如果有框架的话，可以放在框架里面

func NewDB

func NewDB() (db *sql.DB)

NewDB 建立一个全局的db连接

Types

type PurchaseInfo

type PurchaseInfo struct {
	ID           int
	User         string
	Company      string
	Tel          string
	PurchaseNum  int
	PurchaseTime string
	CreatedTime  string
	UpdatedTime  string
}

PurchaseInfo 记录采购信息

type PurchaseInfoDAO

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

func (*PurchaseInfoDAO) Add

func (p *PurchaseInfoDAO) Add(r *PurchaseInfo) (err error)

func (*PurchaseInfoDAO) Count

func (p *PurchaseInfoDAO) Count() (total int64, err error)

func (*PurchaseInfoDAO) Get

func (p *PurchaseInfoDAO) Get(start, limit uint64) (res []*PurchaseInfo, err error)

func (*PurchaseInfoDAO) GetAll

func (p *PurchaseInfoDAO) GetAll(start, limit int64) (res []*PurchaseInfo, err error)