sqlite3

Documentation

Index

• func New() dbal.Grammar
• type Quoter
  • func (quoter *Quoter) WrapUnion(sql string) string
• type SQLite3
  • func (grammarSQL SQLite3) AlterTable(table *dbal.Table) error
  • func (grammarSQL SQLite3) CompileDelete(query *dbal.Query) (string, []interface{})
  • func (grammarSQL SQLite3) CompileInsertOrIgnore(query *dbal.Query, columns []interface{}, values [][]interface{}) (string, []interface{})
  • func (grammarSQL SQLite3) CompileLock(query *dbal.Query, lock interface{}) string
  • func (grammarSQL SQLite3) CompileSelect(query *dbal.Query) string
  • func (grammarSQL SQLite3) CompileSelectOffset(query *dbal.Query, offset *int) string
  • func (grammarSQL SQLite3) CompileTruncate(query *dbal.Query) ([]string, [][]interface{})
  • func (grammarSQL SQLite3) CompileUpdate(query *dbal.Query, values map[string]interface{}) (string, []interface{})
  • func (grammarSQL SQLite3) CompileUpsert(query *dbal.Query, columns []interface{}, values [][]interface{}, ...) (string, []interface{})
  • func (grammarSQL SQLite3) CompileWheres(query *dbal.Query, wheres []dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) CreateTable(table *dbal.Table) error
  • func (grammarSQL SQLite3) ExecSQL(table *dbal.Table, sql string) error
  • func (grammarSQL SQLite3) GetColumnListing(schemaName string, tableName string) ([]*dbal.Column, error)
  • func (grammarSQL SQLite3) GetConstraintListing(schemaName string, tableName string) (map[string]*dbal.Constraint, error)
  • func (grammarSQL SQLite3) GetIndexListing(dbName string, tableName string) ([]*dbal.Index, error)
  • func (grammarSQL SQLite3) GetOperators() []string
  • func (grammarSQL SQLite3) GetTable(name string) (*dbal.Table, error)
  • func (grammarSQL SQLite3) GetTables() ([]string, error)
  • func (grammarSQL SQLite3) GetVersion() (*dbal.Version, error)
  • func (grammarSQL SQLite3) NewWith(db *sqlx.DB, config *dbal.Config, option *dbal.Option) (dbal.Grammar, error)
  • func (grammarSQL SQLite3) NewWithRead(write *sqlx.DB, writeConfig *dbal.Config, read *sqlx.DB, ...) (dbal.Grammar, error)
  • func (grammarSQL SQLite3) ParseType(column *dbal.Column)
  • func (grammarSQL SQLite3) RenameTable(old string, new string) error
  • func (grammarSQL SQLite3) SQLAddColumn(column *dbal.Column) string
  • func (grammarSQL SQLite3) SQLAddIndex(index *dbal.Index) string
  • func (grammarSQL SQLite3) SQLAddPrimary(primary *dbal.Primary) string
  • func (grammarSQL SQLite3) TableExists(name string) (bool, error)
  • func (grammarSQL SQLite3) WhereDate(query *dbal.Query, where dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) WhereDateBased(typ string, query *dbal.Query, where dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) WhereDay(query *dbal.Query, where dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) WhereMonth(query *dbal.Query, where dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) WhereTime(query *dbal.Query, where dbal.Where, bindingOffset *int) string
  • func (grammarSQL SQLite3) WhereYear(query *dbal.Query, where dbal.Where, bindingOffset *int) string

Functions

func New

func New() dbal.Grammar

Types

type Quoter

type Quoter struct {
	sql.Quoter
}

func (*Quoter) WrapUnion

func (quoter *Quoter) WrapUnion(sql string) string

type SQLite3

type SQLite3 struct {
	sql.SQL
}

func (SQLite3) AlterTable

func (grammarSQL SQLite3) AlterTable(table *dbal.Table) error

func (SQLite3) CompileDelete

func (grammarSQL SQLite3) CompileDelete(query *dbal.Query) (string, []interface{})

func (SQLite3) CompileInsertOrIgnore

func (grammarSQL SQLite3) CompileInsertOrIgnore(query *dbal.Query, columns []interface{}, values [][]interface{}) (string, []interface{})

func (SQLite3) CompileLock

func (grammarSQL SQLite3) CompileLock(query *dbal.Query, lock interface{}) string

