mysql

Documentation

Index

• Constants
• func ExtractMysqlComment(sql string) (string, string)
• func Parse(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)
• func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)
• func PutScanner(scanner *Scanner)
• type Lexer
  • func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *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 = 57664

const ACCOUNTS = 57665

const ACTION = 57621

const ADD = 57555

const ADDDATE = 57851

const ADMIN_NAME = 57714

const AFTER = 57388

const AGAINST = 57843

const ALGORITHM = 57628

const ALL = 57373

const ALTER = 57551

const ANALYZE = 57554

const AND = 57451

const ANY = 57635

const APPROXNUM = 57707

const APPROX_COUNT = 57857

const APPROX_COUNT_DISTINCT = 57858

const APPROX_PERCENTILE = 57859

const ARROW = 57897

const AS = 57376

const ASC = 57378

const ASCII = 57674

const ASSIGNMENT = 57469

const ATTRIBUTE = 57717

const AT_AT_ID = 57426

const AT_ID = 57425

const AUTOEXTEND_SIZE = 57713

const AUTO_INCREMENT = 57706

const AUTO_RANDOM = 57615

const AVG = 57888

const AVG_ROW_LENGTH = 57591

const BACKEND = 57915

const BACKUP = 57918

const BEGIN = 57482

const BETWEEN = 57453

const BIGINT = 57501

const BINARY = 57477

const BINDINGS = 57905

const BIT = 57495

const BIT_AND = 57852

const BIT_CAST = 57892

const BIT_LITERAL = 57438

const BIT_OR = 57853

const BIT_XOR = 57854

const BLOB = 57523

const BOOL = 57515

const BOOLEAN = 57844

const BOTH = 57660

const BSI = 57657

const BTREE = 57654

const BY = 57362

const CALL = 57913

const CASCADE = 57620

const CASCADED = 57401

const CASE = 57454

const CAST = 57855

const CHAIN = 57490

const CHANGE = 57672

const CHAR = 57513

const CHARACTER = 57516

const CHARSET = 57445

const CHECK = 57624

const CHECKSUM = 57595

const CIPHER = 57729

const CLIENT = 57697

const CLUSTER = 57633

const COALESCE = 57675

const COLLATE = 57476

const COLLATION = 57676

const COLUMN = 57566

const COLUMNS = 57773

const COLUMN_FORMAT = 57614

const COLUMN_NUMBER = 57783

const COMMENT = 57430

const COMMENT_KEYWORD = 57431

const COMMIT = 57485

const COMMITTED = 57796

const COMPACT = 57612

const COMPRESSED = 57610

const COMPRESSION = 57596

const CONFIG = 57837

const CONNECT = 57366

const CONNECTION = 57746

const CONSISTENT = 57488

const CONSTRAINT = 57567

const CONVERT = 57811

const COPY = 57391

const COUNT = 57856

const CREATE = 57550

const CREDENTIALS = 57434

const CROSS = 57415

const CURDATE = 57860

const CURRENT = 57720

const CURRENT_DATE = 57814

const CURRENT_ROLE = 57816

const CURRENT_TIME = 57804

const CURRENT_TIMESTAMP = 57802

const CURRENT_USER = 57815

const CURRVAL = 57895

const CURTIME = 57861

const CYCLE = 57645

const DATA = 57597

const DATABASE = 57803

const DATABASES = 57766

const DATE = 57575

const DATETIME = 57511

const DATE_ADD = 57862

const DATE_SUB = 57863

const DAY = 57667

const DAY_HOUR = 57826

const DAY_MICROSECOND = 57823

const DAY_MINUTE = 57825

const DAY_SECOND = 57824

const DEALLOCATE = 57641

const DECIMAL = 57506

const DECIMAL_VALUE = 57508

const DECLARE = 57907

const DEFAULT = 57382

const DEFINER = 57397

const DELAYED = 57549

const DELAY_KEY_WRITE = 57599

const DELETE = 57357

const DENSE_RANK = 57891

const DESC = 57379

const DESCRIBE = 57573

const DIRECTORY = 57598

const DISABLE = 57392

const DISCARD = 57760

const DISK = 57593

const DISTINCT = 57374

const DISTINCTROW = 57375

const DIV = 57473

const DO = 57906

const DOUBLE = 57504

const DRAINER = 57838

const DROP = 57552

const DUPLICATE = 57381

const DYNAMIC = 57609

const ELSE = 57457

const ELSEIF = 57459

const EMPTY = 57347

const ENABLE = 57393

