def setUp(self):
from c2cgeoportal.models import User, Role, Layer, RestrictionArea, \
Functionality, DBSession
TestPoint.__table__.create(bind=DBSession.bind, checkfirst=True)
geom = WKTSpatialElement("MULTIPOINT((-90 -45))", srid=21781)
p1 = TestPoint(the_geom=geom, name=u'foo', city=u'Lausanne', country=u'Swiss')
geom = WKTSpatialElement("MULTIPOINT((-90 45))", srid=21781)
p2 = TestPoint(the_geom=geom, name=u'bar', city=u'Chambéry', country=u'France')
geom = WKTSpatialElement("MULTIPOINT((90 45))", srid=21781)
p3 = TestPoint(the_geom=geom, name=u'éàè', city="Paris", country=u'France')
geom = WKTSpatialElement("MULTIPOINT((90 -45))", srid=21781)
p4 = TestPoint(the_geom=geom, name=u'123', city='Londre', country=u'UK')
pt1 = Functionality(name=u'print_template', value=u'1 Wohlen A4 portrait')
pt2 = Functionality(name=u'print_template', value=u'2 Wohlen A3 landscape')
user1 = User(username=u'__test_user1', password=u'__test_user1')
role1 = Role(name=u'__test_role1', description=u'__test_role1', functionalities=[pt1, pt2])
user1.role = role1
user1.email = u'Tarenpion'
user2 = User(username=u'__test_user2', password=u'__test_user2')
role2 = Role(name=u'__test_role2', description=u'__test_role2', functionalities=[pt1, pt2])
user2.role = role2
user2.email = u'Tarenpion'
user3 = User(username=u'__test_user3', password=u'__test_user3')
role3 = Role(name=u'__test_role3', description=u'__test_role3', functionalities=[pt1, pt2])
user3.role = role3
user3.email = u'Tarenpion'
layer2 = Layer(u'testpoint_protected', 400, public=False)
layer3 = Layer(u'testpoint_protected_query_with_collect', public=False)
area = "POLYGON((-100 30, -100 50, 100 50, 100 30, -100 30))"
area = WKTSpatialElement(area, srid=21781)
restricted_area1 = RestrictionArea(u'__test_ra1', u'', [layer2, layer3], [role1], area)
area = "POLYGON((-100 0, -100 20, 100 20, 100 0, -100 0))"
area = WKTSpatialElement(area, srid=21781)
restricted_area2 = RestrictionArea(u'__test_ra2', u'', [layer2, layer3], [role2, role3], area)
area = "POLYGON((-95 43, -95 47, 95 47, 95 43, -95 43))"
area = WKTSpatialElement(area, srid=21781)
restricted_area3 = RestrictionArea(u'__test_ra3', u'', [layer3], [role3], area, readwrite=True)
DBSession.add_all([
p1, p2, p3, p4, user1, user2, user3,
restricted_area1, restricted_area2, restricted_area3
])
DBSession.flush()
self.id_lausanne = p1.id
self.id_paris = p3.id
transaction.commit()
def setUp(self):
import transaction
from sqlalchemy import func
from geoalchemy import WKTSpatialElement
from c2cgeoportal.models import FullTextSearch, User, Role
from c2cgeoportal.models import DBSession
user1 = User(username=u'__test_user1', password=u'__test_user1')
role1 = Role(name=u'__test_role1', description=u'__test_role1')
user1.role = role1
user2 = User(username=u'__test_user2', password=u'__test_user2')
role2 = Role(name=u'__test_role2', description=u'__test_role2')
user2.role = role2
entry1 = FullTextSearch()
entry1.label = 'label1'
entry1.layer_name = 'layer1'
entry1.ts = func.to_tsvector('french', 'soleil travail')
entry1.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry1.public = True
entry2 = FullTextSearch()
entry2.label = 'label2'
entry2.layer_name = 'layer2'
entry2.ts = func.to_tsvector('french', 'pluie semaine')
entry2.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry2.public = False
entry3 = FullTextSearch()
entry3.label = 'label3'
entry3.layer_name = 'layer3'
entry3.ts = func.to_tsvector('french', 'vent neige')
entry3.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry3.public = False
entry3.role = role2
entry4 = FullTextSearch()
entry4.label = 'label4'
entry4.layer_name = 'layer1'
entry4.ts = func.to_tsvector('french', 'soleil travail')
entry4.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry4.public = True
entry5 = FullTextSearch()
entry5.label = 'label5'
entry5.layer_name = 'layer1'
entry5.ts = func.to_tsvector('french', 'params')
entry5.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry5.public = True
entry5.params = {'floor': 5}
DBSession.add_all(
[user1, user2, entry1, entry2, entry3, entry4, entry5])
transaction.commit()
def setUp(self):
import transaction
from sqlalchemy import func
from geoalchemy import WKTSpatialElement
from c2cgeoportal.models import FullTextSearch, User, Role
from c2cgeoportal.models import DBSession
user1 = User(username=u'__test_user1', password=u'__test_user1')
role1 = Role(name=u'__test_role1', description=u'__test_role1')
user1.role = role1
user2 = User(username=u'__test_user2', password=u'__test_user2')
role2 = Role(name=u'__test_role2', description=u'__test_role2')
user2.role = role2
entry1 = FullTextSearch()
entry1.label = 'label1'
entry1.layer_name = 'layer1'
entry1.ts = func.to_tsvector('french', 'soleil travail')
entry1.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry1.public = True
entry2 = FullTextSearch()
entry2.label = 'label2'
entry2.layer_name = 'layer2'
entry2.ts = func.to_tsvector('french', 'pluie semaine')
entry2.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry2.public = False
entry3 = FullTextSearch()
entry3.label = 'label3'
entry3.layer_name = 'layer3'
entry3.ts = func.to_tsvector('french', 'vent neige')
entry3.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry3.public = False
entry3.role = role2
entry4 = FullTextSearch()
entry4.label = 'label4'
entry4.layer_name = 'layer1'
entry4.ts = func.to_tsvector('french', 'soleil travail')
entry4.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry4.public = True
entry5 = FullTextSearch()
entry5.label = 'label5'
entry5.layer_name = 'layer1'
entry5.ts = func.to_tsvector('french', 'params')
entry5.the_geom = WKTSpatialElement("POINT(-90 -45)")
entry5.public = True
entry5.params = {'floor': 5}
DBSession.add_all([user1, user2, entry1, entry2, entry3, entry4, entry5])
transaction.commit()
def setter(request):
class User(object):
pass
class Role(object):
pass
u = User()
u.username = u"__foo"
u.role = Role()
u.role.name = u"__bar"
return u
def setter(request):
class User:
pass
class Role:
pass
u = User()
u.username = "******"
u.role = Role()
u.role.name = "__bar"
return u
def setter(request):
class User(object):
pass
class Role(object):
pass
u = User()
u.username = u'__foo'
u.role = Role()
u.role.name = u'__bar'
return u
