pq

Documentation

Index

• Constants
• func Open(appName string, accessModel skydb.AccessModel, connString string, migrate bool) (skydb.Conn, error)
• type Ext
• type FalseSqlizer
  • func (s FalseSqlizer) ToSql() (sql string, args []interface{}, err error)
• type NotSqlizer
  • func (s NotSqlizer) ToSql() (sql string, args []interface{}, err error)

Constants

const (
	TypeString     = "text"
	TypeNumber     = "double precision"
	TypeBoolean    = "boolean"
	TypeJSON       = "jsonb"
	TypeTimestamp  = "timestamp without time zone"
	TypeLocation   = "geometry(Point)"
	TypeInteger    = "integer"
	TypeSerial     = "serial UNIQUE"
	TypeBigInteger = "bigint"
)

Different data types that can be saved in and loaded from postgreSQL NOTE(limouren): varchar is missing because text can replace them, see the docs here: http://www.postgresql.org/docs/9.5/static/datatype-character.html

Functions

func Open

func Open(appName string, accessModel skydb.AccessModel, connString string, migrate bool) (skydb.Conn, error)

Open returns a new connection to postgresql implementation

Types

type Ext

type Ext interface {
	sqlx.Ext
	Get(dest interface{}, query string, args ...interface{}) error
	QueryRow(query string, args ...interface{}) *sql.Row
}

Ext is an interface for both sqlx.DB and sqlx.Tx

type FalseSqlizer

type FalseSqlizer struct {
}

FalseSqlizer generates SQL condition that evaluates to false

func (FalseSqlizer) ToSql

func (s FalseSqlizer) ToSql() (sql string, args []interface{}, err error)

ToSql generates SQL for FalseSqlizer

type NotSqlizer

type NotSqlizer struct {
	Predicate sq.Sqlizer
}

NotSqlizer generates SQL condition that negates a boolean condition

func (NotSqlizer) ToSql

func (s NotSqlizer) ToSql() (sql string, args []interface{}, err error)

ToSql generates SQL for NotSqlizer