[
https://jira.jboss.org/jira/browse/DNA-49?page=com.atlassian.jira.plugin....
]
Barry LaFond commented on DNA-49:
---------------------------------
DESIGN SUMMARY - Randall's previous comment summarizes the basic behavior and intent
of the DdlSequencer and it's underlying parsing framework.
The following ddl dialects are included with the first version: Oracle, Derby, Postgres
and MySql
Each specific dialect extends a basic parser framework implementing the SQL 92 spec and
includes
- Detailed parsing of CREATE SCHEMA, CREATE TABLE and ALTER TABLE.
- Partial parsing of DROP statements
- General parsing of remaining schema definition statements (i.e. CREATE VIEW, CREATE
DOMAIN, etc.
- Does NOT parse SQL (i.e. SELECT, INSERT, UPDATE, etc....) statements.
Dialect flexibility is achieved through extending the base parser (StandardDdlParser) and
registering sets of dialect-specific keywords and unique "statement start
phrases" (example: CREATE TRIGGER). These registered values assist the tokenizer in
identifying key elements in your DDL which enable the base-parser to efficiently navigate
the tokens and build an object graph reflecting the intended structure of your DDL.
Sequence DDL files
------------------
Key: DNA-49
URL:
https://jira.jboss.org/jira/browse/DNA-49
Project: DNA
Issue Type: Feature Request
Components: Sequencers
Reporter: Randall Hauch
Assignee: Barry LaFond
Fix For: 0.7
Create a sequencer that parses DDL files and generates the subgraph representing the
relational schema. Multiple dialects should be supported, including those for Oracle, MS
SqlServer, PostgreSQL, MySQL, and others. Ideally this could be done with one sequencer
(since most users/admins won't care about which dialect a particular file is;
they'll just want it sequenced).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira