pgxhelper

Dec 5, 2023

Changes in this version

type DatabaseHelper

+ func (dh *DatabaseHelper) AddSort(sort *Sort) (query string)

+ type Dir string

+ var DirAscending Dir = "ASC"

+ var DirDescending Dir = "DESC"

+ type Sort struct

+ Column string

+ Direction Dir

Dec 2, 2023

Changes in this version

+ const OPR_GT

+ const OPR_IS

+ const OPR_IS_NOT

+ const OPR_IS_NULL

+ const OPR_LIKE

+ const OPR_LT

+ const OPR_LTE

+ const OPR_NOT_EQUAL

+ const OPR_NOT_LIKE

Nov 3, 2023

Changes in this version

type DatabaseHelper

+ func (dh *DatabaseHelper) BuildDynamicQuery(values *[]any, opts []*ConditionGroup) string

Sep 9, 2023

Changes in this version

type DBConfig

+ func GetConfigFromEnvOption(keys *KeysConfig) (DBConfig, error)

+ type KeysConfig struct

+ Host string

+ Name string

+ Password string

+ Port string

+ SslMode string

+ Timezone string

+ User string

Sep 5, 2023

Changes in this version

+ const Host

+ const Name

+ const OPR_ANY

+ const OPR_EQUAL

+ const OPR_GTE

+ const OPR_IN

+ const Password

+ const Port

+ const Sslmode

+ const Timezone

+ const User

+ var ErrDuplicateKey = fmt.Errorf("DUPLICATE KEY")

+ var ErrNotFound = fmt.Errorf("NOT FOUND")

+ type Condition struct

+ ColumnName string

+ Operator string

+ Value any

+ type ConditionGroup struct

+ Conditions []*Condition

+ Group *ConditionGroup

+ Join Joiner

+ type Config struct

+ DBName string

+ Host string

+ Password string

+ Port string

+ SslMode string

+ Timezone string

+ User string

+ func (c Config) MakeDSN() string

+ type DBConfig interface

+ MakeDSN func() string

+ func GetConfigFromEnv() (DBConfig, error)

+ type DatabaseHelper struct

+ Pool *pgxpool.Pool

+ func (dh *DatabaseHelper) Exec(ctx context.Context, query string, values ...any) error

+ func (dh *DatabaseHelper) Exist(ctx context.Context, table string, condition string, values ...any) (bool, error)

+ func (dh *DatabaseHelper) MakeTx(ctx context.Context) (pgx.Tx, func(err error) error, error)

+ func (dh *DatabaseHelper) Query(ctx context.Context, scanner Scanner, query string, values ...any) error

+ type Joiner = string

+ const JOINER_AND

+ const JOINER_OR

+ type Scanner = func(row pgx.Row) error