postgres

package

v0.3.0 Latest Latest Go to latest Published: Jan 28, 2022 License: MIT Imports: 4 Imported by: 2

Details

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.