Eclipse Community Forums: DTP » Any way to implement DDL parser

Search

Help

Login

Home » Eclipse Projects » DTP » Any way to implement DDL parser(Parse create,alter and drop statements)

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

Any way to implement DDL parser [message #552461]

Thu, 12 August 2010 09:58

Pradeep is currently offline

Friend

Messages: 2
Registered: August 2010

Junior Member

I need to parse DDL statements like create,alter and drop and extract all the field and their datatype info in each tables . I found that DTP model base project only parses select query and other related statements. So can i really do this using model base project? or some other library
Brian Payton who have commented about parsers in other threads can help me with this

Report message to a moderator

Re: Any way to implement DDL parser [message #552523 is a reply to message #552461]

Thu, 12 August 2010 13:32

David Maier is currently offline

Friend

Messages: 2
Registered: August 2010

Junior Member

Hi,

we are using ANTLR for this purpose. I have two grammar files those are doing stuff like this. One is the grammar of the Ingres Database System and another one is derived from MySQL's grammar and was created for the purpose to migrate Procedures from MySQL to Ingres. Here are the links to them:

* http://code.ingres.com/apps/IngresMigrationToolSet/IngresPar serCollectionLib/trunk/src/com/ingres/antlr/sql/resources/In gresSQL.g

* http://code.ingres.com/apps/IngresMigrationToolSet/IngresPar serCollectionLib/trunk/src/com/ingres/antlr/idiom/resources/ mysql/MySQLASTGen.g

I hope this is helpful for you.

Regards, David

Report message to a moderator

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	what is this ?
Next Topic:	Any way to implement DDL parser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 02:42:41 GMT 2024

Powered by FUDForum. Page generated in 0.02680 seconds

.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top