database

Documentation

Index

• Variables
• func FilterRows(driver Driver, query *builder.Sqlbuilder, filters map[string][]params.Filter, ...) error
• type Driver
  • func New(env *environment.Env) (Driver, error)

Variables

var (
	ErrQueryMessage = "Error executing sql query"
)

Functions

func FilterRows

func FilterRows(driver Driver, query *builder.Sqlbuilder, filters map[string][]params.Filter, table string) error

FilterRows takes in the filters from the params set in http.Params If there is no filters set, an empty string will be returned. Returns errors.INVALID if the operator or column name was not found.

Types

type Driver

type Driver interface {
	DB() *sqlx.DB
	Schema() string
	Builder() *builder.Sqlbuilder
	Install() error
	Migrate(version *version.Version) error
	Tables() ([]string, error)
	Dump(path, filename string) error
	Drop() error
}

Driver represents the functions and methods for interacting with the Database, which could be MySQL (tested) Postgres (experimental).

func New

func New(env *environment.Env) (Driver, error)

New creates a new database driver dependant on the environment. Returns errors.INTERNAL if there there was an error setting up the driver. Returns errors.INVALID if the environment us invalid or the DB could not be pinged.