sqlite

Documentation

Index

• Constants
• type DB
  • func Open(opt *types.SQLiteOpt) (*DB, error)
  • func (db *DB) CreateTable(ctx context.Context, opt online.CreateTableOpt) error
  • func (db *DB) Get(ctx context.Context, opt online.GetOpt) (dbutil.RowMap, error)
  • func (db *DB) Import(ctx context.Context, opt online.ImportOpt) error
  • func (db *DB) MultiGet(ctx context.Context, opt online.MultiGetOpt) (map[string]dbutil.RowMap, error)
  • func (db *DB) Ping(ctx context.Context) error
  • func (db *DB) Purge(ctx context.Context, revisionID int) error
  • func (db *DB) Push(ctx context.Context, opt online.PushOpt) error

Constants

const (
	Backend = types.BackendSQLite
)

const PUSH_QUERY = `
REPLACE INTO {{ .TableName }} ( {{ .Fields }} )
VALUES ( {{ .InsertPlaceholders }} )
`

Types

type DB

type DB struct {
	*sqlx.DB
}

func Open

func Open(opt *types.SQLiteOpt) (*DB, error)

func (*DB) CreateTable

func (db *DB) CreateTable(ctx context.Context, opt online.CreateTableOpt) error

func (*DB) Get

func (db *DB) Get(ctx context.Context, opt online.GetOpt) (dbutil.RowMap, error)

func (*DB) Import

func (db *DB) Import(ctx context.Context, opt online.ImportOpt) error

func (*DB) MultiGet

func (db *DB) MultiGet(ctx context.Context, opt online.MultiGetOpt) (map[string]dbutil.RowMap, error)

func (*DB) Ping

func (db *DB) Ping(ctx context.Context) error

func (*DB) Purge

func (db *DB) Purge(ctx context.Context, revisionID int) error

func (*DB) Push

func (db *DB) Push(ctx context.Context, opt online.PushOpt) error