mysql

Documentation

Index

• Constants
• func ExtractMysqlComment(sql string) (string, string)
• func Parse(sql string) ([]tree.Statement, error)
• func ParseOne(sql string) (tree.Statement, error)
• type Lexer
  • func NewLexer(dialectType dialect.DialectType, sql string) *Lexer
  • func (l *Lexer) AppendStmt(stmt tree.Statement)
  • func (l *Lexer) Error(err string)
  • func (l *Lexer) GetParamIndex() int
  • func (l *Lexer) Lex(lval *yySymType) int
• type PositionedErr
  • func (p PositionedErr) Error() string
• type Scanner
  • func NewScanner(dialectType dialect.DialectType, sql string) *Scanner
  • func (s *Scanner) Scan() (int, string)

Constants

const ACCOUNT = 57628

const ACTION = 57594

const ADD = 57533

const ADDDATE = 57788

const ADMIN_NAME = 57673

const AGAINST = 57782

const ALGORITHM = 57601

const ALL = 57373

const ALTER = 57529

const ANALYZE = 57532

const AND = 57433

const ANY = 57607

const APPROXNUM = 57667

const APPROX_COUNT_DISTINCT = 57794

const APPROX_PERCENTILE = 57795

const ARROW = 57825

const AS = 57376

const ASC = 57378

const ASCII = 57634

const ASSIGNMENT = 57450

const ATTRIBUTE = 57676

const AT_AT_ID = 57412

const AT_ID = 57411

const AUTO_INCREMENT = 57666

const AUTO_RANDOM = 57591

const AVG = 57823

const AVG_ROW_LENGTH = 57567

const BEGIN = 57460

const BETWEEN = 57435

const BIGINT = 57479

const BINARY = 57457

const BINDINGS = 57834

const BIT = 57473

const BIT_AND = 57789

const BIT_LITERAL = 57420

const BIT_OR = 57790

const BIT_XOR = 57791

const BLOB = 57501

const BOOL = 57493

const BOOLEAN = 57783

const BOTH = 57624

const BSI = 57621

const BTREE = 57618

const BY = 57362

const CASCADE = 57593

const CASE = 57436

const CAST = 57792

const CHAIN = 57468

const CHAR = 57491

const CHARACTER = 57494

const CHARSET = 57427

const CHECK = 57597

const CHECKSUM = 57571

const CIPHER = 57687

const CLIENT = 57657

const COALESCE = 57635

const COLLATE = 57456

const COLLATION = 57636

const COLUMN = 57542

const COLUMNS = 57723

const COLUMN_FORMAT = 57590

const COMMENT = 57416

const COMMENT_KEYWORD = 57417

const COMMIT = 57463

const COMMITTED = 57738

const COMPACT = 57588

const COMPRESSED = 57586

const COMPRESSION = 57572

const CONFIG = 57779

const CONNECT = 57366

const CONNECTION = 57702

const CONSISTENT = 57466

const CONSTRAINT = 57543

const CONVERT = 57753

const COUNT = 57793

const CREATE = 57528

const CROSS = 57401

const CURDATE = 57796

const CURRENT = 57679

const CURRENT_DATE = 57756

const CURRENT_ROLE = 57758

const CURRENT_TIME = 57746

const CURRENT_TIMESTAMP = 57744

const CURRENT_USER = 57757

const CURTIME = 57797

const DATA = 57573

const DATABASE = 57745

const DATABASES = 57717

const DATE = 57551

const DATETIME = 57489

const DATE_ADD = 57798

const DATE_SUB = 57799

const DAY = 57630

const DAY_HOUR = 57768

const DAY_MICROSECOND = 57765

const DAY_MINUTE = 57767

const DAY_SECOND = 57766

const DEALLOCATE = 57613

const DECIMAL = 57484

const DECIMAL_VALUE = 57486

const DECLARE = 57836

const DEFAULT = 57382

const DELAYED = 57527

const DELAY_KEY_WRITE = 57575

const DELETE = 57356

const DESC = 57379

const DESCRIBE = 57549

const DIRECTORY = 57574

const DISK = 57569

const DISTINCT = 57374

const DISTINCTROW = 57375

const DIV = 57453

const DO = 57835

const DOUBLE = 57482

const DRAINER = 57780

const DROP = 57530

const DUPLICATE = 57381

const DYNAMIC = 57585

const ELSE = 57439

const EMPTY = 57347

const ENCLOSED = 57709

const ENCRYPTION = 57576

const END = 57440

const ENFORCED = 57598

const ENGINE = 57577

const ENGINES = 57671

const ENUM = 57506

const ERRORS = 57725

const ESCAPE = 57552

const ESCAPED = 57710

const EVENT = 57663

const EVENTS = 57742

const EXCEPT = 57349

const EXECUTE = 57650

const EXISTS = 57377

const EXPANSION = 57787

const EXPIRE = 57627

const EXPLAIN = 57550

const EXTENDED = 57719

const EXTERNAL = 57609

const EXTRACT = 57800

const FAILED_LOGIN_ATTEMPTS = 57681

const FALSE = 57425

const FIELDS = 57722

const FILE = 57660

const FIRST = 57386

const FIXED = 57589

const FLOAT = 57421

const FLOAT_TYPE = 57483

const FOR = 57365

const FORCE = 57404

const FORCE_QUOTE = 57832

const FOREIGN = 57546

const FORMAT = 57700

const FROM = 57357

const FROM_JSONLINE = 57715

const FULL = 57720

const FULLTEXT = 57545

const FUNCTION = 57647

const GE = 57443

const GENERATE_SERIES = 57827

const GEOMETRY = 57508

const GEOMETRYCOLLECTION = 57512

const GLOBAL = 57730

const GRANT = 57652

const GRANTS = 57368

const GROUP = 57359

const GROUP_CONCAT = 57801

const HASH = 57619

const HAVING = 57360

const HEADER = 57830

const HEX = 57419

const HEXNUM = 57422

const HIGH_PRIORITY = 57526

const HISTORY = 57677

const HOUR = 57637

const HOUR_MICROSECOND = 57762

const HOUR_MINUTE = 57764

const HOUR_SECOND = 57763

const ID = 57410

const IDENTIFIED = 57686

const IF = 57540

const IGNORE = 57539

const IMPORT = 57714

const IN = 57449

const INDEX = 57536

const INDEXES = 57727

const INFILE = 57706

const INNER = 57399

const INSERT = 57354

const INT = 57477

const INT1 = 57516

const INT2 = 57517

const INT3 = 57518

const INT4 = 57519

const INT8 = 57520

const INTEGER = 57478

const INTEGRAL = 57418

const INTERSECT = 57350

const INTERVAL = 57459

const INTNUM = 57480

const INTO = 57380

const INVISIBLE = 57617

const IS = 57446

const ISOLATION = 57732

const ISSUER = 57688

const JOIN = 57395

const JSON = 57505

const JSON_EXTRACT = 57824

const KEY = 57429

const KEYS = 57384

const KEY_BLOCK_SIZE = 57547

const LANGUAGE = 57784

const LAST = 57387

const LE = 57442

const LEADING = 57623

const LEFT = 57397

const LESS = 57559

const LEVEL = 57733

const LEX_ERROR = 57346

const LIKE = 57447

const LIMIT = 57363

const LINEAR = 57602

const LINES = 57712

const LINESTRING = 57510

const LIST = 57600

const LIST_ARG = 57415

const LOAD = 57705

const LOCAL = 57741

const LOCALFILE = 57610

const LOCALTIME = 57747

const LOCALTIMESTAMP = 57748

const LOCK = 57383

const LONGBLOB = 57504

const LONGTEXT = 57500

const LOWER_THAN_CHARSET = 57426

const LOWER_THAN_EQ = 57441

const LOWER_THAN_ON = 57405

const LOWER_THAN_SET = 57371

const LOWER_THAN_STRING = 57409

const LOW_CARDINALITY = 57672

const LOW_PRIORITY = 57525

const MANAGE = 57367

const MATCH = 57781

const MAX = 57802

const MAXVALUE = 57556

const MAX_CONNECTIONS_PER_HOUR = 57698

const MAX_FILE_SIZE = 57831

const MAX_QUERIES_PER_HOUR = 57696

const MAX_ROWS = 57578

const MAX_UPDATES_PER_HOUR = 57697

const MAX_USER_CONNECTIONS = 57699

const MEDIUMBLOB = 57503

const MEDIUMINT = 57476

const MEDIUMTEXT = 57499

