forked from osm2pgsql-dev/osm2pgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest-output-pgsql-z_order.cpp
More file actions
37 lines (29 loc) · 1.1 KB
/
Copy pathtest-output-pgsql-z_order.cpp
File metadata and controls
37 lines (29 loc) · 1.1 KB
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
/**
* 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("compute Z order")
{
REQUIRE_NOTHROW(
db.run_file(testing::opt_t().slim(), "test_output_pgsql_z_order.osm"));
auto conn = db.db().connect();
char const *expected[] = {"motorway", "trunk", "primary", "secondary",
"tertiary"};
for (unsigned i = 0; i < 5; ++i) {
auto const sql = "SELECT highway FROM osm2pgsql_test_line"
" WHERE layer IS NULL ORDER BY z_order DESC"
" LIMIT 1 OFFSET {}"_format(i);
REQUIRE(expected[i] == conn.result_as_string(sql));
}
REQUIRE("residential" ==
conn.result_as_string("SELECT highway FROM osm2pgsql_test_line "
"ORDER BY z_order DESC LIMIT 1 OFFSET 0"));
}