Importing from an Oracle Spatial Database

    

      
#include "StdAfx.h"
      
#include "StdArx.h"
      
#include "AdMapOracleConnection.h"
      
#include "AdMapOracleQuery.h"
      
#include "AdMapOracleImport.h"
      
      
BOOL ImportFromOracle()
      
{
      

        
        
// Define Query
        
        
// Get connection pointer
        
AcMapOSEConnection *pConnection = AcMapOSEGetConnection();
        
        
// Declare query interface
        
AcmapOSEQuery *pQuery = new AcMapOSEQuery(pConnection);
        
        
// Initialize query interface with the current import query 
        
// (defined through the user interface) of an open project 
        
// drawing; in this case, the current project drawing
        
pQuery->InitWithCurrent(
        
acdbHostApplicationServices()->workingDatabase());
        
        
// Or initialize with a NULL database, which has the same 
        
// effect as the previous call
        
pQuery->InitWithCurrent();
        
        
// Or initialize with specific condition(s)
        
// Empty vector of features means query all features in the 
        
// Oracle database
        
std::vector<std::string> vFeatureNames;
        
pQuery->AddWhereConditionInFeatures( 
        
vFeatureNames,
        
"AdMapEntityType IS NOT NULL");
        
        
// You can clear the query with pQuery->Clear(),
        
// but not right now; we still need it
        
        
// Check the query with ConvertToSql()
        
char *psql = pQuery->ConvertToSql();
        
        
// Save the query to the Oracle database
        
pQuery->Save("MyQuery");
        
        
// Load the saved query into another query object
        
AcMapOSEQuery *pNewQuery = new AcMapOSEQuery(pConnection);
        
pNewQuery->Load("MyQuery");
        
        
// Compare old and new queries
        
char *pNewSql = pNewQuery->ConvertToSql();
        
        
if(strcmp(pSql,pNewSql) == 0)
        

          
acutPrintf("Query Load/Save works!\n");
        
        
else
        

          
acutPrintf("Query Load/Save failed!\n");
        
        
        
// Import Data
        
        
AcMapOSEImport *pImport = new AcMapOSEImport(pConnection);
        
        
// Use query defined above to import data
        
if(pImport->Import(pQuery))
        

          
acutPrintf("\n Import successful\n");
        
        
else
        

          
acutPrintf("\n Import failed\n");
        
        
        
delete pQuery;
        
delete pImport;
      
      
}