database

Documentation

Index

• func ConnectDB(addr, dbname, user, passwd string) *sql.DB
• func ConnectGormDB() error
• func InitDB(addr, dbname, user, passwd string) (*gorm.DB, error)
• func RunGorm()
• func RunSql()
• type Dao
  • func NewDao() *Dao
  • func (dao *Dao) Save(users []entity.User) error
  • func (dao *Dao) Select(users *[]entity.User) error
• type GormDao
  • func NewGormDao() *GormDao
  • func (dao *GormDao) GormSave(users []entity.User) error
  • func (dao *GormDao) GormSelect() ([]entity.User, error)
• type User

Functions

func ConnectDB

func ConnectDB(addr, dbname, user, passwd string) *sql.DB

func ConnectGormDB

func ConnectGormDB() error

func InitDB

func InitDB(addr, dbname, user, passwd string) (*gorm.DB, error)

func RunGorm

func RunGorm()

func RunSql

func RunSql()

Types

type Dao

type Dao struct {
	DB *sql.DB
}

func NewDao

func NewDao() *Dao

func (*Dao) Save

func (dao *Dao) Save(users []entity.User) error

func (*Dao) Select

func (dao *Dao) Select(users *[]entity.User) error

select query all User

type GormDao

type GormDao struct {
	DB *gorm.DB
}

func NewGormDao

func NewGormDao() *GormDao

func (*GormDao) GormSave

func (dao *GormDao) GormSave(users []entity.User) error

func (*GormDao) GormSelect

func (dao *GormDao) GormSelect() ([]entity.User, error)

select query all User

type User

type User struct {
	Id         int64     `gorm:"column:id;primary_key" json:"id"`
	AddTime    time.Time `gorm:"column:add_time" json:"add_time"`
	UpdateTime time.Time `gorm:"column:update_time" json:"update_time"`
	Name       string    `gorm:"column:name" json:"name"`
	Birthday   string    `gorm:"column:birthday" json:"birthday"`
}