simplesql

package

v0.0.5 Latest Latest Go to latest Published: Feb 8, 2025 License: MIT Imports: 10 Imported by: 2

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/msanath/gondolf

Links

Open Source Insights

Documentation ¶

Index ¶

Variables
func MySQLErrHandler(err error) error
func SQLiteErrHandler(err error) error
type Database
- func NewDatabase(db *sqlx.DB, opts ...Option) Database
type ErrHandler
type Migration
type Option
- func WithErrHandler(errHandler ErrHandler) Option

Constants ¶

This section is empty.

Variables ¶

View Source

var (
	ErrInsertConflict = errors.New("insert conflict")
	ErrRecordNotFound = errors.New("record not found")
	ErrInvalidVersion = errors.New("invalid version or version not provided")
	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) Delete ¶ added in v0.0.2

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

func (*Database) Get ¶ added in v0.0.2

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

func (*Database) Insert ¶ added in v0.0.2

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

func (*Database) List ¶ added in v0.0.2

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

func (*Database) Update ¶ added in v0.0.2

func (d *Database) Update(
	ctx context.Context, execer sqlx.ExecerContext, tableName string, key interface{}, 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

Source Files ¶

View all Source files

Directories ¶

Path	Synopsis
test

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