Hi,
I am Pavan from India. I am new to antlr world. So I am posting here,
I want a query parser engine .
Consider this example
SELECT Employees.LastName, COUNT (Orders.OrderID) AS NumberOfOrders FROM Orders INNER JOIN Employees
ON Orders.EmployeeID=Employees.EmployeeID WHERE LastName='Davolio' OR LastName='Fuller' GROUP BY LastName
HAVING COUNT (Orders.OrderID) > 25;
I want to parse this select statement and retrieve this elements by calling methods.
For example
getStatement() -> “select”
getColumn() -> [Employees.LastName, COUNT (Orders.OrderID)]
getColumnAliase() ->[null, NumberOfOrders]
getJoin() -> [Orders INNER JOIN Employees]
getJoinCondition() -> [ON Orders.EmployeeID=Employees.EmployeeID]
getWhere() -> [OR]
getOr() -> [LastName='Davolio', LastName='Fuller']
getGroupBy() -> [LastName]
getHaving() -> [COUNT (Orders.OrderID) > 25]
Please some one help in how to start working on this. I will give a try to understand. I need input how to accomplish my problem.
Please let me know if more information from my side. :)
Thanks in advance.
Pavan