database

Jan 8, 2025

Changes in this version

type Finder

+ Cursor func(args ...any) (*sqlx.Rows, error)

Dec 24, 2024

Changes in this version

type Finder

+ QuoteFields func(quoted bool) Finder[T]

type Inserter

+ QuoteFields func(quoted bool) Inserter[T]

type Updater

+ QuoteFields func(quoted bool) Updater[T]

Sep 18, 2024

Changes in this version

+ type Commander interface

+ Command func(cmd string) Commander

+ Exec func(args ...any) (sql.Result, error)

+ NumericArgs func(isNumeric bool) Commander

+ Replace func(old string, new string) Commander

+ func NewCMD(db Executable) Commander

+ type Counter interface

+ NumericArgs func(isNumeric bool) Counter

+ Query func(query string) Counter

+ Replace func(old string, new string) Counter

+ Result func(args ...any) (int64, error)

+ func NewCounter(db *sqlx.DB) Counter

+ type Finder interface

+ NumericArgs func(isNumeric bool) Finder[T]

+ Query func(query string) Finder[T]

+ Replace func(old string, new string) Finder[T]

+ Resolve func(resolver func(*T) error) Finder[T]

+ Result func(args ...any) ([]T, error)

+ Single func(args ...any) (*T, error)

+ func NewFinder[T any](db *sqlx.DB) Finder[T]

+ type Inserter interface

+ Insert func(entity T) (sql.Result, error)

+ NumericArgs func(isNumeric bool) Inserter[T]

+ Table func(table string) Inserter[T]

+ func NewInserter[T any](db Executable) Inserter[T]

type QueryBuilder

+ Args func() []any

+ NumericArgs func(bool) QueryBuilder

+ NumericStart func(int) QueryBuilder

+ Raw func() string

+ Replace func(string, string) QueryBuilder

+ SQL func(query string) string

+ type Updater interface

+ NumericArgs func(isNumeric bool) Updater[T]

+ Table func(table string) Updater[T]

+ Update func(entity T) (sql.Result, error)

+ Where func(cond string, args ...any) Updater[T]

+ func NewUpdater[T any](db Executable) Updater[T]

Sep 15, 2024

Changes in this version

type QueryBuilder

+ RawPostgres func(counter int) string

+ RawSQL func() string

+ ToPostgres func(query string, counter int, replacements ...string) string

Sep 6, 2024

Changes in this version

+ func CountOpt(db *sqlx.DB, query string, option Option[int64], args ...any) (int64, error)

+ func FindOneOpt[T any](db *sqlx.DB, query string, option Option[T], args ...any) (*T, error)

+ func FindOpt[T any](db *sqlx.DB, query string, option Option[T], args ...any) ([]T, error)

+ func InsertOpt[T any](db Executable, entity T, table string, option Option[T]) (sql.Result, error)

+ func UpdateOpt[T any](db Executable, entity T, table string, condition string, option Option[T], ...) (sql.Result, error)

Sep 5, 2024

Changes in this version

type Option

+ WithArgs func(...any) Option[T]

+ WithDriver func(Driver) Option[T]

+ WithPlaceholder func(...string) Option[T]

+ WithResolver func(Resolver[T]) Option[T]

Sep 5, 2024

Changes in this version

+ type RepoOption struct

+ func NewOption[T any]() *RepoOption[T]

+ func (opt *RepoOption[T]) WithArgs(args ...any) *RepoOption[T]

+ func (opt *RepoOption[T]) WithDriver(driver Driver) *RepoOption[T]

+ func (opt *RepoOption[T]) WithPlaceholder(oldNew ...string) *RepoOption[T]

+ func (opt *RepoOption[T]) WithResolver(resolver Resolver[T]) *RepoOption[T]

Sep 3, 2024

Changes in this version

+ type Executable interface

+ Exec func(string, ...any) (sql.Result, error)

+ type Option struct

+ func (opt Option[T]) Replacer() *strings.Replacer

+ func (opt Option[T]) ReplacerWithFields(fields string) *strings.Replacer

+ type RepositoryOpt func(*Option[T])

+ func WithArgs[T any](args ...any) RepositoryOpt[T]

+ func WithDriver[T any](driver Driver) RepositoryOpt[T]

+ func WithPlaceholder[T any](oldNew ...string) RepositoryOpt[T]

+ func WithResolver[T any](resolver ...Resolver[T]) RepositoryOpt[T]

+ func WithTable[T any](table string) RepositoryOpt[T]

+ type Resolver func(*T) error

Jul 11, 2024

Changes in this version

type QueryBuilder

+ AndClosureIf func(ifCond bool, cond string, args ...any) QueryBuilder

+ AndIf func(ifCond bool, cond string, args ...any) QueryBuilder

+ OrClosureIf func(ifCond bool, cond string, args ...any) QueryBuilder

+ OrIf func(ifCond bool, cond string, args ...any) QueryBuilder

Jul 11, 2024

Changes in this version

+ func InsertTx(tx *sql.Tx, entity any, table string, driver Driver) (sql.Result, error)

+ func UpdateTx(tx *sql.Tx, entity any, table string, driver Driver, condition string, ...) (sql.Result, error)

type QueryBuilder

+ ToString func(pattern string, counter int, params ...any) string

Jun 29, 2024

Changes in this version

+ func Count(db *sqlx.DB, driver Driver, query string, args ...any) (int64, error)

+ func FindOne[T any](db *sqlx.DB, driver Driver, query string, resolver func(*T), args ...any) (*T, error)

+ func Find[T any](db *sqlx.DB, driver Driver, query string, resolver func(*T), args ...any) ([]T, error)

+ func Insert(db *sqlx.DB, entity any, table string, driver Driver) (sql.Result, error)

+ func NewMySQLConnector(host string, username string, password string, database string) (*sqlx.DB, error)

+ func NewPostgresConnector(host string, port string, user string, password string, database string) (*sqlx.DB, error)

+ func ResolveInsert[T any](entity T, table string, driver Driver) (string, []any)

+ func ResolveQuery[T any](query string, driver Driver) string

+ func ResolveUpdate[T any](entity T, table string, driver Driver, condition string, args ...any) (string, []any)

+ func Update(db *sqlx.DB, entity any, table string, driver Driver, condition string, ...) (sql.Result, error)

+ type Driver string

+ const DriverMySQL

+ const DriverPostgres

+ type IDecoder interface

+ Decode func() error

+ type Query struct

+ Closure bool

+ Params []any

+ Query string

+ Type string

+ type QueryBuilder interface

+ And func(cond string, args ...any)

+ AndClosure func(cond string, args ...any)

+ Or func(cond string, args ...any)

+ OrClosure func(cond string, args ...any)

+ Params func() []any

+ ToSQL func(counter int) string

+ func NewQuery(driver Driver) QueryBuilder