#96 closed enhancement (fixed)
GenericRdbms - Add view definition reader
Reported by: | brentrobinson | Owned by: | brentrobinson |
---|---|---|---|
Priority: | minor | Milestone: | 3.3.0 |
Component: | FDO API | Version: | 3.3.0 |
Severity: | 3 | Keywords: | view reverse-engineering |
Cc: | External ID: |
Description
This enhancement provides the first step to adding the ability to read view definitions (the SQL used to create each view) into the Schema Manager. It adds view definition reading support to Schema Manager base classes.
The next (future) step will be to add view readers to the specific RDBMS providers. The view definitions will be used to get more information about these views when reverse-engineering them into classes. For example, there is currently a defect regarding a view based on a table with a 1:many join to itself, e.g.:
create view myview as select a.* from mytable a, mytable b where a.id = a.parent;
Currently, the class created from this view is wrongly assigned the identity from the table.
Change History (3)
comment:1 by , 18 years ago
Priority: | major → minor |
---|---|
Status: | new → assigned |
comment:2 by , 18 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Revision: 3173 Author: brentrobinson Date: 10:43:13 AM, Thursday, July 12, 2007 Message: Ticket#97 - Added support for reading view definitions
Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsFeatureReader.cpp Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/OwnerReader.h Added : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Rd/ViewReader.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/View.h Modified : /trunk/Utilities/SchemaMgr/Physical.vcproj Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Field.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/PropertyReader.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Rd/Makefile.am Added : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Rd/ViewReader.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/View.cpp