buildsqlx

package module

Go to main page

Versions in this module

v1

v1.0.6

Apr 21, 2024

Changes in this version

type Table

+ func (t *Table) RenameIndex(idxName, newName string) *Table

v1.0.5

Apr 18, 2024

v1.0.4

Oct 21, 2023

v1.0.3

Oct 16, 2023

v1.0.2

Oct 10, 2023

v1.0.1

Oct 7, 2023

v1.0.0

Sep 30, 2023

Changes in this version

+ var ErrNoMoreRows = errors.New("sql: no more rows")

type DB

+ func (r *DB) EachToStruct(fn EachToStructFunc) error

+ func (r *DB) Next(rows *sql.Rows, src any) error

+ func (r *DB) ScanStruct(src any) error

+ type EachToStructFunc func(rows *sql.Rows) error

v0

v0.8.9

Jul 15, 2023

Changes in this version

type DB

+ Txn *Txn

+ type Txn struct

+ Builder *builder

+ Tx *sql.Tx

+ func (r *Txn) Delete() (int64, error)

+ func (r *Txn) Insert(data map[string]any) error

+ func (r *Txn) InsertGetId(data map[string]any) (uint64, error)

+ func (r *Txn) Replace(data map[string]any, conflict string) (int64, error)

+ func (r *Txn) Update(data map[string]any) (int64, error)

v0.8.8

Apr 6, 2023

v0.8.7

Mar 4, 2023

Changes in this version

type Connection

+ func NewConnectionFromDb(db *sql.DB) *Connection

v0.8.6

Feb 26, 2023

v0.8.5

Aug 18, 2022

v0.8.4

Aug 15, 2022

v0.8.3

Aug 14, 2022

v0.8.2

Aug 3, 2022

Changes in this version

type Table

+ func (t *Table) Include(columns ...string) *Table

v0.8.1

Jul 23, 2022

Changes in this version

+ const Concurrently

+ const Constraint

type Table

+ func (t *Table) Concurrently() *Table

v0.8.0

Jul 21, 2022

Changes in this version

+ const IfExists

+ const IfExistsExp

+ const IfExistsUndeclared

+ const IfNotExists

+ const IfNotExistsExp

type DB

+ func (r *DB) SchemaIfNotExists(tblName string, fn func(table *Table) error) (res sql.Result, err error)

type Table

+ func (t *Table) IfExists() *Table

+ func (t *Table) IfNotExists() *Table

v0.7.9

Jul 6, 2022

v0.7.8

Apr 15, 2022

v0.7.7

Apr 2, 2022

Changes in this version

+ const TypeBoolean

type Table

+ func (t *Table) Boolean(colNm string) *Table

v0.7.6

Apr 25, 2021

Changes in this version

type DB

+ func (r *DB) Find(id uint64) (map[string]interface{}, error)

v0.7.5

Nov 7, 2020

v0.7.4

Apr 6, 2020

Changes in this version

+ const Add

+ const AlterTable

+ const CurrentDate

+ const CurrentDateTime

+ const CurrentTime

+ const DefaultSchema

+ const Drop

+ const Modify

+ const Rename

+ const SemiColon

+ const TypeBigInt

+ const TypeBigSerial

+ const TypeChar

+ const TypeDate

+ const TypeDateTime

+ const TypeDateTimeTz

+ const TypeDblPrecision

+ const TypeInt

+ const TypeJson

+ const TypeJsonb

+ const TypeNumeric

+ const TypePoint

+ const TypePolygon

+ const TypeSerial

+ const TypeSmallInt

+ const TypeText

+ const TypeTime

+ const TypeTsQuery

+ const TypeTsVector

+ const TypeVarchar

+ type Connection struct

+ func NewConnection(driverName, dataSourceName string) *Connection

+ type DB struct

+ Builder *builder

+ Conn *Connection

+ func NewDb(c *Connection) *DB

+ func (r *DB) AddSelect(args ...string) *DB

+ func (r *DB) AndHavingRaw(raw string) *DB

+ func (r *DB) AndWhere(operand, operator string, val interface{}) *DB

+ func (r *DB) AndWhereBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) AndWhereIn(field string, in interface{}) *DB

+ func (r *DB) AndWhereNotBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) AndWhereNotIn(field string, in interface{}) *DB

+ func (r *DB) AndWhereNotNull(field string) *DB

+ func (r *DB) AndWhereNull(field string) *DB

+ func (r *DB) AndWhereRaw(raw string) *DB

+ func (r *DB) Avg(column string) (avg float64, err error)

+ func (r *DB) Chunk(amount int64, fn func(rows []map[string]interface{}) bool) error

+ func (r *DB) Count() (cnt int64, err error)

+ func (r *DB) Dd()

+ func (r *DB) Decrement(column string, on uint64) (int64, error)

+ func (r *DB) Delete() (int64, error)

+ func (r *DB) DoesntExists() (bool, error)

+ func (r *DB) Drop(tables string) (sql.Result, error)

+ func (r *DB) DropIfExists(tables string) (sql.Result, error)

+ func (r *DB) Dump()

+ func (r *DB) Exists() (exists bool, err error)

+ func (r *DB) First() (map[string]interface{}, error)

+ func (r *DB) From(fromTbl string) *DB

+ func (r *DB) FullJoin(table, left, operator, right string) *DB

+ func (r *DB) FullOuterJoin(table, left, operator, right string) *DB

+ func (r *DB) Get() ([]map[string]interface{}, error)

+ func (r *DB) GroupBy(expr string) *DB

+ func (r *DB) HasColumns(schema, tbl string, cols ...string) (colsExists bool, err error)

+ func (r *DB) HasTable(schema, tbl string) (tblExists bool, err error)

+ func (r *DB) Having(operand, operator string, val interface{}) *DB

+ func (r *DB) HavingRaw(raw string) *DB

+ func (r *DB) InRandomOrder() *DB

+ func (r *DB) InTransaction(fn func() (interface{}, error)) error

+ func (r *DB) Increment(column string, on uint64) (int64, error)

+ func (r *DB) InnerJoin(table, left, operator, right string) *DB

+ func (r *DB) Insert(data map[string]interface{}) error

+ func (r *DB) InsertBatch(data []map[string]interface{}) error

+ func (r *DB) InsertGetId(data map[string]interface{}) (uint64, error)

+ func (r *DB) LeftJoin(table, left, operator, right string) *DB

+ func (r *DB) Limit(lim int64) *DB

+ func (r *DB) LockForUpdate() *DB

+ func (r *DB) Max(column string) (max float64, err error)

+ func (r *DB) Min(column string) (min float64, err error)

+ func (r *DB) Offset(off int64) *DB

+ func (r *DB) OrHavingRaw(raw string) *DB

+ func (r *DB) OrWhere(operand, operator string, val interface{}) *DB

+ func (r *DB) OrWhereBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) OrWhereIn(field string, in interface{}) *DB

+ func (r *DB) OrWhereNotBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) OrWhereNotIn(field string, in interface{}) *DB

+ func (r *DB) OrWhereNotNull(field string) *DB

+ func (r *DB) OrWhereNull(field string) *DB

+ func (r *DB) OrWhereRaw(raw string) *DB

+ func (r *DB) OrderBy(column string, direction string) *DB

+ func (r *DB) OrderByRaw(exp string) *DB

+ func (r *DB) Pluck(column string) (val []interface{}, err error)

+ func (r *DB) PluckMap(colKey, colValue string) (val []map[interface{}]interface{}, err error)

+ func (r *DB) Rename(from, to string) (sql.Result, error)

+ func (r *DB) Replace(data map[string]interface{}, conflict string) (int64, error)

+ func (r *DB) RightJoin(table, left, operator, right string) *DB

+ func (r *DB) Schema(tblName string, fn func(table *Table)) (res sql.Result, err error)

+ func (r *DB) Select(args ...string) *DB

+ func (r *DB) SelectRaw(raw string) *DB

+ func (r *DB) Sql() *sql.DB

+ func (r *DB) Sum(column string) (max float64, err error)

+ func (r *DB) Table(table string) *DB

+ func (r *DB) Truncate(tables string) (sql.Result, error)

+ func (r *DB) Union() *DB

+ func (r *DB) UnionAll() *DB

+ func (r *DB) Update(data map[string]interface{}) (int64, error)

+ func (r *DB) Value(column string) (val interface{}, err error)

+ func (r *DB) Where(operand, operator string, val interface{}) *DB

+ func (r *DB) WhereBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) WhereExists(rr *DB) *DB

+ func (r *DB) WhereIn(field string, in interface{}) *DB

+ func (r *DB) WhereNotBetween(col string, val1, val2 interface{}) *DB

+ func (r *DB) WhereNotExists(rr *DB) *DB

+ func (r *DB) WhereNotIn(field string, in interface{}) *DB

+ func (r *DB) WhereNotNull(field string) *DB

+ func (r *DB) WhereNull(field string) *DB

+ func (r *DB) WhereRaw(raw string) *DB

+ type Table struct

+ func (t *Table) BigIncrements(colNm string) *Table

+ func (t *Table) BigInt(colNm string) *Table

+ func (t *Table) Change()

+ func (t *Table) Char(colNm string, len uint64) *Table

+ func (t *Table) Collation(coll string) *Table

+ func (t *Table) Comment(cmt string) *Table

+ func (t *Table) Date(colNm string, isDefault bool) *Table

+ func (t *Table) DateTime(colNm string, isDefault bool) *Table

+ func (t *Table) DateTimeTz(colNm string, isDefault bool) *Table

+ func (t *Table) DblPrecision(colNm string) *Table

+ func (t *Table) Decimal(colNm string, precision, scale uint64) *Table

+ func (t *Table) Default(val interface{}) *Table

+ func (t *Table) DropColumn(colNm string)

+ func (t *Table) DropIndex(idxNm string)

+ func (t *Table) ForeignKey(idxName, rfcTbl, onCol string) *Table

+ func (t *Table) Increments(colNm string) *Table

+ func (t *Table) Index(idxName string) *Table

+ func (t *Table) Integer(colNm string) *Table

+ func (t *Table) Json(colNm string) *Table

+ func (t *Table) Jsonb(colNm string) *Table

+ func (t *Table) NotNull() *Table

+ func (t *Table) Numeric(colNm string, precision, scale uint64) *Table

+ func (t *Table) Point(colNm string) *Table

+ func (t *Table) Polygon(colNm string) *Table

+ func (t *Table) Rename(from, to string) *Table

+ func (t *Table) SmallInt(colNm string) *Table

+ func (t *Table) String(colNm string, len uint64) *Table

+ func (t *Table) TableComment(cmt string)

+ func (t *Table) Text(colNm string) *Table

+ func (t *Table) Time(colNm string, isDefault bool) *Table

+ func (t *Table) TsQuery(colNm string) *Table

+ func (t *Table) TsVector(colNm string) *Table

+ func (t *Table) Unique(idxName string) *Table

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