[fdo-trac] #96: GenericRdbms - Add view definition reader

FDO trac_fdo at osgeo.org
Wed Jul 11 08:29:55 EDT 2007


#96: GenericRdbms - Add view definition reader
-----------------------------+----------------------------------------------
   Reporter:  brentrobinson  |       Owner:  brentrobinson           
       Type:  enhancement    |      Status:  new                     
   Priority:  major          |   Milestone:  3.3.0                   
  Component:  FDO API        |     Version:  3.3.0                   
   Severity:  3              |    Keywords:  view reverse-engineering
External_id:                 |  
-----------------------------+----------------------------------------------
 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.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/96>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list