[fdo-internals] Re: FW: [fdo-users] RE: Object and Association Support

[Brent Robinson]

Hi Crispin,

The GenericRdbms unit tests provide some examples for object and association properties. These tests run against the OSGEO MySQL, PostgreSQL, and SQLServerSpatial providers, and also the Autodesk Oracle and SqlServer providers. All files are in See  Providers\GenericRdbms\Src\UnitTest\Common.

Object Properties:

    Creating:

        See UnitTestUtil.cpp (CreateAcadSchema()). 
        A couple of object properties are added to the AcDbEntity feature class.

    Inserting Values:

        In FdoInsertTest.cpp (Insert()), tries both methods for creating object property values
        for AcDb3dPolyline class:

            Non-collection object property (xdata). Sub-properties specified directly to insertCommand
            using nested property syntax, e.g: xdata.DataValue.

            Collection object property (xdata2). Added by insertCommand2. 

Association Properties:

    Creating:
        
        In FdoAssociationSchemaTest.cpp (TestCreate()). 
        It's a bit more complex example since TestCreate() can set up a number of different test 
        cases for difference class types and inheritance scenarios. 

    Inserting:

        FdoAssociationInsertTest.cpp (masterTestNoObj()). 

    Selecting:

        FdoAssociationSelectTest.cpp (masterTestNoObj()).

Brent.

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Orest Halustchak
Sent: Wednesday, August 18, 2010 3:42 PM
To: FDO Internals Mail List
Subject: RE: [fdo-internals] Re: FW: [fdo-users] RE: Object and Association Support

Hi Crispin,

The closest examples that I think exist would be unit tests for the SQL Server Spatial and some other rdbms providers. Brent might be able to point you at some specific unit tests that have good examples.

Other than the unit tests, I'm not aware of client applications using these capabilities for a while now, so I wouldn't be surprised if you run into some bugs. I believe that the object properties would have been exercised more than association properties if that helps.

Regards,
Orest.

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Crispin_at_1Spatial
Sent: Wednesday, August 18, 2010 11:51 AM
To: fdo-internals at lists.osgeo.org
Subject: [fdo-internals] Re: FW: [fdo-users] RE: Object and Association Support


Me again!

I really need to see a schema applied, data created and queried (even if the
result is slightly wrong) to 'prove' that FDO is mature enough to handle
rich objects before potentially investing in provider/development.

Brent said (implied) that this query worked:

>> However, a filter on a data property such as:
>> 
>>    "ParentClass.ChildObject.Value = 1" 

However, I am yet to create a schema and run a query - what provider was the
above using?  Could you provider the schema XML if it is not client specific
please?


This is what I get from the Autodesk MGE provider for example when applying
an association feature class.

>> System.AccessViolationException: Attempted to read or write protected
>> memory. This is often an indication that other memory is corrupt.


Many thanks for any thoughts...
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/FW-fdo-users-RE-Object-and-Association-Support-tp5338133p5436834.html
Sent from the FDO Internals mailing list archive at Nabble.com.
_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals
_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals