Eclipse Community Forums: DTP » Need help using SQL parser

Help

Home

Home » Eclipse Projects » DTP » Need help using SQL parser

Show: Today's Messages :: Show Polls :: Message Navigator

Need help using SQL parser [message #596393]

Mon, 21 September 2009 12:57

aiquefernandez

Messages: 4
Registered: September 2009

Junior Member

Hi.

I'm using the sql parser provided into the DTP package.

I'm trying to do a very simple execise: get the table name from a sql code. This could be:

question: select attribute from mytable
answer: mytable

I suppose that i can get it using the QuerySelect.getFromClause method, but I don't know how to parse an statement and get the QuerySelect from it.

Can anyone help me?, thanks.

Report message to a moderator

Re: Need help using SQL parser [message #596400 is a reply to message #596393]

Tue, 22 September 2009 00:20

Brian Payton

Messages: 154
Registered: July 2009

Senior Member

The answer partly depends on what kind of application you are creating.
If it is a Eclipse plugin application (that is, takes full advantage
of the Eclipse plugin environment) then I can send you some sample code.
If it's an RCP app. or a stand-alone Java app., then it will be more
difficult because of some plugin dependency issues.

Once you have the parser working, then you can use the "Helper" classes
in plugin org.eclipse.datatools.modelbase.sql.query to get whatever
information you need from the parsed query statement. For example,
"getTablesForStatement(QueryStatement stmt)" in the StatementHelper class.

aiquefernandez wrote:
> Hi.
>
> I'm using the sql parser provided into the DTP package.
>
> I'm trying to do a very simple execise: get the table name from a sql
> code. This could be:
>
> question: select attribute from mytable
> answer: mytable
>
> I suppose that i can get it using the QuerySelect.getFromClause method,
> but I don't know how to parse an statement and get the QuerySelect from it.
>
> Can anyone help me?, thanks.

Report message to a moderator

Previous Topic:	Need help using SQL parser
Next Topic:	Problems with datatool again - No repository found containing....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 03 11:39:14 GMT 2021

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter