sqlparser

README

sqlparser

SQL Parser

Documentation

Index

• Constants
• func Parse(cursor *parsly.Cursor, dest interface{}) error
• func ParseCallExpr(rawExpr string) (*expr.Call, error)
• func ParseCreateIndex(SQL string) (*index.Create, error)
• func ParseCreateTable(SQL string) (*table.Create, error)
• func ParseDelete(SQL string) (*del.Statement, error)
• func ParseDropIndex(SQL string) (*index.Drop, error)
• func ParseDropTable(SQL string) (*table.Drop, error)
• func ParseInsert(SQL string) (*insert.Statement, error)
• func ParseList(raw string) (query.List, error)
• func ParseLiteral(cursor *parsly.Cursor) (*expr.Literal, error)
• func ParseQualify(cursor *parsly.Cursor, qualify *expr.Qualify) error
• func ParseQuery(SQL string, opts ...Option) (*query.Select, error)
• func ParseRegisterSet(SQL string) (*schema.RegisterSet, error)
• func ParseRegisterType(SQL string) (*schema.Register, error)
• func ParseTruncateTable(SQL string) (*table.Truncate, error)
• func ParseUpdate(SQL string) (*update.Statement, error)
• func Stringify(n node.Node) string
• func TableName(node node.Node) string
• func Traverse(n node.Node, visitor func(n node.Node) bool)
• func TryParseLiteral(cursor *parsly.Cursor) (*expr.Literal, error)
• type Column
  • func NewColumn(item *query.Item) *Column
  • func (c *Column) Identity() string
• type Columns
  • func NewColumns(list query.List) Columns
  • func (c Columns) ByLowerCase() map[string]*Column
  • func (c Columns) ByName() map[string]*Column
  • func (c Columns) Index() map[string]*Column
  • func (c Columns) IsStarExpr() bool
  • func (c Columns) Namespace(namespace string) Columns
  • func (c Columns) StarExpr(namespace string) *Column
• type Kind
  • func ParseKind(SQL string) Kind
  • func (k Kind) IsCreateTable() bool
  • func (k Kind) IsDelete() bool
  • func (k Kind) IsDropTable() bool
  • func (k Kind) IsInsert() bool
  • func (k Kind) IsLoad() bool
  • func (k Kind) IsMerge() bool
  • func (k Kind) IsRegisterSet() bool
  • func (k Kind) IsRegisterType() bool
  • func (k Kind) IsSelect() bool
  • func (k Kind) IsUnknown() bool
  • func (k Kind) IsUpdate() bool
• type Option
  • func WithErrorHandler(fn func(err error, cur *parsly.Cursor, destNode interface{}) error) Option
• type Options
• type Token

Constants

const (
	KindUnknown       = "unknown"
	KindSelect        = "select"
	KindLoad          = "load"
	KindInsert        = "insert"
	KindUpdate        = "update"
	KindMerge         = "merge"
	KindDelete        = "delete"
	KindRegisterType  = "register type"
	KindRegisterSet   = "register set"
	KindCreateTable   = "create table"
	KindDropTable     = "drop table"
	KindCreateIndex   = "create index"
	KindDropIndex     = "drop index"
	KindTruncateTable = "truncate table"
)

Functions

func Parse

func Parse(cursor *parsly.Cursor, dest interface{}) error

Parse parses SQL into supplied destination

func ParseCallExpr

func ParseCallExpr(rawExpr string) (*expr.Call, error)

ParseCallExpr parses call expression

func ParseCreateIndex

func ParseCreateIndex(SQL string) (*index.Create, error)

ParseCreateIndex parses create table

func ParseCreateTable

func ParseCreateTable(SQL string) (*table.Create, error)

ParseCreateTable parses create table

func ParseDelete

func ParseDelete(SQL string) (*del.Statement, error)

ParseDelete parses DELETE statement

func ParseDropIndex

func ParseDropIndex(SQL string) (*index.Drop, error)

ParseDropIndex parses drop table

func ParseDropTable

func ParseDropTable(SQL string) (*table.Drop, error)

ParseDropTable parses drop table

func ParseInsert

func ParseInsert(SQL string) (*insert.Statement, error)

ParseInsert Parses INSERT INTO statement

