@@ -299,31 +299,32 @@ void QgsDbSourceSelect::addTables()
299
299
QString query = table + " sql=" ;
300
300
301
301
QComboBox *cb = static_cast <QComboBox *>( lstTables->cellWidget (i, dbssType) );
302
- if (cb) {
303
- int i = table.find (" (" );
304
- int j = table.find (" )" );
305
- QString column = table.mid (i+1 ,j-i-1 );
306
- QString type;
307
-
308
- QMapIterator <QString, QPair<QString, QIcon>> it (mLayerIcons );
309
- while ( it.hasNext () ) {
310
- it.next ();
311
-
312
- if ( it.value ().first == cb->currentText () ) {
313
- type=it.key ();
314
- break ;
315
- }
316
- }
317
-
318
- if ( type==" POINT" ) {
319
- query += QString (" GeometryType(\" %1\" ) IN ('POINT','MULTIPOINT')" ).arg (column);
320
- } else if (type==" LINESTRING" ) {
321
- query += QString (" GeometryType(\" %1\" ) IN ('LINESTRING','MULTILINESTRING')" ).arg (column);
322
- } else if (type==" POLYGON" ) {
323
- query += QString (" GeometryType(\" %1\" ) IN ('POLYGON','MULTIPOLYGON')" ).arg (column);
324
- } else {
325
- continue ;
326
- }
302
+ if (cb)
303
+ {
304
+ int i = table.find (" (" );
305
+ int j = table.find (" )" );
306
+ QString column = table.mid (i+1 ,j-i-1 );
307
+ QString type;
308
+
309
+ QMapIterator <QString, QPair < QString, QIcon > > it (mLayerIcons );
310
+ while ( it.hasNext () ) {
311
+ it.next ();
312
+
313
+ if ( it.value ().first == cb->currentText () ) {
314
+ type=it.key ();
315
+ break ;
316
+ }
317
+ }
318
+
319
+ if ( type==" POINT" ) {
320
+ query += QString (" GeometryType(\" %1\" ) IN ('POINT','MULTIPOINT')" ).arg (column);
321
+ } else if (type==" LINESTRING" ) {
322
+ query += QString (" GeometryType(\" %1\" ) IN ('LINESTRING','MULTILINESTRING')" ).arg (column);
323
+ } else if (type==" POLYGON" ) {
324
+ query += QString (" GeometryType(\" %1\" ) IN ('POLYGON','MULTIPOLYGON')" ).arg (column);
325
+ } else {
326
+ continue ;
327
+ }
327
328
}
328
329
329
330
QTableWidgetItem *sqlItem = lstTables->item (i, dbssSql);
@@ -407,47 +408,47 @@ void QgsDbSourceSelect::on_btnConnect_clicked()
407
408
{
408
409
QString myThemePath = QgsApplication::themePath ();
409
410
mLayerIcons .insert (" POINT" ,
410
- qMakePair (tr (" Point layer" ),
411
- QIcon (myThemePath+" /mIconPointLayer.png" )));
411
+ qMakePair (tr (" Point layer" ),
412
+ QIcon (myThemePath+" /mIconPointLayer.png" )));
412
413
mLayerIcons .insert (" MULTIPOINT" ,
413
- qMakePair (tr (" Multi-point layer" ),
414
- mLayerIcons .value (" POINT" ).second ));
414
+ qMakePair (tr (" Multi-point layer" ),
415
+ mLayerIcons .value (" POINT" ).second ));
415
416
416
417
mLayerIcons .insert (" LINESTRING" ,
417
- qMakePair (tr (" Linestring layer" ),
418
- QIcon (myThemePath+" /mIconLineLayer.png" )));
418
+ qMakePair (tr (" Linestring layer" ),
419
+ QIcon (myThemePath+" /mIconLineLayer.png" )));
419
420
mLayerIcons .insert (" MULTILINESTRING" ,
420
- qMakePair (tr (" Multi-linestring layer" ),
421
- mLayerIcons .value (" LINESTRING" ).second ));
421
+ qMakePair (tr (" Multi-linestring layer" ),
422
+ mLayerIcons .value (" LINESTRING" ).second ));
422
423
423
424
mLayerIcons .insert (" POLYGON" ,
424
- qMakePair (tr (" Polygon layer" ),
425
- QIcon (myThemePath+" /mIconPolygonLayer.png" )));
425
+ qMakePair (tr (" Polygon layer" ),
426
+ QIcon (myThemePath+" /mIconPolygonLayer.png" )));
426
427
mLayerIcons .insert (" MULTIPOLYGON" ,
427
- qMakePair (tr (" Multi-polygon layer" ),
428
- mLayerIcons .value (" POLYGON" ).second ));
428
+ qMakePair (tr (" Multi-polygon layer" ),
429
+ mLayerIcons .value (" POLYGON" ).second ));
429
430
430
431
mLayerIcons .insert (" GEOMETRY" ,
431
- qMakePair (tr (" Mixed geometry layer" ),
432
- QIcon (myThemePath+" /mIconGeometryLayer.png" )));
432
+ qMakePair (tr (" Mixed geometry layer" ),
433
+ QIcon (myThemePath+" /mIconGeometryLayer.png" )));
433
434
mLayerIcons .insert (" GEOMETRYCOLLECTION" ,
434
- qMakePair (tr (" Geometry collection layer" ),
435
- mLayerIcons .value (" GEOMETRY" ).second ));
435
+ qMakePair (tr (" Geometry collection layer" ),
436
+ mLayerIcons .value (" GEOMETRY" ).second ));
436
437
437
438
mLayerIcons .insert (" WAITING" ,
438
- qMakePair (tr (" Waiting for layer type" ),
439
- QIcon (myThemePath+" /mIconWaitingForLayerType.png" )));
439
+ qMakePair (tr (" Waiting for layer type" ),
440
+ QIcon (myThemePath+" /mIconWaitingForLayerType.png" )));
440
441
mLayerIcons .insert (" UNKNOWN" ,
441
- qMakePair (tr (" Unknown layer type" ),
442
- QIcon (myThemePath+" /mIconUnknownLayerType.png" )));
442
+ qMakePair (tr (" Unknown layer type" ),
443
+ QIcon (myThemePath+" /mIconUnknownLayerType.png" )));
443
444
444
- mCbMinLength = 0 ;
445
- QMapIterator <QString, QPair< QString, QIcon> > it (mLayerIcons );
445
+ mCbMinLength = 0 ;
446
+ QMapIterator <QString, QPair < QString, QIcon > > it (mLayerIcons );
446
447
while ( it.hasNext () ) {
447
448
it.next ();
448
- int len = it.value ().first .length ();;
449
- mCbMinLength = mCbMinLength <len ? len : mCbMinLength ;
450
- }
449
+ int len = it.value ().first .length ();;
450
+ mCbMinLength = mCbMinLength <len ? len : mCbMinLength ;
451
+ }
451
452
}
452
453
// qDebug("Connection succeeded");
453
454
// tell the DB that we want text encoded in UTF8
0 commit comments