client

Documentation

Index

• Constants
• type DbClient
  • func New(file string) (*DbClient, error)
  • func (client *DbClient) Info() (*Result, error)
  • func (client *DbClient) Query(query string) (*Result, error)
  • func (client *DbClient) Table(table string) (*Result, error)
  • func (client *DbClient) TableIndexes(table string) (*Result, error)
  • func (client *DbClient) TableInfo(table string) (*Result, error)
  • func (client *DbClient) TableSql(table string) ([]string, error)
  • func (client *DbClient) Tables() ([]string, error)
• type Result
  • func (res *Result) CSV() []byte
  • func (res *Result) Format() []map[string]interface{}
• type Row

Constants

const (
	SQLITE_INFO = `` /* 196-byte string literal not displayed */

	SQLITE_TABLES        = "SELECT name FROM sqlite_master WHERE type='table';"
	SQLITE_TABLE_SCHEMA  = "PRAGMA table_info(%s);"
	SQLITE_TABLE_INFO    = "SELECT COUNT(*) FROM %s;"
	SQLITE_TABLE_SQL     = "SELECT sql FROM sqlite_master WHERE type='table' AND name='%s'"
	SQLITE_TABLE_INDEXES = "SELECT * FROM sqlite_master WHERE type='index' AND tbl_name='%s'"
)

Types

type DbClient

type DbClient struct {
	DbFile string
	// contains filtered or unexported fields
}

func New

func New(file string) (*DbClient, error)

func (*DbClient) Info

func (client *DbClient) Info() (*Result, error)

func (*DbClient) Query

func (client *DbClient) Query(query string) (*Result, error)

func (*DbClient) Table

func (client *DbClient) Table(table string) (*Result, error)

Table returns the table structure.

func (*DbClient) TableIndexes

func (client *DbClient) TableIndexes(table string) (*Result, error)

TableIndexes returns the indexes for the given table.

func (*DbClient) TableInfo

func (client *DbClient) TableInfo(table string) (*Result, error)

func (*DbClient) TableSql

func (client *DbClient) TableSql(table string) ([]string, error)

TableSql returns the SQL used to create the given table.

func (*DbClient) Tables

func (client *DbClient) Tables() ([]string, error)

type Result

type Result struct {
	Columns []string `json:"columns"`
	Rows    []Row    `json:"rows"`
}

func (*Result) CSV

func (res *Result) CSV() []byte

func (*Result) Format

func (res *Result) Format() []map[string]interface{}

Format returns a slice of maps. The key in the map represents the column name and the value is the row content.

type Row

type Row []interface{}