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

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