sqliteutil

Documentation

Index

• Variables
• func IsConstraintError(err error) bool
• func KeepTables(ctx context.Context, db DB, tablesToKeep ...string) (err error)
• func LoadSchemaFromSQL(script string) (_ *dbschema.Schema, err error)
• func LoadSnapshotFromSQL(script string) (_ *dbschema.Snapshot, err error)
• func MigrateTablesToDatabase(ctx context.Context, srcDB, destDB DB, tablesToKeep ...string) error
• func QueryData(db dbschema.Queryer, schema *dbschema.Schema) (*dbschema.Data, error)
• func QuerySchema(db dbschema.Queryer) (*dbschema.Schema, error)
• func QuerySnapshot(db dbschema.Queryer) (*dbschema.Snapshot, error)
• type DB

Variables

var (
	// ErrMigrateTables is error class for MigrateTables
	ErrMigrateTables = errs.Class("migrate tables:")

	// ErrKeepTables is error class for MigrateTables
	ErrKeepTables = errs.Class("keep tables:")
)

Functions

func IsConstraintError

func IsConstraintError(err error) bool

IsConstraintError checks if given error is about constraint violation

func KeepTables

func KeepTables(ctx context.Context, db DB, tablesToKeep ...string) (err error)

KeepTables drops all the tables except the specified tables to keep.

func LoadSchemaFromSQL

func LoadSchemaFromSQL(script string) (_ *dbschema.Schema, err error)

LoadSchemaFromSQL inserts script into connstr and loads schema.

func LoadSnapshotFromSQL

func LoadSnapshotFromSQL(script string) (_ *dbschema.Snapshot, err error)

LoadSnapshotFromSQL inserts script into connstr and loads schema.

func MigrateTablesToDatabase

func MigrateTablesToDatabase(ctx context.Context, srcDB, destDB DB, tablesToKeep ...string) error

MigrateTablesToDatabase copies the specified tables from srcDB into destDB. All tables in destDB will be dropped other than those specified in tablesToKeep.

func QueryData

func QueryData(db dbschema.Queryer, schema *dbschema.Schema) (*dbschema.Data, error)

QueryData loads all data from tables

func QuerySchema

func QuerySchema(db dbschema.Queryer) (*dbschema.Schema, error)

QuerySchema loads the schema from sqlite database.

func QuerySnapshot

func QuerySnapshot(db dbschema.Queryer) (*dbschema.Snapshot, error)

QuerySnapshot loads snapshot from database

Types

type DB

type DB interface {
	Conn(ctx context.Context) (*sql.Conn, error)
	Exec(query string, args ...interface{}) (sql.Result, error)
	BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)
}

DB is the minimal interface required to perform migrations.