database

type DBConfig struct {
	Driver             string `json:"driver"`
	Host               string `json:"host"`
	Port               int    `json:"port"`
	EnableSSL          bool   `json:"enable_ssl"`
	Username           string `json:"username"`
	Password           string `json:"password"`
	DBName             string `json:"db_name"`
	MaxIdleConnections int    `json:"max_idle_connections"`
	MaxOpenConnections int    `json:"max_open_connections"`
}

type Database interface {

	// Selects one item, result will be stored in "out". It will be casted
	SelectOne(out interface{}, sql string, args ...interface{}) error

	// Selects multiple items, result will be stored in "out". It will be casted
	SelectMany(out interface{}, sql string, args ...interface{}) error

	// Queries for "SELECT <x> WHERE <y> in (...)". Got results in "out" interface (with casting)
	SelectIn(out interface{}, sql string, args ...interface{}) error

	// Queries for "SELECT <x> WHERE <y> in (...)". Got results in returning rows
	QueryIn(sql string, args ...interface{}) (*sql.Rows, error)

	// Executes an sql request, usually do not expect returning rows
	Exec(sql string, args ...interface{}) (sql.Result, error)

	// Executes an sql request, expect returning data (rows)
	ExecReturning(sql string, args ...interface{}) (*sql.Rows, error)
}

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