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
67
68
69
70
71
72
|
/**
* 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"
#include <string>
static testing::db::import_t db;
static std::string population(osmid_t id)
{
return "SELECT population FROM osm2pgsql_test_point WHERE osm_id = " +
std::to_string(id);
}
TEST_CASE("int4 conversion")
{
options_t const options =
testing::opt_t().slim().style("test_output_pgsql_int4.style");
REQUIRE_NOTHROW(db.run_file(options, "test_output_pgsql_int4.osm"));
auto conn = db.db().connect();
// First three nodes have population values that are out of range for int4 columns
conn.assert_null(population(1));
conn.assert_null(population(2));
conn.assert_null(population(3));
// Check values that are valid for int4 columns, including limits
CHECK(2147483647 == conn.require_scalar<int>(population(4)));
CHECK(10000 == conn.require_scalar<int>(population(5)));
CHECK(-10000 == conn.require_scalar<int>(population(6)));
CHECK(-2147483648 == conn.require_scalar<int>(population(7)));
// More out of range negative values
conn.assert_null(population(8));
conn.assert_null(population(9));
conn.assert_null(population(10));
// Ranges are also parsed into int4 columns
conn.assert_null(population(11));
conn.assert_null(population(12));
// Check values that are valid for int4 columns, including limits
CHECK(2147483647 == conn.require_scalar<int>(population(13)));
CHECK(15000 == conn.require_scalar<int>(population(14)));
CHECK(-15000 == conn.require_scalar<int>(population(15)));
CHECK(-2147483648 == conn.require_scalar<int>(population(16)));
// More out of range negative values
conn.assert_null(population(17));
conn.assert_null(population(18));
// More invalid values
conn.assert_null(population(19));
conn.assert_null(population(20));
conn.assert_null(population(21));
conn.assert_null(population(22));
// Zero is a valid value
CHECK(0 == conn.require_scalar<int>(population(23)));
}
|
