pg

func Conn ¶

func Conn() *sqlx.DB

Conn - Gives default connection

func Connect ¶

func Connect(
	gtx context.Context, url *url.URL, timeZone string) (*sqlx.DB, error)

connect - connects to DB based on connection string or URL

func ConnectWithOpts ¶

func ConnectWithOpts(
	gtx context.Context, opts *ConnOpts) (*sqlx.DB, error)

ConnectWithOpts - connect to postgresdb based on given options

func GetFilterValues ¶

func GetFilterValues(
	gtx context.Context,
	dtype string,
	specs []*data.FilterSpec,
	filter *data.Filter) (*data.FilterValues, error)

func InsertQuery ¶

func InsertQuery(table string, fields ...string) string

InsertQuery - creates a basic insert/create query from table name and fields. This query should only be used with named exec i.e with name parameters. The field names are also used to name the parameters

func NamedConn ¶

func NamedConn(name string) *sqlx.DB

NamedConn - gives connection to database associated with given name. If no connection exists with given name nil is returned. If name is empty default connection is returned

func NewGetterDeleter ¶

func NewGetterDeleter() data.GetterDeleter

func PrintDbTime ¶

func PrintDbTime()

func Rollback ¶

func Rollback(op string, tx *sqlx.Tx)

func SetDefaultConn ¶

func SetDefaultConn(db *sqlx.DB)

SetDefaultConn - sets the default postgres connection

func SetNamedConn ¶

func SetNamedConn(name string, db *sqlx.DB)

SetNamedConn - register a postgres connection against name

func Wrap ¶

func Wrap(cmd *cli.Command) *cli.Command