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)
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)

Documentation

Overview

Package easql is a sqlx + squirrel wrapper

Index

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

Types

type Beginner

type Beginner interface {
	Begin() (Commiter, error)
}

type BeginnerContext

type BeginnerContext interface {
	BeginContext(context.Context) (CommiterContext, error)
}

type Commiter

type Commiter interface {
	Commit() error
	Rollback() error
	Queryer
}

type CommiterContext

type CommiterContext interface {
	Commit() error
	Rollback() error
	QueryerContext
}

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() (Commiter, error)

func (*DB) BeginContext

func (db *DB) BeginContext(ctx context.Context) (CommiterContext, 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