def setUp(): # noqa import transaction from sqlalchemy import func from geoalchemy2 import WKTElement from c2cgeoportal.models import FullTextSearch, User, Role, Interface 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_name = role1.name user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name entry1 = FullTextSearch() entry1.label = "label1" entry1.layer_name = "layer1" entry1.ts = func.to_tsvector("french", "soleil travail") entry1.the_geom = WKTElement("POINT(-90 -45)", 21781) entry1.public = True entry2 = FullTextSearch() entry2.label = "label2" entry2.layer_name = "layer2" entry2.ts = func.to_tsvector("french", "pluie semaine") entry2.the_geom = WKTElement("POINT(-90 -45)", 21781) entry2.public = False entry3 = FullTextSearch() entry3.label = "label3" entry3.layer_name = "layer3" entry3.ts = func.to_tsvector("french", "vent neige") entry3.the_geom = WKTElement("POINT(-90 -45)", 21781) 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 = WKTElement("POINT(-90 -45)", 21781) entry4.public = True entry5 = FullTextSearch() entry5.label = "label5" entry5.ts = func.to_tsvector("french", "params") entry5.public = True entry5.params = {"floor": 5} entry5.actions = [{"action": "add_layer", "data": "layer1"}] entry6 = FullTextSearch() entry6.label = "label6" entry6.ts = func.to_tsvector("french", "params") entry6.interface = Interface("main") entry6.public = True DBSession.add_all([user1, user2, role1, role2, entry1, entry2, entry3, entry4, entry5, entry6]) transaction.commit()
def setUp(self): # noqa import transaction from sqlalchemy import func from geoalchemy2 import WKTElement from c2cgeoportal.models import FullTextSearch, User, Role, Interface 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_name = role1.name user2 = User(username=u"__test_user2", password=u"__test_user2") role2 = Role(name=u"__test_role2", description=u"__test_role2") user2.role_name = role2.name entry1 = FullTextSearch() entry1.label = "label1" entry1.layer_name = "layer1" entry1.ts = func.to_tsvector("french", "soleil travail") entry1.the_geom = WKTElement("POINT(-90 -45)", 21781) entry1.public = True entry2 = FullTextSearch() entry2.label = "label2" entry2.layer_name = "layer2" entry2.ts = func.to_tsvector("french", "pluie semaine") entry2.the_geom = WKTElement("POINT(-90 -45)", 21781) entry2.public = False entry3 = FullTextSearch() entry3.label = "label3" entry3.layer_name = "layer3" entry3.ts = func.to_tsvector("french", "vent neige") entry3.the_geom = WKTElement("POINT(-90 -45)", 21781) 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 = WKTElement("POINT(-90 -45)", 21781) entry4.public = True entry5 = FullTextSearch() entry5.label = "label5" entry5.ts = func.to_tsvector("french", "params") entry5.public = True entry5.params = {"floor": 5} entry5.actions = [{"action": "add_layer", "data": "layer1"}] entry6 = FullTextSearch() entry6.label = "label6" entry6.ts = func.to_tsvector("french", "params") entry6.interface = Interface("main") entry6.public = True DBSession.add_all([user1, user2, role1, role2, entry1, entry2, entry3, entry4, entry5, entry6]) 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()