query

Documentation

Index

• Constants
• type AndExpr
• type BindParam
• type CmpExpr
• type Column
• type ColumnList
• type Condition
• type Copy
• type CreateDatabase
• type CreateIndex
• type CreateTable
• type DataType
  • func DataTypeFrom(t query.DataType) DataType
• type Delete
• type DropDatabase
• type DropTable
• type Expr
• type FormatCode
  • func FormatCodeFrom(t query.DataType) FormatCode
• type Insert
  • func NewInsertWith(tbl *Table, columns ColumnList) *Insert
• type OrExpr
• type Parser
  • func NewParser() *Parser
  • func (parser *Parser) ParseString(query string) ([]*Statement, error)
• type Schema
• type Select
• type Statement
  • func NewStatement(stmt query.Statement) *Statement
  • func (stmt *Statement) Bind(params message.BindParams) error
• type Table
• type Update

Constants

const (
	// Aliases for types defined in github.com/cybergarage/go-postgresql/postgresql/query.
	EQ  = query.EQ
	NEQ = query.NEQ
	LT  = query.LT
	LE  = query.LE
	GT  = query.GT
	GE  = query.GE
	IN  = query.IN
	NIN = query.NIN
)

Types

type AndExpr

type AndExpr = query.AndExpr

type BindParam

type BindParam = query.BindParam

Aliases for types defined in github.com/cybergarage/go-postgresql/postgresql/query.

type CmpExpr

type CmpExpr = query.CmpExpr

type Column

type Column = query.Column

type ColumnList

type ColumnList = query.ColumnList

type Condition

type Condition = query.Condition

type Copy

type Copy = query.Copy

type CreateDatabase

type CreateDatabase = query.CreateDatabase

type CreateIndex

type CreateIndex = query.CreateIndex

type CreateTable

type CreateTable = query.CreateTable

type DataType

type DataType int32

DataType represents a PostgreSQL data type using the object ID.

const (
	BoolType            DataType = 16
	ByteaType           DataType = 17
	CharType            DataType = 18
	NameType            DataType = 19
	Int8Type            DataType = 20
	Int2Type            DataType = 21
	Int2VectorType      DataType = 22
	Int4Type            DataType = 23
	RegProcType         DataType = 24
	TextType            DataType = 25
	OidType             DataType = 26
	TidType             DataType = 27
	XidType             DataType = 28
	CidType             DataType = 29
	XMLType             DataType = 142
	PointType           DataType = 600
	LsegType            DataType = 601
	PathType            DataType = 602
	BoxType             DataType = 603
	PolygonType         DataType = 604
	LineType            DataType = 628
	LineArrayType       DataType = 629
	CircleType          DataType = 718
	CircleArrayType     DataType = 719
	MacaddrType         DataType = 829
	Macaddr8Type        DataType = 774
	InetType            DataType = 869
	InetArrayType       DataType = 1040
	CidrType            DataType = 650
	CidrArrayType       DataType = 651
	Float4Type          DataType = 700
	Float8Type          DataType = 701
	UnknownType         DataType = 705
	AbstimeType         DataType = 702
	ReltimeType         DataType = 703
	TintervalType       DataType = 704
	PolygonArrayType    DataType = 628
	OidvectorType       DataType = 30
	BpcharType          DataType = 1042
	VarcharType         DataType = 1043
	DateType            DataType = 1082
	TimeType            DataType = 1083
	TimestampType       DataType = 1114
	TimestampTzType     DataType = 1184
	IntervalType        DataType = 1186
	TimeTzType          DataType = 1266
	BitType             DataType = 1560
	VarbitType          DataType = 1562
	NumericType         DataType = 1700
	RefcursorType       DataType = 1790
	RegprocedureType    DataType = 2202
	RegoperType         DataType = 2203
	RegoperatorType     DataType = 2204
	RegclassType        DataType = 2205
	RegtypeType         DataType = 2206
	RecordType          DataType = 2249
	CstringType         DataType = 2275
	AnyType             DataType = 2276
	AnyarrayType        DataType = 2277
	VoidType            DataType = 2278
	TriggerType         DataType = 2279
	LanguageHandlerType DataType = 2280
	InternalType        DataType = 2281
	OpaqueType          DataType = 2282
	AnyelementType      DataType = 2283
	AnynonarrayType     DataType = 2776
	GeometryType        DataType = 3614
	GeograpyType        DataType = 4326
)

func DataTypeFrom

func DataTypeFrom(t query.DataType) DataType

DataTypeFrom returns a data type from the specified query data type.

type Delete

type Delete = query.Delete

type DropDatabase

type DropDatabase = query.DropDatabase

type DropTable

type DropTable = query.DropTable

type Expr

type Expr = query.Expr

type FormatCode

type FormatCode int16

FormatCode represents a format code.

const (
	TextFormat   FormatCode = 0
	BinaryFormat FormatCode = 1
)

func FormatCodeFrom

func FormatCodeFrom(t query.DataType) FormatCode

DataTypeFrom returns a data type from the specified query data type.

type Insert

type Insert = query.Insert

func NewInsertWith

func NewInsertWith(tbl *Table, columns ColumnList) *Insert

NewInsertWith returns a new insert statement instance with the specified parameters.

type OrExpr

type OrExpr = query.OrExpr

type Parser

type Parser struct {
	sql.Parser
}

Parse returns a SQL parser.

func NewParser

func NewParser() *Parser

NewParser returns a new parser.

func (*Parser) ParseString

func (parser *Parser) ParseString(query string) ([]*Statement, error)

ParseString parses the specified query string and returns statements.

type Schema

type Schema = query.Schema

type Select

type Select = query.Select

type Statement

type Statement struct {
	query.Statement
}

Statement represents a statement instance.

func NewStatement

func NewStatement(stmt query.Statement) *Statement

NewStatement returns a new statement.

func (*Statement) Bind

func (stmt *Statement) Bind(params message.BindParams) error

Bind binds the statement with the specified parameters.

type Table

type Table = query.Table

type Update

type Update = query.Update