DagonParser

• Chinese documentation

MySQL high-performance parser, use byte stream parsing.

Lexical analysis and grammatical analysis refer to MySQL 8.0

Quick start

Open the /src/test/java folder, select any statement, and run the unit test.

Optimization point

• Pure byte stream analysis, String is not generated if it is not necessary.
• Process all supported SQL, and directly generate the syntax tree after receiving the byte stream to avoid subsequent duplication of work.
• Synchronous collection of relevant information such as SQL summary during grammar analysis.

Parsed statement

DML

• Select
• Update
• Delete
• Insert
• Replace
• Call
• Do
• Handler
• ImportTable
• LoadData
• LoadXML

DDL

• Create
  • CreateTable
  • CreateTrigger
  • CreateProcedure & CreateFunction
  • CreateView
  • CreateEvent
  • CreateLogFileGroup
  • CreateResourceGroup
  • CreateRole
  • CreateServer
  • CreateTablespace
  • CreateUser
  • CreateSpatialReferenceSystem
  • CreateIndex
  • CreateDatabase
• Alter
  • AlterTable
  • AlterDatabase
  • AlterFunction
  • AlterProcedure
  • AlterTablespace
  • AlterView
  • AlterEvent
  • AlterInstance
  • AlterLogfileGroup
  • AlterResourceGroup
  • AlterServer
  • AlterTablespace
  • AlterUser
• Drop
  • DropDatabase
  • DropEvent
  • DropFunction
  • DropIndex
  • DropLogfileGroup
  • DropProcedure
  • DropServer
  • DropSpatialReferenceSystem
  • DropTablespace
  • DropTable
  • DropTrigger
  • DropView

reference

cobar

Thanks

If you want to be added to this list and have submitted an Issue or PR, please contact me.