def setUp(self): # noqa import sqlahelper import transaction from c2cgeoportal.models import DBSession, Role, User, Functionality from c2cgeoportal.lib.dbreflection import init role1 = Role(name=u"__test_role1") user1 = User( username=u"__test_user1", password=u"__test_user1", role=role1 ) role2 = Role(name=u"__test_role2") user2 = User( username=u"__test_user2", password=u"__test_user2", role=role2 ) functionality1 = Functionality(u"__test_s", u"db") functionality2 = Functionality(u"__test_a", u"db1") functionality3 = Functionality(u"__test_a", u"db2") role2.functionalities = [functionality1, functionality2, functionality3] DBSession.add_all([user1, user2, role1, role2]) transaction.commit() engine = sqlahelper.get_engine() init(engine)
def setUp(self): # noqa from c2cgeoportal.models import User, Role, LayerV1, RestrictionArea, Interface, DBSession user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1") user1.role_name = role1.name user1.email = u"Tarenpion" user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name user2.email = u"Tarenpion" main = Interface(name=u"main") layer1 = LayerV1(u"layer_1", public=False) layer1.interfaces = [main] layer2 = LayerV1(u"layer_2", public=False) layer2.interfaces = [main] layer3 = LayerV1(u"layer_3", public=False) layer3.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea(u"__test_ra1", u"", [layer1, layer2], [role1], area, readwrite=True) area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTElement(area, srid=21781) restricted_area2 = RestrictionArea(u"__test_ra2", u"", [layer1, layer2, layer3], [role2], area) DBSession.add_all([user1, user2, role1, role2, restricted_area1, restricted_area2]) DBSession.flush() transaction.commit()
def setup_method(self, _): from c2cgeoportal.models import User, Role, LayerWMS, RestrictionArea, \ Interface, DBSession ogc_server_internal, _ = create_default_ogcserver() user1 = User(username="******", password="******") role1 = Role(name="__test_role1", description="__test_role1") user1.role_name = role1.name user1.email = "Tarenpion" main = Interface(name="main") layer1 = LayerWMS("testpoint_group_name", public=False) layer1.layer = "testpoint_group" layer1.ogc_server = ogc_server_internal layer1.interfaces = [main] layer2 = LayerWMS("testpoint_protected_2_name", public=False) layer2.layer = "testpoint_protected_2" layer2.ogc_server = ogc_server_internal layer2.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea("__test_ra1", "", [layer1, layer2], [role1], area) DBSession.add_all([user1, role1, layer1, layer2, restricted_area1]) DBSession.flush() transaction.commit()
def setUp(self): import transaction import sqlahelper from sqlalchemy import Column, types, ForeignKey from sqlalchemy.orm import relationship from sqlalchemy.ext.declarative import declarative_base from c2cgeoportal.models import DBSession from c2cgeoportal.lib.dbreflection import _association_proxy engine = sqlahelper.get_engine() Base = declarative_base(bind=engine) class Child(Base): __tablename__ = 'child' id = Column(types.Integer, primary_key=True) name = Column(types.Unicode) def __init__(self, name): self.name = name class Parent(Base): __tablename__ = 'parent' id = Column(types.Integer, primary_key=True) child1_id = Column(types.Integer, ForeignKey('child.id')) child2_id = Column(types.Integer, ForeignKey('child.id')) child1_ = relationship(Child, primaryjoin=(child1_id==Child.id)) child1 = _association_proxy('child1_', 'name') child2_ = relationship(Child, primaryjoin=(child2_id==Child.id)) child2 = _association_proxy('child2_', 'name') Base.metadata.create_all() DBSession.add_all([Child('foo'), Child('bar')]) transaction.commit() self.metadata = Base.metadata self.cls = Parent
def setUp(self): # noqa from c2cgeoportal.models import User, Role, LayerV1, RestrictionArea, \ Interface, DBSession create_default_ogcserver() user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1") user1.role_name = role1.name user1.email = u"Tarenpion" main = Interface(name=u"main") layer1 = LayerV1(u"testpoint_group", public=False) layer1.interfaces = [main] layer2 = LayerV1(u"testpoint_protected_2", public=False) layer2.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea(u"__test_ra1", u"", [layer1, layer2], [role1], area) DBSession.add_all([user1, role1, layer1, layer2, restricted_area1]) DBSession.flush() transaction.commit()
def setUp(self): import transaction import sqlahelper from sqlalchemy import Column, types, ForeignKey from sqlalchemy.orm import relationship from sqlalchemy.ext.declarative import declarative_base from c2cgeoportal.models import DBSession from c2cgeoportal.lib.dbreflection import _association_proxy engine = sqlahelper.get_engine() Base = declarative_base(bind=engine) class Child(Base): __tablename__ = 'child' id = Column(types.Integer, primary_key=True) name = Column(types.Unicode) def __init__(self, name): self.name = name class Parent(Base): __tablename__ = 'parent' id = Column(types.Integer, primary_key=True) child1_id = Column(types.Integer, ForeignKey('child.id')) child2_id = Column(types.Integer, ForeignKey('child.id')) child1_ = relationship(Child, primaryjoin=(child1_id == Child.id)) child1 = _association_proxy('child1_', 'name') child2_ = relationship(Child, primaryjoin=(child2_id == Child.id)) child2 = _association_proxy('child2_', 'name') Base.metadata.create_all() DBSession.add_all([Child('foo'), Child('bar')]) transaction.commit() self.metadata = Base.metadata self.cls = Parent
def setUp(self): # noqa import sqlahelper import transaction from c2cgeoportal.models import DBSession, Role, User, Functionality from c2cgeoportal.lib.dbreflection import init create_default_ogcserver() role1 = Role(name=u"__test_role1") user1 = User(username=u"__test_user1", password=u"__test_user1", role=role1) role2 = Role(name=u"__test_role2") user2 = User(username=u"__test_user2", password=u"__test_user2", role=role2) functionality1 = Functionality(u"__test_s", u"db") functionality2 = Functionality(u"__test_a", u"db1") functionality3 = Functionality(u"__test_a", u"db2") role2.functionalities = [ functionality1, functionality2, functionality3 ] DBSession.add_all([user1, user2, role1, role2]) transaction.commit() engine = sqlahelper.get_engine() init(engine)
def setUp(self): # noqa import transaction from sqlalchemy import func from geoalchemy2 import WKTElement from c2cgeoportal.models import FullTextSearch, User, Role, Interface from c2cgeoportal.models import DBSession user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1") user1.role_name = role1.name user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name entry1 = FullTextSearch() entry1.label = "label1" entry1.layer_name = "layer1" entry1.ts = func.to_tsvector("french", "soleil travail") entry1.the_geom = WKTElement("POINT(-90 -45)", 21781) entry1.public = True entry2 = FullTextSearch() entry2.label = "label2" entry2.layer_name = "layer2" entry2.ts = func.to_tsvector("french", "pluie semaine") entry2.the_geom = WKTElement("POINT(-90 -45)", 21781) entry2.public = False entry3 = FullTextSearch() entry3.label = "label3" entry3.layer_name = "layer3" entry3.ts = func.to_tsvector("french", "vent neige") entry3.the_geom = WKTElement("POINT(-90 -45)", 21781) entry3.public = False entry3.role = role2 entry4 = FullTextSearch() entry4.label = "label4" entry4.layer_name = "layer1" entry4.ts = func.to_tsvector("french", "soleil travail") entry4.the_geom = WKTElement("POINT(-90 -45)", 21781) entry4.public = True entry5 = FullTextSearch() entry5.label = "label5" entry5.ts = func.to_tsvector("french", "params") entry5.public = True entry5.params = {"floor": 5} entry5.actions = [{"action": "add_layer", "data": "layer1"}] entry6 = FullTextSearch() entry6.label = "label6" entry6.ts = func.to_tsvector("french", "params") entry6.interface = Interface("main") entry6.public = True DBSession.add_all([user1, user2, role1, role2, entry1, entry2, entry3, entry4, entry5, entry6]) transaction.commit()
def setUp(): # noqa import transaction from sqlalchemy import func from geoalchemy2 import WKTElement from c2cgeoportal.models import FullTextSearch, User, Role, Interface from c2cgeoportal.models import DBSession user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1") user1.role_name = role1.name user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name entry1 = FullTextSearch() entry1.label = "label1" entry1.layer_name = "layer1" entry1.ts = func.to_tsvector("french", "soleil travail") entry1.the_geom = WKTElement("POINT(-90 -45)", 21781) entry1.public = True entry2 = FullTextSearch() entry2.label = "label2" entry2.layer_name = "layer2" entry2.ts = func.to_tsvector("french", "pluie semaine") entry2.the_geom = WKTElement("POINT(-90 -45)", 21781) entry2.public = False entry3 = FullTextSearch() entry3.label = "label3" entry3.layer_name = "layer3" entry3.ts = func.to_tsvector("french", "vent neige") entry3.the_geom = WKTElement("POINT(-90 -45)", 21781) entry3.public = False entry3.role = role2 entry4 = FullTextSearch() entry4.label = "label4" entry4.layer_name = "layer1" entry4.ts = func.to_tsvector("french", "soleil travail") entry4.the_geom = WKTElement("POINT(-90 -45)", 21781) entry4.public = True entry5 = FullTextSearch() entry5.label = "label5" entry5.ts = func.to_tsvector("french", "params") entry5.public = True entry5.params = {"floor": 5} entry5.actions = [{"action": "add_layer", "data": "layer1"}] entry6 = FullTextSearch() entry6.label = "label6" entry6.ts = func.to_tsvector("french", "params") entry6.interface = Interface("main") entry6.public = True DBSession.add_all([user1, user2, role1, role2, entry1, entry2, entry3, entry4, entry5, entry6]) transaction.commit()
def setUp(self): from c2cgeoportal.models import DBSession, User, Role, Layer, \ RestrictionArea, Theme, LayerGroup role1 = Role(name=u'__test_role1') user1 = User(username=u'__test_user1', password=u'__test_user1', role=role1) role2 = Role(name=u'__test_role2', extent=WKTSpatialElement( "POLYGON((1 2, 1 4, 3 4, 3 2, 1 2))", srid=21781)) user2 = User(username=u'__test_user2', password=u'__test_user2', role=role2) public_layer = Layer(name=u'__test_public_layer', order=40, public=True) public_layer.isChecked = False private_layer = Layer(name=u'__test_private_layer', order=40, public=False) private_layer.geoTable = 'a_schema.a_geo_table' layer_in_group = Layer(name=u'__test_layer_in_group') layer_group = LayerGroup(name=u'__test_layer_group') layer_group.children = [layer_in_group] layer_wmsgroup = Layer(name=u'test_wmsfeaturesgroup') layer_wmsgroup.isChecked = False theme = Theme(name=u'__test_theme') theme.children = [ public_layer, private_layer, layer_group, layer_wmsgroup ] poly = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTSpatialElement(poly, srid=21781) RestrictionArea(name=u'__test_ra1', description=u'', layers=[private_layer], roles=[role1], area=area) area = WKTSpatialElement(poly, srid=21781) RestrictionArea(name=u'__test_ra2', description=u'', layers=[private_layer], roles=[role2], area=area, readwrite=True) DBSession.add_all([user1, user2, public_layer, private_layer]) transaction.commit()
def create_default_ogcserver(): from c2cgeoportal.models import DBSession, OGCServer DBSession.query(OGCServer).delete() ogcserver = OGCServer(name="__test_ogc_server") ogcserver.url = mapserv ogcserver_external = OGCServer(name="__test_external_ogc_server") ogcserver_external.url = mapserv + "external=true&" DBSession.add_all([ogcserver, ogcserver_external]) return ogcserver, ogcserver_external
def setup_method(self, _): import transaction from c2cgeoportal.models import DBSession, User, Role r = Role(name="__test_role") u = User(username="******", password="******", role=r) DBSession.add_all([r, u]) transaction.commit()
def setUp(self): from c2cgeoportal.models import User, Role, Layer, RestrictionArea, \ Functionality, DBSession TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True) geom = WKTSpatialElement("MULTIPOINT((-90 -45))", srid=21781) p1 = TestPoint(the_geom=geom, name=u'foo', city=u'Lausanne', country=u'Swiss') geom = WKTSpatialElement("MULTIPOINT((-90 45))", srid=21781) p2 = TestPoint(the_geom=geom, name=u'bar', city=u'Chambéry', country=u'France') geom = WKTSpatialElement("MULTIPOINT((90 45))", srid=21781) p3 = TestPoint(the_geom=geom, name=u'éàè', city="Paris", country=u'France') geom = WKTSpatialElement("MULTIPOINT((90 -45))", srid=21781) p4 = TestPoint(the_geom=geom, name=u'123', city='Londre', country=u'UK') pt1 = Functionality(name=u'print_template', value=u'1 Wohlen A4 portrait') pt2 = Functionality(name=u'print_template', value=u'2 Wohlen A3 landscape') user1 = User(username=u'__test_user1', password=u'__test_user1') role1 = Role(name=u'__test_role1', description=u'__test_role1', functionalities=[pt1, pt2]) user1.role = role1 user1.email = u'Tarenpion' user2 = User(username=u'__test_user2', password=u'__test_user2') role2 = Role(name=u'__test_role2', description=u'__test_role2', functionalities=[pt1, pt2]) user2.role = role2 user2.email = u'Tarenpion' user3 = User(username=u'__test_user3', password=u'__test_user3') role3 = Role(name=u'__test_role3', description=u'__test_role3', functionalities=[pt1, pt2]) user3.role = role3 user3.email = u'Tarenpion' layer2 = Layer(u'testpoint_protected', 400, public=False) layer3 = Layer(u'testpoint_protected_query_with_collect', public=False) area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTSpatialElement(area, srid=21781) restricted_area1 = RestrictionArea(u'__test_ra1', u'', [layer2, layer3], [role1], area) area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTSpatialElement(area, srid=21781) restricted_area2 = RestrictionArea(u'__test_ra2', u'', [layer2, layer3], [role2, role3], area) area = "POLYGON((-95 43, -95 47, 95 47, 95 43, -95 43))" area = WKTSpatialElement(area, srid=21781) restricted_area3 = RestrictionArea(u'__test_ra3', u'', [layer3], [role3], area, readwrite=True) DBSession.add_all([ p1, p2, p3, p4, user1, user2, user3, restricted_area1, restricted_area2, restricted_area3 ]) DBSession.flush() self.id_lausanne = p1.id self.id_paris = p3.id transaction.commit()
def setUp(self): import transaction from sqlalchemy import func from geoalchemy import WKTSpatialElement from c2cgeoportal.models import FullTextSearch, User, Role from c2cgeoportal.models import DBSession user1 = User(username=u'__test_user1', password=u'__test_user1') role1 = Role(name=u'__test_role1', description=u'__test_role1') user1.role = role1 user2 = User(username=u'__test_user2', password=u'__test_user2') role2 = Role(name=u'__test_role2', description=u'__test_role2') user2.role = role2 entry1 = FullTextSearch() entry1.label = 'label1' entry1.layer_name = 'layer1' entry1.ts = func.to_tsvector('french', 'soleil travail') entry1.the_geom = WKTSpatialElement("POINT(-90 -45)") entry1.public = True entry2 = FullTextSearch() entry2.label = 'label2' entry2.layer_name = 'layer2' entry2.ts = func.to_tsvector('french', 'pluie semaine') entry2.the_geom = WKTSpatialElement("POINT(-90 -45)") entry2.public = False entry3 = FullTextSearch() entry3.label = 'label3' entry3.layer_name = 'layer3' entry3.ts = func.to_tsvector('french', 'vent neige') entry3.the_geom = WKTSpatialElement("POINT(-90 -45)") entry3.public = False entry3.role = role2 entry4 = FullTextSearch() entry4.label = 'label4' entry4.layer_name = 'layer1' entry4.ts = func.to_tsvector('french', 'soleil travail') entry4.the_geom = WKTSpatialElement("POINT(-90 -45)") entry4.public = True entry5 = FullTextSearch() entry5.label = 'label5' entry5.layer_name = 'layer1' entry5.ts = func.to_tsvector('french', 'params') entry5.the_geom = WKTSpatialElement("POINT(-90 -45)") entry5.public = True entry5.params = {'floor': 5} DBSession.add_all( [user1, user2, entry1, entry2, entry3, entry4, entry5]) transaction.commit()
def setUp(self): # noqa self.config = testing.setUp() import transaction from c2cgeoportal.models import DBSession, User, Role r = Role(name=u"__test_role") u = User(username=u"__test_user", password=u"__test_user", role=r) DBSession.add_all([r, u]) transaction.commit()
def setUp(self): # noqa self.config = testing.setUp() import transaction from c2cgeoportal.models import DBSession, User, Role r = Role(name=u"__test_role") u = User(username=u"__test_user", password=u"__test_user", role=r) DBSession.add_all([u, r]) transaction.commit()
def setUp(self): import transaction from sqlalchemy import func from geoalchemy import WKTSpatialElement from c2cgeoportal.models import FullTextSearch, User, Role from c2cgeoportal.models import DBSession user1 = User(username=u'__test_user1', password=u'__test_user1') role1 = Role(name=u'__test_role1', description=u'__test_role1') user1.role = role1 user2 = User(username=u'__test_user2', password=u'__test_user2') role2 = Role(name=u'__test_role2', description=u'__test_role2') user2.role = role2 entry1 = FullTextSearch() entry1.label = 'label1' entry1.layer_name = 'layer1' entry1.ts = func.to_tsvector('french', 'soleil travail') entry1.the_geom = WKTSpatialElement("POINT(-90 -45)") entry1.public = True entry2 = FullTextSearch() entry2.label = 'label2' entry2.layer_name = 'layer2' entry2.ts = func.to_tsvector('french', 'pluie semaine') entry2.the_geom = WKTSpatialElement("POINT(-90 -45)") entry2.public = False entry3 = FullTextSearch() entry3.label = 'label3' entry3.layer_name = 'layer3' entry3.ts = func.to_tsvector('french', 'vent neige') entry3.the_geom = WKTSpatialElement("POINT(-90 -45)") entry3.public = False entry3.role = role2 entry4 = FullTextSearch() entry4.label = 'label4' entry4.layer_name = 'layer1' entry4.ts = func.to_tsvector('french', 'soleil travail') entry4.the_geom = WKTSpatialElement("POINT(-90 -45)") entry4.public = True entry5 = FullTextSearch() entry5.label = 'label5' entry5.layer_name = 'layer1' entry5.ts = func.to_tsvector('french', 'params') entry5.the_geom = WKTSpatialElement("POINT(-90 -45)") entry5.public = True entry5.params = {'floor': 5} DBSession.add_all([user1, user2, entry1, entry2, entry3, entry4, entry5]) transaction.commit()
def setUp(self): from c2cgeoportal.models import DBSession, Layer, Theme, LayerGroup layer = Layer(name=u"__test_layer", public=True) layer_group = LayerGroup(name=u"__test_layer_group") layer_group.children = [layer, layer_group] theme = Theme(name=u"__test_theme") theme.children = [layer, layer_group] DBSession.add_all([layer, layer_group, theme]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Interface, LayerWMS, ServerOGC TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True) main = Interface(name=u"main") layer_wms_1 = LayerWMS(name=u"__test_layer_time_1", public=True) layer_wms_1.layer = "test_wmstime" layer_wms_1.time_mode = "single" layer_wms_1.interfaces = [main] layer_wms_1.server_ogc = ServerOGC(name="__test_server_ogc", type="mapserver", image_type="image/jpeg") layer_wms_2 = LayerWMS(name=u"__test_layer_time_2", public=True) layer_wms_2.layer = "test_wmstime2" layer_wms_2.time_mode = "single" layer_wms_2.interfaces = [main] layer_wms_2.server_ogc = ServerOGC(name="__test_server_ogc", type="mapserver", image_type="image/jpeg") layer_wms_group = LayerWMS(name=u"__test_layer_time_group", public=True) layer_wms_group.layer = "test_wmstimegroup" layer_wms_group.time_mode = "range" layer_wms_group.time_widget = "datepicker" layer_wms_group.interfaces = [main] layer_wms_group.server_ogc = ServerOGC(name="__test_server_ogc", type="mapserver", image_type="image/jpeg") layer_group_1 = LayerGroup(name=u"__test_layer_group_1") layer_group_1.children = [layer_wms_1, layer_wms_2] layer_group_2 = LayerGroup(name=u"__test_layer_group_2") layer_group_2.children = [layer_wms_1] layer_group_3 = LayerGroup(name=u"__test_layer_group_3") layer_group_3.children = [layer_wms_1, layer_wms_2, layer_wms_group] layer_group_4 = LayerGroup(name=u"__test_layer_group_4") layer_group_4.children = [layer_wms_group] theme = Theme(name=u"__test_theme") theme.interfaces = [main] theme.children = [ layer_group_1, layer_group_2, layer_group_3, layer_group_4 ] DBSession.add_all([theme]) transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, LayerV1, Theme, Interface, LayerGroup create_default_ogcserver() main = Interface(name="main") mobile = Interface(name="mobile") layer = LayerV1(name="__test_layer") layer.interfaces = [main, mobile] mobile_only_layer = LayerV1(name="__test_mobile_only_layer") mobile_only_layer.interfaces = [mobile] desktop_only_layer = LayerV1(name="__test_desktop_only_layer") desktop_only_layer.interfaces = [main] group = LayerGroup(name="__test_layer_group") group.children = [layer, mobile_only_layer, desktop_only_layer] theme = Theme(name="__test_theme") theme.children = [group] theme.interfaces = [main, mobile] mobile_only_group = LayerGroup(name="__test_mobile_only_layer_group") mobile_only_group.children = [layer] mobile_only_theme = Theme(name="__test_mobile_only_theme") mobile_only_theme.children = [mobile_only_group] mobile_only_theme.interfaces = [mobile] desktop_only_group = LayerGroup(name="__test_desktop_only_layer_group") desktop_only_group.children = [layer] desktop_only_theme = Theme(name="__test_desktop_only_theme") desktop_only_theme.children = [desktop_only_group] desktop_only_theme.interfaces = [main] # the following theme should not appear in the list of themes on desktop # nor on mobile # It should be accessible by explicitely loading it in mobile though mobile_private_group = LayerGroup( name="__test_mobile_private_layer_group") mobile_private_group.children = [layer] mobile_private_theme = Theme(name="__test_mobile_private_theme") mobile_private_theme.children = [mobile_private_group] DBSession.add_all([ layer, mobile_only_layer, desktop_only_layer, theme, mobile_only_theme, desktop_only_theme, mobile_private_theme ]) transaction.commit()
def setUp(self): from c2cgeoportal.models import DBSession, Layer, \ Theme, LayerGroup layer = Layer(name=u'__test_layer', public=True) layer_group = LayerGroup(name=u'__test_layer_group') layer_group.children = [layer, layer_group] theme = Theme(name=u'__test_theme') theme.children = [layer, layer_group] DBSession.add_all([layer, layer_group, theme]) transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Interface, LayerWMS, Metadata main = Interface(name="desktop") ogc_server, _ = create_default_ogcserver() layer_noscale = LayerWMS(name="__test_layer_noscale", public=True) layer_noscale.layer = "test_noscale" layer_noscale.interfaces = [main] layer_noscale.ogc_server = ogc_server layer_minscale = LayerWMS(name="__test_layer_minscale", public=True) layer_minscale.layer = "test_minscale" layer_minscale.interfaces = [main] layer_minscale.ogc_server = ogc_server layer_maxscale = LayerWMS(name="__test_layer_maxscale", public=True) layer_maxscale.layer = "test_maxscale" layer_maxscale.interfaces = [main] layer_maxscale.ogc_server = ogc_server layer_boothscale = LayerWMS(name="__test_layer_boothscale", public=True) layer_boothscale.layer = "test_boothscale" layer_boothscale.interfaces = [main] layer_boothscale.ogc_server = ogc_server layer_metadatascale = LayerWMS(name="__test_layer_metadatascale", public=True) layer_metadatascale.layer = "test_boothscale" layer_metadatascale.interfaces = [main] layer_metadatascale.ogc_server = ogc_server layer_metadatascale.metadatas = [ Metadata("minResolution", "100"), Metadata("maxResolution", "1000"), ] layer_group = LayerGroup(name="__test_layer_group") layer_group.children = [layer_noscale, layer_minscale, layer_maxscale, layer_boothscale, layer_metadatascale] theme = Theme(name="__test_theme") theme.interfaces = [main] theme.children = [layer_group] DBSession.add_all([theme]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, LayerV1, Theme, Interface, LayerGroup create_default_ogcserver() main = Interface(name=u"main") mobile = Interface(name=u"mobile") layer = LayerV1(name=u"__test_layer") layer.interfaces = [main, mobile] mobile_only_layer = LayerV1(name=u"__test_mobile_only_layer") mobile_only_layer.interfaces = [mobile] desktop_only_layer = LayerV1(name=u"__test_desktop_only_layer") desktop_only_layer.interfaces = [main] group = LayerGroup(name=u"__test_layer_group") group.children = [layer, mobile_only_layer, desktop_only_layer] theme = Theme(name=u"__test_theme") theme.children = [group] theme.interfaces = [main, mobile] mobile_only_group = LayerGroup(name=u"__test_mobile_only_layer_group") mobile_only_group.children = [layer] mobile_only_theme = Theme(name=u"__test_mobile_only_theme") mobile_only_theme.children = [mobile_only_group] mobile_only_theme.interfaces = [mobile] desktop_only_group = LayerGroup(name=u"__test_desktop_only_layer_group") desktop_only_group.children = [layer] desktop_only_theme = Theme(name=u"__test_desktop_only_theme") desktop_only_theme.children = [desktop_only_group] desktop_only_theme.interfaces = [main] # the following theme should not appear in the list of themes on desktop # nor on mobile # It should be accessible by explicitely loading it in mobile though mobile_private_group = LayerGroup(name=u"__test_mobile_private_layer_group") mobile_private_group.children = [layer] mobile_private_theme = Theme(name=u"__test_mobile_private_theme") mobile_private_theme.children = [mobile_private_group] DBSession.add_all([ layer, mobile_only_layer, desktop_only_layer, theme, mobile_only_theme, desktop_only_theme, mobile_private_theme ]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None functionality.FUNCTIONALITIES_TYPES = None from c2cgeoportal.models import DBSession, User, Role, \ RestrictionArea, Theme, LayerGroup, Interface, LayerWMS ogcserver, ogcserver_external = create_default_ogcserver() role1 = Role(name=u"__test_role1") role1.id = 999 user1 = User(username=u"__test_user1", password=u"__test_user1", role=role1) user1.email = "*****@*****.**" role2 = Role(name=u"__test_role2", extent=WKTElement( "POLYGON((1 2, 1 4, 3 4, 3 2, 1 2))", srid=21781 )) user2 = User(username=u"__test_user2", password=u"__test_user2", role=role2) main = Interface(name=u"main") private_layer = LayerWMS(name=u"__test_private_layer", public=False) private_layer.layer = "__test_private_layer" private_layer.geo_table = "a_schema.a_geo_table" private_layer.interfaces = [main] private_layer.ogc_server = ogcserver group = LayerGroup(name=u"__test_layer_group") group.children = [private_layer] theme = Theme(name=u"__test_theme") theme.children = [group] theme.interfaces = [main] DBSession.add(RestrictionArea( name=u"__test_ra1", description=u"", layers=[private_layer], roles=[role1], )) DBSession.add(RestrictionArea( name=u"__test_ra2", description=u"", layers=[private_layer], roles=[role2], readwrite=True, )) DBSession.add_all([ user1, user2, role1, role2, theme, group, private_layer, ]) transaction.commit()
def setUp(self): self.config = testing.setUp() from c2cgeoportal.models import DBSession, Layer, \ Theme, LayerGroup layer = Layer(name=u'__test_layer', public=True) layer_group = LayerGroup(name=u'__test_layer_group') layer_group.children = [layer, layer_group] theme = Theme(name=u'__test_theme') theme.children = [layer, layer_group] DBSession.add_all([layer, layer_group, theme]) transaction.commit()
def setUp(self): from c2cgeoportal.models import DBSession, User, Role, Layer, \ RestrictionArea, Theme, LayerGroup role1 = Role(name=u'__test_role1') user1 = User(username=u'__test_user1', password=u'__test_user1', role=role1) role2 = Role(name=u'__test_role2', extent=WKTSpatialElement( "POLYGON((1 2, 1 4, 3 4, 3 2, 1 2))", srid=21781 )) user2 = User(username=u'__test_user2', password=u'__test_user2', role=role2) public_layer = Layer(name=u'__test_public_layer', order=40, public=True) public_layer.isChecked = False private_layer = Layer(name=u'__test_private_layer', order=40, public=False) private_layer.geoTable = 'a_schema.a_geo_table' layer_in_group = Layer(name=u'__test_layer_in_group') layer_group = LayerGroup(name=u'__test_layer_group') layer_group.children = [layer_in_group] layer_wmsgroup = Layer(name=u'test_wmsfeaturesgroup') layer_wmsgroup.isChecked = False theme = Theme(name=u'__test_theme') theme.children = [public_layer, private_layer, layer_group, layer_wmsgroup] poly = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTSpatialElement(poly, srid=21781) RestrictionArea(name=u'__test_ra1', description=u'', layers=[private_layer], roles=[role1], area=area) area = WKTSpatialElement(poly, srid=21781) RestrictionArea( name=u'__test_ra2', description=u'', layers=[private_layer], roles=[role2], area=area, readwrite=True ) DBSession.add_all([user1, user2, public_layer, private_layer]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Interface, LayerWMS main = Interface(name=u"desktop") ogc_server, _ = create_default_ogcserver() layer_noscale = LayerWMS(name=u"__test_layer_noscale", public=True) layer_noscale.layer = "test_noscale" layer_noscale.interfaces = [main] layer_noscale.ogc_server = ogc_server layer_minscale = LayerWMS(name=u"__test_layer_minscale", public=True) layer_minscale.layer = "test_minscale" layer_minscale.interfaces = [main] layer_minscale.ogc_server = ogc_server layer_maxscale = LayerWMS(name=u"__test_layer_maxscale", public=True) layer_maxscale.layer = "test_maxscale" layer_maxscale.interfaces = [main] layer_maxscale.ogc_server = ogc_server layer_boothscale = LayerWMS(name=u"__test_layer_boothscale", public=True) layer_boothscale.layer = "test_boothscale" layer_boothscale.interfaces = [main] layer_boothscale.ogc_server = ogc_server layer_group = LayerGroup(name=u"__test_layer_group") layer_group.children = [layer_noscale, layer_minscale, layer_maxscale, layer_boothscale] theme = Theme(name=u"__test_theme") theme.interfaces = [main] theme.children = [layer_group] DBSession.add_all([theme]) transaction.commit()
def setUp(self): # noqa from c2cgeoportal.models import User, Role, LayerV1, RestrictionArea, \ Interface, DBSession user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1") user1.role_name = role1.name user1.email = u"Tarenpion" user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name user2.email = u"Tarenpion" main = Interface(name=u"main") layer1 = LayerV1(u"layer_1", public=False) layer1.interfaces = [main] layer2 = LayerV1(u"layer_2", public=False) layer2.interfaces = [main] layer3 = LayerV1(u"layer_3", public=False) layer3.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea(u"__test_ra1", u"", [layer1, layer2], [role1], area, readwrite=True) area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTElement(area, srid=21781) restricted_area2 = RestrictionArea(u"__test_ra2", u"", [layer1, layer2, layer3], [role2], area) DBSession.add_all( [user1, user2, role1, role2, restricted_area1, restricted_area2]) DBSession.flush() transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None cleanup_db() self._tables = [] import transaction from c2cgeoportal.models import DBSession, Role, User, Interface, TreeItem, Theme, \ LayerGroup, OGCSERVER_AUTH_NOAUTH for treeitem in DBSession.query(TreeItem).all(): DBSession.delete(treeitem) self.role = Role(name="__test_role") self.user = User( username="******", password="******", role=self.role ) self.main = Interface(name="main") self.ogc_server, external_ogc_server = create_default_ogcserver() self.ogc_server.auth = OGCSERVER_AUTH_NOAUTH external_ogc_server.auth = OGCSERVER_AUTH_NOAUTH self.metadata = None self.layer_ids = [] self.layer_group_1 = LayerGroup(name="__test_layer_group_1") theme = Theme(name="__test_theme") theme.interfaces = [self.main] theme.children = [self.layer_group_1] DBSession.add_all([self.main, self.user, self.role, theme, self.layer_group_1]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, LayerV1, \ Theme, LayerGroup, Interface main = Interface(name=u"main") layer = LayerV1(name=u"__test_layer", public=True) layer.interfaces = [main] layer_group = LayerGroup(name=u"__test_layer_group") layer_group.children = [layer, layer_group] theme = Theme(name=u"__test_theme") theme.children = [layer, layer_group] theme.interfaces = [main] DBSession.add_all([layer, layer_group, theme]) transaction.commit()
def setup_method(self, _): import transaction from c2cgeoportal.models import DBSession, Role, User, Functionality create_default_ogcserver() role1 = Role(name="__test_role1") user1 = User(username="******", password="******", role=role1) role2 = Role(name="__test_role2") user2 = User(username="******", password="******", role=role2) functionality1 = Functionality("__test_s", "db") functionality2 = Functionality("__test_a", "db1") functionality3 = Functionality("__test_a", "db2") role2.functionalities = [ functionality1, functionality2, functionality3 ] DBSession.add_all([user1, user2, role1, role2]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, LayerV1, \ Theme, LayerGroup, Interface create_default_ogcserver() main = Interface(name=u"desktop") layer = LayerV1(name=u"__test_layer", public=True) layer.interfaces = [main] layer_group = LayerGroup(name=u"__test_layer_group") layer_group.children = [layer, layer_group] theme = Theme(name=u"__test_theme") theme.children = [layer, layer_group] theme.interfaces = [main] DBSession.add_all([layer, layer_group, theme]) transaction.commit()
def setUp(self): self.config = testing.setUp() from c2cgeoportal.models import DBSession, User, Role, Layer, RestrictionArea, Theme, LayerGroup role1 = Role(name=u"__test_role1") user1 = User(username=u"__test_user1", password=u"__test_user1", role=role1) role2 = Role(name=u"__test_role2") user2 = User(username=u"__test_user2", password=u"__test_user2", role=role2) public_layer = Layer(name=u"__test_public_layer", order=40, public=True) public_layer.isChecked = False private_layer = Layer(name=u"__test_private_layer", order=40, public=False) private_layer.geoTable = "a_schema.a_geo_table" layer_in_group = Layer(name=u"__test_layer_in_group") layer_group = LayerGroup(name=u"__test_layer_group") layer_group.children = [layer_in_group] theme = Theme(name=u"__test_theme") theme.children = [public_layer, private_layer, layer_group] poly = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTSpatialElement(poly, srid=21781) ra = RestrictionArea(name=u"__test_ra1", description=u"", layers=[private_layer], roles=[role1], area=area) area = WKTSpatialElement(poly, srid=21781) ra = RestrictionArea( name=u"__test_ra2", description=u"", layers=[private_layer], roles=[role2], area=area, readwrite=True ) DBSession.add_all([user1, user2, public_layer, private_layer]) transaction.commit()
def setUp(self): # noqa import transaction import sqlahelper from sqlalchemy import Column, types, ForeignKey from sqlalchemy.orm import relationship from sqlalchemy.ext.declarative import declarative_base from c2cgeoportal.models import DBSession from c2cgeoportal.lib.dbreflection import _AssociationProxy engine = sqlahelper.get_engine() Base = declarative_base(bind=engine) # noqa class Child(Base): __tablename__ = "child" id = Column(types.Integer, primary_key=True) name = Column(types.Unicode) def __init__(self, name): self.name = name class Parent(Base): __tablename__ = "parent" id = Column(types.Integer, primary_key=True) child1_id = Column(types.Integer, ForeignKey("child.id")) child2_id = Column(types.Integer, ForeignKey("child.id")) child1_ = relationship(Child, primaryjoin=(child1_id == Child.id)) child1 = _AssociationProxy("child1_", "name") child2_ = relationship(Child, primaryjoin=(child2_id == Child.id)) child2 = _AssociationProxy("child2_", "name") Child.__table__.create() Parent.__table__.create() self._tables = [Parent.__table__, Child.__table__] DBSession.add_all([Child("foo"), Child("bar")]) transaction.commit() self.metadata = Base.metadata self.cls = Parent
def setUp(self): from c2cgeoportal.models import DBSession, Layer, Theme layer = Layer(name=u'__test_layer') mobile_only_layer = Layer(name=u'__test_mobile_only_layer') mobile_only_layer.inDesktopViewer = False desktop_only_layer = Layer(name=u'__test_desktop_only_layer') desktop_only_layer.inMobileViewer = False theme = Theme(name=u'__test_theme') theme.children = [layer, mobile_only_layer, desktop_only_layer] theme.inMobileViewer = True mobile_only_theme = Theme(name=u'__test_mobile_only_theme') mobile_only_theme.children = [layer] mobile_only_theme.inDesktopViewer = False mobile_only_theme.inMobileViewer = True desktop_only_theme = Theme(name=u'__test_desktop_only_theme') desktop_only_theme.children = [layer] desktop_only_theme.inMobileViewer = False # the following theme should not appear in the list of themes on desktop # nor on mobile # It should be accessible by explicitely loading it in mobile though mobile_private_theme = Theme(name=u'__test_mobile_private_theme') mobile_private_theme.children = [layer] mobile_private_theme.inDesktopViewer = False mobile_private_theme.inMobileViewer = False DBSession.add_all([ layer, mobile_only_layer, desktop_only_layer, theme, mobile_only_theme, desktop_only_theme, mobile_private_theme ]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None functionality.FUNCTIONALITIES_TYPES = None from c2cgeoportal.models import DBSession, User, Role, \ RestrictionArea, Theme, LayerGroup, Interface, LayerWMS ogcserver, ogcserver_external = create_default_ogcserver() role1 = Role(name=u"__test_role1") role1.id = 999 user1 = User(username=u"__test_user1", password=u"__test_user1", role=role1) user1.email = "*****@*****.**" role2 = Role(name=u"__test_role2", extent=WKTElement("POLYGON((1 2, 1 4, 3 4, 3 2, 1 2))", srid=21781)) user2 = User(username=u"__test_user2", password=u"__test_user2", role=role2) main = Interface(name=u"main") private_layer = LayerWMS(name=u"__test_private_layer", public=False) private_layer.layer = "__test_private_layer" private_layer.geo_table = "a_schema.a_geo_table" private_layer.interfaces = [main] private_layer.ogc_server = ogcserver group = LayerGroup(name=u"__test_layer_group") group.children = [private_layer] theme = Theme(name=u"__test_theme") theme.children = [group] theme.interfaces = [main] DBSession.add( RestrictionArea( name=u"__test_ra1", description=u"", layers=[private_layer], roles=[role1], )) DBSession.add( RestrictionArea( name=u"__test_ra2", description=u"", layers=[private_layer], roles=[role2], readwrite=True, )) DBSession.add_all([ user1, user2, role1, role2, theme, group, private_layer, ]) transaction.commit()
def setUp(self): # noqa self.maxDiff = None from c2cgeoportal.models import User, Role, LayerV1, RestrictionArea, \ Functionality, Interface, DBSession, management, OGCServer, \ OGCSERVER_TYPE_GEOSERVER, OGCSERVER_AUTH_GEOSERVER if management: TestPoint.__table__.c.the_geom.type.management = True create_default_ogcserver() ogcserver_geoserver = OGCServer(name="__test_ogc_server_geoserver") ogcserver_geoserver.url = mapserv_url ogcserver_geoserver.type = OGCSERVER_TYPE_GEOSERVER ogcserver_geoserver.auth = OGCSERVER_AUTH_GEOSERVER TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True) geom = WKTElement("MULTIPOINT((-90 -45))", srid=21781) p1 = TestPoint(the_geom=geom, name=u"foo", city=u"Lausanne", country=u"Swiss") geom = WKTElement("MULTIPOINT((-90 45))", srid=21781) p2 = TestPoint(the_geom=geom, name=u"bar", city=u"Chambéry", country=u"France") geom = WKTElement("MULTIPOINT((90 45))", srid=21781) p3 = TestPoint(the_geom=geom, name=u"éàè", city="Paris", country=u"France") geom = WKTElement("MULTIPOINT((90 -45))", srid=21781) p4 = TestPoint(the_geom=geom, name=u"123", city="Londre", country=u"UK") pt1 = Functionality(name=u"print_template", value=u"1 Wohlen A4 portrait") pt2 = Functionality(name=u"print_template", value=u"2 Wohlen A3 landscape") user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1", functionalities=[pt1, pt2]) user1.role_name = role1.name user1.email = u"Tarenpion" user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2", functionalities=[pt1, pt2]) user2.role_name = role2.name user2.email = u"Tarenpion" user3 = User(username=u"__test_user3", password=u"__test_user3") role3 = Role(name=u"__test_role3", description=u"__test_role3", functionalities=[pt1, pt2]) user3.role_name = role3.name user3.email = u"Tarenpion" main = Interface(name=u"main") layer2 = LayerV1(u"testpoint_protected", public=False) layer2.interfaces = [main] layer3 = LayerV1(u"testpoint_protected_query_with_collect", public=False) layer3.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea(u"__test_ra1", u"", [layer2, layer3], [role1], area) area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTElement(area, srid=21781) restricted_area2 = RestrictionArea(u"__test_ra2", u"", [layer2, layer3], [role2, role3], area) area = "POLYGON((-95 43, -95 47, 95 47, 95 43, -95 43))" area = WKTElement(area, srid=21781) restricted_area3 = RestrictionArea(u"__test_ra3", u"", [layer3], [role3], area, readwrite=True) DBSession.add_all([ p1, p2, p3, p4, user1, user2, user3, role1, role2, role3, restricted_area1, restricted_area2, restricted_area3, ogcserver_geoserver ]) DBSession.flush() self.id_lausanne = p1.id self.id_paris = p3.id transaction.commit()
def setUp(self): # noqa self.maxDiff = None from c2cgeoportal.models import User, Role, LayerV1, RestrictionArea, \ Functionality, Interface, DBSession, management, OGCServer, \ OGCSERVER_TYPE_GEOSERVER, OGCSERVER_AUTH_GEOSERVER if management: TestPoint.__table__.c.the_geom.type.management = True create_default_ogcserver() ogcserver_geoserver = OGCServer(name="__test_ogc_server_geoserver") ogcserver_geoserver.url = mapserv ogcserver_geoserver.type = OGCSERVER_TYPE_GEOSERVER ogcserver_geoserver.auth = OGCSERVER_AUTH_GEOSERVER TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True) geom = WKTElement("MULTIPOINT((-90 -45))", srid=21781) p1 = TestPoint(the_geom=geom, name=u"foo", city=u"Lausanne", country=u"Swiss") geom = WKTElement("MULTIPOINT((-90 45))", srid=21781) p2 = TestPoint(the_geom=geom, name=u"bar", city=u"Chambéry", country=u"France") geom = WKTElement("MULTIPOINT((90 45))", srid=21781) p3 = TestPoint(the_geom=geom, name=u"éàè", city="Paris", country=u"France") geom = WKTElement("MULTIPOINT((90 -45))", srid=21781) p4 = TestPoint(the_geom=geom, name=u"123", city="Londre", country=u"UK") pt1 = Functionality(name=u"print_template", value=u"1 Wohlen A4 portrait") pt2 = Functionality(name=u"print_template", value=u"2 Wohlen A3 landscape") user1 = User(username=u"__test_user1", password=u"__test_user1") role1 = Role(name=u"__test_role1", description=u"__test_role1", functionalities=[pt1, pt2]) user1.role_name = role1.name user1.email = u"Tarenpion" user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2", functionalities=[pt1, pt2]) user2.role_name = role2.name user2.email = u"Tarenpion" user3 = User(username=u"__test_user3", password=u"__test_user3") role3 = Role(name=u"__test_role3", description=u"__test_role3", functionalities=[pt1, pt2]) user3.role_name = role3.name user3.email = u"Tarenpion" main = Interface(name=u"main") layer2 = LayerV1(u"testpoint_protected", public=False) layer2.interfaces = [main] layer3 = LayerV1(u"testpoint_protected_query_with_collect", public=False) layer3.interfaces = [main] area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea(u"__test_ra1", u"", [layer2, layer3], [role1], area) area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))" area = WKTElement(area, srid=21781) restricted_area2 = RestrictionArea(u"__test_ra2", u"", [layer2, layer3], [role2, role3], area) area = "POLYGON((-95 43, -95 47, 95 47, 95 43, -95 43))" area = WKTElement(area, srid=21781) restricted_area3 = RestrictionArea(u"__test_ra3", u"", [layer3], [role3], area, readwrite=True) DBSession.add_all([ p1, p2, p3, p4, user1, user2, user3, role1, role2, role3, restricted_area1, restricted_area2, restricted_area3, ogcserver_geoserver ]) DBSession.flush() self.id_lausanne = p1.id self.id_paris = p3.id transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import User, Role, LayerWMS, RestrictionArea, \ Functionality, Interface, DBSession, OGCServer, \ OGCSERVER_TYPE_GEOSERVER, OGCSERVER_AUTH_GEOSERVER cleanup_db() ogc_server_internal, _ = create_default_ogcserver() ogcserver_geoserver = OGCServer(name="__test_ogc_server_geoserver") ogcserver_geoserver.url = mapserv_url ogcserver_geoserver.type = OGCSERVER_TYPE_GEOSERVER ogcserver_geoserver.auth = OGCSERVER_AUTH_GEOSERVER PointTest.__table__.create(bind=DBSession.bind, checkfirst=True) geom = WKTElement("POINT(599910 199955)", srid=21781) p1 = PointTest(geom=geom, name="foo", city="Lausanne", country="Swiss") geom = WKTElement("POINT(599910 200045)", srid=21781) p2 = PointTest(geom=geom, name="bar", city="Chambéry", country="France") geom = WKTElement("POINT(600090 200045)", srid=21781) p3 = PointTest(geom=geom, name="éàè", city="Paris", country="France") geom = WKTElement("POINT(600090 199955)", srid=21781) p4 = PointTest(geom=geom, name="123", city="Londre", country="UK") pt1 = Functionality(name="print_template", value="1 Wohlen A4 portrait") pt2 = Functionality(name="print_template", value="2 Wohlen A3 landscape") user1 = User(username="******", password="******") role1 = Role(name="__test_role1", description="__test_role1", functionalities=[pt1, pt2]) user1.role_name = role1.name user1.email = "Tarenpion" user2 = User(username="******", password="******") role2 = Role(name="__test_role2", description="__test_role2", functionalities=[pt1, pt2]) user2.role_name = role2.name user2.email = "Tarenpion" user3 = User(username="******", password="******") role3 = Role(name="__test_role3", description="__test_role3", functionalities=[pt1, pt2]) user3.role_name = role3.name main = Interface(name="main") layer2 = LayerWMS("testpoint_protected", public=False) layer2.layer = "testpoint_protected" layer2.ogc_server = ogc_server_internal layer2.interfaces = [main] layer3 = LayerWMS("testpoint_protected_query_with_collect", public=False) layer3.layer = "testpoint_protected_query_with_collect" layer3.ogc_server = ogc_server_internal layer3.interfaces = [main] area = "POLYGON((599900 200030, 599900 200050, 600100 200050, 600100 200030, 599900 200030))" area = WKTElement(area, srid=21781) restricted_area1 = RestrictionArea("__test_ra1", "", [layer2, layer3], [role1], area) area = "POLYGON((599900 200000, 599900 200020, 600100 200020, 600100 200000, 599900 200000))" area = WKTElement(area, srid=21781) restricted_area2 = RestrictionArea("__test_ra2", "", [layer2, layer3], [role2, role3], area) area = "POLYGON((599905 200043, 599905 200047, 600095 200047, 600095 200043, 599905 200043))" area = WKTElement(area, srid=21781) restricted_area3 = RestrictionArea("__test_ra3", "", [layer3], [role3], area, readwrite=True) DBSession.add_all([ p1, p2, p3, p4, user1, user2, user3, role1, role2, role3, restricted_area1, restricted_area2, restricted_area3, ogcserver_geoserver ]) DBSession.flush() self.id_lausanne = p1.id self.id_paris = p3.id self.ogc_server_id = ogc_server_internal.id self.role1_id = role1.id self.role2_id = role2.id self.role3_id = role3.id transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Interface, LayerWMS, LayerWMTS PointTest.__table__.create(bind=DBSession.bind, checkfirst=True) main = Interface(name="desktop") ogc_server, _ = create_default_ogcserver() layer_wms_1 = LayerWMS(name="__test_layer_time_1", public=True) layer_wms_1.layer = "test_wmstime" layer_wms_1.time_mode = "value" layer_wms_1.interfaces = [main] layer_wms_1.ogc_server = ogc_server layer_wms_2 = LayerWMS(name="__test_layer_time_2", public=True) layer_wms_2.layer = "test_wmstime2" layer_wms_2.time_mode = "value" layer_wms_2.interfaces = [main] layer_wms_2.ogc_server = ogc_server layer_wmts = LayerWMTS(name="__test_layer_wmts", public=True) layer_wmts.url = "http://example.com/1.0.0/WMTSCapabilities.xml" layer_wmts.layer = "map" layer_wmts.interfaces = [main] layer_wms_group = LayerWMS(name="__test_layer_time_group", public=True) layer_wms_group.layer = "test_wmstimegroup" layer_wms_group.time_mode = "range" layer_wms_group.time_widget = "datepicker" layer_wms_group.interfaces = [main] layer_wms_group.ogc_server = ogc_server layer_group_1 = LayerGroup(name="__test_layer_group_1") layer_group_1.children = [layer_wms_1, layer_wms_2] layer_group_2 = LayerGroup(name="__test_layer_group_2") layer_group_2.children = [layer_wms_1] layer_group_3 = LayerGroup(name="__test_layer_group_3") layer_group_3.children = [layer_wms_1, layer_wms_2, layer_wms_group] layer_group_4 = LayerGroup(name="__test_layer_group_4") layer_group_4.children = [layer_wms_group] layer_group_5 = LayerGroup(name="__test_layer_group_5") layer_group_5.children = [layer_wms_1, layer_wms_2] layer_group_6 = LayerGroup(name="__test_layer_group_6") layer_group_6.children = [layer_wms_1, layer_wms_2, layer_wmts] layer_group_7 = LayerGroup(name="__test_layer_group_7") layer_group_7.children = [layer_wms_1] theme = Theme(name="__test_theme") theme.interfaces = [main] theme.children = [ layer_group_1, layer_group_2, layer_group_3, layer_group_4, layer_group_5, layer_group_6, layer_group_7, ] DBSession.add_all([theme]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Interface, LayerWMS, LayerWMTS TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True) main = Interface(name=u"desktop") ogc_server, _ = create_default_ogcserver() layer_wms_1 = LayerWMS(name=u"__test_layer_time_1", public=True) layer_wms_1.layer = "test_wmstime" layer_wms_1.time_mode = "single" layer_wms_1.interfaces = [main] layer_wms_1.ogc_server = ogc_server layer_wms_2 = LayerWMS(name=u"__test_layer_time_2", public=True) layer_wms_2.layer = "test_wmstime2" layer_wms_2.time_mode = "single" layer_wms_2.interfaces = [main] layer_wms_2.ogc_server = ogc_server layer_wmts = LayerWMTS(name=u"__test_layer_wmts", public=True) layer_wmts.interfaces = [main] layer_wms_group = LayerWMS(name=u"__test_layer_time_group", public=True) layer_wms_group.layer = "test_wmstimegroup" layer_wms_group.time_mode = "range" layer_wms_group.time_widget = "datepicker" layer_wms_group.interfaces = [main] layer_wms_group.ogc_server = ogc_server layer_group_1 = LayerGroup(name=u"__test_layer_group_1") layer_group_1.children = [layer_wms_1, layer_wms_2] layer_group_2 = LayerGroup(name=u"__test_layer_group_2") layer_group_2.children = [layer_wms_1] layer_group_3 = LayerGroup(name=u"__test_layer_group_3") layer_group_3.children = [layer_wms_1, layer_wms_2, layer_wms_group] layer_group_4 = LayerGroup(name=u"__test_layer_group_4") layer_group_4.children = [layer_wms_group] layer_group_5 = LayerGroup(name=u"__test_layer_group_5") layer_group_5.children = [layer_wms_1, layer_wms_2] layer_group_6 = LayerGroup(name=u"__test_layer_group_6") layer_group_6.children = [layer_wms_1, layer_wms_2, layer_wmts] layer_group_7 = LayerGroup(name=u"__test_layer_group_7") layer_group_7.children = [layer_wms_1] theme = Theme(name=u"__test_theme") theme.interfaces = [main] theme.children = [ layer_group_1, layer_group_2, layer_group_3, layer_group_4, layer_group_5, layer_group_6, layer_group_7, ] DBSession.add_all([theme]) transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Functionality, Interface, \ LayerV1, OGCServer, LayerWMS, LayerWMTS, \ Metadata, Dimension, OGCSERVER_AUTH_NOAUTH main = Interface(name="desktop") mobile = Interface(name="mobile") min_levels = Interface(name="min_levels") layer_v1 = LayerV1(name="__test_layer_v1", public=True) layer_v1.interfaces = [main] layer_v1.metadatas = [Metadata("test", "v1")] ogc_server_internal, _ = create_default_ogcserver() ogc_server_external = OGCServer(name="__test_ogc_server_chtopo", url="http://wms.geo.admin.ch/", image_type="image/jpeg", auth=OGCSERVER_AUTH_NOAUTH) ogc_server_external.wfs_support = False layer_internal_wms = LayerWMS(name="__test_layer_internal_wms", public=True) layer_internal_wms.layer = "__test_layer_internal_wms" layer_internal_wms.interfaces = [main, min_levels] layer_internal_wms.metadatas = [Metadata("test", "internal_wms")] layer_internal_wms.ogc_server = ogc_server_internal layer_external_wms = LayerWMS(name="__test_layer_external_wms", layer="ch.swisstopo.dreiecksvermaschung", public=True) layer_external_wms.interfaces = [main] layer_external_wms.metadatas = [Metadata("test", "external_wms")] layer_external_wms.ogc_server = ogc_server_external layer_wmts = LayerWMTS(name="__test_layer_wmts", public=True) layer_wmts.url = "http://example.com/1.0.0/WMTSCapabilities.xml" layer_wmts.layer = "map" layer_wmts.interfaces = [main, mobile] layer_wmts.metadatas = [Metadata("test", "wmts")] layer_wmts.dimensions = [Dimension("year", "2015")] layer_group_1 = LayerGroup(name="__test_layer_group_1") layer_group_1.children = [ layer_v1, layer_internal_wms, layer_external_wms, layer_wmts ] layer_group_1.metadatas = [Metadata("test", "group_1")] layer_group_2 = LayerGroup(name="__test_layer_group_2") layer_group_2.children = [ layer_wmts, layer_internal_wms, layer_external_wms ] layer_group_3 = LayerGroup(name="__test_layer_group_3") layer_group_3.children = [ layer_wmts, layer_internal_wms, layer_external_wms ] layer_group_4 = LayerGroup(name="__test_layer_group_4") layer_group_4.children = [layer_group_2] theme = Theme(name="__test_theme") theme.interfaces = [main, mobile] theme.metadatas = [Metadata("test", "theme")] theme.children = [layer_group_1, layer_group_2] theme_layer = Theme(name="__test_theme_layer") theme_layer.interfaces = [min_levels] theme_layer.children = [layer_internal_wms] functionality1 = Functionality(name="test_name", value="test_value_1") functionality2 = Functionality(name="test_name", value="test_value_2") theme.functionalities = [functionality1, functionality2] DBSession.add_all([theme, theme_layer]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Functionality, Interface, \ LayerV1, ServerOGC, LayerWMS, LayerWMTS, \ UIMetadata, WMTSDimension main = Interface(name=u"main") mobile = Interface(name=u"mobile") min_levels = Interface(name=u"min_levels") layer_v1 = LayerV1(name=u"__test_layer_v1", public=True) layer_v1.interfaces = [main] layer_v1.ui_metadatas = [UIMetadata("test", "v1")] server_ogc_internal = ServerOGC(name="__test_server_ogc_internal", type="mapserver", image_type="image/jpeg") server_ogc_external = ServerOGC(name="__test_server_ogc_external", url="internal_url", image_type="image/jpeg") layer_internal_wms = LayerWMS(name=u"__test_layer_internal_wms", public=True) layer_internal_wms.layer = "__test_layer_internal_wms" layer_internal_wms.interfaces = [main, min_levels] layer_internal_wms.ui_metadatas = [UIMetadata("test", "internal_wms")] layer_internal_wms.server_ogc = server_ogc_internal layer_external_wms = LayerWMS(name=u"__test_layer_external_wms", public=True) layer_external_wms.interfaces = [main] layer_external_wms.ui_metadatas = [UIMetadata("test", "external_wms")] layer_external_wms.server_ogc = server_ogc_external layer_wmts = LayerWMTS(name=u"__test_layer_wmts", public=True) layer_wmts.interfaces = [main, mobile] layer_wmts.ui_metadatas = [UIMetadata("test", "wmts")] layer_wmts.dimensions = [WMTSDimension("year", "2015")] layer_group_1 = LayerGroup(name=u"__test_layer_group_1") layer_group_1.children = [layer_v1, layer_internal_wms, layer_external_wms, layer_wmts] layer_group_1.ui_metadatas = [UIMetadata("test", "group_1")] layer_group_2 = LayerGroup(name=u"__test_layer_group_2") layer_group_2.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_3 = LayerGroup(name=u"__test_layer_group_3") layer_group_3.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_4 = LayerGroup(name=u"__test_layer_group_4") layer_group_4.children = [layer_group_2] theme = Theme(name=u"__test_theme") theme.interfaces = [main, mobile] theme.ui_metadatas = [UIMetadata("test", "theme")] theme.children = [ layer_group_1, layer_group_2 ] theme_layer = Theme(name=u"__test_theme_layer") theme_layer.interfaces = [min_levels] theme_layer.children = [ layer_internal_wms ] functionality1 = Functionality(name=u"test_name", value=u"test_value_1") functionality2 = Functionality(name=u"test_name", value=u"test_value_2") theme.functionalities = [functionality1, functionality2] DBSession.add_all([theme, theme_layer]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Functionality, Interface, \ LayerV1, LayerInternalWMS, LayerExternalWMS, LayerWMTS, \ UIMetadata, WMTSDimension main = Interface(name=u'main') mobile = Interface(name=u'mobile') min_levels = Interface(name=u'min_levels') layer_v1 = LayerV1(name=u'__test_layer_v1', public=True) layer_v1.interfaces = [main] layer_v1.ui_metadata = [UIMetadata('test', 'v1')] layer_internal_wms = LayerInternalWMS(name=u'__test_layer_internal_wms', public=True) layer_internal_wms.layer = "__test_layer_internal_wms" layer_internal_wms.interfaces = [main, min_levels] layer_internal_wms.ui_metadata = [UIMetadata('test', 'internal_wms')] layer_external_wms = LayerExternalWMS(name=u'__test_layer_external_wms', public=True) layer_external_wms.interfaces = [main] layer_external_wms.ui_metadata = [UIMetadata('test', 'external_wms')] layer_wmts = LayerWMTS(name=u'__test_layer_wmts', public=True) layer_wmts.interfaces = [main, mobile] layer_wmts.ui_metadata = [UIMetadata('test', 'wmts')] layer_wmts.dimensions = [WMTSDimension('year', '2015')] layer_group_1 = LayerGroup(name=u'__test_layer_group_1') layer_group_1.children = [layer_v1, layer_internal_wms, layer_external_wms, layer_wmts] layer_group_1.ui_metadata = [UIMetadata('test', 'group_1')] layer_group_2 = LayerGroup(name=u'__test_layer_group_2') layer_group_2.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_3 = LayerGroup(name=u'__test_layer_group_3') layer_group_3.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_4 = LayerGroup(name=u'__test_layer_group_4') layer_group_4.children = [layer_group_2] theme = Theme(name=u'__test_theme') theme.interfaces = [main, mobile] theme.ui_metadata = [UIMetadata('test', 'theme')] theme.children = [ layer_group_1, layer_group_2 ] theme_layer = Theme(name=u'__test_theme_layer') theme_layer.interfaces = [min_levels] theme_layer.children = [ layer_internal_wms ] functionality1 = Functionality(name=u'test_name', value=u'test_value_1') functionality2 = Functionality(name=u'test_name', value=u'test_value_2') theme.functionalities = [functionality1, functionality2] DBSession.add_all([theme, theme_layer]) transaction.commit()
def setUp(self): # noqa # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None from c2cgeoportal.models import DBSession, \ Theme, LayerGroup, Functionality, Interface, \ LayerV1, OGCServer, LayerWMS, LayerWMTS, \ Metadata, Dimension, OGCSERVER_AUTH_NOAUTH main = Interface(name=u"desktop") mobile = Interface(name=u"mobile") min_levels = Interface(name=u"min_levels") layer_v1 = LayerV1(name=u"__test_layer_v1", public=True) layer_v1.interfaces = [main] layer_v1.metadatas = [Metadata("test", "v1")] ogc_server_internal, _ = create_default_ogcserver() ogc_server_external = OGCServer( name="__test_ogc_server_chtopo", url="http://wms.geo.admin.ch/", image_type="image/jpeg", auth=OGCSERVER_AUTH_NOAUTH ) ogc_server_external.wfs_support = False layer_internal_wms = LayerWMS(name=u"__test_layer_internal_wms", public=True) layer_internal_wms.layer = "__test_layer_internal_wms" layer_internal_wms.interfaces = [main, min_levels] layer_internal_wms.metadatas = [Metadata("test", "internal_wms")] layer_internal_wms.ogc_server = ogc_server_internal layer_external_wms = LayerWMS(name=u"__test_layer_external_wms", layer="ch.swisstopo.dreiecksvermaschung", public=True) layer_external_wms.interfaces = [main] layer_external_wms.metadatas = [Metadata("test", "external_wms")] layer_external_wms.ogc_server = ogc_server_external layer_wmts = LayerWMTS(name=u"__test_layer_wmts", public=True) layer_wmts.url = "http://example.com/1.0.0/WMTSCapabilities.xml" layer_wmts.layer = "map" layer_wmts.interfaces = [main, mobile] layer_wmts.metadatas = [Metadata("test", "wmts")] layer_wmts.dimensions = [Dimension("year", "2015")] layer_group_1 = LayerGroup(name=u"__test_layer_group_1") layer_group_1.children = [layer_v1, layer_internal_wms, layer_external_wms, layer_wmts] layer_group_1.metadatas = [Metadata("test", "group_1")] layer_group_2 = LayerGroup(name=u"__test_layer_group_2") layer_group_2.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_3 = LayerGroup(name=u"__test_layer_group_3") layer_group_3.children = [layer_wmts, layer_internal_wms, layer_external_wms] layer_group_4 = LayerGroup(name=u"__test_layer_group_4") layer_group_4.children = [layer_group_2] theme = Theme(name=u"__test_theme") theme.interfaces = [main, mobile] theme.metadatas = [Metadata("test", "theme")] theme.children = [ layer_group_1, layer_group_2 ] theme_layer = Theme(name=u"__test_theme_layer") theme_layer.interfaces = [min_levels] theme_layer.children = [ layer_internal_wms ] functionality1 = Functionality(name=u"test_name", value=u"test_value_1") functionality2 = Functionality(name=u"test_name", value=u"test_value_2") theme.functionalities = [functionality1, functionality2] DBSession.add_all([theme, theme_layer]) transaction.commit()
def setup_method(self, _): self.maxDiff = None from c2cgeoportal.models import User, Role, LayerWMS, RestrictionArea, \ Interface, DBSession, OGCServer, \ OGCSERVER_TYPE_MAPSERVER, OGCSERVER_AUTH_STANDARD cleanup_db() create_default_ogcserver() ogcserver_jpeg = OGCServer(name="__test_ogc_server_jpeg") ogcserver_jpeg.url = mapserv_url ogcserver_jpeg.image_type = "image/jpeg" ogcserver_jpeg.type = OGCSERVER_TYPE_MAPSERVER ogcserver_jpeg.auth = OGCSERVER_AUTH_STANDARD ogcserver_png = OGCServer(name="__test_ogc_server_png") ogcserver_png.url = mapserv_url ogcserver_png.image_type = "image/png" ogcserver_png.type = OGCSERVER_TYPE_MAPSERVER ogcserver_png.auth = OGCSERVER_AUTH_STANDARD ogcserver_wfs1 = OGCServer(name="__test_ogc_server_wfs1") ogcserver_wfs1.url = mapserv_url ogcserver_wfs1.url_wfs = "config://srv" ogcserver_wfs1.image_type = "image/png" ogcserver_wfs1.type = OGCSERVER_TYPE_MAPSERVER ogcserver_wfs1.auth = OGCSERVER_AUTH_STANDARD ogcserver_wfs2 = OGCServer(name="__test_ogc_server_wfs2") ogcserver_wfs2.url = "config://srv" ogcserver_wfs2.url_wfs = mapserv_url ogcserver_wfs2.image_type = "image/png" ogcserver_wfs2.type = OGCSERVER_TYPE_MAPSERVER ogcserver_wfs2.auth = OGCSERVER_AUTH_STANDARD role = Role(name="__test_role", description="__test_role") user = User(username="******", password="******") user.role_name = "__test_role" main = Interface(name="main") layer1 = LayerWMS("__test_layer1", public=False) layer1.layer = "__test_private_layer1" layer1.ogc_server = ogcserver_jpeg layer1.interfaces = [main] layer2 = LayerWMS("__test_layer2", public=False) layer2.layer = "__test_private_layer2" layer2.ogc_server = ogcserver_png layer2.interfaces = [main] layer3 = LayerWMS("__test_layer3", public=False) layer3.layer = "__test_private_layer3" layer3.ogc_server = ogcserver_wfs1 layer3.interfaces = [main] layer4 = LayerWMS("__test_layer4", public=False) layer4.layer = "__test_private_layer4" layer4.ogc_server = ogcserver_wfs2 layer4.interfaces = [main] restricted_area = RestrictionArea("__test_ra", "", [layer1, layer2, layer3, layer4], [role]) DBSession.add_all([user, restricted_area]) transaction.commit()
def setup_method(self, _): # Always see the diff # https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff self.maxDiff = None self._tables = [] functionality.FUNCTIONALITIES_TYPES = None from c2cgeoportal.models import DBSession, User, Role, \ RestrictionArea, TreeItem, Theme, LayerGroup, Interface, LayerWMS from sqlalchemy import Column, Table, types from sqlalchemy.ext.declarative import declarative_base from geoalchemy2 import Geometry for o in DBSession.query(RestrictionArea).all(): DBSession.delete(o) for o in DBSession.query(Role).all(): DBSession.delete(o) for o in DBSession.query(User).all(): DBSession.delete(o) for o in DBSession.query(TreeItem).all(): DBSession.delete(o) ogcserver, ogcserver_external = create_default_ogcserver() role1 = Role(name="__test_role1") role1.id = 999 user1 = User(username="******", password="******", role=role1) user1.email = "*****@*****.**" role2 = Role(name="__test_role2", extent=WKTElement( "POLYGON((1 2, 1 4, 3 4, 3 2, 1 2))", srid=21781 )) user2 = User(username="******", password="******", role=role2) main = Interface(name="main") engine = DBSession.c2c_rw_bind engine.connect() a_geo_table = Table( "a_geo_table", declarative_base(bind=engine).metadata, Column("id", types.Integer, primary_key=True), Column("geom", Geometry("POINT", srid=21781)), schema="geodata" ) self._tables = [a_geo_table] a_geo_table.drop(checkfirst=True) a_geo_table.create() private_layer = LayerWMS(name="__test_private_layer", public=False) private_layer.layer = "__test_private_layer" private_layer.geo_table = "geodata.a_geo_table" private_layer.interfaces = [main] private_layer.ogc_server = ogcserver group = LayerGroup(name="__test_layer_group") group.children = [private_layer] theme = Theme(name="__test_theme") theme.children = [group] theme.interfaces = [main] DBSession.add(RestrictionArea( name="__test_ra1", description="", layers=[private_layer], roles=[role1], )) DBSession.add(RestrictionArea( name="__test_ra2", description="", layers=[private_layer], roles=[role2], readwrite=True, )) DBSession.add_all([ user1, user2, role1, role2, theme, group, private_layer, ]) transaction.commit()