sqlparser

README

sqlparser

SQL Parser

Documentation

Index

• func Parse(cursor *parsly.Cursor, dest interface{}) error
• func ParseCallExpr(rawExpr string) (*expr.Call, error)
• func ParseCreateTable(SQL string) (*table.Create, error)
• func ParseDelete(SQL string) (*del.Statement, 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 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 Option
  • func WithErrorHandler(fn func(err error, cur *parsly.Cursor, destNode interface{}) error) Option
• type Options
• type Token

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