[fdo-users] Is there a Feature class naming convention

Bruno Scott bscott at geomapgis.com
Wed Jan 23 08:44:56 EST 2008

Let me explain my problem.
We have developped a huge application that does lot of specific industry
These industry are Transportation,Cadaster,Facility management,Telco and so
We historically used 2 driver to access and Maintain all these data : OleDb
and OCI
We have recently added support to FDO
The same application could run on Access,SqlServer,Oracle,MySql.... with the
same setting (table name, column name...) only the connection string change.
To make sure that everything works fine we do unit testing on each of these
Symmary of the steps involved in unit testing
  drop all the tables
  Create all the tables
  fill all the tables with known values
  Launch some specific industry fonction
  Test if the function did the right thing
A specific industry function consist of one or many of these:
  Select some record
  Insert some record
  Delete some record
  Update some record

The only things the application knows to acheive this are
  a connection string to the database
  a table name with optionnaly a schema name
  the column names

This end up with something like this
   Drop table "MyTable"...
   Create table "MyTable"...
   Insert into "MyTable"...

These sequence of statement work fine on Most fdo provider
I have problems with Osgeo.PostGIS, 
with PostGIS i have to do that to make it working
   Drop table "MyTable"...
   Create table "MyTable"...
   Insert into "MySchema~MyTable"...

How i am suppose to know that the featureclass name should be
"MySchema~MyTable" instead of "MyTable"
I wish FDO had a method like GetPhysicalName who would return
So i would be able to map featureclassName to physical table name


JasonBirch wrote:
> I believe that the PostGIS provider only implements the native PostGIS
> data access, and has no way of storing FDO-specific logical/physical
> mappings (not sure if I have the right terminology here).  I believe
> that the second scenario would require the PostGIS provider to implement
> some way of persisting this information?
> Jason
> -----Original Message-----
> From: Orest Halustchak
> Subject: RE: [fdo-users] Is there a Feature class naming convention
> If the provider is accessing an existing schema, e.g. not created by
> fdo, then the provider decides how to map the table / file to a class
> and schema. The main thing is that the mapping is unique and unambiguous
> as Traian said.
> The other scenario is if a new class is defined via fdo. In this case,
> the caller is specifying an explicit schema name and class name. A
> describe of that class then should come back with the same names as long
> as the input names were valid (FdoISchemaCapabilities has methods to get
> information about valid names such as name size limits and valid
> characters).
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users

View this message in context: http://www.nabble.com/Is-there-a-Feature-class-naming-convention-tp15021175s18162p15041917.html
Sent from the fdo-users mailing list archive at Nabble.com.

More information about the fdo-users mailing list