def restriction_area_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import LayerWMS, OGCServer, RestrictionArea, Role
roles = []
for i in range(0, 4):
roles.append(Role("secretary_" + str(i)))
dbsession.add_all(roles)
ogc_server = OGCServer(name="test_server")
layers = []
for i in range(0, 4):
layer = LayerWMS(name=f"layer_{i}", layer=f"layer_{i}", public=False)
layer.ogc_server = ogc_server
layers.append(layer)
dbsession.add_all(layers)
restrictionareas = []
for i in range(0, 4):
restrictionarea = RestrictionArea(name=f"restrictionarea_{i}")
restrictionarea.area = from_shape(box(485869.5728, 76443.1884,
837076.5648, 299941.7864),
srid=21781)
restrictionarea.description = f"description_{i}"
restrictionarea.roles = [roles[i % 4], roles[(i + 2) % 4]]
restrictionarea.layers = [layers[i % 4], layers[(i + 2) % 4]]
dbsession.add(restrictionarea)
restrictionareas.append(restrictionarea)
dbsession.flush()
yield {
"layers": layers,
"restriction_areas": restrictionareas,
"roles": roles,
}
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Theme, LayerGroup, Interface, LayerWMS
main = Interface(name="desktop")
ogc_server, _ = create_default_ogcserver()
layer_wms = LayerWMS(name="__test_layer_wms", public=True)
layer_wms.layer = "testpoint_unprotected"
layer_wms.interfaces = [main]
layer_wms.ogc_server = ogc_server
layer_group = LayerGroup(name="__test_layer_group")
layer_group.children = [layer_wms]
theme = Theme(name="__test/theme")
theme.interfaces = [main]
theme.children = [
layer_group
]
DBSession.add(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_commons.models import DBSession
from c2cgeoportal_commons.models.main import LayerWMS, \
Theme, LayerGroup, Interface
ogc_server, _ = create_default_ogcserver()
main = Interface(name="desktop2")
layer = LayerWMS(name="__test_layer", public=True)
layer.layers = "__test_layer"
layer.interfaces = [main]
layer.ogc_server = ogc_server
layer_group = LayerGroup(name="__test_layer_group")
layer_group.children = [layer, layer_group]
theme = Theme(name="__test_theme")
theme.children = [layer_group]
theme.interfaces = [main]
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_commons.models import DBSession
from c2cgeoportal_commons.models.main import Theme, LayerGroup, Interface, LayerWMS
main = Interface(name="desktop")
ogc_server, _ = create_default_ogcserver()
layer_wms = LayerWMS(name="__test_layer_wms", public=True)
layer_wms.layer = "testpoint_unprotected"
layer_wms.interfaces = [main]
layer_wms.ogc_server = ogc_server
layer_group = LayerGroup(name="__test_layer_group")
layer_group.children = [layer_wms]
theme = Theme(name="__test/theme")
theme.interfaces = [main]
theme.children = [layer_group]
DBSession.add(theme)
transaction.commit()
def setup_method(self, _):
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, LayerWMS, RestrictionArea, Interface
from c2cgeoportal_commons.models.static import User
ogc_server_internal = create_default_ogcserver()
role1 = Role(name="__test_role1", description="__test_role1")
user1 = User(username="******",
password="******",
settings_role=role1,
roles=[role1])
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 interface_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import Interface, LayerWMS, OGCServer, Theme
themes = []
for i in range(0, 5):
theme = Theme(name=f"theme_{i}", ordering=1)
themes.append(theme)
servers = [OGCServer(name=f"server_{i}") for i in range(0, 4)]
layers = []
for i in range(0, 15):
layer = LayerWMS(name=f"layer_wms_{i}")
layer.public = 1 == i % 2
layer.ogc_server = servers[i % 4]
dbsession.add(layer)
layers.append(layer)
interfaces = []
for i in range(0, 5):
interface = Interface(name=f"interface_{i}", description=f"description_{i}")
interface.themes = [themes[i % 2], themes[(i + 5) % 5]]
interface.layers = [layers[i % 2], layers[(i + 4) % 5]]
dbsession.add(interface)
interfaces.append(interface)
dbsession.flush()
yield {"interfaces": interfaces}
def __init__(
self, name='', layer='', public=True,
time_mode='disabled',
time_widget='slider',
category_id=0
):
LayerWMS.__init__(self, name=name, layer=layer, public=public,
time_mode=time_mode, time_widget=time_widget)
self.category_id = category_id
def metadatas_test_data(dbsession):
from c2cgeoportal_commons.models.main import \
LayerWMS, LayerWMTS, LayerV1, OGCServer, Metadata, Theme, LayerGroup
dbsession.begin_nested()
ogc_server = OGCServer(name='ogc_server')
layer_wms = LayerWMS(name='layer_wms')
layer_wms.layer = 'wms_layer'
layer_wms.ogc_server = ogc_server
layer_wms.metadatas = [
Metadata(name, value)
for name, value in [
('_string', 'ceci est un test'),
('_liste', 'valeur1,valeur2'),
('_boolean', 'true'),
('_int', '1'),
('_float', '2.5'),
('_url', 'https://localhost/test.html'),
('_json', '{"key":"value"}'),
('_color', '#FFFFFF'),
('_unknown', 'This is a unknown format')
]
]
for metadata in layer_wms.metadatas:
metadata.item = layer_wms
dbsession.add(layer_wms)
layer_wmts = LayerWMTS(name='layer_wmts')
layer_wmts.url = 'https://localhost'
layer_wmts.layer = 'wmts_layer'
dbsession.add(layer_wmts)
layer_v1 = LayerV1(name='layer_v1')
dbsession.add(layer_v1)
theme = Theme(name='theme')
dbsession.add(theme)
group = LayerGroup(name='groups')
dbsession.add(group)
dbsession.flush()
yield {
'ogc_server': ogc_server,
'layer_wms': layer_wms,
'layer_wmts': layer_wmts,
'layer_v1': layer_v1,
'theme': theme,
'group': group
}
dbsession.rollback()
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import LayerWMS, Theme, Interface, LayerGroup
create_default_ogcserver()
main = Interface(name="main")
mobile = Interface(name="mobile")
layer = LayerWMS(name="__test_layer")
layer.interfaces = [main, mobile]
mobile_only_layer = LayerWMS(name="__test_mobile_only_layer")
mobile_only_layer.interfaces = [mobile]
desktop_only_layer = LayerWMS(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 explicitly 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 metadatas_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import \
LayerWMS, LayerWMTS, LayerV1, OGCServer, Metadata, Theme, LayerGroup
ogc_server = OGCServer(name='ogc_server')
layer_wms = LayerWMS(name='layer_wms')
layer_wms.layer = 'wms_layer'
layer_wms.ogc_server = ogc_server
layer_wms.metadatas = [
Metadata(name, value) for name, value in
[('_string',
'ceci est un test'), ('_liste',
'valeur1,valeur2'), ('_boolean',
'true'), ('_int', '1'),
('_float',
'2.5'), ('_url',
'https://localhost/test.html'), ('_json',
'{"key":"value"}'),
('_color', '#FFFFFF'), ('_unknown', 'This is a unknown format')]
]
for metadata in layer_wms.metadatas:
metadata.item = layer_wms
dbsession.add(layer_wms)
layer_wmts = LayerWMTS(name='layer_wmts')
layer_wmts.url = 'https://localhost'
layer_wmts.layer = 'wmts_layer'
dbsession.add(layer_wmts)
layer_v1 = LayerV1(name='layer_v1')
dbsession.add(layer_v1)
theme = Theme(name='theme')
dbsession.add(theme)
group = LayerGroup(name='groups')
dbsession.add(group)
dbsession.flush()
yield {
'ogc_server': ogc_server,
'layer_wms': layer_wms,
'layer_wmts': layer_wmts,
'layer_v1': layer_v1,
'theme': theme,
'group': group
}
def main() -> None:
parser = argparse.ArgumentParser(
description="Create and populate the database tables.")
fill_arguments(parser)
options = parser.parse_args()
settings = get_appsettings(options)
with transaction.manager:
session = get_session(settings, transaction.manager)
from c2cgeoportal_commons.models.main import ( # pylint: disable=import-outside-toplevel
Interface, LayerGroup, LayerWMS, OGCServer, Theme,
)
interfaces = session.query(Interface).all()
ogc_server = session.query(OGCServer).filter(
OGCServer.name == "source for image/png").one()
layer_borders = LayerWMS("Borders", "borders")
layer_borders.interfaces = interfaces
layer_borders.ogc_server = ogc_server
layer_density = LayerWMS("Density", "density")
layer_density.interfaces = interfaces
layer_density.ogc_server = ogc_server
group = LayerGroup("Demo")
group.children = [layer_borders, layer_density]
theme = Theme("Demo")
theme.children = [group]
theme.interfaces = interfaces
session.add(theme)
print("Successfully added the demo theme")
def setup_method(self, _):
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, LayerWMS, RestrictionArea, Interface
from c2cgeoportal_commons.models.static import User
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): # noqa
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
self.clean()
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.static import User
from c2cgeoportal_commons.models.main import \
Theme, LayerGroup, Interface, LayerWMS, LayerWMTS, Role, RestrictionArea
main = Interface(name=u"desktop")
role = Role(name=u"__test_role")
user = User(username=u"__test_user", password=u"__test_user", role=role)
user.email = "*****@*****.**"
ogc_server_internal, _ = create_default_ogcserver()
layer_wms = LayerWMS(name=u"__test_layer_wms", public=True)
layer_wms.layer = "__test_public_layer"
layer_wms.interfaces = [main]
layer_wms.ogc_server = ogc_server_internal
layer_wms_private = LayerWMS(name=u"__test_layer_wms_private", public=True)
layer_wms_private.layer = "__test_private_layer"
layer_wms_private.public = False
layer_wms_private.interfaces = [main]
layer_wms_private.ogc_server = ogc_server_internal
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]
layer_wmts_private = LayerWMTS(name=u"__test_layer_wmts_private", public=True)
layer_wmts_private.url = "http://example.com/1.0.0/WMTSCapabilities.xml"
layer_wmts_private.layer = "map"
layer_wmts_private.public = False
layer_wmts_private.interfaces = [main]
layer_group = LayerGroup(name=u"__test_layer_group")
layer_group.children = [layer_wms, layer_wms_private, layer_wmts, layer_wmts_private]
theme = Theme(name=u"__test_theme")
theme.interfaces = [main]
theme.children = [layer_group]
restriction_area = RestrictionArea(
name=u"__test_ra1", layers=[layer_wms_private, layer_wmts_private], roles=[role]
)
DBSession.add_all([theme, restriction_area, user])
transaction.commit()
def get_test_default_layers(dbsession, default_ogc_server):
from c2cgeoportal_commons.models.main import LayerWMTS, LayerWMS
default_wms = LayerWMS('wms-defaults')
default_wms.ogc_server = default_ogc_server
default_wms.time_widget = 'datepicker'
default_wms.time_mode = 'value'
dbsession.add(default_wms)
default_wmts = LayerWMTS('wmts-defaults')
default_wmts.url = 'https:///wmts.geo.admin_default.ch.org?service=wms&request=GetCapabilities'
default_wmts.layer = 'default'
default_wmts.matrix_set = 'matrix'
dbsession.add(default_wmts)
dbsession.flush()
return {'wms': default_wms, 'wmts': default_wmts}
def metadatas_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import LayerWMS, LayerWMTS, OGCServer, Metadata, Theme, LayerGroup
ogc_server = OGCServer(name="ogc_server")
layer_wms = LayerWMS(name="layer_wms")
layer_wms.layer = "wms_layer"
layer_wms.ogc_server = ogc_server
layer_wms.metadatas = [
Metadata(name, value)
for name, value in [
("_string", "ceci est un test"),
("_liste", "valeur1,valeur2"),
("_boolean", "true"),
("_int", "1"),
("_float", "2.5"),
("_url", "https://localhost/test.html"),
("_json", '{"key":"value"}'),
("_color", "#FFFFFF"),
("_unknown", "This is a unknown format"),
]
]
for metadata in layer_wms.metadatas:
metadata.item = layer_wms
dbsession.add(layer_wms)
layer_wmts = LayerWMTS(name="layer_wmts")
layer_wmts.url = "https://localhost"
layer_wmts.layer = "wmts_layer"
dbsession.add(layer_wmts)
theme = Theme(name="theme")
dbsession.add(theme)
group = LayerGroup(name="groups")
dbsession.add(group)
dbsession.flush()
yield {
"ogc_server": ogc_server,
"layer_wms": layer_wms,
"layer_wmts": layer_wmts,
"theme": theme,
"group": group,
}
def view(self):
if self._is_new():
dbsession = self._request.dbsession
default_wms = LayerWMS.get_default(dbsession)
if default_wms:
return self.copy(default_wms, excludes=['name', 'layer'])
return super().edit()
def test_convert_without_wms_defaults(self, test_app, layer_wmts_test_data,
dbsession):
from c2cgeoportal_commons.models.main import LayerWMS
dbsession.delete(LayerWMS.get_default(dbsession))
layer = layer_wmts_test_data['layers'][3]
test_app.post("/layers_wmts/{}/convert_to_wms".format(layer.id),
status=200)
def view(self) -> Dict[str, Any]:
if self._is_new():
dbsession = self._request.dbsession
default_wms = LayerWMS.get_default(dbsession)
if default_wms:
return self.copy(default_wms,
excludes=["name", "layer"]) # type: ignore
return super().edit() # type: ignore
def __init__(
self, name='', layer='', public=True,
time_mode='disabled',
time_widget='slider',
url='',
layers='',
is_poi=False,
collection_id=0,
rest_url=''
):
LayerWMS.__init__(self, name=name, layer=layer, public=public,
time_mode=time_mode, time_widget=time_widget)
self.url = url
self.layers = layers
self.is_poi = is_poi
self.collection_id = collection_id
self.rest_url = rest_url
def layer_builder(i):
layer = LayerWMS(name="layer_wms_{}".format(i))
layer.layer = "layer_{}".format(i)
layer.public = 1 == i % 2
layer.geo_table = "geotable_{}".format(i)
layer.ogc_server = servers[i % 4]
layer.style = "décontrasté"
return layer
def main():
parser = argparse.ArgumentParser(
description="Create and populate the database tables.")
parser.add_argument('-i',
'--iniconfig',
default='production.ini',
help='project .ini config file')
parser.add_argument(
'-n',
'--app-name',
default="app",
help='The application name (optional, default is "app")')
options = parser.parse_args()
# read the configuration
env = {}
env.update(os.environ)
env["LOG_LEVEL"] = "INFO"
env["GUNICORN_ACCESS_LOG_LEVEL"] = "INFO"
env["C2CGEOPORTAL_LOG_LEVEL"] = "WARN"
fileConfig(options.iniconfig, defaults=env)
get_app(options.iniconfig, options.app_name, options=env)
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Interface, OGCServer, Theme, LayerGroup, LayerWMS
session = DBSession()
interfaces = session.query(Interface).all()
ogc_server = session.query(OGCServer).filter(
OGCServer.name == "source for image/png").one()
layer_borders = LayerWMS("Borders", "borders")
layer_borders.interfaces = interfaces
layer_borders.ogc_server = ogc_server
layer_density = LayerWMS("Density", "density")
layer_density.interfaces = interfaces
layer_density.ogc_server = ogc_server
group = LayerGroup("Demo")
group.children = [layer_borders, layer_density]
theme = Theme("Demo")
theme.children = [group]
theme.interfaces = interfaces
session.add(theme)
transaction.commit()
print("Successfully added the demo theme")
def get_test_default_layers(dbsession, default_ogc_server):
from c2cgeoportal_commons.models.main import LayerVectorTiles, LayerWMS, LayerWMTS
default_wms = LayerWMS("wms-defaults")
default_wms.ogc_server = default_ogc_server
default_wms.time_widget = "datepicker"
default_wms.time_mode = "value"
dbsession.add(default_wms)
default_wmts = LayerWMTS("wmts-defaults")
default_wmts.url = "https:///wmts.geo.admin_default.ch.org?service=wms&request=GetCapabilities"
default_wmts.layer = "default"
default_wmts.matrix_set = "matrix"
dbsession.add(default_wmts)
default_vectortiles = LayerVectorTiles("vectortiles-defaults")
default_vectortiles.style = "https://vectortiles-staging.geoportail.lu/styles/roadmap/style.json"
dbsession.add(default_vectortiles)
dbsession.flush()
return {
"wms": default_wms,
"wmts": default_wmts,
"vectortiles": default_vectortiles
}
def interface_test_data(dbsession):
from c2cgeoportal_commons.models.main import Interface, Theme, OGCServer, LayerWMS
dbsession.begin_nested()
themes = []
for i in range(0, 5):
theme = Theme(name='theme_{}'.format(i),
ordering=1)
themes.append(theme)
servers = [OGCServer(name='server_{}'.format(i)) for i in range(0, 4)]
layers = []
for i in range(0, 15):
layer = LayerWMS(name='layer_wms_{}'.format(i))
layer.public = 1 == i % 2
layer.ogc_server = servers[i % 4]
dbsession.add(layer)
layers.append(layer)
interfaces = []
for i in range(0, 5):
interface = Interface(name='interface_{}'.format(i),
description='description_{}'.format(i))
interface.themes = [themes[i % 2],
themes[(i + 5) % 5]]
interface.layers = [layers[i % 2],
layers[(i + 4) % 5]]
dbsession.add(interface)
interfaces.append(interface)
yield {
'interfaces': interfaces
}
dbsession.rollback()
def convert_to_wms(self):
src = self._get_object()
dbsession = self._request.dbsession
default_wms = LayerWMS.get_default(dbsession)
values = ({
"ogc_server_id": default_wms.ogc_server_id,
"time_mode": default_wms.time_mode,
"time_widget": default_wms.time_widget,
} if default_wms else {
"ogc_server_id":
dbsession.query(OGCServer.id).order_by(OGCServer.id).first()[0],
"time_mode":
"disabled",
"time_widget":
"slider",
})
with dbsession.no_autoflush:
d = delete(LayerWMTS.__table__)
d = d.where(LayerWMTS.__table__.c.id == src.id)
i = insert(LayerWMS.__table__)
values.update({
"id": src.id,
"layer": src.layer,
"style": src.style
})
i = i.values(values)
u = update(TreeItem.__table__)
u = u.where(TreeItem.__table__.c.id == src.id)
u = u.values({"type": "l_wms"})
dbsession.execute(d)
dbsession.execute(i)
dbsession.execute(u)
dbsession.expunge(src)
dbsession.flush()
mark_changed(dbsession)
return {
"success":
True,
"redirect":
self._request.route_url(
"c2cgeoform_item",
table="layers_wms",
id=self._request.matchdict["id"],
_query=[("msg_col", "submit_ok")],
),
}
def convert_to_wms(self):
src = self._get_object()
dbsession = self._request.dbsession
default_wms = LayerWMS.get_default(dbsession)
values = {
'ogc_server_id': default_wms.ogc_server_id,
'time_mode': default_wms.time_mode,
'time_widget': default_wms.time_widget
} if default_wms else {
'ogc_server_id':
dbsession.query(OGCServer.id).order_by(OGCServer.id).first()[0],
'time_mode':
'disabled',
'time_widget':
'slider'
}
with dbsession.no_autoflush:
d = delete(LayerWMTS.__table__)
d = d.where(LayerWMTS.__table__.c.id == src.id)
i = insert(LayerWMS.__table__)
values.update({
'id': src.id,
'layer': src.layer,
'style': src.style
})
i = i.values(values)
u = update(TreeItem.__table__)
u = u.where(TreeItem.__table__.c.id == src.id)
u = u.values({'type': 'l_wms'})
dbsession.execute(d)
dbsession.execute(i)
dbsession.execute(u)
dbsession.expunge(src)
dbsession.flush()
mark_changed(dbsession)
return {
'success':
True,
'redirect':
self._request.route_url('c2cgeoform_item',
table='layers_wms',
id=self._request.matchdict['id'],
_query=[('msg_col', 'submit_ok')])
}
def main():
parser = argparse.ArgumentParser(
description="Create and populate the database tables."
)
parser.add_argument(
'-i', '--iniconfig',
default='geoportal/production.ini',
help='project .ini config file'
)
parser.add_argument(
'-n', '--app-name',
default="app",
help='The application name (optional, default is "app")'
)
options = parser.parse_args()
# read the configuration
fileConfig(options.iniconfig, defaults=os.environ)
get_app(options.iniconfig, options.app_name, options=os.environ)
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Interface, OGCServer, Theme, LayerGroup, LayerWMS
session = DBSession()
interfaces = session.query(Interface).all()
ogc_server = session.query(OGCServer).filter(OGCServer.name == "source for image/png").one()
layer_borders = LayerWMS("Borders", "borders")
layer_borders.interfaces = interfaces
layer_borders.ogc_server = ogc_server
layer_density = LayerWMS("Density", "density")
layer_density.interfaces = interfaces
layer_density.ogc_server = ogc_server
group = LayerGroup("Demo")
group.children = [layer_borders, layer_density]
theme = Theme("Demo")
theme.children = [group]
theme.interfaces = interfaces
session.add(theme)
transaction.commit()
def layer_wms_test_data(dbsession):
from c2cgeoportal_commons.models.main import \
LayerWMS, OGCServer, RestrictionArea, LayergroupTreeitem, \
Interface, Dimension, Metadata, LayerGroup
dbsession.begin_nested()
servers = [OGCServer(name='server_{}'.format(i)) for i in range(0, 4)]
for i, server in enumerate(servers):
server.image_type = 'image/jpeg' if i % 2 == 0 else 'image/png'
restrictionareas = [RestrictionArea(name='restrictionarea_{}'.format(i))
for i in range(0, 5)]
interfaces = [Interface(name) for name in ['desktop', 'mobile', 'edit', 'routing']]
dimensions_protos = [('Date', '2017'),
('Date', '2018'),
('Date', '1988'),
('CLC', 'all'), ]
metadatas_protos = [('copyable', 'true'),
('disclaimer', '© le momo'),
('snappingConfig', '{"tolerance": 50}')]
groups = [LayerGroup(name='layer_group_{}'.format(i)) for i in range(0, 5)]
layers = []
for i in range(0, 25):
layer = LayerWMS(name='layer_wms_{}'.format(i))
layer.layer = 'layer_{}'.format(i)
layer.public = 1 == i % 2
layer.ogc_server = servers[i % 4]
layer.restrictionareas = [restrictionareas[i % 5],
restrictionareas[(i + 2) % 5]]
if i % 10 != 1:
layer.interfaces = [interfaces[i % 4], interfaces[(i + 2) % 4]]
layer.dimensions = [Dimension(name=dimensions_protos[id][0],
value=dimensions_protos[id][1],
layer=layer)
for id in [i % 3, (i + 2) % 4, (i + 3) % 4]]
layer.metadatas = [Metadata(name=metadatas_protos[id][0],
value=metadatas_protos[id][1])
for id in [i % 3, (i + 2) % 3]]
for metadata in layer.metadatas:
metadata.item = layer
dbsession.add(LayergroupTreeitem(group=groups[i % 5],
item=layer,
ordering=len(groups[i % 5].children_relation)))
dbsession.add(LayergroupTreeitem(group=groups[(i + 3) % 5],
item=layer,
ordering=len(groups[(i + 3) % 5].children_relation)))
dbsession.add(layer)
layers.append(layer)
dbsession.flush()
yield {
'servers': servers,
'restrictionareas': restrictionareas,
'layers': layers,
'interfaces': interfaces
}
dbsession.rollback()
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, LayerWMS, RestrictionArea, \
Functionality, Interface, OGCServer, OGCSERVER_TYPE_GEOSERVER, OGCSERVER_AUTH_GEOSERVER
from c2cgeoportal_commons.models.static import User
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 _create_layer(self, exclude_properties=False, metadatas=None, geom_type=False):
""" This function is central for this test class. It creates
a layer with two features, and associates a restriction area
to it. """
import transaction
from sqlalchemy import Column, Table, types, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from geoalchemy2 import Geometry
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import RestrictionArea, LayerWMS
self.__class__._table_index += 1
id = self.__class__._table_index
engine = DBSession.c2c_rw_bind
connection = engine.connect()
if not self.metadata:
self.metadata = declarative_base(bind=engine).metadata
tablename = "geo_table_{0:d}".format(id)
schemaname = "geodata"
table1 = Table(
"{0!s}_child".format(tablename), self.metadata,
Column("id", types.Integer, primary_key=True),
Column("name", types.Unicode),
schema=schemaname
)
self._tables.append(table1)
table2 = Table(
tablename, self.metadata,
Column("id", types.Integer, primary_key=True),
Column("child_id", types.Integer,
ForeignKey("{0!s}.{1!s}_child.id".format(schemaname, tablename))),
Column("name", types.Unicode, nullable=False),
Column("deleted", types.Boolean),
Column("last_update_user", types.Unicode),
Column("last_update_date", types.DateTime),
Column("date", types.Date),
Column("start_time", types.Time),
# Column("interval", Interval()),
Column("short_name1", types.String, nullable=True),
Column("short_name2", types.String(50), nullable=True),
Column("short_number", types.Integer, nullable=True),
Column("double_number", types.Float(precision=4)),
Column("large_binary", types.LargeBinary(length=60), nullable=True),
Column("value", types.Enum("one", "two", "three", name="an_enum_value")),
Column("numeric", types.Numeric(precision=5, scale=2), nullable=True),
Column("numeric2", types.Numeric(), nullable=True),
schema=schemaname
)
if geom_type:
table2.append_column(
Column("geom", Geometry("POINT", srid=21781))
)
else:
table2.append_column(
Column("geom", Geometry(srid=21781))
)
self._tables.append(table2)
table2.drop(checkfirst=True)
table1.drop(checkfirst=True)
table1.create()
table2.create()
ins = table1.insert().values(name="c1é")
connection.execute(ins).inserted_primary_key[0]
ins = table1.insert().values(name="c2é")
connection.execute(ins).inserted_primary_key[0]
layer = LayerWMS(name="test_WMS_1", public=True)
layer.layer = "test_wms"
layer.id = id
layer.geo_table = "{0!s}.{1!s}".format(schemaname, tablename)
layer.interfaces = [self.main]
layer.ogc_server = self.ogc_server
if exclude_properties:
layer.exclude_properties = "name"
if metadatas:
layer.metadatas = metadatas
DBSession.add(self.layer_group_1)
self.layer_group_1.children = self.layer_group_1.children + [layer]
DBSession.add(self.layer_group_1)
ra = RestrictionArea()
ra.name = "__test_ra"
ra.layers = [layer]
ra.roles = [self.role]
ra.readwrite = True
DBSession.add(ra)
transaction.commit()
self.layer_ids.append(id)
return id
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Theme, LayerGroup, Interface, LayerWMS, Metadata
desktop = Interface(name="desktop")
ogc_server_internal, _ = create_default_ogcserver()
layer_wms = LayerWMS(name="__test_layer_internal_wms", public=True)
layer_wms.layer = "__test_layer_internal_wms"
layer_wms.ogc_server = ogc_server_internal
layer_wms.interfaces = [desktop]
layer_wms.metadatas = [
Metadata("string", "string"),
Metadata("list", "1, 2, a"),
Metadata("boolean", "y"),
Metadata("boolean2", "no"),
Metadata("boolean3", "Hello"),
Metadata("integer", "1"),
Metadata("float", "5.5"),
Metadata("json", '{"test": 123}'),
Metadata("json_wrong", '{"test": 123'),
Metadata("date", "Sep 25 2003"),
Metadata("time", "10:36:28"),
Metadata("datetime", "Sep 25 10:36:28 BRST 2003"),
Metadata("date2", "Sep 25 10:36:28 BRST 2003"),
Metadata("time2", "Sep 25 10:36:28 BRST 2003"),
Metadata("datetime2", "Hello"),
Metadata("url1", "http://example.com/hi?a=b#c"),
Metadata("url2", "static:///path/icon.png"),
Metadata("url3", "static://static/path/icon.png"),
Metadata("url4", "static://cgxp/path/icon.png"),
Metadata("url5", "static://project:static/path/icon.png"),
Metadata("url6", "static://project:cgxp/path/icon.png"),
Metadata("url7", "config://server"),
Metadata("url8", "config://server/index.html"),
Metadata("url9", "/dummy/static/icon.png"),
Metadata("url10", "dummy/static/icon.png"),
Metadata("url11", "https:///static/icon.png"),
Metadata("url12", "static://test"),
Metadata("url13", "static://test/"),
Metadata("url14", "config:///static/icon.png"),
Metadata("url15", "config://unknown_server"),
Metadata("url16", "https://"),
Metadata("url17", "https:///"),
Metadata("url18", "https:///static"),
Metadata("url19", ""),
Metadata("url20", "/"),
Metadata("unknown", "Hello"),
]
layer_group = LayerGroup(name="__test_layer_group")
layer_group.children = [layer_wms]
theme = Theme(name="__test_theme")
theme.interfaces = [desktop]
theme.children = [layer_group]
DBSession.add(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_commons.models import DBSession
from c2cgeoportal_commons.models.main import \
Theme, LayerGroup, Interface, LayerWMS, LayerWMTS, Dimension
ogc_server, _ = create_default_ogcserver()
main = Interface(name="main")
layer_wms_1 = LayerWMS(name="__test_layer_wms_1", public=True)
layer_wms_1.layer = "__test_layer_wms_1"
layer_wms_1.interfaces = [main]
layer_wms_1.ogc_server = ogc_server
Dimension("A", "a", layer_wms_1)
layer_wms_2 = LayerWMS(name="__test_layer_wms_2", public=True)
layer_wms_2.layer = "__test_layer_wms_2"
layer_wms_2.interfaces = [main]
layer_wms_2.ogc_server = ogc_server
Dimension("A", "b", layer_wms_2)
layer_wms_3 = LayerWMS(name="__test_layer_wms_3", public=True)
layer_wms_3.layer = "__test_layer_wms_3"
layer_wms_3.interfaces = [main]
layer_wms_3.ogc_server = ogc_server
Dimension("A", None, layer_wms_3)
layer_wms_4 = LayerWMS(name="__test_layer_wms_4", public=True)
layer_wms_4.layer = "__test_layer_wms_4"
layer_wms_4.interfaces = [main]
layer_wms_4.ogc_server = ogc_server
Dimension("A", "a", layer_wms_4)
layer_wms_5 = LayerWMS(name="__test_layer_wms_5", public=True)
layer_wms_5.layer = "__test_layer_wms_5"
layer_wms_5.interfaces = [main]
layer_wms_5.ogc_server = ogc_server
Dimension("B", "b", layer_wms_5)
layer_wms_6 = LayerWMS(name="__test_layer_wms_6", public=True)
layer_wms_6.layer = "__test_layer_wms_6"
layer_wms_6.interfaces = [main]
layer_wms_6.ogc_server = ogc_server
Dimension("FILTER", "countries:\"name\" IN ( 'Germany' , 'Italy' )", layer_wms_6)
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]
Dimension("B", "b", layer_wmts)
layer_wmts_2 = LayerWMTS(name="__test_layer_wmts_2", public=True)
layer_wmts_2.url = "http://example.com/1.0.0/WMTSCapabilities.xml"
layer_wmts_2.layer = "map"
layer_wmts_2.interfaces = [main]
Dimension("FILTER", "countries:\"name\" IN ( 'Germany' , 'Italy' )", layer_wmts_2)
layer_group_1 = LayerGroup(name="__test_layer_group_1")
layer_group_1.children = [layer_wms_1, layer_wmts, layer_wmts_2]
layer_group_2 = LayerGroup(name="__test_layer_group_2")
layer_group_2.children = [layer_wms_1, layer_wms_2]
layer_group_3 = LayerGroup(name="__test_layer_group_3")
layer_group_3.children = [layer_wms_1, layer_wms_3]
layer_group_4 = LayerGroup(name="__test_layer_group_4")
layer_group_4.children = [layer_wms_1, layer_wms_4]
layer_group_5 = LayerGroup(name="__test_layer_group_5")
layer_group_5.children = [layer_wms_1, layer_wms_5, layer_wms_6]
layer_group_6 = LayerGroup(name="__test_layer_group_6")
layer_group_6.children = [layer_wms_3]
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,
]
DBSession.add(theme)
transaction.commit()
def test_data(dbsession):
from c2cgeoportal_commons.models.main import (
LayerWMS,
OGCServer,
OGCSERVER_TYPE_QGISSERVER,
OGCSERVER_AUTH_STANDARD,
RestrictionArea,
Role,
)
from c2cgeoportal_commons.models.static import User
ogc_server1 = OGCServer(name='qgisserver1',
type_=OGCSERVER_TYPE_QGISSERVER,
image_type='image/png',
auth=OGCSERVER_AUTH_STANDARD)
ogc_server2 = OGCServer(name='qgisserver2',
type_=OGCSERVER_TYPE_QGISSERVER,
image_type='image/png',
auth=OGCSERVER_AUTH_STANDARD)
ogc_servers = {
ogc_server.name: ogc_server
for ogc_server in (ogc_server1, ogc_server2)
}
dbsession.add_all(ogc_servers.values())
role1 = Role('role1')
role2 = Role('role2')
roles = {role.name: role for role in (role1, role2)}
dbsession.add_all(roles.values())
user1 = User('user1', roles=[role1])
user2 = User('user12', roles=[role1, role2])
users = {user.username: user for user in (user1, user2)}
dbsession.add_all(users.values())
project = QgsProject.instance()
def add_node(parent_node, node_def):
if node_def['type'] == 'layer':
vlayer = QgsVectorLayer("Point", node_def['name'], 'memory')
project.addMapLayer(vlayer)
node = project.layerTreeRoot().findLayer(vlayer)
clone = node.clone()
parent_node.addChildNode(clone)
node.parent().takeChild(node)
if node_def['type'] == 'group':
node = parent_node.addGroup(node_def['name'])
for child_def in node_def['children']:
add_node(node, child_def)
for node in [{
'name':
'root',
'type':
'group',
'children': [
{
'name': 'public_group',
'type': 'group',
'children': [{
'name': 'public_layer',
'type': 'layer'
}]
},
{
'name': 'private_group1',
'type': 'group',
'children': [{
'name': 'private_layer1',
'type': 'layer'
}]
},
{
'name': 'private_group2',
'type': 'group',
'children': [{
'name': 'private_layer2',
'type': 'layer'
}]
},
]
}]:
add_node(project.layerTreeRoot(), node)
public_group = LayerWMS(name='public_group',
layer='public_group',
public=True)
public_group.ogc_server = ogc_server1
public_layer = LayerWMS(name='public_layer',
layer='public_layer',
public=True)
public_layer.ogc_server = ogc_server1
private_layer1 = LayerWMS(name='private_layer1',
layer='private_layer1',
public=False)
private_layer1.ogc_server = ogc_server1
private_layer2 = LayerWMS(name='private_layer2',
layer='private_layer2',
public=False)
private_layer2.ogc_server = ogc_server1
layers = {
layer.name: layer
for layer in (public_group, public_layer, private_layer1,
private_layer2)
}
dbsession.add_all(layers.values())
ra1 = RestrictionArea('restriction_area1',
layers=[private_layer1],
roles=[role1],
area=from_shape(area1, srid=21781))
ra2 = RestrictionArea('restriction_area2',
layers=[private_layer2],
roles=[role2],
readwrite=True)
restriction_areas = {ra.name: ra for ra in (ra1, ra2)}
dbsession.add_all(restriction_areas.values())
t = dbsession.begin_nested()
dbsession.flush()
yield {
'ogc_servers': ogc_servers,
'roles': roles,
'users': users,
'layers': layers,
'restriction_areas': restriction_areas,
}
t.rollback()
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
self._tables = []
from c2cgeoportal_geoportal.lib import functionality
functionality.FUNCTIONALITIES_TYPES = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, \
RestrictionArea, TreeItem, Theme, LayerGroup, Interface, LayerWMS
from c2cgeoportal_commons.models.static import User
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 = create_default_ogcserver()
role1 = Role(name="__test_role1")
role1.id = 999
user1 = User(username="******", password="******", settings_role=role1, roles=[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="******", settings_role=role2, roles=[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()
def theme_test_data(dbsession):
from c2cgeoportal_commons.models.main import \
Theme, Role, Functionality, LayergroupTreeitem, \
Interface, Metadata, LayerGroup, LayerWMS, OGCServer
dbsession.begin_nested()
interfaces = [Interface(name) for name in ['desktop', 'mobile', 'edit', 'routing']]
groups = [LayerGroup(name='layer_group_{}'.format(i)) for i in range(0, 5)]
layer = LayerWMS(name='layer_wms')
layer.ogc_server = OGCServer(name='server')
dbsession.add(layer)
layers = [layer]
functionalities = [Functionality(name=name, value='value_{}'.format(v))
for name in ('default_basemap', 'location') for v in range(0, 4)]
roles = [Role('secretary_' + str(i)) for i in range(0, 4)]
metadatas_protos = [('copyable', 'true'),
('disclaimer', '© le momo'),
('snappingConfig', '{"tolerance": 50}')]
themes = []
for i in range(0, 25):
theme = Theme(name='theme_{}'.format(i),
ordering=1,
icon='icon_{}'.format(i))
theme.public = 1 == i % 2
theme.interfaces = [interfaces[i % 4],
interfaces[(i + 2) % 4]]
theme.metadatas = [Metadata(name=metadatas_protos[id][0],
value=metadatas_protos[id][1])
for id in [i % 3, (i + 2) % 3]]
for metadata in theme.metadatas:
metadata.item = theme
theme.functionalities = [functionalities[i % 8], functionalities[(i + 3) % 8]]
theme.restricted_roles = [roles[i % 4], roles[(i + 2) % 4]]
dbsession.add(LayergroupTreeitem(group=theme,
item=groups[i % 5],
ordering=len(groups[i % 5].children_relation)))
dbsession.add(LayergroupTreeitem(group=theme,
item=groups[(i + 3) % 5],
ordering=len(groups[(i + 3) % 5].children_relation)))
dbsession.add(theme)
themes.append(theme)
dbsession.flush()
yield {
'themes': themes,
'interfaces': interfaces,
'groups': groups,
'layers': layers,
'functionalities': functionalities,
'roles': roles,
}
dbsession.rollback()
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Interface, LayerGroup, LayerWMS, Theme
main = Interface(name="desktop")
ogc_server = create_default_ogcserver()
layer_wms_1 = LayerWMS(name="__test_layer_wms_1", public=True)
layer_wms_1.layer = "testpoint_unprotected"
layer_wms_1.interfaces = [main]
layer_wms_1.ogc_server = ogc_server
layer_wms_2 = LayerWMS(name="__test_layer_wms_2", public=True)
layer_wms_2.layer = "testpoint_substitution"
layer_wms_2.interfaces = [main]
layer_wms_2.ogc_server = ogc_server
layer_wms_3 = LayerWMS(name="__test_layer_wms_3", public=True)
layer_wms_3.layer = "testpoint_unprotected,testpoint_substitution"
layer_wms_3.interfaces = [main]
layer_wms_3.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_wms_3]
theme = Theme(name="__test_theme")
theme.interfaces = [main]
theme.children = [layer_group_1, layer_group_2]
DBSession.add(theme)
transaction.commit()
def layer_v1tov2(session, layer):
from c2cgeoportal_commons.models.main import OGCServer, LayerWMS, LayerWMTS, \
LayergroupTreeitem, Dimension
if layer.layer_type in ["internal WMS", "external WMS"]:
# use the first one
new_layer = LayerWMS()
is_single_tile = layer.is_single_tile
if is_single_tile is None:
is_single_tile = False
image_type = "image/png"
if layer.layer_type == "internal WMS":
url = "config://internal/mapserv"
else:
if layer.image_type is not None:
image_type = layer.image_type
url = layer.url
ogc_server = session.query(OGCServer).filter(
OGCServer.url == url, OGCServer.image_type == image_type,
OGCServer.is_single_tile == is_single_tile).one()
new_layer.ogc_server = ogc_server
new_layer.layer = layer.layer
new_layer.style = layer.style
new_layer.time_mode = layer.time_mode
new_layer.time_widget = layer.time_widget
elif layer.layer_type == "WMTS":
new_layer = LayerWMTS()
new_layer.url = layer.url
new_layer.layer = layer.layer
new_layer.style = layer.style
new_layer.matrix_set = layer.matrix_set
new_layer.image_type = layer.image_type or "image/png"
if layer.dimensions is not None:
dimensions = loads(layer.dimensions)
for name, value in list(dimensions.items()):
session.add(Dimension(name, value, new_layer))
new_layer.name = layer.name
new_layer.public = layer.public
new_layer.geo_table = layer.geo_table
new_layer.interfaces = layer.interfaces
new_layer.restrictionareas = layer.restrictionareas
for link in layer.parents_relation:
new_link = LayergroupTreeitem()
new_link.ordering = link.ordering
new_link.description = link.description
new_link.treegroup = link.treegroup
new_link.treeitem = new_layer
layer_add_metadata(layer, new_layer, session)
session.add(new_layer)
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import \
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 layertree_test_data(dbsession):
from c2cgeoportal_commons.models.main import \
LayerGroup, LayergroupTreeitem, LayerV1, LayerWMS, LayerWMTS, OGCServer, Theme
dbsession.begin_nested()
layers_v1 = []
for i in range(0, 10):
layer_v1 = LayerV1(name='layer_v1_{}'.format(i))
layers_v1.append(layer_v1)
dbsession.add(layer_v1)
layers_wms = []
ogc_server = OGCServer(name='ogc_server')
dbsession.add(ogc_server)
for i in range(0, 10):
layer_wms = LayerWMS(name='layer_wms_{}'.format(i))
layer_wms.ogc_server = ogc_server
layers_wms.append(layer_wms)
dbsession.add(layer_wms)
layers_wmts = []
for i in range(0, 10):
layer_wmts = LayerWMTS(name='layer_wmts_{}'.format(i))
layer_wmts.url = 'http://localhost/wmts'
layer_wmts.layer = layer_wmts.name
layers_wmts.append(layer_wmts)
dbsession.add(layer_wmts)
groups = []
for i in range(0, 10):
group = LayerGroup(name='layer_group_{}'.format(i))
groups.append(group)
dbsession.add(group)
for j, items in enumerate((layers_v1, layers_wms, layers_wmts)):
dbsession.add(LayergroupTreeitem(group=group, item=items[i], ordering=j))
# a group in a group
dbsession.add(LayergroupTreeitem(group=groups[9], item=groups[8], ordering=3))
themes = []
for i in range(0, 5):
theme = Theme(name='theme_{}'.format(i))
themes.append(theme)
dbsession.add(theme)
dbsession.add(LayergroupTreeitem(group=theme, item=groups[i], ordering=0))
dbsession.add(LayergroupTreeitem(group=theme, item=groups[i + 5], ordering=1))
themes[0].ordering = 1
themes[3].ordering = 2
themes[1].ordering = 3
themes[2].ordering = 4
themes[4].ordering = 5
dbsession.flush()
yield({
'themes': themes,
'groups': groups,
'layers_v1': layers_v1,
'layers_wms': layers_wms,
'layers_wmts': layers_wmts,
})
dbsession.rollback()
def setup_method(self, _):
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import 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 layer_v1tov2(session, layer):
from c2cgeoportal_commons.models.main import OGCServer, LayerWMS, LayerWMTS, \
LayergroupTreeitem, Dimension
if layer.layer_type in ["internal WMS", "external WMS"]:
# use the first one
new_layer = LayerWMS()
is_single_tile = layer.is_single_tile
if is_single_tile is None:
is_single_tile = False
image_type = "image/png"
if layer.layer_type == "internal WMS":
url = "config://internal/mapserv"
else:
if layer.image_type is not None:
image_type = layer.image_type
url = layer.url
ogc_server = session.query(OGCServer).filter(
OGCServer.url == url,
OGCServer.image_type == image_type,
OGCServer.is_single_tile == is_single_tile
).one()
new_layer.ogc_server = ogc_server
new_layer.layer = layer.layer
new_layer.style = layer.style
new_layer.time_mode = layer.time_mode
new_layer.time_widget = layer.time_widget
elif layer.layer_type == "WMTS":
new_layer = LayerWMTS()
new_layer.url = layer.url
new_layer.layer = layer.layer
new_layer.style = layer.style
new_layer.matrix_set = layer.matrix_set
new_layer.image_type = layer.image_type or "image/png"
if layer.dimensions is not None:
dimensions = loads(layer.dimensions)
for name, value in list(dimensions.items()):
session.add(Dimension(name, value, new_layer))
new_layer.name = layer.name
new_layer.public = layer.public
new_layer.geo_table = layer.geo_table
new_layer.interfaces = layer.interfaces
new_layer.restrictionareas = layer.restrictionareas
for link in layer.parents_relation:
new_link = LayergroupTreeitem()
new_link.ordering = link.ordering
new_link.description = link.description
new_link.treegroup = link.treegroup
new_link.treeitem = new_layer
layer_add_metadata(layer, new_layer, session)
session.add(new_layer)
def setUp(self): # noqa
# Always see the diff
# https://docs.python.org/2/library/unittest.html#unittest.TestCase.maxDiff
self.maxDiff = None
self.clean()
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.static import User
from c2cgeoportal_commons.models.main import \
Theme, LayerGroup, Interface, LayerWMS, LayerWMTS, Role, RestrictionArea
main = Interface(name=u"desktop")
role = Role(name=u"__test_role")
user = User(username=u"__test_user",
password=u"__test_user",
role=role)
user.email = "*****@*****.**"
ogc_server_internal, _ = create_default_ogcserver()
layer_wms = LayerWMS(name=u"__test_layer_wms", public=True)
layer_wms.layer = "__test_public_layer"
layer_wms.interfaces = [main]
layer_wms.ogc_server = ogc_server_internal
layer_wms_private = LayerWMS(name=u"__test_layer_wms_private",
public=True)
layer_wms_private.layer = "__test_private_layer"
layer_wms_private.public = False
layer_wms_private.interfaces = [main]
layer_wms_private.ogc_server = ogc_server_internal
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]
layer_wmts_private = LayerWMTS(name=u"__test_layer_wmts_private",
public=True)
layer_wmts_private.url = "http://example.com/1.0.0/WMTSCapabilities.xml"
layer_wmts_private.layer = "map"
layer_wmts_private.public = False
layer_wmts_private.interfaces = [main]
layer_group = LayerGroup(name=u"__test_layer_group")
layer_group.children = [
layer_wms, layer_wms_private, layer_wmts, layer_wmts_private
]
theme = Theme(name=u"__test_theme")
theme.interfaces = [main]
theme.children = [layer_group]
restriction_area = RestrictionArea(
name=u"__test_ra1",
layers=[layer_wms_private, layer_wmts_private],
roles=[role])
DBSession.add_all([theme, restriction_area, user])
transaction.commit()
def theme_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import (
Functionality,
Interface,
LayerGroup,
LayergroupTreeitem,
LayerWMS,
Metadata,
OGCServer,
Role,
Theme,
)
interfaces = [
Interface(name) for name in ["desktop", "mobile", "edit", "routing"]
]
groups = [LayerGroup(name="layer_group_{}".format(i)) for i in range(0, 5)]
layer = LayerWMS(name="layer_wms")
layer.ogc_server = OGCServer(name="server")
dbsession.add(layer)
layers = [layer]
functionalities = [
Functionality(name=name, value="value_{}".format(v))
for name in ("default_basemap", "location") for v in range(0, 4)
]
roles = [Role("secretary_" + str(i)) for i in range(0, 4)]
metadatas_protos = [
("copyable", "true"),
("disclaimer", "© le momo"),
("snappingConfig", '{"tolerance": 50}'),
]
themes = []
for i in range(0, 25):
theme = Theme(name="theme_{}".format(i),
ordering=1,
icon="icon_{}".format(i))
theme.public = 1 == i % 2
theme.interfaces = [interfaces[i % 4], interfaces[(i + 2) % 4]]
theme.metadatas = [
Metadata(name=metadatas_protos[id][0],
value=metadatas_protos[id][1])
for id in [i % 3, (i + 2) % 3]
]
for metadata in theme.metadatas:
metadata.item = theme
theme.functionalities = [
functionalities[i % 8], functionalities[(i + 3) % 8]
]
theme.restricted_roles = [roles[i % 4], roles[(i + 2) % 4]]
dbsession.add(
LayergroupTreeitem(group=theme,
item=groups[i % 5],
ordering=len(groups[i % 5].children_relation)))
dbsession.add(
LayergroupTreeitem(group=theme,
item=groups[(i + 3) % 5],
ordering=len(groups[(i + 3) %
5].children_relation)))
dbsession.add(theme)
themes.append(theme)
dbsession.flush()
yield {
"themes": themes,
"interfaces": interfaces,
"groups": groups,
"layers": layers,
"functionalities": functionalities,
"roles": roles,
}
def _create_layer(
self,
public=False,
none_area=False,
attr_list=False,
exclude_properties=False,
metadatas=None,
geom_type=False,
):
"""This function is central for this test class. It creates
a layer with two features, and associates a restriction area
to it."""
import transaction
from geoalchemy2 import Geometry, WKTElement
from sqlalchemy import CheckConstraint, Column, ForeignKey, Table, types
from sqlalchemy.ext.declarative import declarative_base
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import LayerWMS, OGCServer, RestrictionArea
if self._tables is None:
self._tables = []
self.__class__._table_index += 1
id = self.__class__._table_index
engine = DBSession.c2c_rw_bind
connection = engine.connect()
if not self.metadata:
self.metadata = declarative_base(bind=engine).metadata
tablename = "table_{0:d}".format(id)
table1 = Table(
"{0!s}_child".format(tablename),
self.metadata,
Column("id", types.Integer, primary_key=True),
Column("name", types.Unicode),
schema="public",
)
if geom_type:
table1.append_column(Column("geom", Geometry("POINT", srid=21781)))
else:
table1.append_column(Column("geom", Geometry(srid=21781)))
self._tables.append(table1)
table2 = Table(
tablename,
self.metadata,
Column("id", types.Integer, primary_key=True),
Column("child_id", types.Integer,
ForeignKey("public.{0!s}_child.id".format(tablename))),
Column("name", types.Unicode),
Column(
"email",
types.Unicode,
CheckConstraint(
"""email ~* '^[A-Za-z0-9._%%-]
+@[A-Za-z0-9.-]+[.][A-Za-z]+$'""",
name="proper_email",
),
),
Column("last_update_user", types.Unicode),
Column("last_update_date", types.DateTime),
schema="public",
)
if geom_type:
table2.append_column(Column("geom", Geometry("POINT", srid=21781)))
else:
table2.append_column(Column("geom", Geometry(srid=21781)))
self._tables.append(table2)
table1.drop(checkfirst=True)
table2.drop(checkfirst=True)
table1.create()
table2.create()
ins = table1.insert().values(name="c1é")
c1_id = connection.execute(ins).inserted_primary_key[0]
ins = table1.insert().values(name="c2é")
c2_id = connection.execute(ins).inserted_primary_key[0]
ins = table2.insert().values(child_id=c1_id,
name="foo",
geom=WKTElement("POINT(5 45)", 21781))
connection.execute(ins)
ins = table2.insert().values(child_id=c2_id,
name="bar",
geom=WKTElement("POINT(6 46)", 21781))
connection.execute(ins)
if attr_list:
ins = table2.insert().values(child_id=c2_id,
name="aaa,bbb,foo",
geom=WKTElement("POINT(6 46)", 21781))
connection.execute(ins)
ogc_server = DBSession.query(OGCServer).filter(
OGCServer.name == "__test_ogc_server").one()
layer = LayerWMS()
layer.id = id
layer.name = str(id)
layer.ogc_server = ogc_server
layer.geo_table = tablename
layer.public = public
layer.interface = [self.main]
if exclude_properties:
layer.exclude_properties = "name"
if metadatas:
layer.metadatas = metadatas
DBSession.add(layer)
if not public:
ra = RestrictionArea()
ra.name = "__test_ra"
ra.layers = [layer]
ra.roles = [self.role]
ra.readwrite = True
if not none_area:
poly = "POLYGON((4 44, 4 46, 6 46, 6 44, 4 44))"
ra.area = WKTElement(poly, srid=21781)
DBSession.add(ra)
transaction.commit()
self.layer_ids.append(id)
return id
def setup_method(self, _):
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, LayerWMS, RestrictionArea, Interface, \
OGCServer, OGCSERVER_TYPE_MAPSERVER, OGCSERVER_AUTH_STANDARD
from c2cgeoportal_commons.models.static import User
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
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import (
Dimension,
Interface,
LayerGroup,
LayerWMS,
LayerWMTS,
Theme,
)
ogc_server = create_default_ogcserver()
main = Interface(name="main")
layer_wms_1 = LayerWMS(name="__test_layer_wms_1", public=True)
layer_wms_1.layer = "testpoint_unprotected"
layer_wms_1.interfaces = [main]
layer_wms_1.ogc_server = ogc_server
Dimension("A", "a", layer_wms_1)
layer_wms_2 = LayerWMS(name="__test_layer_wms_2", public=True)
layer_wms_2.layer = "testpoint_unprotected"
layer_wms_2.interfaces = [main]
layer_wms_2.ogc_server = ogc_server
Dimension("A", "b", layer_wms_2)
layer_wms_3 = LayerWMS(name="__test_layer_wms_3", public=True)
layer_wms_3.layer = "testpoint_unprotected"
layer_wms_3.interfaces = [main]
layer_wms_3.ogc_server = ogc_server
Dimension("A", None, layer_wms_3)
layer_wms_4 = LayerWMS(name="__test_layer_wms_4", public=True)
layer_wms_4.layer = "testpoint_unprotected"
layer_wms_4.interfaces = [main]
layer_wms_4.ogc_server = ogc_server
Dimension("A", "a", layer_wms_4)
layer_wms_5 = LayerWMS(name="__test_layer_wms_5", public=True)
layer_wms_5.layer = "testpoint_unprotected"
layer_wms_5.interfaces = [main]
layer_wms_5.ogc_server = ogc_server
Dimension("B", "b", layer_wms_5)
layer_wms_6 = LayerWMS(name="__test_layer_wms_6", public=True)
layer_wms_6.layer = "testpoint_unprotected"
layer_wms_6.interfaces = [main]
layer_wms_6.ogc_server = ogc_server
Dimension("FILTER", "countries:\"name\" IN ( 'Germany' , 'Italy' )",
layer_wms_6)
layer_wms_7 = LayerWMS(name="__test_layer_wms_7", public=True)
layer_wms_7.layer = "testpoint_unprotected"
layer_wms_7.interfaces = [main]
layer_wms_7.ogc_server = ogc_server
Dimension("FLOOR", None, layer_wms_7, "floor")
layer_wmts = LayerWMTS(name="__test_layer_wmts", public=True)
layer_wmts.url = "http://tilecloudchain/1.0.0/WMTSCapabilities.xml"
layer_wmts.layer = "map"
layer_wmts.interfaces = [main]
Dimension("B", "b", layer_wmts)
layer_wmts_2 = LayerWMTS(name="__test_layer_wmts_2", public=True)
layer_wmts_2.url = "http://tilecloudchain/1.0.0/WMTSCapabilities.xml"
layer_wmts_2.layer = "map"
layer_wmts_2.interfaces = [main]
Dimension("FILTER", "countries:\"name\" IN ( 'Germany' , 'Italy' )",
layer_wmts_2)
layer_group_1 = LayerGroup(name="__test_layer_group_1")
layer_group_1.children = [layer_wms_1, layer_wmts, layer_wmts_2]
layer_group_2 = LayerGroup(name="__test_layer_group_2")
layer_group_2.children = [layer_wms_1, layer_wms_2]
layer_group_3 = LayerGroup(name="__test_layer_group_3")
layer_group_3.children = [layer_wms_1, layer_wms_3]
layer_group_4 = LayerGroup(name="__test_layer_group_4")
layer_group_4.children = [layer_wms_1, layer_wms_4]
layer_group_5 = LayerGroup(name="__test_layer_group_5")
layer_group_5.children = [layer_wms_1, layer_wms_5, layer_wms_6]
layer_group_6 = LayerGroup(name="__test_layer_group_6")
layer_group_6.children = [layer_wms_3]
layer_group_7 = LayerGroup(name="__test_layer_group_7")
layer_group_7.children = [layer_wms_7]
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(theme)
transaction.commit()
def theme_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import \
Theme, Role, Functionality, LayergroupTreeitem, \
Interface, Metadata, LayerGroup, LayerWMS, OGCServer
interfaces = [
Interface(name) for name in ['desktop', 'mobile', 'edit', 'routing']
]
groups = [LayerGroup(name='layer_group_{}'.format(i)) for i in range(0, 5)]
layer = LayerWMS(name='layer_wms')
layer.ogc_server = OGCServer(name='server')
dbsession.add(layer)
layers = [layer]
functionalities = [
Functionality(name=name, value='value_{}'.format(v))
for name in ('default_basemap', 'location') for v in range(0, 4)
]
roles = [Role('secretary_' + str(i)) for i in range(0, 4)]
metadatas_protos = [('copyable', 'true'), ('disclaimer', '© le momo'),
('snappingConfig', '{"tolerance": 50}')]
themes = []
for i in range(0, 25):
theme = Theme(name='theme_{}'.format(i),
ordering=1,
icon='icon_{}'.format(i))
theme.public = 1 == i % 2
theme.interfaces = [interfaces[i % 4], interfaces[(i + 2) % 4]]
theme.metadatas = [
Metadata(name=metadatas_protos[id][0],
value=metadatas_protos[id][1])
for id in [i % 3, (i + 2) % 3]
]
for metadata in theme.metadatas:
metadata.item = theme
theme.functionalities = [
functionalities[i % 8], functionalities[(i + 3) % 8]
]
theme.restricted_roles = [roles[i % 4], roles[(i + 2) % 4]]
dbsession.add(
LayergroupTreeitem(group=theme,
item=groups[i % 5],
ordering=len(groups[i % 5].children_relation)))
dbsession.add(
LayergroupTreeitem(group=theme,
item=groups[(i + 3) % 5],
ordering=len(groups[(i + 3) %
5].children_relation)))
dbsession.add(theme)
themes.append(theme)
dbsession.flush()
yield {
'themes': themes,
'interfaces': interfaces,
'groups': groups,
'layers': layers,
'functionalities': functionalities,
'roles': roles,
}
def setup_method(self, _):
self.maxDiff = None
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Role, LayerWMS, RestrictionArea, Interface, \
OGCServer, OGCSERVER_TYPE_MAPSERVER, OGCSERVER_AUTH_STANDARD
from c2cgeoportal_commons.models.static import User
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
from c2cgeoportal_commons.models import DBSession
from c2cgeoportal_commons.models.main import Theme, LayerGroup, Interface, OGCServer, LayerWMS, LayerWMTS
main = Interface(name="main")
ogc_server_internal, _ = create_default_ogcserver()
ogc_server_external = OGCServer(name="__test_ogc_server_external", url="http://wms.geo.admin.ch/", image_type="image/jpeg")
layer_internal_wms = LayerWMS(name="__test_layer_internal_wms", public=True)
layer_internal_wms.layer = "__test_layer_internal_wms"
layer_internal_wms.interfaces = [main]
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.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]
layer_group_1 = LayerGroup(name="__test_layer_group_1")
layer_group_1.children = [layer_internal_wms]
layer_group_2 = LayerGroup(name="__test_layer_group_2")
layer_group_2.children = [layer_external_wms]
layer_group_3 = LayerGroup(name="__test_layer_group_3")
layer_group_3.children = [layer_wmts]
layer_group_4 = LayerGroup(name="__test_layer_group_4")
layer_group_4.children = [layer_group_1, layer_group_2]
layer_group_5 = LayerGroup(name="__test_layer_group_5")
layer_group_5.children = [layer_group_1, layer_group_3]
layer_group_6 = LayerGroup(name="__test_layer_group_6")
layer_group_6.children = [layer_internal_wms]
layer_group_7 = LayerGroup(name="__test_layer_group_7")
layer_group_7.children = [layer_group_1, layer_group_6]
layer_group_8 = LayerGroup(name="__test_layer_group_8")
layer_group_8.children = [layer_group_2, layer_group_6]
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_7, layer_group_8,
]
DBSession.add(theme)
transaction.commit()
