psql

Mar 21, 2024

Changes in this version

type Set

+ func (s *Set) Scan(src any) error

+ func (s *Set) Set(k string)

+ func (s *Set) Unset(k string)

+ func (s Set) Has(k string) bool

+ func (s Set) Value() (driver.Value, error)

Mar 20, 2024

Changes in this version

+ func Factory[T any]() *T

+ type FindInSet struct

+ Field any

+ Value string

+ func (f *FindInSet) EscapeValue() string

+ func (f *FindInSet) String() string

type TableMeta

+ func (t *TableMeta[T]) Factory() *T

Mar 14, 2024

Changes in this version

type Future

+ func (f *Future[T]) Resolve(ctx context.Context) (*T, error)

Jan 21, 2024

Changes in this version

+ type Future struct

+ func Lazy[T any](col, val string) *Future[T]

+ func (f *Future[T]) MarshalContextJSON(ctx context.Context) ([]byte, error)

+ func (f *Future[T]) MarshalJSON() ([]byte, error)

Dec 18, 2023

Changes in this version

+ var ErrDeleteBadAssert = errors.New("delete operation failed assertion")

+ func DeleteOne[T any](ctx context.Context, where any, opts ...*FetchOptions) error

type TableMeta

+ func (t *TableMeta[T]) DeleteOne(ctx context.Context, where any, opts ...*FetchOptions) error

Dec 18, 2023

Changes in this version

type QueryBuilder

+ func (q *QueryBuilder) ExecQuery(ctx context.Context) (sql.Result, error)

Dec 18, 2023

Changes in this version

+ func Delete[T any](ctx context.Context, where any, opts ...*FetchOptions) error

type TableMeta

+ func (t *TableMeta[T]) Delete(ctx context.Context, where any, opts ...*FetchOptions) error

Nov 15, 2023

Changes in this version

type Logger

+ DebugContext func(ctx context.Context, msg string, args ...any)

Jul 18, 2023

Changes in this version

+ func SetLogger(l Logger)

+ type Logger interface

+ Printf func(format string, v ...any)

Jul 17, 2023

Changes in this version

+ func DefineMagicType(typ string, definition string)

type EscapeValueable

+ func Between(a, start, end any) EscapeValueable

Jun 30, 2023

Changes in this version

+ func FetchGrouped(ctx context.Context, where map[string]any, key string, opts ...*FetchOptions) (map[string][]*T, error)

+ func FetchMapped(ctx context.Context, where map[string]any, key string, opts ...*FetchOptions) (map[string]*T, error)

type TableMeta

+ func (t *TableMeta[T]) FetchGrouped(ctx context.Context, where any, key string, opts ...*FetchOptions) (map[string][]*T, error)

+ func (t *TableMeta[T]) FetchMapped(ctx context.Context, where any, key string, opts ...*FetchOptions) (map[string]*T, error)

Jun 23, 2023

Changes in this version

+ var ErrNotReady = errors.New("database is not ready (no connection is available)")

Jun 14, 2023

Changes in this version

+ func EscapeTx(ctx context.Context) (context.Context, bool)

Mar 7, 2023

Changes in this version

type EscapeValueable

+ func Gt(a, b any) EscapeValueable

+ func Gte(a, b any) EscapeValueable

+ func Lt(a, b any) EscapeValueable

+ func Lte(a, b any) EscapeValueable

+ type Not struct

+ V any

+ func (n *Not) EscapeValue() string

type QueryBuilder

+ LimitData []int

+ func (q *QueryBuilder) Prepare(ctx context.Context) (*sql.Stmt, error)

+ func (q *QueryBuilder) RenderArgs() (string, []any, error)

+ func (q *QueryBuilder) RunQuery(ctx context.Context) (*sql.Rows, error)

Mar 6, 2023

Changes in this version

type QueryBuilder

+ OrderByData []SortValueable

+ type SortValueable interface

+ func S(field ...string) SortValueable

Feb 23, 2023

Changes in this version

+ var ErrTxAlreadyProcessed = errors.New("transaction has already been committed or rollbacked")

+ type TxProxy struct

+ func (t *TxProxy) BeginTx(ctx context.Context, opts *sql.TxOptions) (*TxProxy, error)

+ func (tx *TxProxy) Commit() error

+ func (tx *TxProxy) Rollback() error

Feb 14, 2023

Changes in this version

+ func Count(ctx context.Context, where map[string]any) (int, error)

type TableMeta

+ func (t *TableMeta[T]) Count(ctx context.Context, where map[string]any) (int, error)

Feb 10, 2023

Changes in this version

type FetchOptions

+ LimitCount int

+ LimitStart int

+ Sort []string

+ func Limit(cnt int) *FetchOptions

+ func LimitFrom(start, cnt int) *FetchOptions

+ func Sort(fields ...string) *FetchOptions

Jan 17, 2023

Changes in this version

+ var FetchLock = &FetchOptions

+ type FetchOptions struct

+ Lock bool

Jan 17, 2023

Changes in this version

+ func BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ func ContextConn(ctx context.Context, conn *sql.Conn) context.Context

+ func ContextDB(ctx context.Context, db *sql.DB) context.Context

+ func ContextTx(ctx context.Context, tx *sql.Tx) context.Context

+ func Tx(ctx context.Context, cb func(ctx context.Context) error) error

Oct 29, 2022

Changes in this version

+ func Get(ctx context.Context, where map[string]any) (*T, error)

type TableMeta

+ func (t *TableMeta[T]) Get(ctx context.Context, where map[string]interface{}) (*T, error)

