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