[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2110: --------------------------------------- We have to develop an automatic process for the railroad diagrams and for their posting. A raw bnf can be exported from JJDoc that can be feed into Clapham or the online service, but I'm not sure about the upload process for Confluence. For now I've improved the overall generated BNF page. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2110: --------------------------------------- Ramesh, what do you want to do here? Attempt to keep the railroad diagrams up-to-date or keep expanding on the generated BNF that was just enhanced - https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2110: ---------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) I'll assign this one over to you. See the SQLParser.jj, it has metadata embedded in comments for the tokens and productions in a properties format for parsing simplicity. The customized generator will just directly insert the examples, which can be in wiki markup. The default BNF generator for JavaCC is bad for us. It doesn't emit any token information, but I could modify it so that we don't have to manually keep a separate BNF up-to-date. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2110: --------------------------------------- I've corrected those links. Here's the updated BNF, but it's using the default production names and the <token> convention. {code} ddlStmt ::= ( createTable | createDDLProcedure | createNameSpace | createTrigger ) ( <SEMICOLON> )? createNameSpace ::= <SET> <NAMESPACE> stringVal <AS> id createDDLProcedure ::= <CREATE> ( <VIRTUAL> | <FOREIGN> )? ( <PROCEDURE> | <FUNCTION> ) ( id <LPAREN> ( procedureParameter )? ( <COMMA> procedureParameter )* <RPAREN> ( <RETURNS> ( ( ( <TABLE> )? <LPAREN> procedureRsColumn ( <COMMA> procedureRsColumn )* <RPAREN> ) | parseDataType ) )? ( optionsClause )? ( <AS> statement )? ) procedureParameter ::= ( <IN> | <OUT> | <INOUT> )? id parseDataType ( <NOT> <NULL> )? ( <RESULT> )? ( <DEFAULT_KEYWORD> stringVal )? ( optionsClause )? procedureRsColumn ::= id parseDataType ( <NOT> <NULL> )? ( optionsClause )? createTable ::= <CREATE> ( <FOREIGN> <TABLE> | ( <VIRTUAL> )? <VIEW> ) id ( <LPAREN> createColumn ( <COMMA> createColumn )* ( <CONSTRAINT> ( primaryKeys | constraints | foreignKeys ) ( <COMMA> ( primaryKeys | constraints | foreignKeys ) )* )? <RPAREN> )? ( optionsClause )? ( <AS> queryExpression )? foreignKeys ::= <FOREIGN> <KEY> getColumnNames <REFERENCES> id ( getColumnNames )? ( optionsClause )? primaryKeys ::= <PRIMARY> <KEY> ( optionsClause )? constraints ::= ( <UNIQUE> | <INDEX> | <ACCESSPATTERN> ) ( optionsClause )? getColumnNames ::= <LPAREN> id ( <COMMA> id )* <RPAREN> createColumn ::= id parseDataType ( <NOT> <NULL> )? ( <UNIQUE> | ( <INDEX> | <AUTO_INCREMENT> )+ | ( <PRIMARY> <KEY> ) )? ( <DEFAULT_KEYWORD> stringVal )? ( optionsClause )? optionsClause ::= <OPTIONS> <LPAREN> optionPair ( <COMMA> optionPair )* <RPAREN> optionPair ::= id ( nonNumericLiteral | ( plusMinus )? unsignedNumericLiteral ) {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2110: --------------------------------------- create function is covered by createDDLProcedure. {code} createTrigger ::= <CREATE> <TRIGGER> <ON> id <INSTEAD> <OF> ( <INSERT> | <UPDATE> | <DELETE> ) <AS> forEachRowTriggerAction forEachRowTriggerAction ::= <FOR> <EACH> <ROW> ( ( <BEGIN> ( <ATOMIC> )? ( statement )* <END> ) | statement ) {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2110: ---------------------------------- Attachment: SQLParser.bnf The data type bnf is {code} parseDataType ::= ( <STRING> ( <LPAREN> intVal <RPAREN> )? ) | ( <VARCHAR> ( <LPAREN> intVal <RPAREN> )? ) | <BOOLEAN> | <BYTE> | <TINYINT> | <SHORT> | <SMALLINT> | ( <CHAR> ( <LPAREN> intVal <RPAREN> )? ) | <INTEGER> | <LONG> | <BIGINT> | ( <BIGINTEGER> ( <LPAREN> intVal <RPAREN> )? ) | <FLOAT> | <REAL> | <DOUBLE> | ( <BIGDECIMAL> ( <LPAREN> intVal ( <COMMA> intVal )? <RPAREN> )? ) | ( <DECIMAL> ( <LPAREN> intVal ( <COMMA> intVal )? <RPAREN> )? ) | <DATE> | <TIME> | <TIMESTAMP> | <OBJECT> | ( <BLOB> ( <LPAREN> intVal <RPAREN> )? ) | ( <CLOB> ( <LPAREN> intVal <RPAREN> )? ) | ( <VARBINARY> ( <LPAREN> intVal <RPAREN> )? ) | <XML> {code} The full output is attached also. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2110: -------------------------------- Attachment: image.png -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2110: --------------------------------------- I am hesitant to propose this, but I could also just modify the generator to spit out html with this js library included: http://code.google.com/p/html-railroad-diagram/ However we'd have to add that grammar page on the doc download site or we'd have to jump through a lot of confluence hoops. On the plus side the names would be linked and docs/examples can be integrated. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2110. ----------------------------------- Resolution: Done The DDL page was updated. For now we'll just create images as needed. A later enhancement would be to generate the images, but every approach has drawbacks with confluence. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira