db

type Conf struct {
	Debug        bool
	URL          string
	PoolSize     int
	IdleTimeout  int
	ConnLifetime time.Duration
}

type Config struct {
	Master *Conf
	Slaves []*Conf
}

type SQL interface {
	Close() error // Will close all open database connection.
	Writer() SQLExecutor
	Reader() SQLExecutor
	NewTransaction(ctx context.Context) (Transaction, error)
}

type SQLExecutor interface {
	Query(ctx context.Context, destination interface{}, query string, args ...interface{}) error
	Exec(ctx context.Context, query string, args ...interface{}) error
}

type Transaction interface {
	Query(ctx context.Context, destination interface{}, query string, args ...interface{}) error
	Exec(ctx context.Context, query string, args ...interface{}) error
	Commit(ctx context.Context) error
	Rollback(ctx context.Context) error
}