Versions in this module Expand all Collapse all v1 v1.0.0 Apr 15, 2018 Changes in this version + const DELETE + const INNER + const INSERT + const ISDEFAULT + const ISJOIN + const ISSORT + const LEFT + const RIGHT + const SELECT + const UPDATE + type Database struct + func New(dataSourceName string) *Database + func (database *Database) Begin() (*Transaction, error) + func (database *Database) Close() error + func (database *Database) Fetch(sql string, args ...interface{}) *sql.Row + func (database *Database) GetDB() *sql.DB + func (database *Database) Open() (*Database, error) + func (database *Database) Ping() error + func (database *Database) Prepare(sql string) (*sql.Stmt, error) + func (database *Database) Query(sql string, args ...interface{}) (*sql.Rows, error) + func (database *Database) SetDB(db *sql.DB) + type FromSqlParts struct + type JoinSqlParts struct + type OrderBySqlParts struct + type QueryBuilder struct + State *sql.Stmt + func NewQueryBuilder(database *Database) *QueryBuilder + func (queryBuilder *QueryBuilder) Delete(table string) *QueryBuilder + func (queryBuilder *QueryBuilder) From(table string, alias string) *QueryBuilder + func (queryBuilder *QueryBuilder) GetFirstResult() int + func (queryBuilder *QueryBuilder) GetMaxResults() int + func (queryBuilder *QueryBuilder) GetParameter() []interface{} + func (queryBuilder *QueryBuilder) GetParams() []interface{} + func (queryBuilder *QueryBuilder) GetSQL() string + func (queryBuilder *QueryBuilder) GroupBy(groupBy string) *QueryBuilder + func (queryBuilder *QueryBuilder) Having(having string) *QueryBuilder + func (queryBuilder *QueryBuilder) InnerJoin(join string, alias string, condition string) *QueryBuilder + func (queryBuilder *QueryBuilder) Insert(table string) *QueryBuilder + func (queryBuilder *QueryBuilder) Join(join string, alias string, condition string) *QueryBuilder + func (queryBuilder *QueryBuilder) LeftJoin(join string, alias string, condition string) *QueryBuilder + func (queryBuilder *QueryBuilder) OrderBy(sort string, order string) *QueryBuilder + func (queryBuilder *QueryBuilder) PrepareAndExecute() (int64, error) + func (queryBuilder *QueryBuilder) Query() (*sql.Rows, error) + func (queryBuilder *QueryBuilder) QueryAndGetMap() (map[int]map[string]string, error) + func (queryBuilder *QueryBuilder) RightJoin(join string, alias string, condition string) *QueryBuilder + func (queryBuilder *QueryBuilder) Select(value string) *QueryBuilder + func (queryBuilder *QueryBuilder) Set(key string, val interface{}) *QueryBuilder + func (queryBuilder *QueryBuilder) SetFirstResult(firstResult int) *QueryBuilder + func (queryBuilder *QueryBuilder) SetMaxResults(maxResults int) *QueryBuilder + func (queryBuilder *QueryBuilder) SetParam(param interface{}) *QueryBuilder + func (queryBuilder *QueryBuilder) Update(table string, alias string) *QueryBuilder + func (queryBuilder *QueryBuilder) Value(key string, val interface{}) *QueryBuilder + func (queryBuilder *QueryBuilder) Where(condition string) *QueryBuilder + type SetSqlParts struct + type Transaction struct + Tx *sql.Tx + func NewTx() *Transaction + func (transaction *Transaction) Commit() error + func (transaction *Transaction) PrepareAndExecute(queryBuilder *QueryBuilder) (sql.Result, error) + func (transaction *Transaction) Rollback() error + type ValuesSqlParts struct