sqshared

Documentation

Overview

Package sqshared contains shared types for the sqlite3 and moderncsqlite drivers.

Index

• Variables
• func ConvertBytes(buf []byte, tfmt string) (string, error)
• func NewMetadataReader(db drivers.DB, opts ...metadata.ReaderOption) metadata.Reader
• type MetadataReader
  • func (r MetadataReader) Columns(f metadata.Filter) (*metadata.ColumnSet, error)
  • func (r MetadataReader) FunctionColumns(metadata.Filter) (*metadata.FunctionColumnSet, error)
  • func (r MetadataReader) Functions(f metadata.Filter) (*metadata.FunctionSet, error)
  • func (r MetadataReader) IndexColumns(f metadata.Filter) (*metadata.IndexColumnSet, error)
  • func (r MetadataReader) Indexes(f metadata.Filter) (*metadata.IndexSet, error)
  • func (r MetadataReader) Schemas(f metadata.Filter) (*metadata.SchemaSet, error)
  • func (r *MetadataReader) SetLimit(l int)
  • func (r MetadataReader) Tables(f metadata.Filter) (*metadata.TableSet, error)
• type Time
  • func (t *Time) Parse(s string) error
  • func (t *Time) Scan(v interface{}) error
  • func (t *Time) Value() (driver.Value, error)

Variables

var SQLiteTimestampFormats = []string{

	"2006-01-02 15:04:05.999999999-07:00",
	"2006-01-02T15:04:05.999999999-07:00",
	"2006-01-02 15:04:05.999999999",
	"2006-01-02T15:04:05.999999999",
	"2006-01-02 15:04:05",
	"2006-01-02T15:04:05",
	"2006-01-02 15:04",
	"2006-01-02T15:04",
	"2006-01-02",
}

SQLiteTimestampFormats is timestamp formats understood by both this module and SQLite. The first format in the slice will be used when saving time values into the database. When parsing a string from a timestamp or datetime column, the formats are tried in order.

Functions

func ConvertBytes

func ConvertBytes(buf []byte, tfmt string) (string, error)

ConvertBytes is the byte formatter func for sqlite3 databases.

func NewMetadataReader

func NewMetadataReader(db drivers.DB, opts ...metadata.ReaderOption) metadata.Reader

NewMetadataReader creates the metadata reader for sqlite3 databases.

Types

type MetadataReader

type MetadataReader struct {
	metadata.LoggingReader
	// contains filtered or unexported fields
}

func (MetadataReader) Columns

func (r MetadataReader) Columns(f metadata.Filter) (*metadata.ColumnSet, error)

Columns from selected catalog (or all, if empty), matching schemas and tables

func (MetadataReader) FunctionColumns

func (r MetadataReader) FunctionColumns(metadata.Filter) (*metadata.FunctionColumnSet, error)

func (MetadataReader) Functions

func (r MetadataReader) Functions(f metadata.Filter) (*metadata.FunctionSet, error)

func (MetadataReader) IndexColumns

func (r MetadataReader) IndexColumns(f metadata.Filter) (*metadata.IndexColumnSet, error)

func (MetadataReader) Indexes

func (r MetadataReader) Indexes(f metadata.Filter) (*metadata.IndexSet, error)

func (MetadataReader) Schemas

func (r MetadataReader) Schemas(f metadata.Filter) (*metadata.SchemaSet, error)

func (*MetadataReader) SetLimit

func (r *MetadataReader) SetLimit(l int)

func (MetadataReader) Tables

func (r MetadataReader) Tables(f metadata.Filter) (*metadata.TableSet, error)

type Time

type Time time.Time

Time provides a type that will correctly scan the various timestamps values stored by the github.com/mattn/go-sqlite3 driver for time.Time values, as well as correctly satisfying the sql/driver/Valuer interface.

func (*Time) Parse

func (t *Time) Parse(s string) error

Parse attempts to Parse string s to t.

func (*Time) Scan

func (t *Time) Scan(v interface{}) error

Scan satisfies the Scanner interface.

func (*Time) Value

func (t *Time) Value() (driver.Value, error)

Value satisfies the Valuer interface.