func (SQLite3) CompileSelect

func (grammarSQL SQLite3) CompileSelect(query *dbal.Query) string

func (SQLite3) CompileSelectOffset

func (grammarSQL SQLite3) CompileSelectOffset(query *dbal.Query, offset *int) string

func (SQLite3) CompileTruncate

func (grammarSQL SQLite3) CompileTruncate(query *dbal.Query) ([]string, [][]interface{})

func (SQLite3) CompileUpdate

func (grammarSQL SQLite3) CompileUpdate(query *dbal.Query, values map[string]interface{}) (string, []interface{})

func (SQLite3) CompileUpsert

func (grammarSQL SQLite3) CompileUpsert(query *dbal.Query, columns []interface{}, values [][]interface{}, uniqueBy []interface{}, updateValues interface{}) (string, []interface{})

func (SQLite3) CompileWheres

func (grammarSQL SQLite3) CompileWheres(query *dbal.Query, wheres []dbal.Where, bindingOffset *int) string

func (SQLite3) CreateTable

func (grammarSQL SQLite3) CreateTable(table *dbal.Table) error

func (SQLite3) ExecSQL

func (grammarSQL SQLite3) ExecSQL(table *dbal.Table, sql string) error

func (SQLite3) GetColumnListing

func (grammarSQL SQLite3) GetColumnListing(schemaName string, tableName string) ([]*dbal.Column, error)

func (SQLite3) GetConstraintListing

func (grammarSQL SQLite3) GetConstraintListing(schemaName string, tableName string) (map[string]*dbal.Constraint, error)

func (SQLite3) GetIndexListing

func (grammarSQL SQLite3) GetIndexListing(dbName string, tableName string) ([]*dbal.Index, error)

func (SQLite3) GetOperators

func (grammarSQL SQLite3) GetOperators() []string

func (SQLite3) GetTable

func (grammarSQL SQLite3) GetTable(name string) (*dbal.Table, error)

func (SQLite3) GetTables

func (grammarSQL SQLite3) GetTables() ([]string, error)

func (SQLite3) GetVersion

func (grammarSQL SQLite3) GetVersion() (*dbal.Version, error)

func (SQLite3) NewWith

func (grammarSQL SQLite3) NewWith(db *sqlx.DB, config *dbal.Config, option *dbal.Option) (dbal.Grammar, error)

func (SQLite3) NewWithRead

func (grammarSQL SQLite3) NewWithRead(write *sqlx.DB, writeConfig *dbal.Config, read *sqlx.DB, readConfig *dbal.Config, option *dbal.Option) (dbal.Grammar, error)

func (SQLite3) ParseType

func (grammarSQL SQLite3) ParseType(column *dbal.Column)

func (SQLite3) RenameTable

func (grammarSQL SQLite3) RenameTable(old string, new string) error

func (SQLite3) SQLAddColumn

func (grammarSQL SQLite3) SQLAddColumn(column *dbal.Column) string

func (SQLite3) SQLAddIndex

func (grammarSQL SQLite3) SQLAddIndex(index *dbal.Index) string

func (SQLite3) SQLAddPrimary

func (grammarSQL SQLite3) SQLAddPrimary(primary *dbal.Primary) string

func (SQLite3) TableExists

func (grammarSQL SQLite3) TableExists(name string) (bool, error)

func (SQLite3) WhereDate

func (grammarSQL SQLite3) WhereDate(query *dbal.Query, where dbal.Where, bindingOffset *int) string

func (SQLite3) WhereDateBased

func (grammarSQL SQLite3) WhereDateBased(typ string, query *dbal.Query, where dbal.Where, bindingOffset *int) string

func (SQLite3) WhereDay

func (grammarSQL SQLite3) WhereDay(query *dbal.Query, where dbal.Where, bindingOffset *int) string

func (SQLite3) WhereMonth

func (grammarSQL SQLite3) WhereMonth(query *dbal.Query, where dbal.Where, bindingOffset *int) string

func (SQLite3) WhereTime

func (grammarSQL SQLite3) WhereTime(query *dbal.Query, where dbal.Where, bindingOffset *int) string

func (SQLite3) WhereYear

func (grammarSQL SQLite3) WhereYear(query *dbal.Query, where dbal.Where, bindingOffset *int) string