def encode(self):
"""
Returns the image as base64 encoded string.
Returns:
str: The encoded image.
"""
return b64.encode(self.content)
def test_encode():
image_record = ImageRecord('1'.encode('utf-8'))
assert image_record.encode() == b64.encode('1'.encode('utf-8'))
def _import_forest_perimeters(self):
from pyramid_oereb.standard.models import forest_perimeters
connection = self._engine.connect()
# Add dummy PLR data for line geometry
wms_url = u'https://wms.geo.admin.ch/?SERVICE=WMS&REQUEST=GetMap&VERSION=1.1.1&STYLES=default' \
u'&SRS=EPSG:{0}&BBOX=475000,60000,845000,310000&WIDTH=740&HEIGHT=500&FORMAT=image/png' \
u'&LAYERS=ch.bav.kataster-belasteter-standorte-oev.oereb'
connection.execute(
forest_perimeters.ViewService.__table__.insert(), {
'id': '1',
'reference_wms': wms_url.format(Config.get('srid')),
'layer_index': 1,
'layer_opacity': 1.0
})
connection.execute(
forest_perimeters.LegendEntry.__table__.insert(), {
'id':
'1',
'symbol':
b64.encode(file_adapter.read('tests/resources/symbol.png')),
'legend_text': {
'de': u'Test'
},
'type_code':
u'CodeA',
'type_code_list':
u'type_code_list',
'topic':
u'ForestPerimeters',
'view_service_id':
'1'
})
connection.execute(forest_perimeters.Office.__table__.insert(), {
'id': '1',
'name': {
'de': u'Test Office'
}
})
connection.execute(
forest_perimeters.DataIntegration.__table__.insert(), {
'id': '1',
'date': u'2017-07-01T00:00:00',
'office_id': '1'
})
connection.execute(
forest_perimeters.PublicLawRestriction.__table__.insert(), {
'id': '1',
'information': {
'de': u'Long line PLR'
},
'topic': u'ForestPerimeters',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
forest_perimeters.Geometry.__table__.insert(),
{
'id': '1',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'public_law_restriction_id': '1',
'office_id': '1',
# example geometry which does not concern the real_estate (tolerance_check)
'geom': u'SRID=2056;LINESTRING (1.5 1.5, 1.5 2.5)'
})
connection.close()
def _import_land_use_plans(self):
from pyramid_oereb.standard.models import land_use_plans
connection = self._engine.connect()
# Add dummy PLR data for collection geometry test
wms_url = u'https://wms.geo.admin.ch/?SERVICE=WMS&REQUEST=GetMap&VERSION=1.1.1&STYLES=default' \
u'&SRS=EPSG:{0}&BBOX=475000,60000,845000,310000&WIDTH=740&HEIGHT=500&FORMAT=image/png' \
u'&LAYERS=ch.bav.kataster-belasteter-standorte-oev.oereb'
connection.execute(
land_use_plans.ViewService.__table__.insert(), {
'id': '1',
'reference_wms': wms_url.format(Config.get('srid')),
'layer_index': 1,
'layer_opacity': 1.0
})
connection.execute(
land_use_plans.LegendEntry.__table__.insert(), {
'id':
'1',
'symbol':
b64.encode(file_adapter.read('tests/resources/symbol.png')),
'legend_text': {
'de': u'Test'
},
'type_code':
u'CodeA',
'type_code_list':
u'type_code_list',
'topic':
u'LandUsePlans',
'view_service_id':
'1'
})
connection.execute(land_use_plans.Office.__table__.insert(), {
'id': '1',
'name': {
'de': u'Test Office'
}
})
connection.execute(land_use_plans.DataIntegration.__table__.insert(), {
'id': '1',
'date': u'2017-07-01T00:00:00',
'office_id': '1'
})
connection.execute(
land_use_plans.PublicLawRestriction.__table__.insert(), {
'id': '1',
'information': {
'de': u'Large polygon PLR'
},
'topic': u'LandUsePlans',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
land_use_plans.PublicLawRestriction.__table__.insert(), {
'id': '2',
'information': {
'de': u'Small polygon PLR'
},
'topic': u'LandUsePlans',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
land_use_plans.PublicLawRestriction.__table__.insert(), {
'id': '3',
'information': {
'de': u'Double intersection polygon PLR'
},
'topic': u'LandUsePlans',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
land_use_plans.PublicLawRestriction.__table__.insert(), {
'id': '4',
'information': {
'de': u'Future PLR'
},
'topic': u'LandUsePlans',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from':
(date.today() + timedelta(days=7)).isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
land_use_plans.Geometry.__table__.insert(), {
'id':
'1',
'law_status':
u'inForce',
'published_from':
date.today().isoformat(),
'public_law_restriction_id':
'1',
'office_id':
'1',
'geom':
u'SRID=2056;GEOMETRYCOLLECTION('
u'POLYGON((1 -1, 9 -1, 9 7, 1 7, 1 8, 10 8, 10 -2, 1 -2, 1 -1)))'
})
connection.execute(
land_use_plans.Geometry.__table__.insert(), {
'id':
'2',
'law_status':
u'inForce',
'published_from':
date.today().isoformat(),
'public_law_restriction_id':
'1',
'office_id':
'1',
'geom':
u'SRID=2056;GEOMETRYCOLLECTION(POLYGON((0 0, 0 1.5, 1.5 1.5, 1.5 0, 0 0)))'
})
connection.execute(
land_use_plans.Geometry.__table__.insert(), {
'id':
'3',
'law_status':
u'inForce',
'published_from':
date.today().isoformat(),
'public_law_restriction_id':
'1',
'office_id':
'1',
'geom':
u'SRID=2056;GEOMETRYCOLLECTION('
u'POLYGON((3 2.5, 3 5, 7 5, 7 0, 3 0, 3 1, 6 1, 6 4, 4 2.5, 3 2.5)))'
})
connection.execute(
land_use_plans.Geometry.__table__.insert(), {
'id':
'4',
'law_status':
u'inForce',
'published_from':
date.today().isoformat(),
'public_law_restriction_id':
'1',
'office_id':
'1',
'geom':
u'SRID=2056;GEOMETRYCOLLECTION(POLYGON((1.5 1.5, 1.5 2, 2 2, 2 1.5, 1.5 1.5)))'
})
connection.execute(
land_use_plans.Geometry.__table__.insert(), {
'id': '5',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'public_law_restriction_id': '1',
'office_id': '1',
'geom': u'SRID=2056;GEOMETRYCOLLECTION(POINT(1 2))'
})
connection.close()
def _import_motorways_building_lines(self):
from pyramid_oereb.standard.models import motorways_building_lines
connection = self._engine.connect()
# Add dummy PLR data for line geometry
wms_url = u'https://wms.geo.admin.ch/?SERVICE=WMS&REQUEST=GetMap&VERSION=1.1.1&STYLES=default' \
u'&SRS=EPSG:{0}&BBOX=475000,60000,845000,310000&WIDTH=740&HEIGHT=500&FORMAT=image/png' \
u'&LAYERS=ch.bav.kataster-belasteter-standorte-oev.oereb'
connection.execute(
motorways_building_lines.ViewService.__table__.insert(), {
'id': '1',
'reference_wms': wms_url.format(Config.get('srid')),
'layer_index': 1,
'layer_opacity': 1.0
})
connection.execute(
motorways_building_lines.LegendEntry.__table__.insert(), {
'id':
'1',
'symbol':
b64.encode(file_adapter.read('tests/resources/symbol.png')),
'legend_text': {
'de': u'Test'
},
'type_code':
u'CodeA',
'type_code_list':
u'type_code_list',
'topic':
u'MotorwaysBuildingLines',
'view_service_id':
'1'
})
connection.execute(motorways_building_lines.Office.__table__.insert(),
{
'id': '1',
'name': {
'de': u'Test Office'
}
})
connection.execute(
motorways_building_lines.DataIntegration.__table__.insert(), {
'id': '1',
'date': u'2017-07-01T00:00:00',
'office_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestriction.__table__.insert(), {
'id': '1',
'information': {
'de': u'Long line PLR'
},
'topic': u'MotorwaysBuildingLines',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestriction.__table__.insert(), {
'id': '2',
'information': {
'de': u'Short line PLR'
},
'topic': u'MotorwaysBuildingLines',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestriction.__table__.insert(), {
'id': '3',
'information': {
'de': u'Double intersection line PLR'
},
'topic': u'MotorwaysBuildingLines',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestriction.__table__.insert(), {
'id': '4',
'information': {
'de': u'Future geometry'
},
'topic': u'MotorwaysBuildingLines',
'type_code': u'CodeA',
"type_code_list": u'',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'view_service_id': '1',
'office_id': '1'
})
connection.execute(
motorways_building_lines.Geometry.__table__.insert(), {
'id': '1',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'public_law_restriction_id': '1',
'office_id': '1',
'geom': u'SRID=2056;LINESTRING (0 0, 2 2)'
})
connection.execute(
motorways_building_lines.Geometry.__table__.insert(), {
'id': '2',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'public_law_restriction_id': '2',
'office_id': '1',
'geom': u'SRID=2056;LINESTRING (1.5 1.5, 1.5 2.5)'
})
connection.execute(
motorways_building_lines.Geometry.__table__.insert(), {
'id': '3',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'public_law_restriction_id': '3',
'office_id': '1',
'geom': u'SRID=2056;LINESTRING (3 1, 3 4, 6 4, 6 1, 4.5 1)'
})
connection.execute(
motorways_building_lines.Geometry.__table__.insert(), {
'id': '4',
'law_status': u'inForce',
'published_from':
(date.today() + timedelta(days=7)).isoformat(),
'public_law_restriction_id': '4',
'office_id': '1',
'geom': u'SRID=2056;LINESTRING (0 0, 4 4)'
})
connection.execute(
motorways_building_lines.DocumentBase.__table__.insert(), {
'id': '1',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'type': u'document'
})
connection.execute(
motorways_building_lines.Document.__table__.insert(), {
'id': '1',
'document_type': u'Law',
'title': {
'de': u'First level document'
},
'office_id': '1'
})
connection.execute(
motorways_building_lines.DocumentBase.__table__.insert(), {
'id': '2',
'law_status': u'inForce',
'published_from':
(date.today() + timedelta(days=7)).isoformat(),
'type': u'document'
})
connection.execute(
motorways_building_lines.Document.__table__.insert(), {
'id': '2',
'document_type': u'Law',
'title': {
'de': u'First level future document'
},
'office_id': '1'
})
connection.execute(
motorways_building_lines.DocumentBase.__table__.insert(), {
'id': '3',
'law_status': u'inForce',
'published_from': date.today().isoformat(),
'type': u'document'
})
connection.execute(
motorways_building_lines.Document.__table__.insert(), {
'id': '3',
'document_type': u'Law',
'title': {
'de': u'Second level document'
},
'office_id': '1'
})
connection.execute(
motorways_building_lines.DocumentBase.__table__.insert(), {
'id': '4',
'law_status': u'inForce',
'published_from':
(date.today() + timedelta(days=7)).isoformat(),
'type': u'document'
})
connection.execute(
motorways_building_lines.Document.__table__.insert(), {
'id': '4',
'document_type': u'Law',
'title': {
'de': u'Second level future document'
},
'office_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestrictionDocument.__table__.
insert(), {
'id': '1',
'public_law_restriction_id': '1',
'document_id': '1'
})
connection.execute(
motorways_building_lines.PublicLawRestrictionDocument.__table__.
insert(), {
'id': '2',
'public_law_restriction_id': '1',
'document_id': '2'
})
connection.execute(
motorways_building_lines.DocumentReference.__table__.insert(), {
'id': '1',
'document_id': '1',
'reference_document_id': '3'
})
connection.execute(
motorways_building_lines.DocumentReference.__table__.insert(), {
'id': '2',
'document_id': '1',
'reference_document_id': '4'
})
connection.close()
def _import_main(self):
from pyramid_oereb.standard.models import main
connection = self._engine.connect()
# Add dummy address
connection.execute(
main.Address.__table__.insert(), {
'street_name': u'test',
'street_number': u'10',
'zip_code': 4410,
'geom': 'SRID=2056;POINT(1 1)'
})
# Add dummy municipality
connection.execute(
main.Municipality.__table__.insert(), {
'fosnr': 1234,
'name': u'Test',
'published': True,
'logo': b64.encode(
file_adapter.read('tests/resources/python.svg')),
'geom':
'SRID=2056;MULTIPOLYGON(((0 0, 0 10, 10 10, 10 0, 0 0)))'
})
# Add dummy exclustion of liability
connection.execute(
main.ExclusionOfLiability.__table__.insert(), {
'id': 1,
'title': {
'de':
u'Haftungsausschluss Kataster der belasteten Standorte',
'fr':
u'Clause de non-responsabilité du cadastre des sites pollués (CSP)',
'it': u'Clausola di esclusione della responsabilità ...',
'rm': u''
},
'content': {
"de": u'Der Kataster der belasteten Standorte (KbS) \
wurde anhand der vom Bundesamt für Umwelt BAFU fe ...',
"fr":
u'Le cadastre des sites pollués (CSP) est établi d’après \
les critères émis par l’Office fédéral ...',
"it":
u'Il catasto dei siti inquinati (CSIN) è stato elaborato sulla \
base dei criteri definiti dall ...',
"rm": u''
}
})
# Add dummy glossary
connection.execute(
main.Glossary.__table__.insert(), {
'id': '1',
'title': {
u'fr': u'SGRF',
u'de': u'AGI'
},
'content': {
'fr': u'Service de la géomatique et du registre foncier',
'de': u'Amt für Geoinformation'
}
})
# Add dummy real estate
connection.execute(
main.RealEstate.__table__.insert(), {
'id': '1',
'egrid': u'TEST',
'number': u'1000',
'identdn': u'BLTEST',
'type': u'RealEstate',
'canton': u'BL',
'municipality': u'Liestal',
'fosnr': 1234,
'land_registry_area': 4,
'limit': 'SRID=2056;MULTIPOLYGON(((0 0, 0 2, 2 2, 2 0, 0 0)))'
})
connection.execute(
main.RealEstate.__table__.insert(), {
'id': '2',
'egrid': u'TEST2',
'number': u'9999',
'identdn': u'BLTEST',
'type': u'RealEstate',
'canton': u'BL',
'municipality': u'Liestal',
'fosnr': 1234,
'land_registry_area': 9,
'limit': 'SRID=2056;MULTIPOLYGON(((2 0, 2 3, 5 3, 5 0, 2 0)))'
})
connection.close()