postgres

Documentation

Index

• func Array_Scan(src interface{}, dest interface{}) error
• func Array_Value(v interface{}) (driver.Value, error)
• func CreateSchema(db *sql.DB, schema string) error
• func InitializeHSTORE(db *sql.DB, schema ...string) error
• func InitializeUUID(db *sql.DB, schema ...string) error
• func JsonbScan(dest interface{}, src interface{}) error
• func JsonbValue(obj interface{}) (driver.Value, error)
• type BigIntegerArray
  • func (h BigIntegerArray) Declare(props xql.PropertySet) string
  • func (p *BigIntegerArray) Scan(src interface{}) error
  • func (p BigIntegerArray) Value() (driver.Value, error)
• type BoolArray
  • func (h BoolArray) Declare(props xql.PropertySet) string
  • func (p *BoolArray) Scan(src interface{}) error
  • func (p BoolArray) Value() (driver.Value, error)
• type DoubleArray
  • func (h DoubleArray) Declare(props xql.PropertySet) string
  • func (p *DoubleArray) Scan(src interface{}) error
  • func (p DoubleArray) Value() (driver.Value, error)
• type Elemented
• type HSTORE
  • func (h HSTORE) Declare(props xql.PropertySet) string
  • func (h *HSTORE) Scan(value interface{}) error
  • func (h HSTORE) Value() (driver.Value, error)
• type IntegerArray
  • func (h IntegerArray) Declare(props xql.PropertySet) string
  • func (p *IntegerArray) Scan(src interface{}) error
  • func (p IntegerArray) Value() (driver.Value, error)
• type JSON
  • func (j JSON) Declare(props xql.PropertySet) string
  • func (j *JSON) Scan(value interface{}) error
  • func (j JSON) Value() (driver.Value, error)
• type JSONB
  • func (j JSONB) Declare(props xql.PropertySet) string
  • func (j *JSONB) Scan(value interface{}) error
  • func (j JSONB) Value() (driver.Value, error)
• type PostgresDialect
  • func (pb PostgresDialect) Create(t *xql.Table, options ...interface{}) (s string, args []interface{}, err error)
  • func (pb PostgresDialect) Delete(t *xql.Table, filters []xql.QueryFilter) (s string, args []interface{}, err error)
  • func (pb PostgresDialect) Drop(t *xql.Table, force bool) (stm string, args []interface{}, err error)
  • func (pb PostgresDialect) Insert(t *xql.Table, obj interface{}, col ...string) (s string, args []interface{}, err error)
  • func (pb PostgresDialect) InsertWithInsertedId(t *xql.Table, obj interface{}, insertedId string, col ...string) (s string, args []interface{}, err error)
  • func (pb PostgresDialect) Select(t *xql.Table, cols []xql.QueryColumn, filters []xql.QueryFilter, ...) (s string, args []interface{}, err error)
  • func (pb PostgresDialect) Update(t *xql.Table, filters []xql.QueryFilter, cols ...xql.UpdateColumn) (s string, args []interface{}, err error)
• type RealArray
  • func (h RealArray) Declare(props xql.PropertySet) string
  • func (p *RealArray) Scan(src interface{}) error
  • func (p RealArray) Value() (driver.Value, error)
• type SmallIntegerArray
  • func (h SmallIntegerArray) Declare(props xql.PropertySet) string
  • func (p *SmallIntegerArray) Scan(src interface{}) error
  • func (p SmallIntegerArray) Value() (driver.Value, error)
• type StringArray
  • func (h StringArray) Declare(props xql.PropertySet) string
  • func (p *StringArray) Scan(src interface{}) error
  • func (p StringArray) Value() (driver.Value, error)

Functions

func Array_Scan

func Array_Scan(src interface{}, dest interface{}) error

func Array_Value

func Array_Value(v interface{}) (driver.Value, error)

func CreateSchema

func CreateSchema(db *sql.DB, schema string) error

func InitializeHSTORE

func InitializeHSTORE(db *sql.DB, schema ...string) error

func InitializeUUID

func InitializeUUID(db *sql.DB, schema ...string) error

func JsonbScan

func JsonbScan(dest interface{}, src interface{}) error

func JsonbValue

func JsonbValue(obj interface{}) (driver.Value, error)

Types

type BigIntegerArray

type BigIntegerArray []int64

func (BigIntegerArray) Declare

func (h BigIntegerArray) Declare(props xql.PropertySet) string

func (*BigIntegerArray) Scan

func (p *BigIntegerArray) Scan(src interface{}) error

func (BigIntegerArray) Value

func (p BigIntegerArray) Value() (driver.Value, error)

type BoolArray

type BoolArray []bool

func (BoolArray) Declare

func (h BoolArray) Declare(props xql.PropertySet) string

