// only if libspatialite version is >= 4.0.0
bool QgsSpatiaLiteConnection::getTableInfoAbstractInterface( sqlite3 *handle, bool loadGeometrylessTables )
{
int ret;
int i;
char **results = nullptr;
int rows;
int columns;
char *errMsg = nullptr;
QString sql;
gaiaVectorLayersListPtr list;
const char *version = spatialite_version();
if ( isdigit( *version ) && *version >= '4' )
; // OK, linked against libspatialite v.4.0 (or any subsequent)
else
{
mErrorMsg = tr( "obsolete libspatialite: AbstractInterface is unsupported" );
return false;
}
// attempting to load the VectorLayersList
list = gaiaGetVectorLayersList( handle, nullptr, nullptr, GAIA_VECTORS_LIST_FAST );
if ( list )
{
gaiaVectorLayerPtr lyr = list->First;
while ( lyr )
{
// populating the QGIS own Layers List
if ( lyr->AuthInfos )
{
if ( lyr->AuthInfos->IsHidden )
{
// skipping any Hidden layer
lyr = lyr->Next;
continue;
}
}
QString tableName = QString::fromUtf8( lyr->TableName );
QString column = QString::fromUtf8( lyr->GeometryName );
QString type = tr( "UNKNOWN" );
switch ( lyr->GeometryType )
{
case GAIA_VECTOR_GEOMETRY:
type = tr( "GEOMETRY" );
break;
case GAIA_VECTOR_POINT:
type = tr( "POINT" );
break;
case GAIA_VECTOR_LINESTRING:
type = tr( "LINESTRING" );
break;
case GAIA_VECTOR_POLYGON:
type = tr( "POLYGON" );
break;
case GAIA_VECTOR_MULTIPOINT:
type = tr( "MULTIPOINT" );
break;
case GAIA_VECTOR_MULTILINESTRING:
type = tr( "MULTILINESTRING" );
break;
case GAIA_VECTOR_MULTIPOLYGON:
type = tr( "MULTIPOLYGON" );
break;
case GAIA_VECTOR_GEOMETRYCOLLECTION:
type = tr( "GEOMETRYCOLLECTION" );
break;
}
mTables.append( TableEntry( tableName, column, type ) );
lyr = lyr->Next;
}
gaiaFreeVectorLayersList( list );
}
if ( loadGeometrylessTables )
{
// get all tables
sql = "SELECT name "
"FROM sqlite_master "
"WHERE type in ('table', 'view')";
ret = sqlite3_get_table( handle, sql.toUtf8(), &results, &rows, &columns, &errMsg );
if ( ret != SQLITE_OK )
goto error;
if ( rows < 1 )
;
else
{
for ( i = 1; i <= rows; i++ )
{
QString tableName = QString::fromUtf8( results[( i * columns ) + 0] );
mTables.append( TableEntry( tableName, QString(), QStringLiteral( "qgis_table" ) ) );
}
}
sqlite3_free_table( results );
}
return true;
error:
// unexpected IO error
mErrorMsg = tr( "unknown error cause" );
if ( errMsg )
{
mErrorMsg = errMsg;
sqlite3_free( errMsg );
}
return false;
}
static int
do_test (sqlite3 * handle, const void *p_cache)
{
int ret;
char *err_msg = NULL;
int row_count;
const char *sql;
char **results;
int rows;
int columns;
double tic;
gaiaVectorLayersListPtr list;
ret =
sqlite3_exec (handle, "SELECT InitSpatialMetadata(1)", NULL, NULL,
&err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "InitSpatialMetadata() error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -2;
}
ret =
load_shapefile (handle, "shp/merano-3d/polygons", "polygons", "CP1252",
25832, "geom", 0, 1, 1, 0, &row_count, err_msg);
if (!ret)
{
fprintf (stderr, "load_shapefile() error: %s\n", err_msg);
sqlite3_close (handle);
return -3;
}
ret = update_layer_statistics (handle, "polygons", "geom");
if (!ret)
{
fprintf (stderr, "update_layer_statistics() error %s\n", err_msg);
sqlite3_close (handle);
return -8;
}
ret =
load_shapefile (handle, "shp/merano-3d/roads", "roads", "CP1252", 25832,
"geom", 0, 0, 1, 0, &row_count, err_msg);
if (!ret)
{
fprintf (stderr, "load_shapefile() error: %s\n", err_msg);
sqlite3_close (handle);
return -4;
}
ret =
load_shapefile (handle, "shp/merano-3d/points", "points", "CP1252",
25832, "geom", 0, 0, 1, 0, &row_count, err_msg);
if (!ret)
{
fprintf (stderr, "load_shapefile() error: %s\n", err_msg);
sqlite3_close (handle);
return -5;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polygons (FEATURE_ID, DATUM, HAUSNR) VALUES (1250000, 0.1, 'alpha')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "INSERT polygons (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -14;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polygons (FEATURE_ID, DATUM, HAUSNR) VALUES (1250000, 0.1, 'alpha')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "INSERT polygons (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -15;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polygons (FEATURE_ID, DATUM, TEXT_I) VALUES (1250000, 0.1, 'alpha')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "INSERT polygons (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -16;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE polyg_xy (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE polyg_xy error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -17;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('polyg_xy', 'geom', 25832, 'POLYGON', 'XY')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeomety polyg_xy error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -17;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xy (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXY(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xy (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -18;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xy (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXY(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xy (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -19;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE polyg_xym (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE polyg_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -20;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('polyg_xym', 'geom', 25832, 'POLYGON', 'XYM')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry polyg_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -21;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xym (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -22;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xym (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -23;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE polyg_xyz (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE polyg_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -24;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('polyg_xyz', 'geom', 25832, 'POLYGON', 'XYZ')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry polyg_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -25;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xyz (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -26;
}
ret =
sqlite3_exec (handle,
"INSERT INTO polyg_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM polygons WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding polyg_xyz (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -27;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE roads_xyz (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE roads_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -28;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('roads_xyz', 'geom', 25832, 'LINESTRING', 'XYZ')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeomety roads_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -29;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xyz (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -30;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xyz (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -31;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE roads_xym (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE roads_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -32;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('roads_xym', 'geom', 25832, 'LINESTRING', 'XYM')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry roads_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -33;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xym (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -34;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xym (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -35;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE roads_xyzm (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE roads_xyzm error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -36;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('roads_xyzm', 'geom', 25832, 'LINESTRING', 'XYZM')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry roads_xyzm error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -37;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xyzm (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZM(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xyzm (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -38;
}
ret =
sqlite3_exec (handle,
"INSERT INTO roads_xyzm (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZM(geom) FROM roads WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding roads_xyzm (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -39;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE points_xyz (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE points_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -40;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('points_xyz', 'geom', 25832, 'POINT', 'XYZ')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeomety points_xyz error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -41;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xyz (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -42;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xyz (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZ(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xyz (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -43;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE points_xym (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE points_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -44;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('points_xym', 'geom', 25832, 'POINT', 'XYM')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry points_xym error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -45;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xym (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -46;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xym (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYM(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xym (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -47;
}
ret =
sqlite3_exec (handle,
"CREATE TABLE points_xyzm (pk_elem INTEGER PRIMARY KEY AUTOINCREMENT, FEATURE_ID INTEGER, DATUM DOUBLE, TEXT_I TEXT, BLOB_I BLOB)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE points_xyzm error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -48;
}
ret =
sqlite3_exec (handle,
"SELECT AddGeometryColumn('points_xyzm', 'geom', 25832, 'POINT', 'XYZM')",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "AddGeometry points_xyzm error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -49;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xyzm (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZM(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xyzm (1) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -50;
}
ret =
sqlite3_exec (handle,
"INSERT INTO points_xyzm (pk_elem, FEATURE_ID, DATUM, TEXT_I, BLOB_I, geom) SELECT NULL, FEATURE_ID, DATUM, 'alpha', zeroblob(20), CastToXYZM(geom) FROM points WHERE geom IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "feeding points_xyzm (2) error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -51;
}
elementary_geometries (handle, "points", "geom", "elem_point", "pk_elem",
"mul_id");
elementary_geometries (handle, "roads", "geom", "elem_linestring",
"pk_elem", "mul_id");
elementary_geometries (handle, "polygons", "geom", "elem_poly", "pk_elem",
"mul_id");
elementary_geometries (handle, "polyg_xy", "geom", "elem_poly_xy",
"pk_elem1", "mul_id");
elementary_geometries (handle, "polyg_xym", "geom", "elem_poly_xym",
"pk_elem1", "mul_id");
elementary_geometries (handle, "polyg_xyz", "geom", "elem_poly_xyz",
"pk_elem1", "mul_id");
elementary_geometries (handle, "roads_xyz", "geom", "elem_roads_xy",
"pk_elem1", "mul_id");
elementary_geometries (handle, "roads_xym", "geom", "elem_roads_xym",
"pk_elem1", "mul_id");
elementary_geometries (handle, "roads_xyzm", "geom", "elem_roads_xyz",
"pk_elem1", "mul_id");
elementary_geometries (handle, "points_xyz", "geom", "elem_points_xy",
"pk_elem1", "mul_id");
elementary_geometries (handle, "points_xym", "geom", "elem_points_xym",
"pk_elem1", "mul_id");
elementary_geometries (handle, "points_xyzm", "geom", "elem_points_xyz",
"pk_elem1", "mul_id");
remove_duplicated_rows (handle, "polyg_xy");
remove_duplicated_rows (handle, "polyg_xyz");
remove_duplicated_rows (handle, "polyg_xym");
remove_duplicated_rows (handle, "roads_xyz");
remove_duplicated_rows (handle, "roads_xym");
remove_duplicated_rows (handle, "roads_xyzm");
remove_duplicated_rows (handle, "points_xyz");
remove_duplicated_rows (handle, "points_xym");
remove_duplicated_rows (handle, "points_xyzm");
sql = "CREATE VIEW test_view AS "
"SELECT ROWID AS ROWID, pk_elem AS id, geom AS geometry FROM roads_xyz";
ret = sqlite3_exec (handle, sql, NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "CREATE test_view error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -52;
}
sql =
"INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, "
"f_table_name, f_geometry_column, read_only) VALUES "
"('test_view', 'geometry', 'rowid', 'roads_xyz', 'geom', 1)";
ret = sqlite3_exec (handle, sql, NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "Register SpatialView error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -53;
}
ret = update_layer_statistics (handle, NULL, NULL);
if (!ret)
{
fprintf (stderr, "update_layer_statistics() error %s\n", err_msg);
sqlite3_close (handle);
return -54;
}
sql = "SELECT row_count, extent_min_x, extent_max_y "
"FROM geometry_columns_statistics "
"WHERE f_table_name LIKE 'roads' " "AND f_geometry_column LIKE 'geom'";
ret = sqlite3_get_table (handle, sql, &results, &rows, &columns, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "Error: %s\n", err_msg);
sqlite3_free (err_msg);
return -55;
}
if (rows != 1)
{
fprintf (stderr,
"Unexpected num of rows for GEOMETRY_COLUMNS_STATISTICS.\n");
return -56;
}
if (atoi (results[columns + 0]) != 18)
{
fprintf (stderr,
"Unexpected error: GEOMETRY_COLUMNS_STATISTICS bad result row_count: %s\n",
results[columns + 0]);
return -57;
}
tic = fabs (atof (results[columns + 1]) - 666057.648017325);
if (tic >= 0.00000002)
{
fprintf (stderr,
"Unexpected error: GEOMETRY_COLUMNS_STATISTICS bad result extent_min_x: %s\n",
results[columns + 1]);
return -58;
}
tic = fabs (atof (results[columns + 2]) - 5170671.31627796);
if (tic >= 0.0000002)
{
fprintf (stderr,
"Unexpected error: GEOMETRY_COLUMNS_STATISTICS bad result extent_max_y: %s\n",
results[columns + 2]);
return -59;
}
sqlite3_free_table (results);
ret = gaiaDropTable (handle, "polygons");
if (!ret)
{
fprintf (stderr, "DROP polygons error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -60;
}
/* checking gaiaGetVectorLayersList() - ALL */
list =
gaiaGetVectorLayersList (handle, NULL, NULL,
GAIA_VECTORS_LIST_OPTIMISTIC);
gaiaFreeVectorLayersList (list);
#ifdef ENABLE_LWGEOM /* only if LWGEOM is supported */
if (p_cache == NULL)
ret = check_all_geometry_columns (handle, "./report", NULL, NULL);
else
ret =
check_all_geometry_columns_r (p_cache, handle, "./report", NULL,
NULL);
if (!ret)
{
fprintf (stderr, "check_all_geometry_columns() error\n");
sqlite3_close (handle);
return -61;
}
if (p_cache == NULL)
ret =
sanitize_all_geometry_columns (handle, "tmp_", "./report", NULL,
NULL);
else
ret =
sanitize_all_geometry_columns_r (p_cache, handle, "tmp_",
"./report", NULL, NULL);
if (!ret)
{
fprintf (stderr, "sanitize_all_geometry_columns() error\n");
sqlite3_close (handle);
return -62;
}
#endif /* end LWGEOM conditionals */
/* checking gaiaGetVectorLayersList() - Table */
list =
gaiaGetVectorLayersList (handle, "elem_points_xyz", NULL,
GAIA_VECTORS_LIST_OPTIMISTIC);
gaiaFreeVectorLayersList (list);
/* checking gaiaGetVectorLayersList() - Table and Geometry */
list =
gaiaGetVectorLayersList (handle, "elem_roads_xy", "geom",
GAIA_VECTORS_LIST_OPTIMISTIC);
gaiaFreeVectorLayersList (list);
return 0;
}
