easql

README

easql

A sqlx + squirrel wrapper

Feature

• Provide convenient query/exec APIs.
• Provide same query/exec APIs to DB and Tx.

Installation

$ go get github.com/adlandh/easql

Usage

Get(interface{}, squirrel.SelectBuilder) error
Select(interface{}, squirrel.SelectBuilder) error
Insert(squirrel.InsertBuilder) (sql.Result, error)
Update(squirrel.UpdateBuilder) (sql.Result, error)
Delete(squirrel.DeleteBuilder) (sql.Result, error)

Documentation

Overview

Package easql is a sqlx + squirrel wrapper

Index

• type DB
  • func NewDB(raw *sqlx.DB) *DB
  • func (db *DB) Begin() (*Tx, error)
  • func (db *DB) BeginContext(ctx context.Context) (*Tx, error)
• type Queryer
• type QueryerContext
• type RawQueryer
• type RawQueryerContext
• type Tx
  • func (tx *Tx) Commit() error
  • func (tx *Tx) Rollback() error

Types

type DB

type DB struct {
	Queryer
	QueryerContext
	// contains filtered or unexported fields
}

func NewDB

func NewDB(raw *sqlx.DB) *DB

func (*DB) Begin

func (db *DB) Begin() (*Tx, error)

func (*DB) BeginContext

func (db *DB) BeginContext(ctx context.Context) (*Tx, error)

type Queryer

type Queryer interface {
	Get(interface{}, squirrel.SelectBuilder) error
	Select(interface{}, squirrel.SelectBuilder) error
	Insert(squirrel.InsertBuilder) (sql.Result, error)
	Update(squirrel.UpdateBuilder) (sql.Result, error)
	Delete(squirrel.DeleteBuilder) (sql.Result, error)
}

type QueryerContext

type QueryerContext interface {
	GetContext(context.Context, interface{}, squirrel.SelectBuilder) error
	SelectContext(context.Context, interface{}, squirrel.SelectBuilder) error
	InsertContext(context.Context, squirrel.InsertBuilder) (sql.Result, error)
	UpdateContext(context.Context, squirrel.UpdateBuilder) (sql.Result, error)
	DeleteContext(context.Context, squirrel.DeleteBuilder) (sql.Result, error)
}

type RawQueryer

type RawQueryer interface {
	Get(interface{}, string, ...interface{}) error
	Select(interface{}, string, ...interface{}) error
	Exec(string, ...interface{}) (sql.Result, error)
}

type RawQueryerContext

type RawQueryerContext interface {
	GetContext(context.Context, interface{}, string, ...interface{}) error
	SelectContext(context.Context, interface{}, string, ...interface{}) error
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
}

type Tx

type Tx struct {
	Queryer
	QueryerContext
	// contains filtered or unexported fields
}

func (*Tx) Commit

func (tx *Tx) Commit() error

func (*Tx) Rollback

func (tx *Tx) Rollback() error