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 # 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_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()