README
¶
dotsqlx
Dotsql wrapper allowing seemless work with jmoiron/sqlx
Installation
go get github.com/swithek/dotsqlx
Usage
// connect to db and obtain a new sqlx db instance.
dbx, err := sqlx.Connect("postgres", "user=foo dbname=bar sslmode=disable")
if err != nil {
// handle error
}
// load your queries and obtain a new dotsql instance.
dot, err := dotsql.LoadFromFile("./queries.sql")
if err != nil {
// handle error
}
// wrap dotsql's instance, extend its logic and allow sqlx support.
dotx := dotsqlx.Wrap(dot)
// execute named dotsql queries in sqlx methods.
var users []Users
if err = dotx.Select(dbx, &users, "select_users"); err != nil {
// handle error
}
// you can use dotsql's methods as well.
res, err := dotx.Exec(dbx, "insert_user")
if err != nil {
// handle error
}
Documentation
¶
Index ¶
- type DotSqlx
- func (d DotSqlx) BindNamed(dbx NamedBinder, name string, arg interface{}) (string, []interface{}, error)
- func (d DotSqlx) Get(dbx Getter, dest interface{}, name string, args ...interface{}) error
- func (d DotSqlx) GetContext(ctx context.Context, dbx GetterContext, dest interface{}, name string, ...) error
- func (d DotSqlx) In(name string, args ...interface{}) (string, []interface{}, error)
- func (d DotSqlx) MustExec(dbx MustExecer, name string, args ...interface{}) sql.Result
- func (d DotSqlx) MustExecContext(ctx context.Context, dbx MustExecerContext, name string, args ...interface{}) sql.Result
- func (d DotSqlx) NamedExec(dbx NamedExecer, name string, arg interface{}) (sql.Result, error)
- func (d DotSqlx) NamedExecContext(ctx context.Context, dbx NamedExecerContext, name string, arg interface{}) (sql.Result, error)
- func (d DotSqlx) NamedQuery(dbx NamedQueryer, name string, arg interface{}) (*sqlx.Rows, error)
- func (d DotSqlx) NamedQueryContext(ctx context.Context, dbx NamedQueryerContext, name string, arg interface{}) (*sqlx.Rows, error)
- func (d DotSqlx) PrepareNamed(dbx NamedPreparer, name string) (*sqlx.NamedStmt, error)
- func (d DotSqlx) PrepareNamedContext(ctx context.Context, dbx NamedPreparerContext, name string) (*sqlx.NamedStmt, error)
- func (d DotSqlx) Preparex(dbx Preparerx, name string) (*sqlx.Stmt, error)
- func (d DotSqlx) PreparexContext(ctx context.Context, dbx PreparerxContext, name string) (*sqlx.Stmt, error)
- func (d DotSqlx) QueryRowx(dbx QueryRowerx, name string, args ...interface{}) (*sqlx.Row, error)
- func (d DotSqlx) QueryRowxContext(ctx context.Context, dbx QueryRowerxContext, name string, args ...interface{}) (*sqlx.Row, error)
- func (d DotSqlx) Queryx(dbx Queryerx, name string, args ...interface{}) (*sqlx.Rows, error)
- func (d DotSqlx) QueryxContext(ctx context.Context, dbx QueryerxContext, name string, args ...interface{}) (*sqlx.Rows, error)
- func (d DotSqlx) Rebind(dbx Rebinder, name string) (string, error)
- func (d DotSqlx) Select(dbx Selecter, dest interface{}, name string, args ...interface{}) error
- func (d DotSqlx) SelectContext(ctx context.Context, dbx SelecterContext, dest interface{}, name string, ...) error
- type Getter
- type GetterContext
- type MustExecer
- type MustExecerContext
- type NamedBinder
- type NamedExecer
- type NamedExecerContext
- type NamedPreparer
- type NamedPreparerContext
- type NamedQueryer
- type NamedQueryerContext
- type Preparerx
- type PreparerxContext
- type QueryRowerx
- type QueryRowerxContext
- type Queryerx
- type QueryerxContext
- type Rebinder
- type Selecter
- type SelecterContext
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type DotSqlx ¶
DotSqlx wraps dotsql.DotSql instance and allows seamless work with jmoiron/sqlx.
func (DotSqlx) BindNamed ¶
func (d DotSqlx) BindNamed(dbx NamedBinder, name string, arg interface{}) (string, []interface{}, error)
BindNamed is a wrapper for jmoiron/sqlx's BindNamed(), using dotsql named query.
func (DotSqlx) GetContext ¶
func (d DotSqlx) GetContext(ctx context.Context, dbx GetterContext, dest interface{}, name string, args ...interface{}) error
GetContext is a wrapper for jmoiron/sqlx's GetContext(), using dotsql named query.
func (DotSqlx) MustExec ¶
func (d DotSqlx) MustExec(dbx MustExecer, name string, args ...interface{}) sql.Result
MustExec is a wrapper for jmoiron/sqlx's MustExec(), using dotsql named query.
func (DotSqlx) MustExecContext ¶
func (d DotSqlx) MustExecContext(ctx context.Context, dbx MustExecerContext, name string, args ...interface{}) sql.Result
MustExecContext is a wrapper for jmoiron/sqlx's MustExecContext(), using dotsql named query.
func (DotSqlx) NamedExec ¶
NamedExec is a wrapper for jmoiron/sqlx's NamedExec(), using dotsql named query.
func (DotSqlx) NamedExecContext ¶
func (d DotSqlx) NamedExecContext(ctx context.Context, dbx NamedExecerContext, name string, arg interface{}) (sql.Result, error)
NamedExecContext is a wrapper for jmoiron/sqlx's NamedExecContext(), using dotsql named query.
func (DotSqlx) NamedQuery ¶
NamedQuery is a wrapper for jmoiron/sqlx's NamedQuery(), using dotsql named query.
func (DotSqlx) NamedQueryContext ¶
func (d DotSqlx) NamedQueryContext(ctx context.Context, dbx NamedQueryerContext, name string, arg interface{}) (*sqlx.Rows, error)
NamedQueryContext is a wrapper for jmoiron/sqlx's NamedQueryContext(), using dotsql named query.
func (DotSqlx) PrepareNamed ¶
PrepareNamed is a wrapper for jmoiron/sqlx's PrepareNamed(), using dotsql named query.
func (DotSqlx) PrepareNamedContext ¶
func (d DotSqlx) PrepareNamedContext(ctx context.Context, dbx NamedPreparerContext, name string) (*sqlx.NamedStmt, error)
PrepareNamedContext is a wrapper for jmoiron/sqlx's PrepareNamedContext(), using dotsql named query.
func (DotSqlx) Preparex ¶
Preparex is a wrapper for jmoiron/sqlx's Preparex(), using dotsql named query.
func (DotSqlx) PreparexContext ¶
func (d DotSqlx) PreparexContext(ctx context.Context, dbx PreparerxContext, name string) (*sqlx.Stmt, error)
PreparexContext is a wrapper for jmoiron/sqlx's PreparexContext(), using dotsql named query.
func (DotSqlx) QueryRowx ¶
QueryRowx is a wrapper for jmoiron/sqlx's QueryRowx(), using dotsql named query.
func (DotSqlx) QueryRowxContext ¶
func (d DotSqlx) QueryRowxContext(ctx context.Context, dbx QueryRowerxContext, name string, args ...interface{}) (*sqlx.Row, error)
QueryRowxContext is a wrapper for jmoiron/sqlx's QueryRowxContext(), using dotsql named query.
func (DotSqlx) QueryxContext ¶
func (d DotSqlx) QueryxContext(ctx context.Context, dbx QueryerxContext, name string, args ...interface{}) (*sqlx.Rows, error)
QueryxContext is a wrapper for jmoiron/sqlx's QueryxContext(), using dotsql named query.
func (DotSqlx) SelectContext ¶
func (d DotSqlx) SelectContext(ctx context.Context, dbx SelecterContext, dest interface{}, name string, args ...interface{}) error
SelectContext is a wrapper for jmoiron/sqlx's SelectContext(), using dotsql named query.
type GetterContext ¶
type GetterContext interface {
GetContext(ctx context.Context, dest interface{}, query string, args ...interface{}) error
}
GetterContext is an interface used by GetContext.
type MustExecer ¶
MustExecer is an interface used by MustExec.
type MustExecerContext ¶
type MustExecerContext interface {
MustExecContext(ctx context.Context, query string, args ...interface{}) sql.Result
}
MustExecerContext is an interface used by MustExecContext.
type NamedBinder ¶
type NamedBinder interface {
BindNamed(query string, arg interface{}) (string, []interface{}, error)
}
NamedBinder is an interface used by BindNamed.
type NamedExecer ¶
NamedExecer is an interface used by NamedExec.
type NamedExecerContext ¶
type NamedExecerContext interface {
NamedExecContext(ctx context.Context, query string, arg interface{}) (sql.Result, error)
}
NamedExecerContext is an interface used by NamedExecContext.
type NamedPreparer ¶
NamedPreparer is an interface used by PrepareNamed.
type NamedPreparerContext ¶
type NamedPreparerContext interface {
PrepareNamedContext(ctx context.Context, query string) (*sqlx.NamedStmt, error)
}
NamedPreparerContext is an interface used by PrepareNamedContext.
type NamedQueryer ¶
NamedQueryer is an interface used by NamedQuery.
type NamedQueryerContext ¶
type NamedQueryerContext interface {
NamedQueryContext(ctx context.Context, query string, arg interface{}) (*sqlx.Rows, error)
}
NamedQueryerContext is an interface used by NamedQueryContext.
type PreparerxContext ¶
type PreparerxContext interface {
PreparexContext(ctx context.Context, query string) (*sqlx.Stmt, error)
}
PreparerxContext is an interface used by PreparexContext.
type QueryRowerx ¶
QueryRowerx is an interface used by QueryRowx.
type QueryRowerxContext ¶
type QueryRowerxContext interface {
QueryRowxContext(ctx context.Context, query string, args ...interface{}) *sqlx.Row
}
QueryRowerxContext is an interface used by QueryRowxContext.
type QueryerxContext ¶
type QueryerxContext interface {
QueryxContext(ctx context.Context, query string, args ...interface{}) (*sqlx.Rows, error)
}
QueryerxContext is an interface used by QueryxContext.
Source Files