postgres

package

v0.3.0 Latest Latest Go to latest Published: Jan 28, 2022 License: MIT Imports: 4 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.

This section is empty.

type Options struct {
	Host     string
	Port     string
	User     string
	Password string
	Database string
	Table    string
}

Options are the postgres datastore options, reexported here for convenience.

func (opts *Options) Create() (*sqlds.Datastore, error)

Create returns a datastore connected to postgres

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

Queries are the postgres queries for a given table.

func NewQueries(tbl string) Queries

NewQueries creates a new PostgreSQL set of queries for the passed table

func (q Queries) Delete() string

Delete returns the postgres query for deleting a row.

func (q Queries) Exists() string

Exists returns the postgres query for determining if a row exists.

func (q Queries) Get() string

Get returns the postgres query for getting a row.

func (q Queries) GetSize() string

GetSize returns the postgres query for determining the size of a value.

func (q Queries) Limit() string

Limit returns the postgres query fragment for limiting results.

func (q Queries) Offset() string

Offset returns the postgres query fragment for returning rows from a given offset.

func (q Queries) Prefix() string

Prefix returns the postgres query fragment for getting a rows with a key prefix.

func (q Queries) Put() string

Put returns the postgres query for putting a row.

func (q Queries) Query() string

Query returns the postgres query for getting multiple rows.