int
do_test (sqlite3 * handle, int legacy)
{
#ifndef OMIT_ICONV /* only if ICONV is supported */
int ret;
char *dumpname = __FILE__ "dump";
char *err_msg = NULL;
int row_count;
ret =
load_shapefile_ex (handle, "./shp/gaza/barrier", "barrier", "UTF-8",
4326, NULL, NULL, "POINT", 1, 0, 1, 1, &row_count,
err_msg);
if (!ret)
{
fprintf (stderr,
"load_shapefile_ex() error for shp/gaza/barrier: %s\n",
err_msg);
sqlite3_close (handle);
return -3;
}
if (row_count != 5)
{
fprintf (stderr, "unexpected row count for shp/gaza/barrier: %i\n",
row_count);
sqlite3_close (handle);
return -4;
}
ret =
load_shapefile_ex (handle, "./shp/gaza/aeroway", "aeroway", "UTF-8",
4326, "col1", NULL, "LINESTRING", 1, 0, 0, 0,
&row_count, err_msg);
if (!ret)
{
fprintf (stderr,
"load_shapefile_ex() error for shp/gaza/aeroway: %s\n",
err_msg);
sqlite3_close (handle);
return -5;
}
if (row_count != 1)
{
fprintf (stderr, "unexpected row count for shp/gaza/aeroway: %i\n",
row_count);
sqlite3_close (handle);
return -6;
}
ret = load_shapefile_ex (handle, "./shp/gaza/route", "route", "UTF-8", 4326,
NULL, NULL, "MULTILINESTRING", 1, 0, 1, 1,
&row_count, err_msg);
if (!ret)
{
fprintf (stderr, "load_shapefile_ex() error for shp/gaza/route: %s\n",
err_msg);
sqlite3_close (handle);
return -7;
}
if (row_count != 2)
{
fprintf (stderr, "unexpected row count for shp/gaza/route: %i\n",
row_count);
sqlite3_close (handle);
return -8;
}
if (legacy)
{
sqlite3_exec (handle, "DELETE FROM layer_statistics", NULL, NULL,
NULL);
sqlite3_exec (handle, "DELETE FROM views_layer_statistics", NULL,
NULL, NULL);
}
else
{
sqlite3_exec (handle, "DELETE FROM geometry_columns_statistics", NULL,
NULL, NULL);
sqlite3_exec (handle, "DELETE FROM views_geometry_columns_statistics",
NULL, NULL, NULL);
}
ret =
dump_shapefile (handle, "route", "Geometry", dumpname, "UTF-8", "", 1,
&row_count, err_msg);
if (!ret)
{
fprintf (stderr, "dump_shapefile() error for UTF-8_1 route: %s\n",
err_msg);
sqlite3_close (handle);
return -9;
}
cleanup_shapefile (dumpname);
if (row_count != 2)
{
fprintf (stderr, "unexpected dump row count for UTF-8_1 route: %i\n",
row_count);
sqlite3_close (handle);
return -10;
}
ret =
dump_shapefile (handle, "route", "Geometry", dumpname, "UTF-8",
"LINESTRING", 1, &row_count, err_msg);
if (!ret)
{
fprintf (stderr, "dump_shapefile() error for UTF-8_1 route: %s\n",
err_msg);
sqlite3_close (handle);
return -13;
}
cleanup_shapefile (dumpname);
if (row_count != 2)
{
fprintf (stderr,
"unexpected dump row count for UTF-8_1 route LINESTRING: %i\n",
row_count);
sqlite3_close (handle);
return -14;
}
ret =
sqlite3_exec (handle,
"SELECT DiscardGeometryColumn('route', 'Geometry')", NULL,
NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DiscardGeometry route error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -15;
}
if (legacy)
ret =
sqlite3_exec (handle,
"INSERT INTO geometry_columns (f_table_name, f_geometry_column, type, coord_dimension, srid, spatial_index_enabled) VALUES ('beta', 'gamma', 'LINESTRING', 'XY', 4326, 0)",
NULL, NULL, &err_msg);
else
ret =
sqlite3_exec (handle,
"INSERT INTO geometry_columns (f_table_name, f_geometry_column, geometry_type, coord_dimension, srid, spatial_index_enabled) VALUES (Lower('Beta'), Lower('Gamma'), 2, 2, 4326, 0)",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "GeometryColumns route error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -16;
}
if (legacy)
{
sqlite3_exec (handle, "DELETE FROM layer_statistics", NULL, NULL,
NULL);
ret =
sqlite3_exec (handle,
"INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column) VALUES ('route', 'Geometry', 'ROWID', 'beta', 'gamma')",
NULL, NULL, &err_msg);
}
else
{
sqlite3_exec (handle, "DELETE FROM geometry_columns_statistics", NULL,
NULL, NULL);
ret =
sqlite3_exec (handle,
"INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only) VALUES (Lower('Route'), Lower('Geometry'), Lower('ROWID'), Lower('Beta'), Lower('Gamma'), 1)",
NULL, NULL, &err_msg);
}
if (ret != SQLITE_OK)
{
fprintf (stderr, "ViewsGeometryColumns route error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -17;
}
ret =
dump_shapefile (handle, "route", "Geometry", dumpname, "UTF-8", NULL, 1,
&row_count, err_msg);
if (!ret)
{
fprintf (stderr, "dump_shapefile() error for UTF-8_1 route (2): %s\n",
err_msg);
sqlite3_close (handle);
return -17;
}
cleanup_shapefile (dumpname);
if (row_count != 2)
{
fprintf (stderr,
"unexpected dump row count for UTF-8_1 route LINESTRING (2): %i\n",
row_count);
sqlite3_close (handle);
return -18;
}
if (legacy)
{
/* final DB cleanup */
ret =
sqlite3_exec (handle, "DROP TABLE aeroway", NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DROP TABLE aeroway error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -19;
}
ret =
sqlite3_exec (handle, "DROP TABLE barrier", NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DROP TABLE barrier error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -20;
}
ret = sqlite3_exec (handle, "DROP TABLE route", NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DROP TABLE route error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -21;
}
ret =
sqlite3_exec (handle, "DROP TABLE idx_route_Geometry", NULL, NULL,
&err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DROP TABLE idx_route_Geometry error: %s\n",
err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -22;
}
ret =
sqlite3_exec (handle, "DROP TABLE idx_barrier_Geometry", NULL,
NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DROP TABLE idx_barrier_Geometry error: %s\n",
err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -23;
}
ret =
sqlite3_exec (handle, "DELETE FROM geometry_columns", NULL, NULL,
&err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DELETE FROM geometry_columns error: %s\n",
err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -24;
}
ret =
sqlite3_exec (handle, "DELETE FROM views_geometry_columns", NULL,
NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr,
"DELETE FROM views_geometry_columns error: %s\n",
err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -25;
}
ret =
sqlite3_exec (handle,
"DELETE FROM spatialite_history WHERE geometry_column IS NOT NULL",
NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "DELETE FROM spatialite_history error: %s\n",
err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -26;
}
ret = sqlite3_exec (handle, "VACUUM", NULL, NULL, &err_msg);
if (ret != SQLITE_OK)
{
fprintf (stderr, "VACUUM error: %s\n", err_msg);
sqlite3_free (err_msg);
sqlite3_close (handle);
return -27;
}
}
#endif /* end ICONV conditional */
/* ok, succesfull termination */
return 0;
}
int main (int argc, char *argv[])
{
#ifndef OMIT_ICONV /* only if ICONV is supported */
int ret;
sqlite3 *handle;
char *dumpname = __FILE__"dump";
char *err_msg = NULL;
int row_count;
void *cache = spatialite_alloc_connection();
if (argc > 1 || argv[0] == NULL)
argc = 1; /* silencing stupid compiler warnings */
ret = sqlite3_open_v2 (":memory:", &handle, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL);
if (ret != SQLITE_OK) {
fprintf(stderr, "cannot open in-memory database: %s\n", sqlite3_errmsg (handle));
sqlite3_close(handle);
return -1;
}
spatialite_init_ex (handle, cache, 0);
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/points", "points", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/points: %s\n", err_msg);
sqlite3_close(handle);
return -3;
}
if (row_count != 20) {
fprintf (stderr, "unexpected row count for shp/merano-3d/points: %i\n", row_count);
sqlite3_close(handle);
return -4;
}
ret = load_shapefile (handle, "./shp/merano-3d/polygons", "polygons", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/polygons: %s\n", err_msg);
sqlite3_close(handle);
return -5;
}
if (row_count != 10) {
fprintf (stderr, "unexpected row count for shp/merano-3d/polygons: %i\n", row_count);
sqlite3_close(handle);
return -6;
}
ret = load_shapefile (handle, "./shp/merano-3d/roads", "roads", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/roads: %s\n", err_msg);
sqlite3_close(handle);
return -7;
}
if (row_count != 18) {
fprintf (stderr, "unexpected row count for shp/merano-3d/roads: %i\n", row_count);
sqlite3_close(handle);
return -8;
}
ret = dump_shapefile (handle, "roads", "col1", dumpname, "CP1252", "LINESTRING", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d roads: %s\n", err_msg);
sqlite3_close(handle);
return -9;
}
cleanup_shapefile(dumpname);
if (row_count != 18) {
fprintf (stderr, "unexpected row count for 3d roads: %i\n", row_count);
sqlite3_close(handle);
return -10;
}
ret = dump_shapefile (handle, "polygons", "col1", dumpname, "CP1252", "POLYGON", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d polygons: %s\n", err_msg);
sqlite3_close(handle);
return -11;
}
cleanup_shapefile(dumpname);
if (row_count != 10) {
fprintf (stderr, "unexpected row count for 3d polygons: %i\n", row_count);
sqlite3_close(handle);
return -12;
}
ret = dump_shapefile (handle, "points", "col1", dumpname, "CP1252", "POINT", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d points: %s\n", err_msg);
sqlite3_close(handle);
return -13;
}
cleanup_shapefile(dumpname);
if (row_count != 20) {
fprintf (stderr, "unexpected row count for 3d points: %i\n", row_count);
sqlite3_close(handle);
return -14;
}
ret = sqlite3_close (handle);
if (ret != SQLITE_OK) {
fprintf (stderr, "sqlite3_close() error: %s\n", sqlite3_errmsg (handle));
return -15;
}
spatialite_cleanup_ex (cache);
#endif /* end ICONV conditional */
return 0;
}
int main (int argc, char *argv[])
{
int ret;
sqlite3 *handle;
char *dumpname = __FILE__"dump";
char *err_msg = NULL;
int row_count;
spatialite_init (0);
ret = sqlite3_open_v2 (":memory:", &handle, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL);
if (ret != SQLITE_OK) {
fprintf(stderr, "cannot open in-memory database: %s\n", sqlite3_errmsg (handle));
sqlite3_close(handle);
return -1;
}
ret = sqlite3_exec (handle, "SELECT InitSpatialMetadata()", 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/points", "points", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/points: %s\n", err_msg);
sqlite3_close(handle);
return -3;
}
if (row_count != 20) {
fprintf (stderr, "unexpected row count for shp/merano-3d/points: %i\n", row_count);
sqlite3_close(handle);
return -4;
}
ret = load_shapefile (handle, "./shp/merano-3d/polygons", "polygons", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/polygons: %s\n", err_msg);
sqlite3_close(handle);
return -5;
}
if (row_count != 10) {
fprintf (stderr, "unexpected row count for shp/merano-3d/polygons: %i\n", row_count);
sqlite3_close(handle);
return -6;
}
ret = load_shapefile (handle, "./shp/merano-3d/roads", "roads", "CP1252", 25832,
"col1", 0, 0, 1, 0, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "load_shapefile() error for shp/merano-3d/roads: %s\n", err_msg);
sqlite3_close(handle);
return -7;
}
if (row_count != 18) {
fprintf (stderr, "unexpected row count for shp/merano-3d/roads: %i\n", row_count);
sqlite3_close(handle);
return -8;
}
ret = dump_shapefile (handle, "roads", "col1", dumpname, "CP1252", "LINESTRING", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d roads: %s\n", err_msg);
sqlite3_close(handle);
return -9;
}
cleanup_shapefile(dumpname);
if (row_count != 18) {
fprintf (stderr, "unexpected row count for 3d roads: %i\n", row_count);
sqlite3_close(handle);
return -10;
}
ret = dump_shapefile (handle, "polygons", "col1", dumpname, "CP1252", "POLYGON", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d polygons: %s\n", err_msg);
sqlite3_close(handle);
return -11;
}
cleanup_shapefile(dumpname);
if (row_count != 10) {
fprintf (stderr, "unexpected row count for 3d polygons: %i\n", row_count);
sqlite3_close(handle);
return -12;
}
ret = dump_shapefile (handle, "points", "col1", dumpname, "CP1252", "POINT", 1, &row_count, err_msg);
if (!ret) {
fprintf (stderr, "dump_shapefile() error for 3d points: %s\n", err_msg);
sqlite3_close(handle);
return -13;
}
cleanup_shapefile(dumpname);
if (row_count != 20) {
fprintf (stderr, "unexpected row count for 3d points: %i\n", row_count);
sqlite3_close(handle);
return -14;
}
ret = sqlite3_close (handle);
if (ret != SQLITE_OK) {
fprintf (stderr, "sqlite3_close() error: %s\n", sqlite3_errmsg (handle));
return -15;
}
spatialite_cleanup();
sqlite3_reset_auto_extension();
return 0;
}