const MEMORY = 57570

const MICROSECOND = 57638

const MID = 57803

const MIN = 57804

const MINUS = 57351

const MINUTE = 57639

const MINUTE_MICROSECOND = 57760

const MINUTE_SECOND = 57761

const MIN_ROWS = 57579

const MOD = 57454

const MODE = 57392

const MODUMP = 57716

const MONTH = 57640

const MULTILINESTRING = 57514

const MULTIPOINT = 57513

const MULTIPOLYGON = 57515

const NAMES = 57729

const NATURAL = 57402

const NCHAR = 57496

const NE = 57444

const NEVER = 57631

const NEXT = 57389

const NO = 57469

const NONE = 57694

const NOT = 57434

const NOW = 57805

const NULL = 57423

const NULLS = 57385

const NULLX = 57665

const NULL_SAFE_EQUAL = 57445

const NUMERIC = 57485

const OFFSET = 57364

const ON = 57406

const ONLY = 57736

const OPEN = 57724

const OPTIMIZE = 57554

const OPTION = 57653

const OPTIONAL = 57680

const OPTIONALLY = 57708

const OR = 57430

const ORDER = 57361

const OUTER = 57400

const OUTFILE = 57829

const OWNERSHIP = 57369

const PACK_KEYS = 57580

const PARSER = 57615

const PARTIAL = 57595

const PARTITION = 57557

const PARTITIONS = 57603

const PASSWORD = 57695

const PASSWORD_LOCK_TIME = 57682

const PIPE_CONCAT = 57431

const PLUGINS = 57743

const POINT = 57509

const POLYGON = 57511

const POSITION = 57806

const PREPARE = 57612

const PRIMARY = 57541

const PRIORITY = 57471

const PRIVILEGES = 57648

const PROCEDURE = 57561

const PROCESSLIST = 57721

const PROFILES = 57704

const PROPERTIES = 57614

const PROXY = 57566

const PUMP = 57632

const QUARTER = 57641

const QUERY = 57786

const QUICK = 57472

const RANDOM = 57674

const RANGE = 57599

const READ = 57734

const REAL = 57481

const RECURSIVE = 57778

const REDUNDANT = 57587

const REFERENCE = 57370

const REFERENCES = 57654

const REGEXP = 57448

const RELEASE = 57470

const RELOAD = 57659

const RENAME = 57531

const REORGANIZE = 57558

const REPAIR = 57553

const REPEAT = 57642

const REPEATABLE = 57737

const REPLACE = 57752

const REPLICATION = 57655

const REQUIRE = 57692

const RESTRICT = 57592

const REUSE = 57678

const REVERSE = 57643

const REVOKE = 57646

const RIGHT = 57398

const ROLE = 57565

const ROLLBACK = 57464

const ROUTINE = 57662

const ROW = 57828

const ROWS = 57713

const ROW_COUNT = 57644

const ROW_FORMAT = 57581

const RTREE = 57620

const S3OPTION = 57521

const SAN = 57691

const SCHEMA = 57534

const SCHEMAS = 57728

const SECOND = 57633

const SECONDARY = 57684

const SECOND_MICROSECOND = 57759

const SELECT = 57352

const SEPARATOR = 57754

const SERIALIZABLE = 57740

const SESSION = 57731

const SESSION_USER = 57807

const SET = 57372

const SHARE = 57391

const SHIFT_LEFT = 57451

const SHIFT_RIGHT = 57452

const SHOW = 57548

const SHUTDOWN = 57664

const SIGNED = 57668

const SIMPLE = 57596

const SLAVE = 57656

const SMALLINT = 57475

const SNAPSHOT = 57467

const SOME = 57608

const SPATIAL = 57544

const SQL_BIG_RESULT = 57523

const SQL_BUFFER_RESULT = 57524

const SQL_CACHE = 57394

const SQL_NO_CACHE = 57393

const SQL_SMALL_RESULT = 57522

const SQL_TSI_DAY = 57771

const SQL_TSI_HOUR = 57770

const SQL_TSI_MINUTE = 57777

const SQL_TSI_MONTH = 57773

const SQL_TSI_QUARTER = 57774

const SQL_TSI_SECOND = 57776

const SQL_TSI_WEEK = 57772

const SQL_TSI_YEAR = 57775

const SSL = 57693

const START = 57461

