//---------------------------------------------------------
bool CData_Source_PgSQL::Source_Create(const wxTreeItemId &Item)
{
CData_Source_PgSQL_Data *pData = Item.IsOk() ? (CData_Source_PgSQL_Data *)GetItemData(Item) : NULL; if( pData == NULL ) return( false );
if( pData->Get_Type() == TYPE_ROOT
|| pData->Get_Type() == TYPE_SERVER )
{
CSG_Module *pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", DB_PGSQL_DB_Create);
if( pModule && pModule->On_Before_Execution() )
{
if( pData->Get_Type() == TYPE_SERVER )
{
pModule->Set_Parameter("PG_HOST", pData->Get_Host());
pModule->Set_Parameter("PG_PORT", pData->Get_Port());
}
if( DLG_Parameters(pModule->Get_Parameters()) )
{
pModule->Execute();
}
}
}
return( true );
}
//---------------------------------------------------------
void CData_Source_PgSQL::Source_Open(const wxTreeItemId &Item)
{
CData_Source_PgSQL_Data *pData = Item.IsOk() ? (CData_Source_PgSQL_Data *)GetItemData(Item) : NULL; if( pData == NULL ) return;
if( pData->Get_Type() == TYPE_ROOT
|| pData->Get_Type() == TYPE_SERVER )
{
CSG_Module *pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", DB_PGSQL_Get_Connection); // CGet_Connection
if( pModule && pModule->On_Before_Execution() )
{
if( pData->Get_Type() == TYPE_SERVER )
{
pModule->Set_Parameter("PG_HOST", pData->Get_Host());
pModule->Set_Parameter("PG_PORT", pData->Get_Port());
}
if( DLG_Parameters(pModule->Get_Parameters()) )
{
pModule->Execute();
}
}
}
else if( pData->is_Connected() )
{
Update_Source(Item);
}
else if( !Source_Open(pData, true) )
{
DLG_Message_Show_Error(_TL("Could not connect to data source."), _TL("Connect to PostgreSQL"));
}
}
//---------------------------------------------------------
bool PGSQL_Save_Shapes (CSG_Shapes *pShapes)
{
CSG_Module *pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", DB_PGSQL_Shapes_Save);
if( pModule && pModule->On_Before_Execution() && pModule->Set_Parameter("SHAPES", pShapes)
&& DLG_Parameters(pModule->Get_Parameters()) && pModule->Execute() )
{
return( true );
}
return( false );
}
//---------------------------------------------------------
bool PGSQL_Save_Grid (CSG_Grid *pGrid)
{
CSG_Module *pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", DB_PGSQL_Raster_Save);
if( pModule && pModule->On_Before_Execution() && pModule->Set_Parameter("NAME", pGrid->Get_Name()) )
{
pModule->Get_Parameters()->Get_Parameter("GRIDS")->asList()->Del_Items();
if( pModule->Get_Parameters()->Get_Parameter("GRIDS")->asList()->Add_Item(pGrid)
&& DLG_Parameters(pModule->Get_Parameters()) && pModule->Execute() )
{
return( true );
}
}
return( false );
}
//---------------------------------------------------------
bool CSG_Shapes::Create(const CSG_String &File_Name)
{
Destroy();
SG_UI_Msg_Add(CSG_String::Format("%s: %s...", _TL("Load shapes"), File_Name.c_str()), true);
//-----------------------------------------------------
bool bResult = File_Name.BeforeFirst(':').Cmp("PGSQL") && SG_File_Exists(File_Name) && _Load_ESRI(File_Name);
if( bResult )
{
Set_File_Name(File_Name, true);
Load_MetaData(File_Name);
}
//-----------------------------------------------------
else if( File_Name.BeforeFirst(':').Cmp("PGSQL") == 0 ) // database source
{
CSG_String s(File_Name);
s = s.AfterFirst(':'); CSG_String Host (s.BeforeFirst(':'));
s = s.AfterFirst(':'); CSG_String Port (s.BeforeFirst(':'));
s = s.AfterFirst(':'); CSG_String DBName(s.BeforeFirst(':'));
s = s.AfterFirst(':'); CSG_String Table (s.BeforeFirst(':'));
CSG_Module *pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", 0); // CGet_Connections
if( pModule != NULL )
{
SG_UI_ProgressAndMsg_Lock(true);
//---------------------------------------------
CSG_Table Connections;
CSG_String Connection = DBName + " [" + Host + ":" + Port + "]";
pModule->Settings_Push();
if( pModule->On_Before_Execution() && SG_MODULE_PARAMETER_SET("CONNECTIONS", &Connections) && pModule->Execute() ) // CGet_Connections
{
for(int i=0; !bResult && i<Connections.Get_Count(); i++)
{
if( !Connection.Cmp(Connections[i].asString(0)) )
{
bResult = true;
}
}
}
pModule->Settings_Pop();
//---------------------------------------------
if( bResult && (bResult = (pModule = SG_Get_Module_Library_Manager().Get_Module("db_pgsql", 20)) != NULL) == true ) // CPGIS_Shapes_Load
{
pModule->Settings_Push();
bResult = pModule->On_Before_Execution()
&& SG_MODULE_PARAMETER_SET("CONNECTION", Connection)
&& SG_MODULE_PARAMETER_SET("TABLES" , Table)
&& SG_MODULE_PARAMETER_SET("SHAPES" , this)
&& pModule->Execute();
pModule->Settings_Pop();
}
SG_UI_ProgressAndMsg_Lock(false);
}
}
//-----------------------------------------------------
if( bResult )
{
Set_Modified(false);
Set_Update_Flag();
SG_UI_Msg_Add(_TL("okay"), false, SG_UI_MSG_STYLE_SUCCESS);
return( true );
}
for(int iShape=Get_Count()-1; iShape>=0; iShape--) // be kind, keep at least those shapes that have been loaded successfully
{
if( !Get_Shape(iShape)->is_Valid() )
{
Del_Shape(iShape);
}
}
if( Get_Count() <= 0 )
{
Destroy();
}
SG_UI_Msg_Add(_TL("failed"), false, SG_UI_MSG_STYLE_FAILURE);
return( false );
}
