kingfadzi / sql-parser-demo Goto Github PK

========
Overview
========
Simple project showing basic usage of the FoundationDB SQL Parser:
https://github.com/FoundationDB/sql-parser

The demo will scan any valid SQL statement and print all preferenced columns to
stdout. This shows the the simplest way to consume a parsed query tree,
the com.foundationdb.sql.parser.Visitor interface.


==========
Build Demo
==========
$ mvn package


============
Running Demo
============
--------------------
Parse standard input
--------------------
$ echo "SELECT x FROM t" |java -jar target/ParserDemo.jar
Statement: CursorNode
  x

-----------------------------------------------
Run the internal demo and echo input statements
-----------------------------------------------
$ java -jar target/ParserDemo.jar --demo --echo
...

-------------------------------------------
Parse a file containing one or more queries
-------------------------------------------
$ java -jar target/ParserDemo.jar --file two_queries.sql 
Statement: CursorNode
  hello
Statement: InsertNode
  state