sqlite

Documentation

Index

• func CheckConstraints(db *sql.DB, schemaName, tableName string) ([]m.CheckConstraint, error)
• func Columns(db *sql.DB, schemaName, tableName string) ([]m.Column, error)
• func CurrentCatalog(db *sql.DB) (m.Catalog, error)
• func Indexes(db *sql.DB, schemaName, tableName string) ([]m.Index, error)
• func Name() string
• func PrimaryKeys(db *sql.DB, schemaName, tableName string) ([]m.PrimaryKey, error)
• func ReferentialConstraints(db *sql.DB, schemaName, tableName string) ([]m.ReferentialConstraint, error)
• func Schemata(db *sql.DB, nclude, xclude string) ([]m.Schema, error)
• func Tables(db *sql.DB, schemaName string) ([]m.Table, error)
• func UniqueConstraints(db *sql.DB, schemaName, tableName string) ([]m.UniqueConstraint, error)

Functions

func CheckConstraints

func CheckConstraints(db *sql.DB, schemaName, tableName string) ([]m.CheckConstraint, error)

CheckConstraints returns an empty set it is unclear how to extract check constraints from SQLite other than parsing the sqlite_master.sql column

func Columns

func Columns(db *sql.DB, schemaName, tableName string) ([]m.Column, error)

Columns obtains the list of columns for the (schemaName, tableName) parameters and returns the results

func CurrentCatalog

func CurrentCatalog(db *sql.DB) (m.Catalog, error)

CurrentCatalog defines the query for obtaining information about the currently connected catalog (database) and returns the results of executing the query

func Indexes

func Indexes(db *sql.DB, schemaName, tableName string) ([]m.Index, error)

Indexes defines the query for obtaining a list of indexes for the (schemaName, tableName) parameters and returns the results of executing the query

func Name

func Name() string

Name returns the name of the specific database engine

func PrimaryKeys

func PrimaryKeys(db *sql.DB, schemaName, tableName string) ([]m.PrimaryKey, error)

PrimaryKeys defines the query for obtaining the primary keys for the (schemaName, tableName) parameters and returns the results of executing the query

func ReferentialConstraints

func ReferentialConstraints(db *sql.DB, schemaName, tableName string) ([]m.ReferentialConstraint, error)

ReferentialConstraints defines the query for obtaining the referential constraints for the (schemaName, tableName) parameters (as either the parent or child) and returns the results of executing the query

func Schemata

func Schemata(db *sql.DB, nclude, xclude string) ([]m.Schema, error)

Schemata doesn't do much as sqlite doesn't appear to have schemas

func Tables

func Tables(db *sql.DB, schemaName string) ([]m.Table, error)

Tables defines the query for obtaining a list of tables and views for the (schemaName) parameter and returns the results of executing the query

func UniqueConstraints

func UniqueConstraints(db *sql.DB, schemaName, tableName string) ([]m.UniqueConstraint, error)

UniqueConstraints defines the query for obtaining a list of unique constraints for the (schemaName, tableName) parameters and returns the results of executing the query