All Projects → MyCATApache → SQLparser

MyCATApache / SQLparser

Licence: other
A Quick SQL Parser Designed for MyCAT 2.0

Programming Languages

java
68154 projects - #9 most used programming language

Projects that are alternatives of or similar to SQLparser

my-demo
Demo Application for Dubbo, Mycat, Sharding-Proxy, Seata, SkyWalking, PinPoint, ZipKin, Docker, Kubernetes, Istio, Postman/Newman, FitNesse
Stars: ✭ 37 (-33.93%)
Mutual labels:  mycat
Blog
每周一篇,内容精简,不咸不淡,期盼探讨。微信公众号:芋道源码【纯源码分享公众号】
Stars: ✭ 2,327 (+4055.36%)
Mutual labels:  mycat
Technology Talk
汇总java生态圈常用技术框架、开源中间件,系统架构、数据库、大公司架构案例、常用三方类库、项目管理、线上问题排查、个人成长、思考等知识
Stars: ✭ 12,136 (+21571.43%)
Mutual labels:  mycat
Smproxy
Swoole MySQL Proxy 一个基于 MySQL 协议,Swoole 开发的MySQL数据库连接池。 A MySQL database connection pool based on MySQL protocol and Swoole.
Stars: ✭ 1,665 (+2873.21%)
Mutual labels:  mycat
docker-mycat
docker创建mycat
Stars: ✭ 66 (+17.86%)
Mutual labels:  mycat

SQLParser

通过一次遍历提取SQL相关信息的项目,为MYCAT2.0而设计

还需要完善的部分:

  • 注解语法catlet、db_type、sql、schema的提取
  • DCL、TCL语法支持
  • ""和''字符串支持 √
  • 注释支持 √
  • 生成sql语句hash值
  • 生成schema和table name的hash值 √
  • 支持获取limit条数 √

SQLContext考虑实现以下接口:

  1. sql语句个数(通过 ; 区分) √
  2. 单个sql语句中token位置,例如 [select(1), from(15), join(26)]
  3. 单个sql语句表名位置及其hash √
  4. 单个sql语句库名(与表名相关)位置及其hash √
  5. 是否包含注解 √
  6. 注解类型 √
  7. 注解语句 √
  8. sql关键字替换
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].