sqlab

README

sqlab

The project waiting for planning, some SQL tool functions are temporarily deposited.

Documentation

Index

• type Mysql
  • func (m Mysql) UpsertBuilder(tableName string, fields []string) ...
• type Sql
  • func (s Sql) In(query string, args ...interface{}) (string, []interface{}, error)

Types

type Mysql

type Mysql struct {
	Sql
}

Mysql mysql tools

func (Mysql) UpsertBuilder

func (m Mysql) UpsertBuilder(
	tableName string, fields []string,
) func(valueGroups ...[]interface{}) (sql string, values []interface{}, err error)

UpsertBuilder build INSERT INTO ... ON DUPLICATE KEY UPDATE ...

type Sql

type Sql struct {
}

Sql sql common tools

func (Sql) In

func (s Sql) In(query string, args ...interface{}) (string, []interface{}, error)

In expands slice values in args, returning the modified query string and a new arg list that can be executed by a database. The `query` should use the `?` bindVar. The return value uses the `?` bindVar.