Oct 23, 2022

Changes in this version

+ func InsertIgnore(ctx context.Context, target ...*T) error

+ func Replace(ctx context.Context, target ...*T) error

type TableMeta

+ func (t *TableMeta[T]) InsertIgnore(ctx context.Context, targets ...*T) error

+ func (t *TableMeta[T]) Replace(ctx context.Context, targets ...*T) error

Oct 17, 2022

Changes in this version

+ func InitCfg(cfg *mysql.Config) error

Oct 17, 2022

Changes in this version

type TableMeta

+ func (t *TableMeta[T]) Update(ctx context.Context, target ...*T) error

Oct 16, 2022

Changes in this version

+ func HasChanged(obj *T) bool

type TableMeta

+ func (t *TableMeta[T]) HasChanged(obj any) bool

+ type TableMetaIntf interface

+ Name func() string

Oct 16, 2022

Changes in this version

+ const NameQuoteChar

+ const NameQuoteRune

+ var ErrNotNillable = errors.New("field is nil but cannot be nil")

+ var FormatTableName = formatCamelSnakeCase

+ func ErrorNumber(err error) uint16

+ func Escape(val any) string

+ func Exec(q *SQLQuery) error

+ func Fetch(ctx context.Context, obj any, where map[string]any) ([]any, error)

+ func FetchOne(ctx context.Context, target any, where map[string]any) error

+ func Init(dsn string) error

+ func Insert(ctx context.Context, target ...interface{}) error

+ func IsNotExist(err error) bool

+ func Query(q *SQLQuery, cb func(*sql.Rows) error) error

+ func QueryContext(ctx context.Context, q *SQLQuery, cb func(*sql.Rows) error) error

+ func QuoteName(v string) string

+ func Raw(s string) any

+ func Update(ctx context.Context, target ...interface{}) error

+ func V(v driver.Value) driver.Value

+ type Comparison struct

+ A any

+ B any

+ Op string

+ func Equal(a, b any) *Comparison

+ func (c *Comparison) EscapeValue() string

+ type Error struct

+ Err error

+ Query string

+ func (e *Error) Error() string

+ func (e *Error) Unwrap() error

+ type EscapeTableable interface

+ EscapeTable func() string

+ type EscapeValueable interface

+ EscapeValue func() string

+ func F(field ...string) EscapeValueable

+ type Hex []byte

+ func (h *Hex) Scan(src interface{}) error

+ func (h *Hex) Value() (driver.Value, error)

+ type Key struct

+ type Like struct

+ Field any

+ Like string

+ func (l *Like) EscapeValue() string

+ func (l *Like) String() string

+ type Name struct

+ type QueryBuilder struct

+ CalcFoundRows bool

+ Distinct bool

+ Fields []any

+ FieldsSet []any

+ ForUpdate bool

+ GroupBy []any

+ InsertIgnore bool

+ Limit []int

+ OrderBy []any

+ Query string

+ Tables []EscapeTableable

+ UpdateIgnore bool

+ WhereData WhereAND

+ func B() *QueryBuilder

+ func (q *QueryBuilder) AlsoSelect(fields ...any) *QueryBuilder

+ func (q *QueryBuilder) Delete() *QueryBuilder

+ func (q *QueryBuilder) From(table any) *QueryBuilder

+ func (q *QueryBuilder) Insert(fields ...any) *QueryBuilder

+ func (q *QueryBuilder) Into(table EscapeTableable) *QueryBuilder

+ func (q *QueryBuilder) Render() (string, error)

+ func (q *QueryBuilder) Replace(table EscapeTableable) *QueryBuilder

+ func (q *QueryBuilder) Select(fields ...any) *QueryBuilder

+ func (q *QueryBuilder) Set(fields ...any) *QueryBuilder

+ func (q *QueryBuilder) Table(table any) *QueryBuilder

+ func (q *QueryBuilder) Update(table any) *QueryBuilder

+ func (q *QueryBuilder) Where(where ...any) *QueryBuilder

+ type SQLQuery struct

+ Args []any

+ Query string

+ func Q(q string, args ...any) *SQLQuery

+ type Set struct

+ K any

+ V any

+ func (s *Set) EscapeValue() string

+ type ShowFieldsResult struct

+ Collation *string

+ Comment string

+ Default *string

+ Extra string

+ Field string

+ Key string

+ Null string

+ Privileges string

+ Type string

+ Virtual Name

+ type ShowIndexResult struct

+ Cardinality int64

+ Collation string

+ ColumnName string

+ Comment string

+ IndexComment string

+ IndexType string

+ KeyName string

+ NonUnique bool

+ Null string

+ SeqInIndex int64

+ SubPart *int64

+ Table string

+ Virtual Name

+ type TableMeta struct

+ func GetTableMeta(typ reflect.Type) *TableMeta

+ func Table(obj any) *TableMeta

+ func (t *TableMeta) Fetch(ctx context.Context, where map[string]interface{}) ([]interface{}, error)

+ func (t *TableMeta) FetchOne(ctx context.Context, target interface{}, where map[string]interface{}) error

+ func (t *TableMeta) Insert(ctx context.Context, targets ...any) error

+ func (t *TableMeta) Name() string

+ func (t *TableMeta) ScanTo(row *sql.Rows, v any) error

+ type WhereAND []any

+ func (w WhereAND) EscapeValue() string

+ func (w WhereAND) String() string

+ type WhereOR []any

+ func (w WhereOR) EscapeValue() string

+ func (w WhereOR) String() string