[JBoss JIRA] Updated: (DNA-49) Sequence DDL files
by Randall Hauch (JIRA)
[ https://jira.jboss.org/jira/browse/DNA-49?page=com.atlassian.jira.plugin.... ]
Randall Hauch updated DNA-49:
-----------------------------
Fix Version/s: 0.7
(was: Future Releases)
Assignee: Barry LaFond (was: Bojidar Penchev)
Complexity: High (was: Medium)
Priority: Major (was: Minor)
Barry has picked up this work, and has developed a very nice sequencer capable of parsing the more important DDL statements from several different dialects, and constructing a graph structure that is largely the same for all dialects (though some dialects will result in dialect-specific properties and maybe nodes). The sequencer attempts to detect the dialect by running multiple parsers and finding the one with the "best fit".
One very interesting capability of this sequencer is that, although only a subset of the (more common) DDL statements are supported, the sequencer is still extremely functional since it does still add all statements into the output graph, just without much detail other than just the statement text and the position in the DDL file. Thus, if a DDL file contains statements the sequencer understands and statements that the sequencer does not understand, the graph will still contain all statements and those statements understood by the sequencer will have their full detail. Since the underlying parsers are able to operate upon a single statement, it is possible to go back later (after the parsers have been enhanced to support additional DDL statements) and re-parse only those incomplete statements in the graph.
Support for additional statements and additional dialects will be added in the future under different issues.
> 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
16 years, 5 months
[JBoss JIRA] Created: (DNA-558) DNA documentation problem
by Tom Ruff (JIRA)
DNA documentation problem
-------------------------
Key: DNA-558
URL: https://jira.jboss.org/jira/browse/DNA-558
Project: DNA
Issue Type: Bug
Components: Documentation
Affects Versions: 0.6
Reporter: Tom Ruff
This applies to the DNA Reference Guide at the following link:
http://docs.jboss.org/jbossdna/latest/manuals/reference/html/sequencing_f...
In chapter 7.2, Stream Sequencers, the following sentence left out a key word ("context").
So this:
"The provides additional details about the information that is being sequenced, including the location and properties of the node being sequenced, the MIME type of the node being sequenced, and a Problems object where the sequencer can record problems that aren't severe enough to warrant throwing an exception. "
Should be this:
"The context provides additional details about the information that is being sequenced, including the location and properties of the node being sequenced, the MIME type of the node being sequenced, and a Problems object where the sequencer can record problems that aren't severe enough to warrant throwing an exception. "
Also, immediately above that in the code block the type for the context parameter isn't provided - with javadoc hyperlink - as it is for the other two parameters. Yes, I know this should probably be a separate issue.
--
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
16 years, 5 months
[JBoss JIRA] Created: (DNA-550) Add method to Graph to read a set of properties on multiple nodes
by Randall Hauch (JIRA)
Add method to Graph to read a set of properties on multiple nodes
-----------------------------------------------------------------
Key: DNA-550
URL: https://jira.jboss.org/jira/browse/DNA-550
Project: DNA
Issue Type: Feature Request
Components: Graph
Affects Versions: 0.6
Reporter: Randall Hauch
Assignee: Randall Hauch
Priority: Blocker
Fix For: 0.7
The JCR observation manager implementation needs to be able to read the primary type and mixins of many nodes, yet there's no efficient way to do this in Graph (or Graph.Batch). The simplest case is to add a method to Graph that would take a set of property names and multiple Location objects, execute the requests as a single composite request, and return the read Property objects for each of the supplied Location objects.
--
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
16 years, 5 months
[JBoss JIRA] Created: (DNA-553) File system connector should make it possible to extend/customize the properties on the nt:folder, nt:file, and nt:resource nodes
by Randall Hauch (JIRA)
File system connector should make it possible to extend/customize the properties on the nt:folder, nt:file, and nt:resource nodes
---------------------------------------------------------------------------------------------------------------------------------
Key: DNA-553
URL: https://jira.jboss.org/jira/browse/DNA-553
Project: DNA
Issue Type: Feature Request
Affects Versions: 0.6
Reporter: Randall Hauch
Assignee: Randall Hauch
Fix For: 0.7
Using the JCR API to access files is a common use case for the file system connector and our JCR implementation. See the referenced forum thread.
However, there are times when additional properties from the files (e.g., properties of PDF or MS Office files) are to be loaded onto the nt:folder, nt:file, and nt:resource nodes. The current implementation makes this much more difficult to achieve than it should be, since it requires creating a whole new connector and subclassing most of the classes in the existing file system connector.
The existing classes should be changed so that it is far easier to add custom logic. This change should be quite straightforward.
--
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
16 years, 5 months
[JBoss JIRA] Created: (DNA-552) Support BETWEEN and NOT BETWEEN in WHERE clause of SQL language and abstract query model
by Randall Hauch (JIRA)
Support BETWEEN and NOT BETWEEN in WHERE clause of SQL language and abstract query model
----------------------------------------------------------------------------------------
Key: DNA-552
URL: https://jira.jboss.org/jira/browse/DNA-552
Project: DNA
Issue Type: Feature Request
Components: Graph
Affects Versions: 0.6
Reporter: Randall Hauch
Assignee: Randall Hauch
Fix For: 0.7
Our search/query implementation will perform much better when it can detect a range of values in a criteria. Currently, ranges can only be specified using the form "WHERE ... <dynamicOperand> <operator1> <staticOperand1> ... AND <dynamicOperand> <operator2> <staticOperand2> ..." For example:
WHERE ... DEPTH(myType) >= 3 AND DEPTH(myType) <=6
SQL already has a BETWEEN operator (and corresponding NOT BETWEEN operator) that makes this not only more concise but also more easily understandable and obvious about the intent:
WHERE ... DEPTH(myType) BETWEEN 3 and 6
This concept would also have to be added to the abstract query model, and in particular as a subclass of Constraint that has a DynamicOperand and two StaticOperand values. And by adding this specialization of Constraint, we can add an optimizer rule that looks for ANDed constraints that represent a range on a DynamicOperand, and rewrite the constraints as a BETWEEN (or NOT BETWEEN).
Note that a NOT BETWEEN would simply wrap a BetweenCriteria with a Not.
--
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
16 years, 5 months