[dna-issues] [JBoss JIRA] Commented: (DNA-49) Sequence DDL files

[Barry LaFond (JIRA)]

    [ https://jira.jboss.org/jira/browse/DNA-49?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12496731#action_12496731 ] 

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