void MainWindow::setupConnections()
{
/*
* Actions
*/
connect(actionAbout, SIGNAL(triggered()), aboutDial, SLOT(exec()));
connect(actionAddDb, SIGNAL(triggered()), this, SLOT(createDatabase()));
connect(actionClearRecent, SIGNAL(triggered()), this, SLOT(clearRecent()));
connect(actionCloseTab, SIGNAL(triggered()), this, SLOT(closeCurrentTab()));
connect(actionCopy, SIGNAL(triggered()), this, SLOT(copy()));
connect(actionCut, SIGNAL(triggered()), this, SLOT(cut()));
connect(actionDbManager, SIGNAL(triggered()), dbDialog, SLOT(exec()));
connect(actionLogs, SIGNAL(triggered()), logDial, SLOT(exec()));
connect(actionNewQuery, SIGNAL(triggered()), this, SLOT(newQuery()));
connect(actionNextTab, SIGNAL(triggered()), this, SLOT(nextTab()));
connect(actionOpenQuery, SIGNAL(triggered()), this, SLOT(openQuery()));
connect(actionPaste, SIGNAL(triggered()), this, SLOT(paste()));
connect(actionPlugins, SIGNAL(triggered()), pluginDialog, SLOT(exec()));
connect(actionPreferences, SIGNAL(triggered()), confDial, SLOT(exec()));
connect(actionPreviousTab, SIGNAL(triggered()), this, SLOT(previousTab()));
connect(actionPrint, SIGNAL(triggered()), this, SLOT(print()));
connect(actionRedo, SIGNAL(triggered()), this, SLOT(redo()));
connect(actionSaveQuery, SIGNAL(triggered()), this, SLOT(saveQuery()));
connect(actionSaveQueryAs, SIGNAL(triggered()), this, SLOT(saveQueryAs()));
connect(actionSearch, SIGNAL(triggered()), this, SLOT(search()));
connect(actionSelect_all, SIGNAL(triggered()), this, SLOT(selectAll()));
connect(actionUndo, SIGNAL(triggered()), this, SLOT(undo()));
/*
* DbTreeView
*/
connect(dbTreeView, SIGNAL(tableSelected(QSqlDatabase*,QString)),
this, SLOT(openTable(QSqlDatabase*,QString)));
/*
* DbManager
*/
connect(DbManager::instance(), SIGNAL(statusChanged(QSqlDatabase*)),
this, SLOT(checkDb(QSqlDatabase*)));
connect(DbManager::model(), SIGNAL(dataChanged(QModelIndex,QModelIndex)),
this, SLOT(reloadDbList()));
/*
* Dialogs
*/
connect(dbWizard, SIGNAL(accepted()), this, SLOT(reloadDbList()));
connect(logDial, SIGNAL(event(QString)),
QMainWindow::statusBar(), SLOT(showMessage(QString)));
connect(QueryScheduler::instance(), SIGNAL(countChanged(int)),
this, SLOT(setQueryCount(int)));
/*
* Tab widget
*/
connect(tabWidget, SIGNAL(currentChanged(int)), this, SLOT(refreshTab()));
connect(tabWidget, SIGNAL(tabCloseRequested(int)), this, SLOT(closeTab(int)));
}
QgsOracleFeatureIterator::QgsOracleFeatureIterator( QgsOracleFeatureSource* source, bool ownSource, const QgsFeatureRequest &request )
: QgsAbstractFeatureIteratorFromSource( source, ownSource, request )
, mRewind( false )
{
mConnection = QgsOracleConn::connectDb( mSource->mUri.connectionInfo() );
if ( !mConnection )
{
close();
return;
}
mQry = QSqlQuery( *mConnection );
if ( mRequest.flags() & QgsFeatureRequest::SubsetOfAttributes )
{
mAttributeList = mRequest.subsetOfAttributes();
if ( mAttributeList.isEmpty() )
mAttributeList = mSource->mFields.allAttributesList();
}
else
mAttributeList = mSource->mFields.allAttributesList();
QString whereClause;
switch ( request.filterType() )
{
case QgsFeatureRequest::FilterExpression:
break;
case QgsFeatureRequest::FilterRect:
if ( !mSource->mGeometryColumn.isNull() )
{
QgsRectangle rect( mRequest.filterRect() );
QString bbox = QString( "mdsys.sdo_geometry(2003,%1,NULL,"
"mdsys.sdo_elem_info_array(1,1003,3),"
"mdsys.sdo_ordinate_array(%2,%3,%4,%5)"
")" )
.arg( mSource->mSrid < 1 ? "NULL" : QString::number( mSource->mSrid ) )
.arg( qgsDoubleToString( rect.xMinimum() ) )
.arg( qgsDoubleToString( rect.yMinimum() ) )
.arg( qgsDoubleToString( rect.xMaximum() ) )
.arg( qgsDoubleToString( rect.yMaximum() ) );
if ( !mSource->mSpatialIndex.isNull() )
{
whereClause = QString( "sdo_filter(%1,%2)='TRUE'" ).arg( QgsOracleProvider::quotedIdentifier( mSource->mGeometryColumn ) ).arg( bbox );
#if 0
if ( mRequest.flags() & QgsFeatureRequest::ExactIntersect )
{
whereClause += QString( " AND sdo_relate(%1,%2,'mask=ANYINTERACT')='TRUE'" )
.arg( quotedIdentifier( P->mGeometryColumn ) )
.arg( bbox );
}
#endif
}
}
break;
case QgsFeatureRequest::FilterFid:
whereClause = QgsOracleUtils::whereClause( request.filterFid(), mSource->mFields, mSource->mPrimaryKeyType, mSource->mPrimaryKeyAttrs, mSource->mShared );
break;
case QgsFeatureRequest::FilterFids:
whereClause = QgsOracleUtils::whereClause( request.filterFids(), mSource->mFields, mSource->mPrimaryKeyType, mSource->mPrimaryKeyAttrs, mSource->mShared );
break;
case QgsFeatureRequest::FilterNone:
break;
}
if ( mSource->mRequestedGeomType != QGis::WKBUnknown && mSource->mRequestedGeomType != mSource->mDetectedGeomType )
{
if ( !whereClause.isEmpty() )
whereClause += " AND ";
whereClause += QgsOracleConn::databaseTypeFilter( "featureRequest", mSource->mGeometryColumn, mSource->mRequestedGeomType );
}
if ( !mSource->mSqlWhereClause.isEmpty() )
{
if ( !whereClause.isEmpty() )
whereClause += " AND ";
whereClause += "(" + mSource->mSqlWhereClause + ")";
}
if ( !openQuery( whereClause ) )
return;
}
QgsOracleFeatureIterator::QgsOracleFeatureIterator( QgsOracleProvider *p, const QgsFeatureRequest &request )
: QgsAbstractFeatureIterator( request )
, P( p )
, mRewind( false )
{
P->mActiveIterators << this;
mQry = QSqlQuery( *P->mConnection );
if ( mRequest.flags() & QgsFeatureRequest::SubsetOfAttributes )
{
mAttributeList = mRequest.subsetOfAttributes();
if ( mAttributeList.isEmpty() )
mAttributeList = P->attributeIndexes();
}
else
mAttributeList = P->attributeIndexes();
QString whereClause;
switch ( request.filterType() )
{
case QgsFeatureRequest::FilterExpression:
break;
case QgsFeatureRequest::FilterRect:
if ( !P->mGeometryColumn.isNull() )
{
QgsRectangle rect( mRequest.filterRect() );
QString bbox = QString( "mdsys.sdo_geometry(2003,%1,NULL,"
"mdsys.sdo_elem_info_array(1,1003,3),"
"mdsys.sdo_ordinate_array(%2,%3,%4,%5)"
")" )
.arg( P->mSrid < 1 ? "NULL" : QString::number( P->mSrid ) )
.arg( qgsDoubleToString( rect.xMinimum() ) )
.arg( qgsDoubleToString( rect.yMinimum() ) )
.arg( qgsDoubleToString( rect.xMaximum() ) )
.arg( qgsDoubleToString( rect.yMaximum() ) );
if ( !P->mSpatialIndex.isNull() )
{
whereClause = QString( "sdo_filter(%1,%2)='TRUE'" ).arg( P->quotedIdentifier( P->mGeometryColumn ) ).arg( bbox );
#if 0
if ( mRequest.flags() & QgsFeatureRequest::ExactIntersect )
{
whereClause += QString( " AND sdo_relate(%1,%2,'mask=ANYINTERACT')='TRUE'" )
.arg( quotedIdentifier( P->mGeometryColumn ) )
.arg( bbox );
}
#endif
}
}
break;
case QgsFeatureRequest::FilterFid:
whereClause = P->whereClause( request.filterFid() );
break;
case QgsFeatureRequest::FilterFids:
whereClause = P->whereClause( request.filterFids() );
break;
case QgsFeatureRequest::FilterNone:
break;
}
if ( P->mRequestedGeomType != QGis::WKBUnknown && P->mRequestedGeomType != P->mDetectedGeomType )
{
if ( !whereClause.isEmpty() )
whereClause += " AND ";
whereClause += QgsOracleConn::databaseTypeFilter( "featureRequest", P->mGeometryColumn, P->mRequestedGeomType );
}
if ( !P->mSqlWhereClause.isEmpty() )
{
if ( !whereClause.isEmpty() )
whereClause += " AND ";
whereClause += "(" + P->mSqlWhereClause + ")";
}
if ( !openQuery( whereClause ) )
return;
}