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, Metadata, Theme
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 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 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 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 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 _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, _):
# 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 _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, Functionality, Interface, OGCServer, LayerWMS, LayerWMTS, \
Metadata, Dimension, OGCSERVER_AUTH_NOAUTH
main = Interface(name="desktop")
mobile = Interface(name="mobile")
min_levels = Interface(name="min_levels")
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_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_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, 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 _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 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()
