postgres

package

v0.14.7 Latest Latest Go to latest Published: Aug 7, 2022 License: MPL-2.0 Imports: 21 Imported by: 2

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

func Connect(ctx context.Context, dsnURI string) (*pgxpool.Pool, error)

Connect connects to the given DSN and returns a pgxpool

type PgDatabase struct {
	// contains filtered or unexported fields
}

func NewPgDatabase(ctx context.Context, logger hclog.Logger, dsn string, sd schema.Dialect) (*PgDatabase, error)

func (p PgDatabase) Begin(ctx context.Context) (execution.TXQueryExecer, error)

func (p PgDatabase) Close()

func (p PgDatabase) CopyFrom(ctx context.Context, resources schema.Resources, shouldCascade bool) error

CopyFrom copies all resources from []*Resource

func (p PgDatabase) Delete(ctx context.Context, t *schema.Table, kvFilters []interface{}) error

func (p PgDatabase) Dialect() schema.Dialect

func (p PgDatabase) Exec(ctx context.Context, query string, args ...interface{}) error

Exec allows executions of postgres queries with given args returning error of execution

func (p PgDatabase) Insert(ctx context.Context, t *schema.Table, resources schema.Resources, shouldCascade bool) error

Insert inserts all resources to given table, table and resources are assumed from same table.

func (p PgDatabase) Query(ctx context.Context, query string, args ...interface{}) (pgx.Rows, error)

Query allows execution of postgres queries with given args returning data result

func (p PgDatabase) QueryOne(ctx context.Context, query string, args ...interface{}) pgx.Row

QueryOne allows execution of postgres queries with given args returning data result

func (p PgDatabase) RawCopyFrom(ctx context.Context, r io.Reader, sql string) error

func (p PgDatabase) RawCopyTo(ctx context.Context, w io.Writer, sql string) error

func (p PgDatabase) RemoveStaleData(ctx context.Context, t *schema.Table, executionStart time.Time, kvFilters []interface{}) error

type PgTx struct {
	pgx.Tx
}

func (p PgTx) Begin(ctx context.Context) (execution.TXQueryExecer, error)

func (p PgTx) Exec(ctx context.Context, query string, args ...interface{}) error

type UUID struct {
	pgtype.UUID
}

func (u UUID) Get() interface{}

func (u UUID) String() string