const ENCLOSED = 57754

const ENCRYPTION = 57600

const END = 57458

const ENFORCED = 57625

const ENGINE = 57601

const ENGINES = 57711

const ENGINE_ATTRIBUTE = 57616

const ENUM = 57528

const ERRORS = 57775

const ESCAPE = 57576

const ESCAPED = 57755

const EVENT = 57703

const EVENTS = 57800

const EXCEPT = 57349

const EXCLUSIVE = 57739

const EXECUTE = 57690

const EXISTS = 57377

const EXPANSION = 57848

const EXPIRE = 57663

const EXPLAIN = 57574

const EXTENDED = 57769

const EXTENSION = 57643

const EXTERNAL = 57637

const EXTRACT = 57864

const FAILED_LOGIN_ATTEMPTS = 57722

const FALSE = 57443

const FIELDS = 57772

const FILE = 57700

const FILESYSTEM = 57919

const FIRST = 57386

const FIXED = 57613

const FLOAT = 57439

const FLOAT_TYPE = 57505

const FOLLOWING = 57764

const FOR = 57365

const FORCE = 57418

const FORCE_QUOTE = 57902

const FOREIGN = 57570

const FORMAT = 57744

const FROM = 57358

const FULL = 57770

const FULLTEXT = 57569

const FUNCTION = 57687

const GE = 57462

const GEOMETRY = 57530

const GEOMETRYCOLLECTION = 57534

const GLOBAL = 57787

const GRANT = 57692

const GRANTS = 57368

const GROUP = 57360

const GROUPS = 57765

const GROUP_CONCAT = 57865

const HASH = 57655

const HAVING = 57361

const HEADER = 57900

const HEADERS = 57841

const HEX = 57437

const HEXNUM = 57440

const HIGH_PRIORITY = 57548

const HISTORY = 57718

const HOUR = 57677

const HOUR_MICROSECOND = 57820

const HOUR_MINUTE = 57822

const HOUR_SECOND = 57821

const ID = 57424

const IDENTIFIED = 57728

const IF = 57564

const IGNORE = 57563

const ILIKE = 57470

const IMPORT = 57759

const IN = 57468

const INCREMENT = 57644

const INDEX = 57560

const INDEXES = 57777

const INFILE = 57751

const INLINE = 57750

const INNER = 57413

const INOUT = 57481

const INPLACE = 57390

const INSERT = 57355

const INSERT_METHOD = 57618

const INSTANT = 57389

const INT = 57499

const INT1 = 57538

const INT2 = 57539

const INT3 = 57540

const INT4 = 57541

const INT8 = 57542

const INTEGER = 57500

const INTEGRAL = 57436

const INTERSECT = 57350

const INTERVAL = 57479

const INTNUM = 57502

const INTO = 57380

const INVISIBLE = 57653

const INVOKER = 57398

const IS = 57465

const ISOLATION = 57790

const ISSUER = 57730

const ITERATE = 57911

const JOIN = 57409

const JSON = 57527

const KEY = 57447

const KEYS = 57384

const KEY_BLOCK_SIZE = 57571

const KILL = 57917

const LANGUAGE = 57845

const LAST = 57387

const LASTVAL = 57896

const LE = 57461

const LEADING = 57659

const LEAVE = 57910

const LEFT = 57411

const LESS = 57583

const LEVEL = 57791

const LEX_ERROR = 57346

const LIKE = 57466

const LIMIT = 57363

const LINEAR = 57629

const LINES = 57757

const LINESTRING = 57532

const LIST = 57627

const LIST_ARG = 57429

const LOAD = 57749

const LOCAL = 57799

const LOCALFILE = 57638

const LOCALTIME = 57805

const LOCALTIMESTAMP = 57806

const LOCK = 57383

const LOCKS = 57780

const LONGBLOB = 57526

const LONGTEXT = 57522

const LOOP = 57908

const LOWER_THAN_CHARSET = 57444

const LOWER_THAN_EQ = 57460

const LOWER_THAN_ON = 57419

const LOWER_THAN_ORDER = 57352

const LOWER_THAN_SET = 57371

const LOWER_THAN_STRING = 57423

const LOW_CARDINALITY = 57712

const LOW_PRIORITY = 57547

const MANAGE = 57367

const MATCH = 57842

const MAX = 57866

const MAXVALUE = 57580

const MAX_CONNECTIONS_PER_HOUR = 57742

const MAX_FILE_SIZE = 57901

const MAX_QUERIES_PER_HOUR = 57740

