sqlite

Documentation

Index

• type Options
  • func (opts *Options) Create() (*sqlds.Datastore, error)
• type Queries
  • func NewQueries(tbl string) Queries
  • func (q Queries) Delete() string
  • func (q Queries) Exists() string
  • func (q Queries) Get() string
  • func (q Queries) GetSize() string
  • func (q Queries) Limit() string
  • func (q Queries) Offset() string
  • func (q Queries) Prefix() string
  • func (q Queries) Put() string
  • func (q Queries) Query() string

Types

type Options

type Options struct {
	Driver string
	DSN    string
	Table  string
	// Don't try to create table
	NoCreate bool

	// sqlcipher extension specific
	Key            []byte
	CipherPageSize uint
}

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

func (*Options) Create

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

Create returns a datastore connected to sqlite

type Queries

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

Queries are the sqlite queries for a given table.

func NewQueries

func NewQueries(tbl string) Queries

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

func (Queries) Delete

func (q Queries) Delete() string

Delete returns the sqlite query for deleting a row.

func (Queries) Exists

func (q Queries) Exists() string

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

func (Queries) Get

func (q Queries) Get() string

Get returns the sqlite query for getting a row.

func (Queries) GetSize

func (q Queries) GetSize() string

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

func (Queries) Limit

func (q Queries) Limit() string

Limit returns the sqlite query fragment for limiting results.

func (Queries) Offset

func (q Queries) Offset() string

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

func (Queries) Prefix

func (q Queries) Prefix() string

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

func (Queries) Put

func (q Queries) Put() string

Put returns the sqlite query for putting a row.

func (Queries) Query

func (q Queries) Query() string

Query returns the sqlite query for getting multiple rows.