sqlutil

type ColumnMap interface {
}

type DbMap interface {
	SQLExecutor
	Begin() (Transaction, error)
	//
	GetTableByName(t string) (TableMap, bool)
	GetTableByMeta(meta interface{}) (TableMap, bool)
	AddTable(meta interface{}, name string) (TableMap, error)
	AddTable2(meta interface{}, name, comment string) (TableMap, error)
	AddTable3(meta interface{}, schema, name, comment string) (TableMap, error)
	CreateTables(ifNotExists bool, args ...interface{}) (sql string, err error)
	TruncateTables(args ...interface{}) (sql string, err error)
	DropTables(ifExists bool, args ...interface{}) (sql string, err error)
	DropTableByName(t string, ifExists bool) error
	DropTableByMeta(meta interface{}, ifExists bool) error
}

type SQLExecutor interface {
	dialect.Execer
	dialect.Queryer
	//
	Insert(objects ...interface{}) (int64, error)
	Update(objects ...interface{}) (int64, error)
	Delete(objects ...interface{}) (int64, error)
	Get(objects ...interface{}) (int64, error)
	//
	SelectBool(query string, args ...interface{}) (bool, error)
	SelectNullBool(query string, args ...interface{}) (sql.NullBool, error)
	SelectInt(query string, args ...interface{}) (int64, error)
	SelectNullInt(query string, args ...interface{}) (sql.NullInt64, error)
	SelectFloat(query string, args ...interface{}) (float64, error)
	SelectNullFloat(query string, args ...interface{}) (sql.NullFloat64, error)
	SelectStr(query string, args ...interface{}) (string, error)
	SelectNullStr(query string, args ...interface{}) (sql.NullString, error)
	//
	SelectVal(holder interface{}, query string, args ...interface{}) error
	SelectOne(holder interface{}, query string, args ...interface{}) error
	SelectAll(slices interface{}, query string, args ...interface{}) (int64, error)
}

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

type StmtBind interface {
	Close() error
	Exec(args ...interface{}) (sql.Result, error)
	Query(args ...interface{}) error
	Next() error
	One() error
}

type TableMap interface {
	SQLExecutor
	//
	CreateSQL(ifNotExists bool) string
	Create(ifNotExists bool) error
	DropSQL(ifExists bool) string
	Drop(ifExists bool) error
	TruncateSQL() string
	Truncate() error

	//
	Insert2(exec SQLExecutor, data map[string]string, except []string) (id int64, err error)
	Update2(exec SQLExecutor, where string, data map[string]string, except []string) (rows int64, err error)
	Delete2(exec SQLExecutor, where string) (rows int64, err error)
	SelectVal2(holder interface{}, where string, args ...interface{}) error
	SelectOne2(holder interface{}, where string, args ...interface{}) error
	SelectAll2(slices interface{}, where string, args ...interface{}) (int64, error)
	SelectVal2x(holder interface{}, where, suffix string, args ...interface{}) error
	SelectOne2x(holder interface{}, where, suffix string, args ...interface{}) error
	SelectAll2x(slices interface{}, where, suffix string, args ...interface{}) (int64, error)
	SelectVal3(holder interface{}, fields, where string, args ...interface{}) error
	SelectOne3(holder interface{}, fields, where string, args ...interface{}) error
	SelectAll3(slices interface{}, fields, where string, args ...interface{}) (int64, error)
	SelectVal3x(holder interface{}, fields, where, suffix string, args ...interface{}) error
	SelectOne3x(holder interface{}, fields, where, suffix string, args ...interface{}) error
	SelectAll3x(slices interface{}, fields, where, suffix string, args ...interface{}) (int64, error)
	// contains filtered or unexported methods
}

type Transaction interface {
	SQLExecutor
	//
	Commit() error
	Rollback() error
}