Skip to content

Instantly share code, notes, and snippets.

@klonuo
Created August 12, 2014 14:54
Show Gist options
  • Save klonuo/b697c194c2c15ff2b40d to your computer and use it in GitHub Desktop.
Save klonuo/b697c194c2c15ff2b40d to your computer and use it in GitHub Desktop.
Setting up test database
For the test, we need to create a tablespace. This needs root privileges
....****************************************
Running initial import for basic case
*********************************
.****************************************
Running initial import for slim --drop case
*********************************
.****************************************
Running initial import for Hstore index drop
*********************************
.****************************************
Running initial import for lat lon projection
*********************************
.****************************************
Running initial import for --tag-transform-script
*********************************
...****************************************
Running initial import for basic case
*********************************
Running diff-import for basic case
*********************************
.****************************************
Running initial import for Parallel processing
*********************************
Running diff-import for Parallel processing
*********************************
.****************************************
Running initial import for Parallel processing with non 100% node-cache
*********************************
Running diff-import for Parallel processing with non 100% node-cache
*********************************
.****************************************
Running initial import for Parallel processing with disabled node-cache
*********************************
Running diff-import for Parallel processing with disabled node-cache
*********************************
.****************************************
Running initial import for Hstore match only
*********************************
Running diff-import for Hstore match only
*********************************
.****************************************
Running initial import for Hstore name column
*********************************
Running diff-import for Hstore name column
*********************************
.****************************************
Running initial import for Hstore
*********************************
Running diff-import for Hstore
*********************************
.****************************************
Running initial import for Hstore all
*********************************
Running diff-import for Hstore all
*********************************
.****************************************
Running initial import for Hstore index
*********************************
Running diff-import for Hstore index
*********************************
.****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
.****************************************
Running initial import for Extra tags hstore all
*********************************
Running diff-import for Extra tags hstore all
*********************************
.****************************************
Running initial import for --tablespace-main-data
*********************************
Running diff-import for --tablespace-main-data
*********************************
.****************************************
Running initial import for --tablespace-main-index
*********************************
Running diff-import for --tablespace-main-index
*********************************
.****************************************
Running initial import for --tablespace-slim-data
*********************************
Running diff-import for --tablespace-slim-data
*********************************
.****************************************
Running initial import for --tablespace-slim-index
*********************************
Running diff-import for --tablespace-slim-index
*********************************
.****************************************
Running initial import for --tag-transform-script
*********************************
Running diff-import for --tag-transform-script
*********************************
...****************************************
Running initial import for basic case
*********************************
Running diff-import for basic case
*********************************
F****************************************
Running initial import for multi geometry
*********************************
Running diff-import for multi geometry
*********************************
F****************************************
Running initial import for hstore case
*********************************
Running diff-import for hstore case
*********************************
F****************************************
Running initial import for hstore case
*********************************
Running diff-import for hstore case
*********************************
F****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
F****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
F****************************************
Running initial import for lua tagtransform case
*********************************
Running diff-import for lua tagtransform case
*********************************
F****************************************
Running initial import for lua tagtransform case with hstore
*********************************
Running diff-import for lua tagtransform case with hstore
*********************************
F..****************************************
Running initial import in gazetteer mode for basic case
*********************************
Running diff-import in gazetteer mode for basic case
*********************************
.
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {[]}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-G']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-k']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-k', '--hstore-match-only']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-x', '-k', '--hstore-match-only']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-x', '-j']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['--tag-transform-script', 'style.lua']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['--tag-transform-script', 'style.lua', '-k']}
----------------------------------------------------------------------
Ran 40 tests in 302.809s
FAILED (failures=8)
Cleaning up test database
[Finished in 319.2s]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment