database

Jun 27, 2024

Changes in this version

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

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

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

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

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

+ func ResolveQuery[T any](query string) 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 QueryBuilder

+ func NewQuery(driver Driver) QueryBuilder

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

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

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

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

+ ToSQL func(counter int) string

Jun 22, 2024

Changes in this version

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

Sep 13, 2023

Changes in this version

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

+ type Query struct

+ Closure bool

+ Params []any

+ Query string

+ Type string

+ type QueryBuilder struct

+ func (qb *QueryBuilder) Add(q Query)

+ func (qb *QueryBuilder) Params() (vars []any)

+ func (qb *QueryBuilder) Query() (res string)