dal

Jan 31, 2023

Changes in this version

+ const LockClause

type Clause

+ func Lock(write bool, nowait bool) Clause

+ type ClauseColumn struct

+ Alias string

+ Name string

+ Raw bool

+ Table string

+ type ClauseTable struct

+ Alias string

+ Name string

+ Raw bool

type Dal

+ Begin func() Transaction

+ DropColumns func(table string, columnName ...string) errors.Error

+ DropIndexes func(table string, indexes ...string) errors.Error

+ DropTables func(dst ...interface{}) errors.Error

+ IsDuplicationError func(err errors.Error) bool

+ IsErrorNotFound func(err errors.Error) bool

+ RenameColumn func(table, oldColumnName, newColumnName string) errors.Error

+ RenameTable func(oldName, newName string) errors.Error

+ Session func(config SessionConfig) Dal

+ UpdateAllColumn func(entity interface{}, clauses ...Clause) errors.Error

+ UpdateColumn func(entity interface{}, columnName string, value interface{}, clauses ...Clause) errors.Error

type DalClause

+ func Expr(expr string, params ...interface{}) DalClause

+ type DalSet struct

+ ColumnName string

+ Value interface{}

+ type DefaultTabler struct

+ Name string

+ func (d DefaultTabler) TableName() string

+ type Rows interface

+ Close func() error

+ ColumnTypes func() ([]*sql.ColumnType, error)

+ Columns func() ([]string, error)

+ Next func() bool

+ Scan func(dest ...any) error

+ type SessionConfig struct

+ PrepareStmt bool

+ SkipDefaultTransaction bool

+ type Tabler interface

+ TableName func() string

+ type Transaction interface

+ Commit func() errors.Error

+ Rollback func() errors.Error

Nov 3, 2022

Changes in this version

type Dal

+ Dialect func() string

Sep 30, 2022

Changes in this version

type Dal

+ AddColumn func(table, columnName, columnType string) errors.Error

+ DropColumn func(table, columnName string) errors.Error

+ UpdateColumns func(entity interface{}, clauses ...Clause) errors.Error

Jul 28, 2022

Changes in this version

+ const FromClause

+ const GroupbyClause

+ const HavingClause

+ const JoinClause

+ const LimitClause

+ const OffsetClause

+ const OrderbyClause

+ const SelectClause

+ const WhereClause

+ func GetColumnNames(d Dal, dst schema.Tabler, filter func(columnMeta ColumnMeta) bool) (names []string, err error)

+ func GetPrimarykeyColumnNames(d Dal, dst schema.Tabler) (names []string, err error)

+ type Clause struct

+ Data interface{}

+ Type string

+ func From(table interface{}) Clause

+ func Groupby(expr string) Clause

+ func Having(clause string, params ...interface{}) Clause

+ func Join(clause string, params ...interface{}) Clause

+ func Limit(limit int) Clause

+ func Offset(offset int) Clause

+ func Orderby(expr string) Clause

+ func Select(fields string) Clause

+ func Where(clause string, params ...interface{}) Clause

+ type ColumnMeta interface

+ AutoIncrement func() (isAutoIncrement bool, ok bool)

+ ColumnType func() (columnType string, ok bool)

+ Comment func() (value string, ok bool)

+ DatabaseTypeName func() string

+ DecimalSize func() (precision int64, scale int64, ok bool)

+ DefaultValue func() (value string, ok bool)

+ Length func() (length int64, ok bool)

+ Name func() string

+ Nullable func() (nullable bool, ok bool)

+ PrimaryKey func() (isPrimaryKey bool, ok bool)

+ ScanType func() reflect.Type

+ Unique func() (unique bool, ok bool)

+ func GetPrimarykeyColumns(d Dal, dst schema.Tabler) ([]ColumnMeta, error)

+ type Dal interface

+ All func(dst interface{}, clauses ...Clause) error

+ AllTables func() ([]string, error)

+ AutoMigrate func(entity interface{}, clauses ...Clause) error

+ Count func(clauses ...Clause) (int64, error)

+ Create func(entity interface{}, clauses ...Clause) error

+ CreateIfNotExist func(entity interface{}, clauses ...Clause) error

+ CreateOrUpdate func(entity interface{}, clauses ...Clause) error

+ Cursor func(clauses ...Clause) (*sql.Rows, error)

+ Delete func(entity interface{}, clauses ...Clause) error

+ Exec func(query string, params ...interface{}) error

+ Fetch func(cursor *sql.Rows, dst interface{}) error

+ First func(dst interface{}, clauses ...Clause) error

+ GetColumns func(dst schema.Tabler, filter func(columnMeta ColumnMeta) bool) (cms []ColumnMeta, err error)

+ GetPrimaryKeyFields func(t reflect.Type) []reflect.StructField

+ Pluck func(column string, dest interface{}, clauses ...Clause) error

+ RawCursor func(query string, params ...interface{}) (*sql.Rows, error)

+ Update func(entity interface{}, clauses ...Clause) error

+ type DalClause struct

+ Expr string

+ Params []interface{}