Eclipse Community Forums: DTP » Need help using SQL parser

Help

Home

Home » Eclipse Projects » DTP » Need help using SQL parser(SQL Parser)

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

Need help using SQL parser [message #486997]

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 #487116 is a reply to message #486997]

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:	Install just MySQL, and no SDK
Next Topic:	Need help using SQL parser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:07:59 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter