@@ -135,7 +135,7 @@ void QgsSpatiaLiteProvider::loadFields()
135
135
136
136
QString sql = QString ( " PRAGMA table_info(%1)" ).arg ( quotedValue ( mTableName ) );
137
137
138
- strcpy (xSql, sql.toUtf8 ().constData ());
138
+ strcpy ( xSql, sql.toUtf8 ().constData () );
139
139
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
140
140
if ( ret != SQLITE_OK )
141
141
goto error;
@@ -227,7 +227,7 @@ bool QgsSpatiaLiteProvider::featureAtId( int featureId, QgsFeature & feature, bo
227
227
}
228
228
sql += QString ( " FROM %1 WHERE ROWID = %2" ).arg ( quotedValue ( mTableName ) ).arg ( featureId );
229
229
230
- strcpy (xSql, sql.toUtf8 ().constData ());
230
+ strcpy ( xSql, sql.toUtf8 ().constData () );
231
231
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &stmt, NULL ) != SQLITE_OK )
232
232
{
233
233
// some error occurred
@@ -308,7 +308,7 @@ bool QgsSpatiaLiteProvider::featureAtId( int featureId, QgsFeature & feature, bo
308
308
if ( mFetchGeom )
309
309
{
310
310
QString geoCol = QString ( " AsBinary(%1)" ).arg ( geometryColumn );
311
- strcpy (geomName, geoCol.toUtf8 ().constData ());
311
+ strcpy ( geomName, geoCol.toUtf8 ().constData () );
312
312
if ( strcasecmp ( geomName, sqlite3_column_name ( stmt, ic ) ) == 0 )
313
313
{
314
314
if ( sqlite3_column_type ( stmt, ic ) == SQLITE_BLOB )
@@ -433,7 +433,7 @@ bool QgsSpatiaLiteProvider::nextFeature( QgsFeature & feature )
433
433
if ( mFetchGeom )
434
434
{
435
435
QString geoCol = QString ( " AsBinary(%1)" ).arg ( geometryColumn );
436
- strcpy (geomName, geoCol.toUtf8 ().constData ());
436
+ strcpy ( geomName, geoCol.toUtf8 ().constData () );
437
437
if ( strcasecmp ( geomName, sqlite3_column_name ( sqliteStatement, ic ) ) == 0 )
438
438
{
439
439
if ( sqlite3_column_type ( sqliteStatement, ic ) == SQLITE_BLOB )
@@ -553,7 +553,7 @@ void QgsSpatiaLiteProvider::select( QgsAttributeList fetchAttributes, QgsRectang
553
553
554
554
mFetchGeom = fetchGeometry;
555
555
mAttributesToFetch = fetchAttributes;
556
- strcpy (xSql, sql.toUtf8 ().constData ());
556
+ strcpy ( xSql, sql.toUtf8 ().constData () );
557
557
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &sqliteStatement, NULL ) != SQLITE_OK )
558
558
{
559
559
// some error occurred
@@ -660,7 +660,7 @@ QVariant QgsSpatiaLiteProvider::minimumValue( int index )
660
660
661
661
QString sql = QString ( " SELECT Min(%1) FROM %2" ).arg ( fld.name () ).arg ( quotedValue ( mTableName ) );
662
662
663
- strcpy (xSql, sql.toUtf8 ().constData ());
663
+ strcpy ( xSql, sql.toUtf8 ().constData () );
664
664
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
665
665
if ( ret != SQLITE_OK )
666
666
goto error;
@@ -715,7 +715,7 @@ QVariant QgsSpatiaLiteProvider::maximumValue( int index )
715
715
716
716
QString sql = QString ( " SELECT Max(%1) FROM %2" ).arg ( fld.name () ).arg ( quotedValue ( mTableName ) );
717
717
718
- strcpy (xSql, sql.toUtf8 ().constData ());
718
+ strcpy ( xSql, sql.toUtf8 ().constData () );
719
719
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
720
720
if ( ret != SQLITE_OK )
721
721
goto error;
@@ -770,7 +770,7 @@ void QgsSpatiaLiteProvider::uniqueValues( int index, QList < QVariant > &uniqueV
770
770
sql = QString ( " SELECT DISTINCT %1 FROM %2 ORDER BY %1" ).arg ( fld.name () ).arg ( quotedValue ( mTableName ) );
771
771
772
772
// SQLite prepared statement
773
- strcpy (xSql, sql.toUtf8 ().constData ());
773
+ strcpy ( xSql, sql.toUtf8 ().constData () );
774
774
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &stmt, NULL ) != SQLITE_OK )
775
775
{
776
776
// some error occurred
@@ -852,7 +852,7 @@ bool QgsSpatiaLiteProvider::addFeatures( QgsFeatureList & flist )
852
852
return true ;
853
853
const QgsAttributeMap & attributevec = flist[0 ].attributeMap ();
854
854
855
- strcpy (xSql, " BEGIN" );
855
+ strcpy ( xSql, " BEGIN" );
856
856
int ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
857
857
if ( ret != SQLITE_OK )
858
858
{
@@ -892,7 +892,7 @@ bool QgsSpatiaLiteProvider::addFeatures( QgsFeatureList & flist )
892
892
sql += " )" ;
893
893
894
894
// SQLite prepared statement
895
- strcpy (xSql, sql.toUtf8 ().constData ());
895
+ strcpy ( xSql, sql.toUtf8 ().constData () );
896
896
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &stmt, NULL ) != SQLITE_OK )
897
897
{
898
898
// some error occurred
@@ -952,7 +952,7 @@ bool QgsSpatiaLiteProvider::addFeatures( QgsFeatureList & flist )
952
952
QString txt = it->toString ();
953
953
int len = txt.length ();
954
954
char *vl = new char [len];
955
- strcpy (vl, txt.toUtf8 ().constData ());
955
+ strcpy ( vl, txt.toUtf8 ().constData () );
956
956
sqlite3_bind_text ( stmt, ++ia, vl, len, SQLITE_TRANSIENT );
957
957
delete [] vl;
958
958
}
@@ -980,7 +980,7 @@ bool QgsSpatiaLiteProvider::addFeatures( QgsFeatureList & flist )
980
980
}
981
981
sqlite3_finalize ( stmt );
982
982
983
- strcpy (xSql, " COMMIT" );
983
+ strcpy ( xSql, " COMMIT" );
984
984
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
985
985
if ( ret != SQLITE_OK )
986
986
{
@@ -1003,7 +1003,7 @@ bool QgsSpatiaLiteProvider::addFeatures( QgsFeatureList & flist )
1003
1003
if ( toCommit == true )
1004
1004
{
1005
1005
// ROLLBACK after some previous error
1006
- strcpy (xSql, " ROLLBACK" );
1006
+ strcpy ( xSql, " ROLLBACK" );
1007
1007
sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , NULL );
1008
1008
}
1009
1009
@@ -1018,7 +1018,7 @@ bool QgsSpatiaLiteProvider::deleteFeatures( const QgsFeatureIds & id )
1018
1018
QString sql;
1019
1019
char xSql[1024 ];
1020
1020
1021
- strcpy (xSql, " BEGIN" );
1021
+ strcpy ( xSql, " BEGIN" );
1022
1022
int ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1023
1023
if ( ret != SQLITE_OK )
1024
1024
{
@@ -1030,7 +1030,7 @@ bool QgsSpatiaLiteProvider::deleteFeatures( const QgsFeatureIds & id )
1030
1030
sql = QString ( " DELETE FROM %1 WHERE ROWID = ?" ).arg ( quotedValue ( mTableName ) );
1031
1031
1032
1032
// SQLite prepared statement
1033
- strcpy (xSql, sql.toUtf8 ().constData ());
1033
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1034
1034
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &stmt, NULL ) != SQLITE_OK )
1035
1035
{
1036
1036
// some error occurred
@@ -1065,7 +1065,7 @@ bool QgsSpatiaLiteProvider::deleteFeatures( const QgsFeatureIds & id )
1065
1065
}
1066
1066
sqlite3_finalize ( stmt );
1067
1067
1068
- strcpy (xSql, " COMMIT" );
1068
+ strcpy ( xSql, " COMMIT" );
1069
1069
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1070
1070
if ( ret != SQLITE_OK )
1071
1071
{
@@ -1089,7 +1089,7 @@ bool QgsSpatiaLiteProvider::deleteFeatures( const QgsFeatureIds & id )
1089
1089
if ( toCommit == true )
1090
1090
{
1091
1091
// ROLLBACK after some previous error
1092
- strcpy (xSql, " ROLLBACK" );
1092
+ strcpy ( xSql, " ROLLBACK" );
1093
1093
sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , NULL );
1094
1094
}
1095
1095
@@ -1103,7 +1103,7 @@ bool QgsSpatiaLiteProvider::addAttributes( const QgsNewAttributesMap & name )
1103
1103
QString sql;
1104
1104
char xSql[1024 ];
1105
1105
1106
- strcpy (xSql, " BEGIN" );
1106
+ strcpy ( xSql, " BEGIN" );
1107
1107
int ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1108
1108
if ( ret != SQLITE_OK )
1109
1109
{
@@ -1115,7 +1115,7 @@ bool QgsSpatiaLiteProvider::addAttributes( const QgsNewAttributesMap & name )
1115
1115
for ( QgsNewAttributesMap::const_iterator iter = name.begin (); iter != name.end (); ++iter )
1116
1116
{
1117
1117
sql = QString ( " ALTER TABLE %1 ADD COLUMN %2 %3" ).arg ( quotedValue ( mTableName ) ).arg ( quotedValue ( iter.key () ) ).arg ( iter.value () );
1118
- strcpy (xSql, sql.toUtf8 ().constData ());
1118
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1119
1119
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1120
1120
if ( ret != SQLITE_OK )
1121
1121
{
@@ -1124,7 +1124,7 @@ bool QgsSpatiaLiteProvider::addAttributes( const QgsNewAttributesMap & name )
1124
1124
}
1125
1125
}
1126
1126
1127
- strcpy (xSql, " COMMIT" );
1127
+ strcpy ( xSql, " COMMIT" );
1128
1128
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1129
1129
if ( ret != SQLITE_OK )
1130
1130
{
@@ -1148,7 +1148,7 @@ bool QgsSpatiaLiteProvider::addAttributes( const QgsNewAttributesMap & name )
1148
1148
if ( toCommit == true )
1149
1149
{
1150
1150
// ROLLBACK after some previous error
1151
- strcpy (xSql, " ROLLBACK" );
1151
+ strcpy ( xSql, " ROLLBACK" );
1152
1152
sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , NULL );
1153
1153
}
1154
1154
@@ -1162,7 +1162,7 @@ bool QgsSpatiaLiteProvider::changeAttributeValues( const QgsChangedAttributesMap
1162
1162
QString sql;
1163
1163
char xSql[1024 ];
1164
1164
1165
- strcpy (xSql, " BEGIN" );
1165
+ strcpy ( xSql, " BEGIN" );
1166
1166
int ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1167
1167
if ( ret != SQLITE_OK )
1168
1168
{
@@ -1198,7 +1198,7 @@ bool QgsSpatiaLiteProvider::changeAttributeValues( const QgsChangedAttributesMap
1198
1198
}
1199
1199
sql += QString ( " WHERE ROWID=%1" ).arg ( fid );
1200
1200
1201
- strcpy (xSql, sql.toUtf8 ().constData ());
1201
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1202
1202
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1203
1203
if ( ret != SQLITE_OK )
1204
1204
{
@@ -1207,7 +1207,7 @@ bool QgsSpatiaLiteProvider::changeAttributeValues( const QgsChangedAttributesMap
1207
1207
}
1208
1208
}
1209
1209
1210
- strcpy (xSql, " COMMIT" );
1210
+ strcpy ( xSql, " COMMIT" );
1211
1211
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1212
1212
if ( ret != SQLITE_OK )
1213
1213
{
@@ -1231,7 +1231,7 @@ bool QgsSpatiaLiteProvider::changeAttributeValues( const QgsChangedAttributesMap
1231
1231
if ( toCommit == true )
1232
1232
{
1233
1233
// ROLLBACK after some previous error
1234
- strcpy (xSql, " ROLLBACK" );
1234
+ strcpy ( xSql, " ROLLBACK" );
1235
1235
sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , NULL );
1236
1236
}
1237
1237
@@ -1246,7 +1246,7 @@ bool QgsSpatiaLiteProvider::changeGeometryValues( QgsGeometryMap & geometry_map
1246
1246
QString sql;
1247
1247
char xSql[1024 ];
1248
1248
1249
- strcpy (xSql, " BEGIN" );
1249
+ strcpy ( xSql, " BEGIN" );
1250
1250
int ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1251
1251
if ( ret != SQLITE_OK )
1252
1252
{
@@ -1260,7 +1260,7 @@ bool QgsSpatiaLiteProvider::changeGeometryValues( QgsGeometryMap & geometry_map
1260
1260
arg ( quotedValue ( mTableName ) ).arg ( quotedValue ( geometryColumn ) ).arg ( mSrid );
1261
1261
1262
1262
// SQLite prepared statement
1263
- strcpy (xSql, sql.toUtf8 ().constData ());
1263
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1264
1264
if ( sqlite3_prepare_v2 ( sqliteHandle, xSql, strlen ( xSql ), &stmt, NULL ) != SQLITE_OK )
1265
1265
{
1266
1266
// some error occurred
@@ -1303,7 +1303,7 @@ bool QgsSpatiaLiteProvider::changeGeometryValues( QgsGeometryMap & geometry_map
1303
1303
}
1304
1304
sqlite3_finalize ( stmt );
1305
1305
1306
- strcpy (xSql, " COMMIT" );
1306
+ strcpy ( xSql, " COMMIT" );
1307
1307
ret = sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , &errMsg );
1308
1308
if ( ret != SQLITE_OK )
1309
1309
{
@@ -1326,7 +1326,7 @@ bool QgsSpatiaLiteProvider::changeGeometryValues( QgsGeometryMap & geometry_map
1326
1326
if ( toCommit == true )
1327
1327
{
1328
1328
// ROLLBACK after some previous error
1329
- strcpy (xSql, " ROLLBACK" );
1329
+ strcpy ( xSql, " ROLLBACK" );
1330
1330
sqlite3_exec ( sqliteHandle, xSql, NULL , NULL , NULL );
1331
1331
}
1332
1332
@@ -1443,7 +1443,7 @@ bool QgsSpatiaLiteProvider::getGeometryDetails()
1443
1443
" WHERE f_table_name=%1 and f_geometry_column=%2" ).arg ( quotedValue ( mTableName ) ).
1444
1444
arg ( quotedValue ( geometryColumn ) );
1445
1445
1446
- strcpy (xSql, sql.toUtf8 ().constData ());
1446
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1447
1447
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
1448
1448
if ( ret != SQLITE_OK )
1449
1449
goto error;
@@ -1500,7 +1500,7 @@ bool QgsSpatiaLiteProvider::getGeometryDetails()
1500
1500
1501
1501
sql = QString ( " SELECT proj4text FROM spatial_ref_sys WHERE srid=%1" ).arg ( mSrid );
1502
1502
1503
- strcpy (xSql, sql.toUtf8 ().constData ());
1503
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1504
1504
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
1505
1505
if ( ret != SQLITE_OK )
1506
1506
goto error;
@@ -1542,7 +1542,7 @@ bool QgsSpatiaLiteProvider::getTableSummary()
1542
1542
QString sql = QString ( " SELECT Min(MbrMinX(%1)), Min(MbrMinY(%1)), "
1543
1543
" Max(MbrMaxX(%1)), Max(MbrMaxY(%1)), Count(*) " " FROM %2" ).arg ( geometryColumn ).arg ( quotedValue ( mTableName ) );
1544
1544
1545
- strcpy (xSql, sql.toUtf8 ().constData ());
1545
+ strcpy ( xSql, sql.toUtf8 ().constData () );
1546
1546
ret = sqlite3_get_table ( sqliteHandle, xSql, &results, &rows, &columns, &errMsg );
1547
1547
if ( ret != SQLITE_OK )
1548
1548
goto error;
0 commit comments