const STARTING = 57711

const STATS_AUTO_RECALC = 57582

const STATS_PERSISTENT = 57583

const STATS_SAMPLE_PAGES = 57584

const STATUS = 57563

const STD = 57808

const STDDEV = 57809

const STDDEV_POP = 57810

const STDDEV_SAMP = 57811

const STORAGE = 57568

const STRAIGHT_JOIN = 57396

const STREAM = 57353

const STRING = 57413

const SUBDATE = 57812

const SUBJECT = 57690

const SUBPARTITION = 57604

const SUBPARTITIONS = 57605

const SUBQUERY_AS_EXPR = 57408

const SUBSTR = 57813

const SUBSTRING = 57814

const SUM = 57815

const SUPER = 57651

const SUSPEND = 57675

const SYSDATE = 57816

const SYSTEM_USER = 57817

const TABLE = 57535

const TABLES = 57718

const TABLESPACE = 57649

const TEMPORARY = 57661

const TERMINATED = 57707

const TEXT = 57497

const THAN = 57560

const THEN = 57438

const TIME = 57487

const TIMESTAMP = 57488

const TIMESTAMPDIFF = 57755

const TINYBLOB = 57502

const TINYINT = 57474

const TINYTEXT = 57498

const TO = 57538

const TRAILING = 57625

const TRANSACTION = 57462

const TRANSLATE = 57818

const TRIGGER = 57562

const TRIGGERS = 57703

const TRIM = 57819

const TRUE = 57424

const TRUNCATE = 57555

const TYPE = 57606

const UNARY = 57455

const UNBOUNDED = 57683

const UNCOMMITTED = 57739

const UNDERSCORE_BINARY = 57458

const UNION = 57348

const UNIQUE = 57428

const UNKNOWN = 57626

const UNLOCK = 57629

const UNNEST = 57826

const UNSIGNED = 57669

const UNUSED = 57833

const UPDATE = 57355

const URL = 57611

const USAGE = 57658

const USE = 57403

const USER = 57685

const USING = 57407

const UTC_DATE = 57749

const UTC_TIME = 57750

const UTC_TIMESTAMP = 57751

const UUID = 57507

const VALUE = 57390

const VALUES = 57388

const VALUE_ARG = 57414

const VARBINARY = 57495

const VARCHAR = 57492

const VARIABLES = 57564

const VARIANCE = 57820

const VAR_POP = 57821

const VAR_SAMP = 57822

const VERBOSE = 57701

const VIEW = 57537

const VISIBLE = 57616

const WARNINGS = 57726

const WEEK = 57645

const WHEN = 57437

const WHERE = 57358

const WITH = 57785

const WORK = 57465

const WRITE = 57735

const X509 = 57689

const XOR = 57432

const YEAR = 57490

const YEAR_MONTH = 57769

const ZEROFILL = 57670

const ZONEMAP = 57622

Functions

func ExtractMysqlComment

func ExtractMysqlComment(sql string) (string, string)

ExtractMysqlComment extracts the version and SQL from a comment-only query such as /*!50708 sql here */

func Parse

func Parse(sql string) ([]tree.Statement, error)

func ParseOne

func ParseOne(sql string) (tree.Statement, error)

Types

type Lexer

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

func NewLexer

func NewLexer(dialectType dialect.DialectType, sql string) *Lexer

func (*Lexer) AppendStmt

func (l *Lexer) AppendStmt(stmt tree.Statement)

func (*Lexer) Error

func (l *Lexer) Error(err string)

func (*Lexer) GetParamIndex

func (l *Lexer) GetParamIndex() int

func (*Lexer) Lex

func (l *Lexer) Lex(lval *yySymType) int

type PositionedErr

type PositionedErr struct {
	Err    string
	Line   int
	Col    int
	Near   string
	LenStr string
}

PositionedErr holds context related to parser errros

func (PositionedErr) Error

func (p PositionedErr) Error() string

type Scanner

type Scanner struct {
	LastToken string
	LastError error

	MysqlSpecialComment *Scanner

	Pos    int
	Line   int
	Col    int
	PrePos int
	// contains filtered or unexported fields
}

func NewScanner

func NewScanner(dialectType dialect.DialectType, sql string) *Scanner

func (*Scanner) Scan

func (s *Scanner) Scan() (int, string)