crud

package module

Go to main page

Versions in this module

v2

v2.5.0

Nov 29, 2021

Changes in this version

type DB

+ func (db *DB) WithContext(ctx context.Context) *WithContext

type Tx

+ Context context.Context

+ type WithContext struct

+ Context context.Context

+ DB *stdsql.DB

+ Id string

+ IdKey string

+ func (ctx *WithContext) Create(record interface{}) error

+ func (ctx *WithContext) CreateAndRead(record interface{}) error

+ func (ctx *WithContext) Delete(record interface{}) error

+ func (ctx *WithContext) Exec(sql string, params ...interface{}) (stdsql.Result, error)

+ func (ctx *WithContext) Query(sql string, params ...interface{}) (*stdsql.Rows, error)

+ func (ctx *WithContext) Read(scanTo interface{}, params ...interface{}) error

+ func (ctx *WithContext) Update(record interface{}) error

v2.4.2

Nov 28, 2021

Changes in this version

+ type Client interface

+ Create func(interface{}) error

+ CreateAndRead func(interface{}) error

+ Delete func(interface{}) error

+ Exec func(string, ...interface{}) (stdsql.Result, error)

+ Query func(string, ...interface{}) (*stdsql.Rows, error)

+ Read func(interface{}, ...interface{}) error

+ Update func(interface{}) error

v2.4.1

Nov 28, 2021

v2.4.0

Nov 28, 2021

Changes in this version

type Tx

+ Id string

+ IdKey string

+ func (tx *Tx) CreateAndRead(record interface{}) error

v2.3.2

Nov 28, 2021

Changes in this version

+ func ReadTableColumns(any interface{}) ([]string, error)

v2.3.1

Nov 25, 2021

Changes in this version

+ func HasPK(fields []*Field) bool

+ func ReadTableName(any interface{}) (string, string)

+ func ResolveReadParams(params []interface{}) (string, []interface{}, error)

+ func SQLTableNameOf(any interface{}) string

+ func SetDefaultPK(fields []*Field)

+ type DB struct

+ Client *stdsql.DB

+ Driver string

+ URL string

+ func Connect(driver, url string) (*DB, error)

+ func (db *DB) Begin() (*Tx, error)

+ func (db *DB) CheckIfTableExists(name string) bool

+ func (db *DB) Create(record interface{}) error

+ func (db *DB) CreateAndGetResult(record interface{}) (stdsql.Result, error)

+ func (db *DB) CreateAndRead(record interface{}) error

+ func (db *DB) CreateTable(st interface{}, ifexists bool) error

+ func (db *DB) CreateTables(structs ...interface{}) error

+ func (db *DB) Delete(record interface{}) error

+ func (db *DB) DropTable(st interface{}, ifexists bool) error

+ func (db *DB) DropTables(structs ...interface{}) error

+ func (db *DB) Exec(sql string, params ...interface{}) (stdsql.Result, error)

+ func (db *DB) Ping() error

+ func (db *DB) Query(sql string, params ...interface{}) (*stdsql.Rows, error)

+ func (db *DB) Read(scanTo interface{}, params ...interface{}) error

+ func (db *DB) ResetTables(structs ...interface{}) error

+ func (db *DB) Update(record interface{}) error

+ type ExecFn func(string, ...interface{}) (stdsql.Result, error)

+ type Field struct

+ Name string

+ SQL *sql.Options

+ Value interface{}

+ func GetFieldsOf(st interface{}) ([]*Field, error)

+ type FieldIteration struct

+ Index int

+ Length int

+ ReflectType reflect.Type

+ ReflectValue reflect.Value

+ func NewFieldIteration(st interface{}) *FieldIteration

+ func (iteration *FieldIteration) IsEmbeddedStruct() bool

+ func (iteration *FieldIteration) Name() string

+ func (iteration *FieldIteration) Next() bool

+ func (iteration *FieldIteration) SQLOptions() (*sql.Options, error)

+ func (iteration *FieldIteration) TypeField() reflect.StructField

+ func (iteration *FieldIteration) Value() interface{}

+ func (iteration *FieldIteration) ValueField() reflect.Value

+ type QueryFn func(string, ...interface{}) (*stdsql.Rows, error)

+ type Row struct

+ SQLTableName string

+ Values []*RowValue

+ func (row *Row) SQLValues() map[string]interface{}

+ type RowValue struct

+ SQLColumn string

+ Value interface{}

+ func GetRowValuesOf(st interface{}) ([]*RowValue, error)

+ type Scan struct

+ SQLColumnDict map[string]string

+ Table *Table

+ To interface{}

+ ToPointers bool

+ ToStructs bool

+ func NewScan(to interface{}) (*Scan, error)

+ func (scan *Scan) All(rows *sql.Rows) error

+ func (scan *Scan) One(rows *sql.Rows) error

+ func (scan *Scan) Scan(rows *sql.Rows, record reflect.Value) error

+ func (scan *Scan) ScanToStruct(rows *sql.Rows, record reflect.Value) error

+ type Table struct

+ Fields []*Field

+ Name string

+ SQLName string

+ func NewTable(any interface{}) (*Table, error)

+ func (table *Table) PrimaryKeyField() *Field

+ func (table *Table) SQLColumnDict() map[string]string

+ func (table *Table) SQLOptions() []*sql.Options

+ func (table *Table) SQLUpdateColumnSet() []string

+ func (table *Table) SQLUpdateValueSet() []interface{}

+ type Tx struct

+ Client *stdsql.Tx

+ func (tx *Tx) Commit() error

+ func (tx *Tx) Create(record interface{}) error

+ func (tx *Tx) Delete(record interface{}) error

+ func (tx *Tx) Exec(sql string, params ...interface{}) (stdsql.Result, error)

+ func (tx *Tx) Query(sql string, params ...interface{}) (*stdsql.Rows, error)

+ func (tx *Tx) Read(scanTo interface{}, params ...interface{}) error

+ func (tx *Tx) Rollback() error

+ func (tx *Tx) Update(record interface{}) error

v2.3.0

Nov 24, 2021

Other modules containing this package

github.com/azer/crud

github.com/azer/crud/v4

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL