sqluct

Apr 5, 2024

Changes in this version

type JSON

+ func (s *JSON[V]) UnmarshalJSON(bytes []byte) error

+ func (s JSON[V]) MarshalJSON() ([]byte, error)

Aug 24, 2023

Changes in this version

+ type JSON struct

+ Val V

+ func (s *JSON[V]) Scan(src any) error

+ func (s JSON[V]) Value() (driver.Value, error)

Jun 19, 2023

Changes in this version

+ const SerialID

+ type Quoted string

type Referencer

+ func (r *Referencer) Col(ptr interface{}) string

+ func (r *Referencer) Eq(ptr interface{}, val interface{}) squirrel.Eq

type Storage

+ func (s *Storage) MakeReferencer() *Referencer

+ type StorageOf struct

+ R *V

+ func Table(storage *Storage, tableName string) StorageOf[V]

+ func (s *StorageOf[V]) DeleteStmt() squirrel.DeleteBuilder

+ func (s *StorageOf[V]) Get(ctx context.Context, qb ToSQL) (V, error)

+ func (s *StorageOf[V]) InsertRow(ctx context.Context, row V, options ...func(o *Options)) (int64, error)

+ func (s *StorageOf[V]) InsertRows(ctx context.Context, rows []V, options ...func(o *Options)) (sql.Result, error)

+ func (s *StorageOf[V]) List(ctx context.Context, qb ToSQL) ([]V, error)

+ func (s *StorageOf[V]) SelectStmt(options ...func(*Options)) squirrel.SelectBuilder

+ func (s *StorageOf[V]) UpdateStmt(value any, options ...func(*Options)) squirrel.UpdateBuilder

Jan 4, 2023

Changes in this version

+ type Plain = StringStatement

type ToSQL

+ func Stmt(query string, args ...interface{}) ToSQL

Jan 4, 2023

Changes in this version

+ func Get(ctx context.Context, s *Storage, qb ToSQL) (V, error)

+ func List(ctx context.Context, s *Storage, qb ToSQL) ([]V, error)

type Storage

+ func Open(driverName, dataSourceName string) (*Storage, error)

Oct 11, 2022

Changes in this version

+ const DialectMySQL

+ const DialectPostgres

+ const DialectSQLite3

+ const DialectUnknown

+ func InsertIgnore(o *Options)

+ type Dialect string

type Mapper

+ Dialect Dialect

type Options

+ InsertIgnore bool

Jul 2, 2021

Changes in this version

type Referencer

+ func (r *Referencer) Cols(ptr interface{}) []string

May 24, 2021

Changes in this version

type Storage

+ func (s *Storage) DB() *sqlx.DB

Apr 28, 2021

Changes in this version

type Options

+ PrepareColumn func(col string) string

type Referencer

+ func (r *Referencer) ColumnsOf(rowStructPtr interface{}) func(o *Options)

Feb 22, 2021

Changes in this version

+ func IgnoreOmitEmpty(o *Options)

type Options

+ IgnoreOmitEmpty bool

Jan 7, 2021

Changes in this version

+ func QuoteANSI(tableAndColumn ...string) string

+ func QuoteBackticks(tableAndColumn ...string) string

+ func QuoteNoop(tableAndColumn ...string) string

type Mapper

+ func (sm *Mapper) FindColumnNames(structPtr interface{}) (map[interface{}]string, error)

+ type Referencer struct

+ IdentifierQuoter func(tableAndColumn ...string) string

+ Mapper *Mapper

+ func (r *Referencer) AddTableAlias(rowStructPtr interface{}, alias string)

+ func (r *Referencer) Fmt(format string, ptrs ...interface{}) string

+ func (r *Referencer) Q(tableAndColumn ...string) string

+ func (r *Referencer) Ref(ptr interface{}) string

type Storage

+ IdentifierQuoter func(tableAndColumn ...string) string

+ func (s *Storage) Ref() *Referencer

Dec 10, 2020

Changes in this version

type Mapper

+ func (sm *Mapper) ColumnsValues(v reflect.Value, options ...func(*Options)) ([]string, []interface{})

Dec 8, 2020

Changes in this version

+ func Columns(columns ...string) func(o *Options)

+ func OrderDesc(o *Options)

+ func SkipZeroValues(o *Options)

+ func TxFromContext(ctx context.Context) *sqlx.Tx

+ func TxToContext(ctx context.Context, tx *sqlx.Tx) context.Context

+ type Mapper struct

+ ReflectMapper *reflectx.Mapper

+ func (sm *Mapper) Col(structPtr, fieldPtr interface{}) string

+ func (sm *Mapper) FindColumnName(structPtr, fieldPtr interface{}) (string, error)

+ func (sm *Mapper) Insert(q squirrel.InsertBuilder, val interface{}, options ...func(*Options)) squirrel.InsertBuilder

+ func (sm *Mapper) Order(columns interface{}, options ...func(*Options)) string

+ func (sm *Mapper) Select(q squirrel.SelectBuilder, columns interface{}, options ...func(*Options)) squirrel.SelectBuilder

+ func (sm *Mapper) Update(q squirrel.UpdateBuilder, val interface{}, options ...func(*Options)) squirrel.UpdateBuilder

+ func (sm *Mapper) WhereEq(conditions interface{}, options ...func(*Options)) squirrel.Eq

+ type Options struct

+ Columns []string

+ OrderDesc bool

+ SkipZeroValues bool

+ type Storage struct

+ Format squirrel.PlaceholderFormat

+ Mapper *Mapper

+ OnError func(ctx context.Context, err error)

+ Trace func(ctx context.Context, stmt string, args []interface{}) (newCtx context.Context, onFinish func(error))

+ func NewStorage(db *sqlx.DB) *Storage

+ func (s *Storage) Col(structPtr, fieldPtr interface{}) string

+ func (s *Storage) DeleteStmt(tableName string) squirrel.DeleteBuilder

+ func (s *Storage) Exec(ctx context.Context, qb ToSQL) (res sql.Result, err error)

+ func (s *Storage) InTx(ctx context.Context, fn func(context.Context) error) (err error)

+ func (s *Storage) InsertStmt(tableName string, val interface{}, options ...func(*Options)) squirrel.InsertBuilder

+ func (s *Storage) Query(ctx context.Context, qb ToSQL) (*sqlx.Rows, error)

+ func (s *Storage) QueryBuilder() squirrel.StatementBuilderType

+ func (s *Storage) Select(ctx context.Context, qb ToSQL, dest interface{}) (err error)

+ func (s *Storage) SelectStmt(tableName string, columns interface{}, options ...func(*Options)) squirrel.SelectBuilder

+ func (s *Storage) UpdateStmt(tableName string, val interface{}, options ...func(*Options)) squirrel.UpdateBuilder

+ func (s *Storage) WhereEq(conditions interface{}, options ...func(*Options)) squirrel.Eq

+ type StringStatement string

+ func (s StringStatement) ToSql() (string, []interface{}, error)

+ type ToSQL interface

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