postgres

package

v0.0.0-...-0764311 Latest Latest Go to latest Published: Jan 22, 2024 License: MIT Imports: 12 Imported by: 0

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 NewPGDialect(ctx context.Context, dsn string) (dialect.Dialect, error)

NewPGDialect initializes a new PGDialect instance.

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

PGDialect manages a connection with PostgreSQL.

func (d *PGDialect) BulkInsert(ctx context.Context, table dialect.Table, data []map[string]interface{}) error

BulkInsert inserts multiple data a single database transaction. It disables triggers to avoid conflicts on foreign constraints.

func (d *PGDialect) Close(ctx context.Context) error

Close closes a connection.

func (d *PGDialect) Columns(ctx context.Context, tableName string) ([]dialect.Column, error)

Columns returns sorted columns with types of a table.

func (d *PGDialect) ForeignKeys(ctx context.Context, tableName string) (dialect.ForeignKeys, error)

ForeignKeys returns the foreign keys of a table.

func (d *PGDialect) PrimaryKeyConstraint(ctx context.Context, tableName string) (string, error)

PrimaryKeyConstraint returns the primary key constraint of a table.

func (d *PGDialect) PrimaryKeys(ctx context.Context, tableName string) ([]dialect.PrimaryKey, error)

PrimaryKeys returns primary keys of a table.

func (d *PGDialect) ReferenceKeys(ctx context.Context, tableName string) (dialect.ReferenceKeys, error)

ReferenceKeys returns the "Referenced by" constraints of a table.

func (d *PGDialect) ResultSet(ctx context.Context, query string, args ...interface{}) ([]map[string]interface{}, error)

ResultSet executes a query and converts Rows in map[string]interface{}.

func (d *PGDialect) Table(ctx context.Context, tableName string) (dialect.Table, error)

Table returns a table with its reference keys, foreign keys, columns and primary keys.

func (d *PGDialect) Tables(ctx context.Context) (dialect.Tables, error)

Tables returns all the tables from the database.