storeql

Documentation

Index

• Variables
• func DeleteFromDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error
• func ExecBoilerplate(action string, storable Storable) (boilerplate string)
• func InsertIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error
• func SQLColumns(s Storable) (cols []string)
• func SQLValues(s Storable) (vals []driver.Value)
• func UpdateIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error
• func UpsertIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error
• func Where(ctx context.Context, db *sqlx.DB, storable Storable, whereClause string, ...) *sqlx.Row
• func WhereMany(ctx context.Context, db *sqlx.DB, storable Storable, whereClause string, ...) (*sqlx.Rows, error)
• type PqErr
  • func (err *PqErr) Error() string
  • func (err *PqErr) Is(errChecker func(error) *pq.Error) bool
• type Storable

Variables

var ErrNoId = errors.New("storable entity given has no id")

Functions

func DeleteFromDB

func DeleteFromDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error

func ExecBoilerplate

func ExecBoilerplate(action string, storable Storable) (boilerplate string)

func InsertIntoDB

func InsertIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error

InsertIntoDB inserts the storable entity to the DB Finally, it assigns the inserted Id to the given entities

func SQLColumns

func SQLColumns(s Storable) (cols []string)

func SQLValues

func SQLValues(s Storable) (vals []driver.Value)

func UpdateIntoDB

func UpdateIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error

func UpsertIntoDB

func UpsertIntoDB(ctx context.Context, db *sqlx.DB, storables ...Storable) error

func Where

func Where(ctx context.Context, db *sqlx.DB, storable Storable, whereClause string, args ...interface{}) *sqlx.Row

func WhereMany

func WhereMany(ctx context.Context, db *sqlx.DB, storable Storable, whereClause string, args ...interface{}) (*sqlx.Rows, error)

Types

type PqErr

type PqErr struct {
	// contains filtered or unexported fields
}

func (*PqErr) Error

func (err *PqErr) Error() string

func (*PqErr) Is

func (err *PqErr) Is(errChecker func(error) *pq.Error) bool

type Storable

type Storable interface {
	GetId() uint64
	SetId(uint64)
	SQLTable() string
	SQLMap() map[string]driver.Value
}

Storable entity is any entity that can be stored in an SQL database