sqliteutil

package
v0.28.3-rc-crdb Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Dec 19, 2019 License: AGPL-3.0 Imports: 10 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
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 added in v0.28.0

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.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL