sqlite

package

v0.0.0-...-c914e5a Latest Latest Go to latest Published: Jul 19, 2020 License: MIT Imports: 6 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type Db struct {
	*goqu.Database
	// contains filtered or unexported fields
}

Db wraps goqu.Database to expose a Close method for the underlying database driver

func NewDb(name string) (db *Db, err error)

NewDb creates a new Db

func (db *Db) Close() (err error)

Close closes the database driver

func (db *Db) CreateTable(name string, schema Schema) (err error)

CreateTable creates a table

func (db *Db) DeleteRowsByID(table string, idCol string, ids ...interface{}) (numDeletedRows int64, err error)

DeleteRowsByID deletes rows from a table by their ids

func (db *Db) InsertRows(table string, rows []interface{}) (numInsertedRows int64, lastID int64, err error)

InsertRows inserts rows into a table

type DbType string

DbType is a sqlite3 data type

const (
	DbInteger DbType = "INTEGER"
	DbFloat   DbType = "REAL"
	DbString  DbType = "TEXT"
)

sqlite3 data types

type Schema map[string]string

Schema represents a table's schema as a map of column name to type

func (sc Schema) String() (st string)