database

type Database interface {
	Init(dbname string, cfg *viper.Viper, logger *zap.Logger) error
	Close()
	InitTables(ctsqls, cisqls []string) error

	Count(table string, where []Where) (int, error)

	Insert(table string, feilds []Feild) (sql.Result, error)
	Replace(table string, feilds []Feild) (sql.Result, error) // insert or replace
	Delete(table string, where []Where) (sql.Result, error)
	Update(table string, toupdate []Feild, where []Where) (sql.Result, error)
	SelectRows(table string, where []Where, order *Order, paging *Paging, result interface{}) error
	SelectRowsOffset(table string, where []Where, order *Order, offset, limit uint64, result interface{}) error

	Begin() error
	Commit() error
	Rollback() error
}

type Feild struct {
	Name  string
	Value interface{}
}

type Order struct {
	Type   string   // "asc" or "desc"
	Feilds []string // order by x
}

type Paging struct {
	CursorName  string // cursor column
	CursorValue uint64 // cursor column
	Limit       uint   // limit
}

type Where struct {
	Name  string
	Value interface{}
	Op    string // can be =、>、<、<> and any operator supported by sql-database
}