def roles_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import Role, Functionality, RestrictionArea
from c2cgeoportal_commons.models.static import User
functionalities = {}
for name in ('default_basemap', 'location'):
functionalities[name] = []
for v in range(0, 4):
functionality = Functionality(
name=name,
value='value_{}'.format(v))
dbsession.add(functionality)
functionalities[name].append(functionality)
restrictionareas = []
for i in range(0, 5):
restrictionarea = RestrictionArea(
name='restrictionarea_{}'.format(i))
dbsession.add(restrictionarea)
restrictionareas.append(restrictionarea)
roles = []
for i in range(0, 23):
role = Role('secretary_' + str(i))
role.functionalities = [
functionalities['default_basemap'][0],
functionalities['location'][0],
functionalities['location'][1]]
role.restrictionareas = [
restrictionareas[0],
restrictionareas[1]]
role.extent = from_shape(box(485869.5728, 76443.1884, 837076.5648, 299941.7864),
srid=21781)
dbsession.add(role)
roles.append(role)
# Users roles must not be broken with role name changes
users = []
for i in range(0, 23):
user = User("babar_" + str(i),
email='mail' + str(i),
settings_role=roles[i],
roles=[roles[i]])
user.password = '******'
user.is_password_changed = i % 2 == 1
users.append(user)
dbsession.add(user)
dbsession.flush()
yield {
'functionalities': functionalities,
'restrictionareas': restrictionareas,
'users': users,
'roles': roles
}
def roles_test_data(dbsession, transact):
del transact
from c2cgeoportal_commons.models.main import Functionality, RestrictionArea, Role
from c2cgeoportal_commons.models.static import User
# Note that "default_basemap" is not relevant for roles
functionalities = {}
for name in ("default_basemap", "default_theme", "print_template"):
functionalities[name] = []
for v in range(0, 4):
functionality = Functionality(name=name, value=f"value_{v}")
dbsession.add(functionality)
functionalities[name].append(functionality)
restrictionareas = []
for i in range(0, 5):
restrictionarea = RestrictionArea(name=f"restrictionarea_{i}")
dbsession.add(restrictionarea)
restrictionareas.append(restrictionarea)
roles = []
for i in range(0, 23):
role = Role("secretary_" + str(i))
role.functionalities = [
functionalities["default_theme"][0],
functionalities["print_template"][0],
functionalities["print_template"][1],
]
role.restrictionareas = [restrictionareas[0], restrictionareas[1]]
role.extent = from_shape(box(485869.5728, 76443.1884, 837076.5648,
299941.7864),
srid=21781)
dbsession.add(role)
roles.append(role)
# Users roles must not be broken with role name changes
users = []
for i in range(0, 23):
user = User("babar_" + str(i),
email="mail" + str(i),
settings_role=roles[i],
roles=[roles[i]])
user.password = "******"
user.is_password_changed = i % 2 == 1
users.append(user)
dbsession.add(user)
dbsession.flush()
yield {
"functionalities": functionalities,
"restrictionareas": restrictionareas,
"users": users,
"roles": roles,
}
def roles_test_data(dbsession):
from c2cgeoportal_commons.models.main import Role, Functionality, RestrictionArea
dbsession.begin_nested()
functionalities = {}
for name in ('default_basemap', 'location'):
functionalities[name] = []
for v in range(0, 4):
functionality = Functionality(
name=name,
value='value_{}'.format(v))
dbsession.add(functionality)
functionalities[name].append(functionality)
restrictionareas = []
for i in range(0, 5):
restrictionarea = RestrictionArea(
name='restrictionarea_{}'.format(i))
dbsession.add(restrictionarea)
restrictionareas.append(restrictionarea)
roles = []
for i in range(0, 23):
role = Role('secretary_' + str(i))
role.functionalities = [
functionalities['default_basemap'][0],
functionalities['location'][0],
functionalities['location'][1]]
role.restrictionareas = [
restrictionareas[0],
restrictionareas[1]]
role.extent = from_shape(box(485869.5728, 76443.1884, 837076.5648, 299941.7864),
srid=21781)
dbsession.add(role)
roles.append(role)
dbsession.flush()
yield {
'functionalities': functionalities,
'restrictionareas': restrictionareas,
'roles': roles
}
dbsession.rollback()