sqlite3

Documentation

Index

• type DataType
• type Layout
  • func (la *Layout) AddField(name string, dtype DataType, primaryKey, autoIncr bool)
  • func (la *Layout) SetTableName(name string)
• type SQLite
  • func (sq *SQLite) Close() error
  • func (sq *SQLite) CreateTable(tableName, table string) error
  • func (sq *SQLite) CreateTableFromLayout(la Layout) error
  • func (sq *SQLite) DropTable(tableName string) error
  • func (sq *SQLite) Lock()
  • func (sq *SQLite) Open(dataSourceName string) error
  • func (sq *SQLite) TableExists(tableName string) (bool, error)
  • func (sq *SQLite) Unlock()
  • func (sq *SQLite) Vacuum() error

Types

type DataType

type DataType string

const (
	TypeTEXT    DataType = "TEXT"
	TypeNUMERIC DataType = "NUMERIC"
	TypeINTEGER DataType = "INTEGER"
	TypeREAL    DataType = "REAL"
	TypeBLOB    DataType = "BLOB"
	TypeDATE    DataType = "DATE"
)

type Layout

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

func (*Layout) AddField

func (la *Layout) AddField(name string, dtype DataType, primaryKey, autoIncr bool)

func (*Layout) SetTableName

func (la *Layout) SetTableName(name string)

type SQLite

type SQLite struct {
	DB   *sql.DB
	Tx   *sql.Tx
	Rows *sql.Rows
	// contains filtered or unexported fields
}

func (*SQLite) Close

func (sq *SQLite) Close() error

func (*SQLite) CreateTable

func (sq *SQLite) CreateTable(tableName, table string) error

func (*SQLite) CreateTableFromLayout

func (sq *SQLite) CreateTableFromLayout(la Layout) error

func (*SQLite) DropTable

func (sq *SQLite) DropTable(tableName string) error

func (*SQLite) Lock

func (sq *SQLite) Lock()

func (*SQLite) Open

func (sq *SQLite) Open(dataSourceName string) error

func (*SQLite) TableExists

func (sq *SQLite) TableExists(tableName string) (bool, error)

func (*SQLite) Unlock

func (sq *SQLite) Unlock()

func (*SQLite) Vacuum

func (sq *SQLite) Vacuum() error