sqldb

type Params struct {
	DSN             string
	Server          string
	Host            string
	Port            string
	Username        string
	Password        string
	Database        string
	MaxCap          *int
	MaxIdle         *int
	ConnMaxLifetime *int
	MaxRetries      *int
	RetriesInterval *int
	RetryableErrors []string
}

type Sql interface {
	DB() *sqlx.DB
	Ping() error
	CreateTx() (*sqlx.Tx, error)
	Exec(query string, args ...interface{}) (sql.Result, error)
	Query(query string, args ...interface{}) (*sql.Rows, error)
	NamedExec(query string, arg interface{}) (sql.Result, error)
	NamedQuery(query string, arg interface{}) (*sqlx.Rows, error)
	Select(dest interface{}, query string, args ...interface{}) error
}

type SqlTx interface {
	NamedExec(query string, arg interface{}) (sql.Result, error)
	NamedQuery(query string, arg interface{}) (*sqlx.Rows, error)
	Commit() error
	Rollback() error
}