def rebuild_spatial_db(): conn = spatial_model.get_spatial_db_connection() res = conn.execute(text('SELECT id FROM collection WHERE id = :id'), {'id': TEST_COLLECTION_ID}) if res.rowcount: conn.execute(text('DELETE FROM collection WHERE id = :id'), {'id': TEST_COLLECTION_ID})
def create_test_spatial_data(): conn = spatial_model.get_spatial_db_connection() collections = [{ 'id': TEST_COLLECTION_ID, 'hash': '24B436C17A710184B1A921AEE33FB2BE', }] for collection in collections: conn.execute( text('INSERT INTO collection ("id", "hash") VALUES (:id, :hash);'), collection) datasets = [{ 'id': TEST_DATASET_ID, 'collid': TEST_COLLECTION_ID, }] for dataset in datasets: conn.execute( text( 'INSERT INTO dataset ("id", "collid") VALUES (:id, :collid);'), dataset) features = [ { 'datasetid': TEST_DATASET_ID, 'properties': '{"ID":1,"SITE":"Beddington Park","ADDRESS":"Church Road","WARD":"Beddington North","Easting":529045.924,"Northing":165372.031,"Area":4039.859,"Perimeter":464.361}', #'created': '2013-01-10 17:27:27.223566', #'modified': '2013-01-10 17:27:27.223566', 'geom': '0101000020346C00002B8716D92B25204191ED7C3FE02F0441' }, { 'datasetid': TEST_DATASET_ID, 'properties': '{"ID":4,"SITE":"Carshalton Park","ADDRESS":"Ruskin Road","WARD":"Carshalton Central","Easting":528009.573,"Northing":164145.634,"Area":3613.636,"Perimeter":214.241}', #'created': '2013-01-10 17:27:27.223566', #'modified': '2013-01-10 17:27:27.223566', 'geom': '0101000020346C000089416025131D20418D976E128D090441', } ] for feature in features: conn.execute( text( 'INSERT INTO feature ("datasetid", "properties", "geom") VALUES (:datasetid, :properties, :geom);' ), feature)
def create_test_spatial_data(): conn = spatial_model.get_spatial_db_connection() collections = [ {'id': TEST_COLLECTION_ID, 'hash': '24B436C17A710184B1A921AEE33FB2BE', } ] for collection in collections: conn.execute(text('INSERT INTO collection ("id", "hash") VALUES (:id, :hash);'), collection) datasets = [ {'id': TEST_DATASET_ID, 'collid': TEST_COLLECTION_ID, } ] for dataset in datasets: conn.execute(text('INSERT INTO dataset ("id", "collid") VALUES (:id, :collid);'), dataset) features = [ {'datasetid': TEST_DATASET_ID, 'properties': '{"ID":1,"SITE":"Beddington Park","ADDRESS":"Church Road","WARD":"Beddington North","Easting":529045.924,"Northing":165372.031,"Area":4039.859,"Perimeter":464.361}', #'created': '2013-01-10 17:27:27.223566', #'modified': '2013-01-10 17:27:27.223566', 'geom': '0101000020346C00002B8716D92B25204191ED7C3FE02F0441'}, {'datasetid': TEST_DATASET_ID, 'properties': '{"ID":4,"SITE":"Carshalton Park","ADDRESS":"Ruskin Road","WARD":"Carshalton Central","Easting":528009.573,"Northing":164145.634,"Area":3613.636,"Perimeter":214.241}', #'created': '2013-01-10 17:27:27.223566', #'modified': '2013-01-10 17:27:27.223566', 'geom': '0101000020346C000089416025131D20418D976E128D090441', } ] for feature in features: conn.execute(text('INSERT INTO feature ("datasetid", "properties", "geom") VALUES (:datasetid, :properties, :geom);'), feature)