db

Documentation

Index

• func Copy(rs *sql.Rows, db Database, table string, uniqueKeys ...string) error
• func Count(db Database, object IObject, prefix string, sql string, args ...interface{}) (int64, error)
• func Delete(db Database, object IObject, prefix string) (sql.Result, error)
• func DeleteWithSQL(db Database, object IObject, prefix string, sql string, args ...interface{}) (sql.Result, error)
• func Each(object interface{}, fn func(field Field) bool) bool
• func Insert(db Database, object IObject, prefix string) (sql.Result, error)
• func Install(db Database, object IObject, prefix string, autoIncrement int64, ...) (error, interface{})
• func InstallSQL(table interface{}, prefix string, autoIncrement int64, ver interface{}) (string, interface{})
• func Merge(options ...interface{}) interface{}
• func Query(db Database, object IObject, prefix string, sql string, args ...interface{}) (*sql.Rows, error)
• func QueryWithKeys(db Database, object IObject, prefix string, keys map[string]bool, sql string, ...) (*sql.Rows, error)
• func TableName(prefix string, object IObject) string
• func Transaction(db *sql.DB, fn func(conn Database) error) error
• func Update(db Database, object IObject, prefix string) (sql.Result, error)
• func UpdateWithKeys(db Database, object IObject, prefix string, keys map[string]bool) (sql.Result, error)
• type Database
• type Field
• type IObject
  • func Get(db Database, object IObject, prefix string, sql string, args ...interface{}) (IObject, error)
• type Object
  • func (O *Object) GetId() int64
  • func (O *Object) GetName() string
  • func (O *Object) GetTitle() string
  • func (O *Object) SetId(id int64)
• type Scaner
  • func NewScaner(object interface{}) *Scaner
  • func (o *Scaner) Scan(rows *sql.Rows) error

Functions

func Copy

func Copy(rs *sql.Rows, db Database, table string, uniqueKeys ...string) error

func Count

func Count(db Database, object IObject, prefix string, sql string, args ...interface{}) (int64, error)

func Delete

func Delete(db Database, object IObject, prefix string) (sql.Result, error)

func DeleteWithSQL

func DeleteWithSQL(db Database, object IObject, prefix string, sql string, args ...interface{}) (sql.Result, error)

func Each

func Each(object interface{}, fn func(field Field) bool) bool

func Insert

func Insert(db Database, object IObject, prefix string) (sql.Result, error)

func Install

func Install(db Database, object IObject, prefix string, autoIncrement int64, table interface{}) (error, interface{})

func InstallSQL

func InstallSQL(table interface{}, prefix string, autoIncrement int64, ver interface{}) (string, interface{})

func Merge

func Merge(options ...interface{}) interface{}

func Query

func Query(db Database, object IObject, prefix string, sql string, args ...interface{}) (*sql.Rows, error)

func QueryWithKeys

func QueryWithKeys(db Database, object IObject, prefix string, keys map[string]bool, sql string, args ...interface{}) (*sql.Rows, error)

func TableName

func TableName(prefix string, object IObject) string

func Transaction

func Transaction(db *sql.DB, fn func(conn Database) error) error

func Update

func Update(db Database, object IObject, prefix string) (sql.Result, error)

func UpdateWithKeys

func UpdateWithKeys(db Database, object IObject, prefix string, keys map[string]bool) (sql.Result, error)

Types

type Database

type Database interface {
	Query(query string, args ...interface{}) (*sql.Rows, error)
	Exec(query string, args ...interface{}) (sql.Result, error)
}

type Field

type Field struct {
	F            reflect.StructField `json:"-"`
	V            reflect.Value       `json:"-"`
	Name         string              `json:"name"`
	IsObject     bool                `json:"-"`
	IsJSONObject bool                `json:"-"`
}

type IObject

type IObject interface {
	GetTitle() string
	GetName() string
	GetId() int64
	SetId(id int64)
}

func Get

func Get(db Database, object IObject, prefix string, sql string, args ...interface{}) (IObject, error)

type Object

type Object struct {
	Id int64 `json:"id" title:"ID"`
}

func (*Object) GetId

func (O *Object) GetId() int64

func (*Object) GetName

func (O *Object) GetName() string

func (*Object) GetTitle

func (O *Object) GetTitle() string

func (*Object) SetId

func (O *Object) SetId(id int64)

type Scaner

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

func NewScaner

func NewScaner(object interface{}) *Scaner

func (*Scaner) Scan

func (o *Scaner) Scan(rows *sql.Rows) error