Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#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 brentrobinson, 17 years ago

Priority: majorminor
Status: newassigned

comment:2 by brentrobinson, 17 years ago

Resolution: fixed
Status: assignedclosed

comment:3 by brentrobinson, 17 years ago

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

Note: See TracTickets for help on using tickets.