Documentation ¶
Index ¶
- Constants
- Variables
- func And(exp ...string) (and string)
- func As(name, alias string) string
- func Eq(column, placeholder string) string
- func GetConnectionManager() *connectionManager
- func Gt(column, placeholder string) string
- func Gte(column, placeholder string) string
- func Load(rows *sql.Rows, value interface{}) (int, error)
- func LoadOne(rows *sql.Rows, value interface{}) (int, error)
- func Lt(column, placeholder string) string
- func Lte(column, placeholder string) string
- func Neq(column, placeholder string) string
- func Or(exp ...string) (or string)
- type Builder
- func (b *Builder) Build() (*Builder, error)
- func (b *Builder) Delete(table string) *DeleteBuilder
- func (b *Builder) GetParameters() []interface{}
- func (b *Builder) GetSQL() string
- func (b *Builder) Insert(table string) *InsertBuilder
- func (b *Builder) RawBuild() (*Builder, error)
- func (b *Builder) SQL(sql string) *SQLBuilder
- func (b *Builder) Select(columns ...string) *SelectBuilder
- func (b *Builder) SetParameter(p, v interface{}) *Builder
- func (b *Builder) Update(table string) *UpdateBuilder
- type Connection
- type DeleteBuilder
- func (b *DeleteBuilder) Build()
- func (b *DeleteBuilder) GetBuilder() *Builder
- func (b *DeleteBuilder) GetSQL() (q string)
- func (b *DeleteBuilder) OrWhere(condition string) *DeleteBuilder
- func (b *DeleteBuilder) SetParameter(p, v interface{}) *DeleteBuilder
- func (b *DeleteBuilder) Where(condition string) *DeleteBuilder
- type IBuilder
- type ISession
- type InsertBuilder
- func (b *InsertBuilder) Build()
- func (b *InsertBuilder) Column(column, parameter string) *InsertBuilder
- func (b *InsertBuilder) Columns(columns ...string) *InsertBuilder
- func (b *InsertBuilder) GetBuilder() *Builder
- func (b *InsertBuilder) GetSQL() (q string)
- func (b *InsertBuilder) LastInsertId() *InsertBuilder
- func (b *InsertBuilder) SetParameter(p, v interface{}) *InsertBuilder
- func (b *InsertBuilder) Type(entity interface{}) *InsertBuilder
- type Join
- type NullBool
- type NullFloat64
- type NullInt64
- type NullString
- type NullTime
- type Order
- type SQLBuilder
- type SelectBuilder
- func (b *SelectBuilder) Build()
- func (b *SelectBuilder) Distinct() *SelectBuilder
- func (b *SelectBuilder) FirstResult(firstResult int64) *SelectBuilder
- func (b *SelectBuilder) From(table string) *SelectBuilder
- func (b *SelectBuilder) GetBuilder() *Builder
- func (b *SelectBuilder) GetCountSQL() (q string)
- func (b *SelectBuilder) GetSQL() (q string)
- func (b *SelectBuilder) GroupBy(columns ...string) *SelectBuilder
- func (b *SelectBuilder) Having(condition string) *SelectBuilder
- func (b *SelectBuilder) InnerJoin(join Join) *SelectBuilder
- func (b *SelectBuilder) LeftJoin(join Join) *SelectBuilder
- func (b *SelectBuilder) MaxResult(maxResults int64) *SelectBuilder
- func (b *SelectBuilder) OrWhere(condition string) *SelectBuilder
- func (b *SelectBuilder) OrderASC(columns ...string) *SelectBuilder
- func (b *SelectBuilder) OrderDESC(columns ...string) *SelectBuilder
- func (b *SelectBuilder) RightJoin(join Join) *SelectBuilder
- func (b *SelectBuilder) SetParameter(p, v interface{}) *SelectBuilder
- func (b *SelectBuilder) Where(condition string) *SelectBuilder
- type Session
- func (s *Session) CountQuery(b SelectBuilder) ([]map[string]interface{}, int64, error)
- func (s *Session) CountQueryArray(b SelectBuilder) ([][]interface{}, int64, error)
- func (s *Session) CountQueryType(b SelectBuilder, o interface{}) (int64, error)
- func (s *Session) Exec(b Builder) error
- func (s *Session) FirstResult(b Builder) (map[string]interface{}, error)
- func (s *Session) FirstResultArray(b Builder) ([]interface{}, error)
- func (s *Session) FirstResultType(b Builder, o interface{}) error
- func (s *Session) Query(b Builder) ([]map[string]interface{}, error)
- func (s *Session) QueryArray(b Builder) ([][]interface{}, error)
- func (s *Session) QueryType(b Builder, o interface{}) error
- func (s *Session) Scan(b Builder, v ...interface{}) error
- type SessionHandler
- type Transaction
- func (tx *Transaction) Commit() error
- func (t *Transaction) CountQuery(b SelectBuilder) ([]map[string]interface{}, int64, error)
- func (t *Transaction) CountQueryArray(b SelectBuilder) ([][]interface{}, int64, error)
- func (t *Transaction) CountQueryType(b SelectBuilder, o interface{}) (int64, error)
- func (t *Transaction) Exec(b Builder) error
- func (t *Transaction) FirstResult(b Builder) (map[string]interface{}, error)
- func (t *Transaction) FirstResultArray(b Builder) ([]interface{}, error)
- func (t *Transaction) FirstResultType(b Builder, o interface{}) error
- func (t *Transaction) Query(b Builder) ([]map[string]interface{}, error)
- func (t *Transaction) QueryArray(b Builder) ([][]interface{}, error)
- func (t *Transaction) QueryType(b Builder, o interface{}) error
- func (tx *Transaction) Rollback() error
- func (t *Transaction) Scan(b Builder, v ...interface{}) error
- type UpdateBuilder
- func (b *UpdateBuilder) Build()
- func (b *UpdateBuilder) GetBuilder() *Builder
- func (b *UpdateBuilder) GetSQL() (q string)
- func (b *UpdateBuilder) OrWhere(condition string) *UpdateBuilder
- func (b *UpdateBuilder) Set(column, parameter string) *UpdateBuilder
- func (b *UpdateBuilder) SetParameter(p, v interface{}) *UpdateBuilder
- func (b *UpdateBuilder) Sets(columns ...string) *UpdateBuilder
- func (b *UpdateBuilder) Type(entity interface{}) *UpdateBuilder
- func (b *UpdateBuilder) Where(condition string) *UpdateBuilder
- type Where
Constants ¶
const UNIQUE_CONNECTION = "DAL_UNIQUE"
Variables ¶
var Now = nowSentinel{}
Now is a value that serializes to the current time
Functions ¶
func GetConnectionManager ¶
func GetConnectionManager() *connectionManager
Types ¶
type Builder ¶
type Builder struct {
// contains filtered or unexported fields
}
Builder -
func NewBuilder ¶
func NewBuilder() *Builder
func (*Builder) Delete ¶
func (b *Builder) Delete(table string) *DeleteBuilder
func (*Builder) GetParameters ¶
func (b *Builder) GetParameters() []interface{}
func (*Builder) Insert ¶
func (b *Builder) Insert(table string) *InsertBuilder
func (*Builder) SQL ¶
func (b *Builder) SQL(sql string) *SQLBuilder
func (*Builder) SetParameter ¶
SetParameter -
func (*Builder) Update ¶
func (b *Builder) Update(table string) *UpdateBuilder
type Connection ¶
type Connection struct {
// contains filtered or unexported fields
}
func (*Connection) GetSession ¶
func (c *Connection) GetSession() *Session
func (*Connection) GetTransaction ¶
func (c *Connection) GetTransaction() (*Transaction, error)
type DeleteBuilder ¶
type DeleteBuilder struct {
// contains filtered or unexported fields
}
func (*DeleteBuilder) Build ¶
func (b *DeleteBuilder) Build()
func (*DeleteBuilder) GetBuilder ¶
func (b *DeleteBuilder) GetBuilder() *Builder
func (*DeleteBuilder) GetSQL ¶
func (b *DeleteBuilder) GetSQL() (q string)
func (*DeleteBuilder) OrWhere ¶
func (b *DeleteBuilder) OrWhere(condition string) *DeleteBuilder
func (*DeleteBuilder) SetParameter ¶
func (b *DeleteBuilder) SetParameter(p, v interface{}) *DeleteBuilder
func (*DeleteBuilder) Where ¶
func (b *DeleteBuilder) Where(condition string) *DeleteBuilder
type ISession ¶
type ISession interface { Scan(b Builder, v ...interface{}) error CountQuery(b SelectBuilder) ([]map[string]interface{}, int64, error) CountQueryArray(b SelectBuilder) ([][]interface{}, int64, error) CountQueryType(b SelectBuilder, o interface{}) (int64, error) Query(b Builder) ([]map[string]interface{}, error) QueryArray(b Builder) ([][]interface{}, error) QueryType(b Builder, o interface{}) error FirstResult(b Builder) (map[string]interface{}, error) FirstResultArray(b Builder) ([]interface{}, error) FirstResultType(b Builder, o interface{}) error Exec(b Builder) error }
type InsertBuilder ¶
type InsertBuilder struct {
// contains filtered or unexported fields
}
func (*InsertBuilder) Build ¶
func (b *InsertBuilder) Build()
func (*InsertBuilder) Column ¶
func (b *InsertBuilder) Column(column, parameter string) *InsertBuilder
func (*InsertBuilder) Columns ¶
func (b *InsertBuilder) Columns(columns ...string) *InsertBuilder
func (*InsertBuilder) GetBuilder ¶
func (b *InsertBuilder) GetBuilder() *Builder
func (*InsertBuilder) GetSQL ¶
func (b *InsertBuilder) GetSQL() (q string)
func (*InsertBuilder) LastInsertId ¶
func (b *InsertBuilder) LastInsertId() *InsertBuilder
func (*InsertBuilder) SetParameter ¶
func (b *InsertBuilder) SetParameter(p, v interface{}) *InsertBuilder
func (*InsertBuilder) Type ¶
func (b *InsertBuilder) Type(entity interface{}) *InsertBuilder
type NullBool ¶
NullBool is a type that can be null or a bool
func NewNullBool ¶
func NewNullBool(v interface{}) (n NullBool)
func (NullBool) MarshalJSON ¶
MarshalJSON correctly serializes a NullBool to JSON
func (*NullBool) UnmarshalJSON ¶
UnmarshalJSON correctly deserializes a NullBool from JSON
type NullFloat64 ¶
type NullFloat64 struct {
sql.NullFloat64
}
NullFloat64 is a type that can be null or a float64
func NewNullFloat64 ¶
func NewNullFloat64(v interface{}) (n NullFloat64)
func (NullFloat64) MarshalJSON ¶
func (n NullFloat64) MarshalJSON() ([]byte, error)
MarshalJSON correctly serializes a NullFloat64 to JSON
func (*NullFloat64) UnmarshalJSON ¶
func (n *NullFloat64) UnmarshalJSON(b []byte) error
UnmarshalJSON correctly deserializes a NullFloat64 from JSON
type NullInt64 ¶
NullInt64 is a type that can be null or an int
func NewNullInt64 ¶
func NewNullInt64(v interface{}) (n NullInt64)
func (NullInt64) MarshalJSON ¶
MarshalJSON correctly serializes a NullInt64 to JSON
func (*NullInt64) UnmarshalJSON ¶
UnmarshalJSON correctly deserializes a NullInt64 from JSON
type NullString ¶
type NullString struct {
sql.NullString
}
NullString is a type that can be null or a string
func NewNullString ¶
func NewNullString(v interface{}) (n NullString)
func (NullString) MarshalJSON ¶
func (n NullString) MarshalJSON() ([]byte, error)
MarshalJSON correctly serializes a NullString to JSON
func (*NullString) UnmarshalJSON ¶
func (n *NullString) UnmarshalJSON(b []byte) error
UnmarshalJSON correctly deserializes a NullString from JSON
type NullTime ¶
NullTime is a type that can be null or a time
func NewNullTime ¶
func NewNullTime(v interface{}) (n NullTime)
func (NullTime) MarshalJSON ¶
MarshalJSON correctly serializes a NullTime to JSON
func (*NullTime) Scan ¶
Scan implements the Scanner interface. The value type must be time.Time or string / []byte (formatted time-string), otherwise Scan fails.
func (*NullTime) UnmarshalJSON ¶
UnmarshalJSON correctly deserializes a NullTime from JSON
type SQLBuilder ¶
type SQLBuilder struct {
// contains filtered or unexported fields
}
func (*SQLBuilder) Build ¶
func (b *SQLBuilder) Build() error
func (*SQLBuilder) GetSQL ¶
func (b *SQLBuilder) GetSQL() (q string)
func (*SQLBuilder) RawBuild ¶
func (b *SQLBuilder) RawBuild() error
func (*SQLBuilder) SetParameter ¶
func (b *SQLBuilder) SetParameter(p, v interface{}) *SQLBuilder
type SelectBuilder ¶
type SelectBuilder struct {
// contains filtered or unexported fields
}
func (*SelectBuilder) Build ¶
func (b *SelectBuilder) Build()
func (*SelectBuilder) Distinct ¶
func (b *SelectBuilder) Distinct() *SelectBuilder
func (*SelectBuilder) FirstResult ¶
func (b *SelectBuilder) FirstResult(firstResult int64) *SelectBuilder
func (*SelectBuilder) GetBuilder ¶
func (b *SelectBuilder) GetBuilder() *Builder
func (*SelectBuilder) GetCountSQL ¶
func (b *SelectBuilder) GetCountSQL() (q string)
func (*SelectBuilder) GetSQL ¶
func (b *SelectBuilder) GetSQL() (q string)
func (*SelectBuilder) GroupBy ¶
func (b *SelectBuilder) GroupBy(columns ...string) *SelectBuilder
func (*SelectBuilder) Having ¶
func (b *SelectBuilder) Having(condition string) *SelectBuilder
func (*SelectBuilder) InnerJoin ¶
func (b *SelectBuilder) InnerJoin(join Join) *SelectBuilder
InnerJoin -
func (*SelectBuilder) LeftJoin ¶
func (b *SelectBuilder) LeftJoin(join Join) *SelectBuilder
LeftJoin -
func (*SelectBuilder) MaxResult ¶
func (b *SelectBuilder) MaxResult(maxResults int64) *SelectBuilder
func (*SelectBuilder) OrWhere ¶
func (b *SelectBuilder) OrWhere(condition string) *SelectBuilder
func (*SelectBuilder) OrderASC ¶
func (b *SelectBuilder) OrderASC(columns ...string) *SelectBuilder
func (*SelectBuilder) OrderDESC ¶
func (b *SelectBuilder) OrderDESC(columns ...string) *SelectBuilder
func (*SelectBuilder) RightJoin ¶
func (b *SelectBuilder) RightJoin(join Join) *SelectBuilder
RightJoin -
func (*SelectBuilder) SetParameter ¶
func (b *SelectBuilder) SetParameter(p, v interface{}) *SelectBuilder
func (*SelectBuilder) Where ¶
func (b *SelectBuilder) Where(condition string) *SelectBuilder
type Session ¶
type Session struct { *Connection // contains filtered or unexported fields }
func (*Session) CountQuery ¶
func (s *Session) CountQuery(b SelectBuilder) ([]map[string]interface{}, int64, error)
func (*Session) CountQueryArray ¶
func (s *Session) CountQueryArray(b SelectBuilder) ([][]interface{}, int64, error)
func (*Session) CountQueryType ¶
func (s *Session) CountQueryType(b SelectBuilder, o interface{}) (int64, error)
func (*Session) FirstResult ¶
func (*Session) FirstResultArray ¶
func (*Session) FirstResultType ¶
func (*Session) QueryArray ¶
type SessionHandler ¶
type SessionHandler interface{}
type Transaction ¶
type Transaction struct {
// contains filtered or unexported fields
}
func (*Transaction) Commit ¶
func (tx *Transaction) Commit() error
func (*Transaction) CountQuery ¶
func (t *Transaction) CountQuery(b SelectBuilder) ([]map[string]interface{}, int64, error)
func (*Transaction) CountQueryArray ¶
func (t *Transaction) CountQueryArray(b SelectBuilder) ([][]interface{}, int64, error)
func (*Transaction) CountQueryType ¶
func (t *Transaction) CountQueryType(b SelectBuilder, o interface{}) (int64, error)
func (*Transaction) Exec ¶
func (t *Transaction) Exec(b Builder) error
func (*Transaction) FirstResult ¶
func (t *Transaction) FirstResult(b Builder) (map[string]interface{}, error)
func (*Transaction) FirstResultArray ¶
func (t *Transaction) FirstResultArray(b Builder) ([]interface{}, error)
func (*Transaction) FirstResultType ¶
func (t *Transaction) FirstResultType(b Builder, o interface{}) error
func (*Transaction) Query ¶
func (t *Transaction) Query(b Builder) ([]map[string]interface{}, error)
func (*Transaction) QueryArray ¶
func (t *Transaction) QueryArray(b Builder) ([][]interface{}, error)
func (*Transaction) QueryType ¶
func (t *Transaction) QueryType(b Builder, o interface{}) error
func (*Transaction) Rollback ¶
func (tx *Transaction) Rollback() error
func (*Transaction) Scan ¶
func (t *Transaction) Scan(b Builder, v ...interface{}) error
type UpdateBuilder ¶
type UpdateBuilder struct {
// contains filtered or unexported fields
}
func (*UpdateBuilder) Build ¶
func (b *UpdateBuilder) Build()
func (*UpdateBuilder) GetBuilder ¶
func (b *UpdateBuilder) GetBuilder() *Builder
func (*UpdateBuilder) GetSQL ¶
func (b *UpdateBuilder) GetSQL() (q string)
func (*UpdateBuilder) OrWhere ¶
func (b *UpdateBuilder) OrWhere(condition string) *UpdateBuilder
func (*UpdateBuilder) Set ¶
func (b *UpdateBuilder) Set(column, parameter string) *UpdateBuilder
func (*UpdateBuilder) SetParameter ¶
func (b *UpdateBuilder) SetParameter(p, v interface{}) *UpdateBuilder
func (*UpdateBuilder) Sets ¶
func (b *UpdateBuilder) Sets(columns ...string) *UpdateBuilder
func (*UpdateBuilder) Type ¶
func (b *UpdateBuilder) Type(entity interface{}) *UpdateBuilder
func (*UpdateBuilder) Where ¶
func (b *UpdateBuilder) Where(condition string) *UpdateBuilder