func (*BoolArray) Scan

func (p *BoolArray) Scan(src interface{}) error

func (BoolArray) Value

func (p BoolArray) Value() (driver.Value, error)

type DoubleArray

type DoubleArray []float64

func (DoubleArray) Declare

func (h DoubleArray) Declare(props xql.PropertySet) string

func (*DoubleArray) Scan

func (p *DoubleArray) Scan(src interface{}) error

func (DoubleArray) Value

func (p DoubleArray) Value() (driver.Value, error)

type Elemented

type Elemented interface {
	Elem2Strings() []string
	Strings2Elem(...string) error
}

type HSTORE

type HSTORE map[string]interface{}

func (HSTORE) Declare

func (h HSTORE) Declare(props xql.PropertySet) string

func (*HSTORE) Scan

func (h *HSTORE) Scan(value interface{}) error

Scan implements the Scanner interface.

Note h.Map is reallocated before the scan to clear existing values. If the hstore column's database value is NULL, then h.Map is set to nil instead.

func (HSTORE) Value

func (h HSTORE) Value() (driver.Value, error)

Value implements the driver Valuer interface. Note if h.Map is nil, the database column value will be set to NULL.

type IntegerArray

type IntegerArray []int

func (IntegerArray) Declare

func (h IntegerArray) Declare(props xql.PropertySet) string

func (*IntegerArray) Scan

func (p *IntegerArray) Scan(src interface{}) error

func (IntegerArray) Value

func (p IntegerArray) Value() (driver.Value, error)

type JSON

type JSON struct {
}

func (JSON) Declare

func (j JSON) Declare(props xql.PropertySet) string

func (*JSON) Scan

func (j *JSON) Scan(value interface{}) error

func (JSON) Value

func (j JSON) Value() (driver.Value, error)

type JSONB

type JSONB JSON

func (JSONB) Declare

func (j JSONB) Declare(props xql.PropertySet) string

func (*JSONB) Scan

func (j *JSONB) Scan(value interface{}) error

func (JSONB) Value

func (j JSONB) Value() (driver.Value, error)

type PostgresDialect

type PostgresDialect struct {
}

func (PostgresDialect) Create

func (pb PostgresDialect) Create(t *xql.Table, options ...interface{}) (s string, args []interface{}, err error)

Create Implement the IDialect interface for creating table.

func (PostgresDialect) Delete

func (pb PostgresDialect) Delete(t *xql.Table, filters []xql.QueryFilter) (s string, args []interface{}, err error)

Delete Implement the IDialect interface to generate DELETE statement

func (PostgresDialect) Drop

func (pb PostgresDialect) Drop(t *xql.Table, force bool) (stm string, args []interface{}, err error)

Drop Implement the IDialect interface for generate DROP statement

func (PostgresDialect) Insert

func (pb PostgresDialect) Insert(t *xql.Table, obj interface{}, col ...string) (s string, args []interface{}, err error)

Insert Implement the IDialect interface to generate insert statement

func (PostgresDialect) InsertWithInsertedId

func (pb PostgresDialect) InsertWithInsertedId(t *xql.Table, obj interface{}, insertedId string, col ...string) (s string, args []interface{}, err error)

Insert Implement the IDialect interface to generate insert statement

func (PostgresDialect) Select

func (pb PostgresDialect) Select(t *xql.Table, cols []xql.QueryColumn, filters []xql.QueryFilter, orders []xql.QueryOrder, lockFor string, offset int64, limit int64) (s string, args []interface{}, err error)

Select Implement the IDialect interface for select values.

func (PostgresDialect) Update

func (pb PostgresDialect) Update(t *xql.Table, filters []xql.QueryFilter, cols ...xql.UpdateColumn) (s string, args []interface{}, err error)

Update Implement the IDialect interface to generate UPDATE statement

type RealArray

type RealArray []float32

func (RealArray) Declare

func (h RealArray) Declare(props xql.PropertySet) string

func (*RealArray) Scan

func (p *RealArray) Scan(src interface{}) error

func (RealArray) Value

func (p RealArray) Value() (driver.Value, error)

type SmallIntegerArray

type SmallIntegerArray []int16

func (SmallIntegerArray) Declare

func (h SmallIntegerArray) Declare(props xql.PropertySet) string

func (*SmallIntegerArray) Scan

func (p *SmallIntegerArray) Scan(src interface{}) error

func (SmallIntegerArray) Value

func (p SmallIntegerArray) Value() (driver.Value, error)

type StringArray

type StringArray []string

func (StringArray) Declare

func (h StringArray) Declare(props xql.PropertySet) string

func (*StringArray) Scan

func (p *StringArray) Scan(src interface{}) error

func (StringArray) Value

func (p StringArray) Value() (driver.Value, error)