git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Access SELECT and WHERE Clause column names in SQL Query


Thank you Michael.

I tried SqlVisitor only earlier but was not able to make that work. Got it
now and able to fetch required details from the query.

On Tue, Oct 30, 2018 at 7:00 PM Michael Mior <mmior@xxxxxxxxxx> wrote:

> What have you tried? You should be able to build a SqlParser and call the
> parseQuery method. With the resulting SqlNode, you may want to try
> implementing the SqlVisitor interface to get the data you need.
>
> --
> Michael Mior
> mmior@xxxxxxxxxx
>
>
> Le mar. 30 oct. 2018 à 02:02, Shashwat Kumar <shashwatkmr.001@xxxxxxxxx> a
> écrit :
>
> > Hi,
> >
> > My backend gets the SQL query from the user. I want to modify SQL
> statement
> > before executing it. How can I get the SELECT column names and WHERE
> column
> > names from the SQL query.
> > I know that probably SqlParser is to be used but I am not able to make it
> > work. Please advise.
> >
> > --
> > Regards
> > Shashwat Kumar
> >
>


-- 
Regards
Shashwat Kumar