1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
/**
* SPDX-License-Identifier: GPL-2.0-or-later
*
* This file is part of osm2pgsql (https://osm2pgsql.org/).
*
* Copyright (C) 2006-2021 by the osm2pgsql developer community.
* For a full list of authors see the git log.
*/
#include <catch.hpp>
#include "common-import.hpp"
#include "common-options.hpp"
static testing::db::import_t db;
TEST_CASE("schema separation")
{
{
auto conn = db.db().connect();
conn.exec("CREATE SCHEMA IF NOT EXISTS myschema;"
"CREATE TABLE myschema.osm2pgsql_test_point (id bigint);"
"CREATE TABLE myschema.osm2pgsql_test_line (id bigint);"
"CREATE TABLE myschema.osm2pgsql_test_polygon (id bigint);"
"CREATE TABLE myschema.osm2pgsql_test_roads (id bigint)");
}
REQUIRE_NOTHROW(
db.run_file(testing::opt_t().slim(), "test_output_pgsql_z_order.osm"));
auto conn = db.db().connect();
conn.require_has_table("public.osm2pgsql_test_point");
conn.require_has_table("public.osm2pgsql_test_line");
conn.require_has_table("public.osm2pgsql_test_polygon");
conn.require_has_table("public.osm2pgsql_test_roads");
conn.require_has_table("myschema.osm2pgsql_test_point");
conn.require_has_table("myschema.osm2pgsql_test_line");
conn.require_has_table("myschema.osm2pgsql_test_polygon");
conn.require_has_table("myschema.osm2pgsql_test_roads");
REQUIRE(2 == conn.get_count("osm2pgsql_test_point"));
REQUIRE(11 == conn.get_count("osm2pgsql_test_line"));
REQUIRE(1 == conn.get_count("osm2pgsql_test_polygon"));
REQUIRE(8 == conn.get_count("osm2pgsql_test_roads"));
REQUIRE(0 == conn.get_count("myschema.osm2pgsql_test_point"));
REQUIRE(0 == conn.get_count("myschema.osm2pgsql_test_line"));
REQUIRE(0 == conn.get_count("myschema.osm2pgsql_test_polygon"));
REQUIRE(0 == conn.get_count("myschema.osm2pgsql_test_roads"));
}
TEST_CASE("liechtenstein slim with schema")
{
options_t options = testing::opt_t().slim();
options.output_dbschema = "myschema";
auto conn = db.db().connect();
conn.exec("CREATE SCHEMA IF NOT EXISTS myschema;");
REQUIRE_NOTHROW(db.run_file(options, "liechtenstein-2013-08-03.osm.pbf"));
REQUIRE(1342 == conn.get_count("myschema.osm2pgsql_test_point"));
REQUIRE(3231 == conn.get_count("myschema.osm2pgsql_test_line"));
REQUIRE(375 == conn.get_count("myschema.osm2pgsql_test_roads"));
REQUIRE(4130 == conn.get_count("myschema.osm2pgsql_test_polygon"));
}
|