const MAX_ROWS = 57602

const MAX_UPDATES_PER_HOUR = 57741

const MAX_USER_CONNECTIONS = 57743

const MEDIAN = 57874

const MEDIUMBLOB = 57525

const MEDIUMINT = 57498

const MEDIUMTEXT = 57521

const MEMORY = 57594

const MERGE = 57395

const MICROSECOND = 57678

const MID = 57867

const MIN = 57868

const MINUS = 57351

const MINUTE = 57679

const MINUTE_MICROSECOND = 57818

const MINUTE_SECOND = 57819

const MINVALUE = 57646

const MIN_ROWS = 57603

const MOD = 57474

const MODE = 57406

const MODIFY = 57671

const MODUMP = 57761

const MONTH = 57680

const MULTILINESTRING = 57536

const MULTIPOINT = 57535

const MULTIPOLYGON = 57537

const MYSQL_COMPATIBILITY_MODE = 57670

const NAMES = 57786

const NATURAL = 57416

const NCHAR = 57518

const NE = 57463

const NEVER = 57668

const NEXT = 57403

const NEXTVAL = 57893

const NO = 57491

const NODE = 57779

const NONE = 57736

const NOT = 57452

const NOW = 57869

const NULL = 57441

const NULLS = 57385

const NULLX = 57705

const NULL_SAFE_EQUAL = 57464

const NUMERIC = 57507

const OFFSET = 57364

const ON = 57420

const ONLY = 57794

const OPEN = 57774

const OPTIMIZE = 57578

const OPTION = 57693

const OPTIONAL = 57721

const OPTIONALLY = 57753

const OR = 57448

const ORDER = 57353

const OUT = 57480

const OUTER = 57414

const OUTFILE = 57899

const OVER = 57762

const OWNERSHIP = 57369

const PACK_KEYS = 57604

const PARALLEL = 57903

const PARSER = 57651

const PARTIAL = 57622

const PARTITION = 57581

const PARTITIONS = 57630

const PASSWORD = 57737

const PASSWORD_LOCK_TIME = 57723

const PERSIST = 57788

const PIPE_CONCAT = 57449

const PLUGINS = 57801

const POINT = 57531

const POLYGON = 57533

const POSITION = 57870

const PRECEDING = 57763

const PREPARE = 57640

const PRIMARY = 57565

const PRIORITY = 57493

const PRIVILEGES = 57688

const PROCEDURE = 57585

const PROCESSLIST = 57771

const PROFILES = 57748

const PROPERTIES = 57650

const PROXY = 57590

const PUBLICATION = 57647

const PUBLICATIONS = 57649

const PUMP = 57669

const QUARTER = 57681

const QUERY = 57847

const QUERY_RESULT = 57920

const QUICK = 57494

const QUOTE_ID = 57432

const RANDOM = 57715

const RANGE = 57626

const RANK = 57889

const READ = 57792

const REAL = 57503

const RECURSIVE = 57836

const REDUNDANT = 57611

const REFERENCE = 57370

const REFERENCES = 57694

const REGEXP = 57467

const RELEASE = 57492

const RELOAD = 57699

const RENAME = 57553

const REORGANIZE = 57582

const REPAIR = 57577

const REPEAT = 57682

const REPEATABLE = 57795

const REPLACE = 57810

const REPLICATION = 57695

const REQUIRE = 57734

const RESET = 57642

const RESTRICT = 57619

const RESTRICTED = 57726

const RETURNS = 57556

const REUSE = 57719

const REVERSE = 57683

const REVOKE = 57686

const RIGHT = 57412

const ROLE = 57589

const ROLES = 57781

const ROLLBACK = 57486

const ROUTINE = 57702

const ROW = 57898

const ROWS = 57758

const ROW_COUNT = 57684

const ROW_FORMAT = 57605

const ROW_NUMBER = 57890

const RTREE = 57656

const S3OPTION = 57543

const SAN = 57733

const SCHEMA = 57557

const SCHEMAS = 57778

const SECOND = 57673

const SECONDARY = 57725

const SECONDARY_ENGINE_ATTRIBUTE = 57617

const SECOND_MICROSECOND = 57817

const SECURITY = 57400

const SELECT = 57354

const SEPARATOR = 57812

const SEQUENCE = 57559

const SEQUENCES = 57768

const SERIALIZABLE = 57798

const SERVERS = 57916

const SESSION = 57789

const SESSION_USER = 57871

const SET = 57372

const SETVAL = 57894

const SHARE = 57405