func ParseList

func ParseList(raw string) (query.List, error)

ParseList parses list

func ParseLiteral

func ParseLiteral(cursor *parsly.Cursor) (*expr.Literal, error)

ParseLiteral parses literal

func ParseQualify

func ParseQualify(cursor *parsly.Cursor, qualify *expr.Qualify) error

ParseQualify parses qualify expr

func ParseQuery

func ParseQuery(SQL string, opts ...Option) (*query.Select, error)

ParseQuery parses query

func ParseRegisterSet

func ParseRegisterSet(SQL string) (*schema.RegisterSet, error)

ParseRegisterSet parses register set

func ParseRegisterType

func ParseRegisterType(SQL string) (*schema.Register, error)

ParseRegisterType parses register type

func ParseTruncateTable

func ParseTruncateTable(SQL string) (*table.Truncate, error)

ParseTruncateTable parses truncate table

func ParseUpdate

func ParseUpdate(SQL string) (*update.Statement, error)

ParseUpdate parses update statement

func Stringify

func Stringify(n node.Node) string

Stringify stringifies node

func TableName

func TableName(node node.Node) string

TableName returns main table name

func Traverse

func Traverse(n node.Node, visitor func(n node.Node) bool)

Traverse traverse node

func TryParseLiteral

func TryParseLiteral(cursor *parsly.Cursor) (*expr.Literal, error)

TryParseLiteral tries to parse literal

Types

type Column

type Column column.Spec

Column represent column

func NewColumn

func NewColumn(item *query.Item) *Column

func (*Column) Identity

func (c *Column) Identity() string

type Columns

type Columns []*Column

Columns represens column

func NewColumns

func NewColumns(list query.List) Columns

NewColumns creates a columns

func (Columns) ByLowerCase

func (c Columns) ByLowerCase() map[string]*Column

ByLowerCase indexes column by lower cased name

func (Columns) ByName

func (c Columns) ByName() map[string]*Column

ByName indexes column by name

func (Columns) Index

func (c Columns) Index() map[string]*Column

Index indexes column by first non-empty alias or name or expr respectively

func (Columns) IsStarExpr

func (c Columns) IsStarExpr() bool

func (Columns) Namespace

func (c Columns) Namespace(namespace string) Columns

Namespace returns namespace column

func (Columns) StarExpr

func (c Columns) StarExpr(namespace string) *Column

StarExpr returns star expr

type Kind

type Kind string

Kind represents the type of SQL statement.

func ParseKind

func ParseKind(SQL string) Kind

func (Kind) IsCreateTable

func (k Kind) IsCreateTable() bool

IsCreateTable returns true if the Kind is KindCreateTable.

func (Kind) IsDelete

func (k Kind) IsDelete() bool

IsDelete returns true if the Kind is KindDelete.

func (Kind) IsDropTable

func (k Kind) IsDropTable() bool

IsDropTable returns true if the Kind is KindDropTable.

func (Kind) IsInsert

func (k Kind) IsInsert() bool

IsInsert returns true if the Kind is KindInsert.

func (Kind) IsLoad

func (k Kind) IsLoad() bool

IsLoad returns true if the Kind is KindLoad.

func (Kind) IsMerge

func (k Kind) IsMerge() bool

IsMerge returns true if the Kind is KindMerge.

func (Kind) IsRegisterSet

func (k Kind) IsRegisterSet() bool

IsRegisterSet returns true if the Kind is KindRegisterSet.

func (Kind) IsRegisterType

func (k Kind) IsRegisterType() bool

IsRegisterType returns true if the Kind is KindRegisterType.

func (Kind) IsSelect

func (k Kind) IsSelect() bool

IsSelect returns true if the Kind is KindSelect.

func (Kind) IsUnknown

func (k Kind) IsUnknown() bool

IsUnknown returns true if the Kind is KindUnknown.

func (Kind) IsUpdate

func (k Kind) IsUpdate() bool

IsUpdate returns true if the Kind is KindUpdate.

type Option

type Option func(o *Options)

func WithErrorHandler

func WithErrorHandler(fn func(err error, cur *parsly.Cursor, destNode interface{}) error) Option

type Options

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

type Token

type Token int

Token represents a token