dal

package module
v1.3.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Oct 23, 2022 License: MIT Imports: 15 Imported by: 0

README

go-dal

Data Acces Layer for golang

Documentation

Index

Constants

View Source 
const UNIQUE_CONNECTION = "DAL_UNIQUE"

Variables

View Source 
var Now = nowSentinel{}

Now is a value that serializes to the current time

Functions

func And 

func And(exp ...string) (and string)

func As 

func As(name, alias string) string

func Eq 

func Eq(column, placeholder string) string

func GetConnectionManager 

func GetConnectionManager() *connectionManager

func Gt 

func Gt(column, placeholder string) string

func Gte 

func Gte(column, placeholder string) string

func Load 

func Load(rows *sql.Rows, value interface{}) (int, error)

func LoadOne 

func LoadOne(rows *sql.Rows, value interface{}) (int, error)

func Lt 

func Lt(column, placeholder string) string

func Lte 

func Lte(column, placeholder string) string

func Neq 

func Neq(column, placeholder string) string

func Or 

func Or(exp ...string) (or string)

Types

type Builder 

type Builder struct {
	// contains filtered or unexported fields
}

Builder -

func NewBuilder 

func NewBuilder() *Builder

func (*Builder) Build 

func (b *Builder) Build() (*Builder, error)

func (*Builder) Delete 

func (b *Builder) Delete(table string) *DeleteBuilder

func (*Builder) GetParameters 

func (b *Builder) GetParameters() []interface{}

func (*Builder) GetSQL 

func (b *Builder) GetSQL() string

GetSQL -

func (*Builder) Insert 

func (b *Builder) Insert(table string) *InsertBuilder

func (*Builder) RawBuild 

func (b *Builder) RawBuild() (*Builder, error)

func (*Builder) SQL 

func (b *Builder) SQL(sql string) *SQLBuilder

func (*Builder) Select 

func (b *Builder) Select(columns ...string) *SelectBuilder

Select -

func (*Builder) SetParameter 

func (b *Builder) SetParameter(p, v interface{}) *Builder

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 IBuilder 

type IBuilder interface {
	GetSQL() string
}

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 Join 

type Join struct {
	FromAlias, JoinTable, JoinCondition string
}

type NullBool 

type NullBool struct {
	sql.NullBool
}

NullBool is a type that can be null or a bool

func NewNullBool 

func NewNullBool(v interface{}) (n NullBool)

func (NullBool) MarshalJSON 

func (n NullBool) MarshalJSON() ([]byte, error)

MarshalJSON correctly serializes a NullBool to JSON

func (*NullBool) UnmarshalJSON 

func (n *NullBool) UnmarshalJSON(b []byte) error

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 

type NullInt64 struct {
	sql.NullInt64
}

NullInt64 is a type that can be null or an int

func NewNullInt64 

func NewNullInt64(v interface{}) (n NullInt64)

func (NullInt64) MarshalJSON 

func (n NullInt64) MarshalJSON() ([]byte, error)

MarshalJSON correctly serializes a NullInt64 to JSON

func (*NullInt64) UnmarshalJSON 

func (n *NullInt64) UnmarshalJSON(b []byte) error

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 

type NullTime struct {
	Time  time.Time
	Valid bool // Valid is true if Time is not NULL
}

NullTime is a type that can be null or a time

func NewNullTime 

func NewNullTime(v interface{}) (n NullTime)

func (NullTime) MarshalJSON 

func (n NullTime) MarshalJSON() ([]byte, error)

MarshalJSON correctly serializes a NullTime to JSON

func (*NullTime) Scan 

func (n *NullTime) Scan(value interface{}) error

Scan implements the Scanner interface. The value type must be time.Time or string / []byte (formatted time-string), otherwise Scan fails.

func (*NullTime) UnmarshalJSON 

func (n *NullTime) UnmarshalJSON(b []byte) error

UnmarshalJSON correctly deserializes a NullTime from JSON

func (NullTime) Value 

func (n NullTime) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Order 

type Order struct {
	// contains filtered or unexported fields
}

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

func (b *SelectBuilder) From(table string) *SelectBuilder

From -

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

func (s *Session) Exec(b Builder) error

func (*Session) FirstResult 

func (s *Session) FirstResult(b Builder) (map[string]interface{}, error)

func (*Session) FirstResultArray 

func (s *Session) FirstResultArray(b Builder) ([]interface{}, error)

func (*Session) FirstResultType 

func (s *Session) FirstResultType(b Builder, o interface{}) error

func (*Session) Query 

func (s *Session) Query(b Builder) ([]map[string]interface{}, error)

func (*Session) QueryArray 

func (s *Session) QueryArray(b Builder) ([][]interface{}, error)

func (*Session) QueryType 

func (s *Session) QueryType(b Builder, o interface{}) error

func (*Session) Scan 

func (s *Session) Scan(b Builder, v ...interface{}) error

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

type Where 

type Where struct {
	// contains filtered or unexported fields
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.