Comments (1)
That's how I parse the whole statement. Is there any more elegant way to analyst the SQL?
package main
import (
"fmt"
"github.com/knocknote/vitess-sqlparser/sqlparser"
)
func main() {
stmt, err := sqlparser.Parse("select hello, good from user_items where user_id = 1 limit 10")
if err != nil {
panic(err)
}
tableName := stmt.(*sqlparser.Select).From[0].(*sqlparser.AliasedTableExpr).Expr.(sqlparser.TableName).Name.String()
selectCol0 := stmt.(*sqlparser.Select).SelectExprs[0].(*sqlparser.AliasedExpr).Expr.(*sqlparser.ColName).Name.String()
selectCol1 := stmt.(*sqlparser.Select).SelectExprs[1].(*sqlparser.AliasedExpr).Expr.(*sqlparser.ColName).Name.String()
operator := stmt.(*sqlparser.Select).Where.Expr.(*sqlparser.ComparisonExpr).Operator
leftVal := stmt.(*sqlparser.Select).Where.Expr.(*sqlparser.ComparisonExpr).Left.(*sqlparser.ColName).Name.String()
rightVal := stmt.(*sqlparser.Select).Where.Expr.(*sqlparser.ComparisonExpr).Right.(*sqlparser.SQLVal).Val
limitNum := stmt.(*sqlparser.Select).Limit.Rowcount.(*sqlparser.SQLVal).Val
fmt.Printf("select %s, %s from %s where %s %s %s limit %s", selectCol0, selectCol1, tableName, leftVal, operator, string(rightVal), string(limitNum))
}
from vitess-sqlparser.
Related Issues (20)
- How to get 'table name'? HOT 2
- any tutorial on usage? HOT 1
- select * from abc where a = "xyz"; HOT 1
- Would like to replace all table names. Any examples? HOT 2
- Support WITH clause
- Multilevel qualifier treated as parse error
- _binary charset introducer not supported
- Any example on how to get all table names and column names from the sql ?
- Compiling for 32bit architecture HOT 1
- Support function?
- How can I get the binding query?
- support COLLATE column option, ON UPDATE constraint option in CREATE TABLE parsing?
- why "show databases" trigger [signal SIGSEGV: segmentation violation code=0x1 addr=0x48 pc=0xde0b22]
- Postgres `$` dollar placeholder support.
- Chinese are not supported
- example of parser details HOT 1
- Writes from EXPLAIN ANALYZE are classified as OtherRead
- How do you add a new where clause to an existing sql statement? HOT 1
- Fix README Installation section
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vitess-sqlparser.