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

Index

• type DB
  • func NewDB(raw *sqlx.DB) *DB
  • func (db *DB) Begin() (*Tx, error)
• type Queryer
• type RawQueryer
• type Tx
  • func (tx *Tx) Commit() error
  • func (tx *Tx) Rollback() error

Types

type DB

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

func NewDB

func NewDB(raw *sqlx.DB) *DB

func (*DB) Begin

func (db *DB) Begin() (*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 RawQueryer

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

type Tx

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

func (*Tx) Commit

func (tx *Tx) Commit() error

func (*Tx) Rollback

func (tx *Tx) Rollback() error