simplesql

Documentation

Index

• Variables
• func MySQLErrHandler(err error) error
• func SQLiteErrHandler(err error) error
• type Database
  • func NewDatabase(db *sqlx.DB, opts ...Option) Database
  • func (d *Database) ApplyMigrations(schemaMigrations []Migration) error
  • func (d *Database) GetRowByKey(ctx context.Context, tableName string, key interface{}, row interface{}) error
  • func (d *Database) HardDeleteByKey(ctx context.Context, tableName string, key interface{}, row interface{}) error
  • func (d *Database) InsertRow(ctx context.Context, execer sqlx.ExecerContext, tableName string, ...) error
  • func (d *Database) SelectRows(ctx context.Context, tableName string, filters interface{}, result interface{}) error
  • func (d *Database) UpdateRow(ctx context.Context, execer sqlx.ExecerContext, ID string, version uint64, ...) error
• type ErrHandler
• type Migration
• type Option
  • func WithErrHandler(errHandler ErrHandler) Option

Variables

var (
	ErrInsertConflict = errors.New("insert conflict")
	ErrRecordNotFound = errors.New("record not found")
	ErrInternal       = errors.New("internal error")
)

Functions

func MySQLErrHandler

func MySQLErrHandler(err error) error

MySQLErrHandler processes MySQL errors and returns a custom StorageError

func SQLiteErrHandler

func SQLiteErrHandler(err error) error

SQLiteErrHandler processes SQLite errors and returns a custom StorageError

Types

type Database

type Database struct {
	DB *sqlx.DB
	// contains filtered or unexported fields
}

func NewDatabase

func NewDatabase(db *sqlx.DB, opts ...Option) Database

func (*Database) ApplyMigrations

func (d *Database) ApplyMigrations(schemaMigrations []Migration) error

func (*Database) GetRowByKey

func (d *Database) GetRowByKey(
	ctx context.Context, tableName string, key interface{}, row interface{},
) error

func (*Database) HardDeleteByKey

func (d *Database) HardDeleteByKey(
	ctx context.Context, tableName string, key interface{}, row interface{},
) error

func (*Database) InsertRow

func (d *Database) InsertRow(
	ctx context.Context, execer sqlx.ExecerContext, tableName string, row interface{},
) error

func (*Database) SelectRows

func (d *Database) SelectRows(
	ctx context.Context, tableName string, filters interface{}, result interface{},
) error

func (*Database) UpdateRow

func (d *Database) UpdateRow(
	ctx context.Context, execer sqlx.ExecerContext, ID string, version uint64, tableName string, fields interface{},
) error

type ErrHandler

type ErrHandler func(error) error

type Migration

type Migration struct {
	Version int
	Up      string
	Down    string
}

type Option

type Option func(*Database)

func WithErrHandler

func WithErrHandler(errHandler ErrHandler) Option