const SHARED = 57738

const SHIFT_LEFT = 57471

const SHIFT_RIGHT = 57472

const SHOW = 57572

const SHUTDOWN = 57704

const SIGNED = 57708

const SIMPLE = 57623

const SLAVE = 57696

const SMALLINT = 57497

const SNAPSHOT = 57489

const SOME = 57636

const SOURCE = 57839

const SPATIAL = 57568

const SPBEGIN = 57914

const SQL = 57399

const SQL_BIG_RESULT = 57545

const SQL_BUFFER_RESULT = 57546

const SQL_CACHE = 57408

const SQL_NO_CACHE = 57407

const SQL_SMALL_RESULT = 57544

const SQL_TSI_DAY = 57829

const SQL_TSI_HOUR = 57828

const SQL_TSI_MINUTE = 57835

const SQL_TSI_MONTH = 57831

const SQL_TSI_QUARTER = 57832

const SQL_TSI_SECOND = 57834

const SQL_TSI_WEEK = 57830

const SQL_TSI_YEAR = 57833

const SSL = 57735

const STAGE = 57433

const STAGES = 57435

const START = 57483

const STARTING = 57756

const STATS_AUTO_RECALC = 57606

const STATS_PERSISTENT = 57607

const STATS_SAMPLE_PAGES = 57608

const STATUS = 57587

const STD = 57872

const STDDEV = 57873

const STDDEV_POP = 57875

const STDDEV_SAMP = 57876

const STORAGE = 57592

const STRAIGHT_JOIN = 57410

const STREAM = 57840

const STRING = 57427

const SUBDATE = 57877

const SUBJECT = 57732

const SUBPARTITION = 57631

const SUBPARTITIONS = 57632

const SUBQUERY_AS_EXPR = 57422

const SUBSCRIPTIONS = 57648

const SUBSTR = 57878

const SUBSTRING = 57879

const SUM = 57880

const SUPER = 57691

const SUSPEND = 57716

const SYSDATE = 57881

const SYSTEM_USER = 57882

const TABLE = 57558

const TABLES = 57767

const TABLESPACE = 57689

const TABLE_NUMBER = 57782

const TABLE_SIZE = 57785

const TABLE_VALUES = 57784

const TEMPORARY = 57701

const TEMPTABLE = 57396

const TERMINATED = 57752

const TEXT = 57519

const THAN = 57584

const THEN = 57456

const TIME = 57509

const TIMESTAMP = 57510

const TIMESTAMPDIFF = 57813

const TINYBLOB = 57524

const TINYINT = 57496

const TINYTEXT = 57520

const TO = 57562

const TRAILING = 57661

const TRANSACTION = 57484

const TRANSLATE = 57883

const TRIGGER = 57586

const TRIGGERS = 57747

const TRIM = 57884

const TRUE = 57442

const TRUNCATE = 57579

const TYPE = 57634

const UNARY = 57475

const UNBOUNDED = 57724

const UNCOMMITTED = 57797

const UNDEFINED = 57394

const UNDERSCORE_BINARY = 57478

const UNION = 57348

const UNIQUE = 57446

const UNKNOWN = 57662

const UNLOCK = 57666

const UNSIGNED = 57709

const UNTIL = 57912

const UNUSED = 57904

const UPDATE = 57356

const URL = 57639

const USAGE = 57698

const USE = 57417

const USER = 57727

const USING = 57421

const UTC_DATE = 57807

const UTC_TIME = 57808

const UTC_TIMESTAMP = 57809

const UUID = 57529

const VALIDATION = 57850

const VALUE = 57404

const VALUES = 57402

const VALUE_ARG = 57428

const VARBINARY = 57517

const VARCHAR = 57514

const VARIABLES = 57588

const VARIANCE = 57885

const VAR_POP = 57886

const VAR_SAMP = 57887

const VERBOSE = 57745

const VIEW = 57561

const VISIBLE = 57652

const WARNINGS = 57776

const WEEK = 57685

const WHEN = 57455

const WHERE = 57359

const WHILE = 57909

const WITH = 57846

const WITHOUT = 57849

const WORK = 57487

const WRITE = 57793

const X509 = 57731

const XOR = 57450

const YEAR = 57512

const YEAR_MONTH = 57827

const ZEROFILL = 57710

const ZONEMAP = 57658

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(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)

func ParseOne

func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)

func PutScanner

func PutScanner(scanner *Scanner)

Types

type Lexer

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

func NewLexer

func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *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

	CommentFlag bool
	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)