Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to go about a DDL parser
How to go about a DDL parser [message #51603] Wed, 19 November 2008 11:01 Go to next message
Yigal Spinner is currently offline Yigal Spinner
Messages: 102
Registered: July 2009
Senior Member
I'm new to the DTP project. I scan the newsgroups and other resources
and it is confusing.
In the articles
( http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm)
it shows that there is an extension point that will create a DDL parser
but I can not find the extension point.

In other article
( http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/SQL%20Query%20Parser%20User%20documentation.htm)
I found code that parses SQL commands but not the "CREATE" command.
Does some one have sample code (plugin) that will parse DDL?

I saw few newsgroup entries talking about getting the EMF model of the
DDL but no reference to how to go about doing it.

In my current project I need to create a list of tables and columns that
are created by the DDL. I would like to use the DTP to shorten the
development time of a parser.

Any help?

Thanks
Yigal
Re: How to go about a DDL parser [message #52232 is a reply to message #51603] Mon, 12 January 2009 18:40 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
Yigal,

The DDL parser extension point mentioned in the first article is defined
in plugin org.eclipse.datatools.connectivity.sqm.core. See plugin
org.eclipse.datatools.connectivity.apache.derby for an example of a
plugin that implements the interfaces defined in sqm.core.

The second article describes a parser that is focused on parsing DML
rather than DDL. It can be extended to parse DDL statements, but it
would take some work.

Regards,
Brian Payton
SQL and XQuery Tools Development
IBM Information Management

Yigal wrote:
> I'm new to the DTP project. I scan the newsgroups and other resources
> and it is confusing.
> In the articles
> ( http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm)
> it shows that there is an extension point that will create a DDL parser
> but I can not find the extension point.
>
> In other article
> ( http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/SQL%20Query%20Parser%20User%20documentation.htm)
> I found code that parses SQL commands but not the "CREATE" command.
> Does some one have sample code (plugin) that will parse DDL?
>
> I saw few newsgroup entries talking about getting the EMF model of the
> DDL but no reference to how to go about doing it.
>
> In my current project I need to create a list of tables and columns that
> are created by the DDL. I would like to use the DTP to shorten the
> development time of a parser.
>
> Any help?
>
> Thanks
> Yigal
Re: How to go about a DDL parser [message #594204 is a reply to message #51603] Mon, 12 January 2009 18:40 Go to previous message
Brian Payton is currently offline Brian Payton
Messages: 152
Registered: July 2009
Senior Member
Yigal,

The DDL parser extension point mentioned in the first article is defined
in plugin org.eclipse.datatools.connectivity.sqm.core. See plugin
org.eclipse.datatools.connectivity.apache.derby for an example of a
plugin that implements the interfaces defined in sqm.core.

The second article describes a parser that is focused on parsing DML
rather than DDL. It can be extended to parse DDL statements, but it
would take some work.

Regards,
Brian Payton
SQL and XQuery Tools Development
IBM Information Management

Yigal wrote:
> I'm new to the DTP project. I scan the newsgroups and other resources
> and it is confusing.
> In the articles
> ( http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm)
> it shows that there is an extension point that will create a DDL parser
> but I can not find the extension point.
>
> In other article
> ( http://www.eclipse.org/datatools/project_sqldevtools/sqltool s_doc/SQL%20Query%20Parser%20User%20documentation.htm)
> I found code that parses SQL commands but not the "CREATE" command.
> Does some one have sample code (plugin) that will parse DDL?
>
> I saw few newsgroup entries talking about getting the EMF model of the
> DDL but no reference to how to go about doing it.
>
> In my current project I need to create a list of tables and columns that
> are created by the DDL. I would like to use the DTP to shorten the
> development time of a parser.
>
> Any help?
>
> Thanks
> Yigal
Previous Topic:question about add predefined data type
Next Topic:sql server 2005 error only with data:sample contents
Goto Forum:
  


Current Time: Sun Apr 20 18:01:04 EDT 2014

Powered by FUDForum. Page generated in 0.14865 seconds