--- a/test/unittest_entity.py Mon Apr 07 18:04:56 2014 +0200
+++ b/test/unittest_entity.py Tue Apr 01 10:26:37 2014 +0200
@@ -45,151 +45,154 @@
cls.fetch_attrs, cls.cw_fetch_order = self.backup_dict[cls]
def test_boolean_value(self):
- e = self.vreg['etypes'].etype_class('CWUser')(self.request())
- self.assertTrue(e)
+ with self.admin_access.web_request() as req:
+ e = self.vreg['etypes'].etype_class('CWUser')(req)
+ self.assertTrue(e)
def test_yams_inheritance(self):
from entities import Note
- e = self.vreg['etypes'].etype_class('SubNote')(self.request())
- self.assertIsInstance(e, Note)
- e2 = self.vreg['etypes'].etype_class('SubNote')(self.request())
- self.assertIs(e.__class__, e2.__class__)
+ with self.admin_access.web_request() as req:
+ e = self.vreg['etypes'].etype_class('SubNote')(req)
+ self.assertIsInstance(e, Note)
+ e2 = self.vreg['etypes'].etype_class('SubNote')(req)
+ self.assertIs(e.__class__, e2.__class__)
def test_has_eid(self):
- e = self.vreg['etypes'].etype_class('CWUser')(self.request())
- self.assertEqual(e.eid, None)
- self.assertEqual(e.has_eid(), False)
- e.eid = 'X'
- self.assertEqual(e.has_eid(), False)
- e.eid = 0
- self.assertEqual(e.has_eid(), True)
- e.eid = 2
- self.assertEqual(e.has_eid(), True)
+ with self.admin_access.web_request() as req:
+ e = self.vreg['etypes'].etype_class('CWUser')(req)
+ self.assertEqual(e.eid, None)
+ self.assertEqual(e.has_eid(), False)
+ e.eid = 'X'
+ self.assertEqual(e.has_eid(), False)
+ e.eid = 0
+ self.assertEqual(e.has_eid(), True)
+ e.eid = 2
+ self.assertEqual(e.has_eid(), True)
def test_copy(self):
- req = self.request()
- req.create_entity('Tag', name=u'x')
- p = req.create_entity('Personne', nom=u'toto')
- oe = req.create_entity('Note', type=u'x')
- self.execute('SET T ecrit_par U WHERE T eid %(t)s, U eid %(u)s',
- {'t': oe.eid, 'u': p.eid})
- self.execute('SET TAG tags X WHERE X eid %(x)s', {'x': oe.eid})
- e = req.create_entity('Note', type=u'z')
- e.copy_relations(oe.eid)
- self.assertEqual(len(e.ecrit_par), 1)
- self.assertEqual(e.ecrit_par[0].eid, p.eid)
- self.assertEqual(len(e.reverse_tags), 1)
- # check meta-relations are not copied, set on commit
- self.assertEqual(len(e.created_by), 0)
+ with self.admin_access.web_request() as req:
+ req.create_entity('Tag', name=u'x')
+ p = req.create_entity('Personne', nom=u'toto')
+ oe = req.create_entity('Note', type=u'x')
+ req.execute('SET T ecrit_par U WHERE T eid %(t)s, U eid %(u)s',
+ {'t': oe.eid, 'u': p.eid})
+ req.execute('SET TAG tags X WHERE X eid %(x)s', {'x': oe.eid})
+ e = req.create_entity('Note', type=u'z')
+ e.copy_relations(oe.eid)
+ self.assertEqual(len(e.ecrit_par), 1)
+ self.assertEqual(e.ecrit_par[0].eid, p.eid)
+ self.assertEqual(len(e.reverse_tags), 1)
+ # check meta-relations are not copied, set on commit
+ self.assertEqual(len(e.created_by), 0)
def test_copy_with_nonmeta_composite_inlined(self):
- req = self.request()
- p = req.create_entity('Personne', nom=u'toto')
- oe = req.create_entity('Note', type=u'x')
- self.schema['ecrit_par'].rdef('Note', 'Personne').composite = 'subject'
- self.execute('SET T ecrit_par U WHERE T eid %(t)s, U eid %(u)s',
- {'t': oe.eid, 'u': p.eid})
- e = req.create_entity('Note', type=u'z')
- e.copy_relations(oe.eid)
- self.assertFalse(e.ecrit_par)
- self.assertTrue(oe.ecrit_par)
+ with self.admin_access.web_request() as req:
+ p = req.create_entity('Personne', nom=u'toto')
+ oe = req.create_entity('Note', type=u'x')
+ self.schema['ecrit_par'].rdef('Note', 'Personne').composite = 'subject'
+ req.execute('SET T ecrit_par U WHERE T eid %(t)s, U eid %(u)s',
+ {'t': oe.eid, 'u': p.eid})
+ e = req.create_entity('Note', type=u'z')
+ e.copy_relations(oe.eid)
+ self.assertFalse(e.ecrit_par)
+ self.assertTrue(oe.ecrit_par)
def test_copy_with_composite(self):
- user = self.user()
- adeleid = self.execute('INSERT EmailAddress X: X address "toto@logilab.org", U use_email X WHERE U login "admin"')[0][0]
- e = self.execute('Any X WHERE X eid %(x)s', {'x': user.eid}).get_entity(0, 0)
- self.assertEqual(e.use_email[0].address, "toto@logilab.org")
- self.assertEqual(e.use_email[0].eid, adeleid)
- usereid = self.execute('INSERT CWUser X: X login "toto", X upassword "toto", X in_group G '
- 'WHERE G name "users"')[0][0]
- e = self.execute('Any X WHERE X eid %(x)s', {'x': usereid}).get_entity(0, 0)
- e.copy_relations(user.eid)
- self.assertFalse(e.use_email)
- self.assertFalse(e.primary_email)
+ with self.admin_access.web_request() as req:
+ adeleid = req.execute('INSERT EmailAddress X: X address "toto@logilab.org", U use_email X WHERE U login "admin"')[0][0]
+ e = req.execute('Any X WHERE X eid %(x)s', {'x': req.user.eid}).get_entity(0, 0)
+ self.assertEqual(e.use_email[0].address, "toto@logilab.org")
+ self.assertEqual(e.use_email[0].eid, adeleid)
+ usereid = req.execute('INSERT CWUser X: X login "toto", X upassword "toto", X in_group G '
+ 'WHERE G name "users"')[0][0]
+ e = req.execute('Any X WHERE X eid %(x)s', {'x': usereid}).get_entity(0, 0)
+ e.copy_relations(req.user.eid)
+ self.assertFalse(e.use_email)
+ self.assertFalse(e.primary_email)
def test_copy_with_non_initial_state(self):
- user = self.user()
- user = self.execute('INSERT CWUser X: X login "toto", X upassword %(pwd)s, X in_group G WHERE G name "users"',
- {'pwd': 'toto'}).get_entity(0, 0)
- self.commit()
- user.cw_adapt_to('IWorkflowable').fire_transition('deactivate')
- self.commit()
- eid2 = self.execute('INSERT CWUser X: X login "tutu", X upassword %(pwd)s', {'pwd': 'toto'})[0][0]
- e = self.execute('Any X WHERE X eid %(x)s', {'x': eid2}).get_entity(0, 0)
- e.copy_relations(user.eid)
- self.commit()
- e.cw_clear_relation_cache('in_state', 'subject')
- self.assertEqual(e.cw_adapt_to('IWorkflowable').state, 'activated')
+ with self.admin_access.web_request() as req:
+ user = req.execute('INSERT CWUser X: X login "toto", X upassword %(pwd)s, X in_group G WHERE G name "users"',
+ {'pwd': 'toto'}).get_entity(0, 0)
+ req.cnx.commit()
+ user.cw_adapt_to('IWorkflowable').fire_transition('deactivate')
+ req.cnx.commit()
+ eid2 = req.execute('INSERT CWUser X: X login "tutu", X upassword %(pwd)s', {'pwd': 'toto'})[0][0]
+ e = req.execute('Any X WHERE X eid %(x)s', {'x': eid2}).get_entity(0, 0)
+ e.copy_relations(user.eid)
+ req.cnx.commit()
+ e.cw_clear_relation_cache('in_state', 'subject')
+ self.assertEqual(e.cw_adapt_to('IWorkflowable').state, 'activated')
def test_related_cache_both(self):
- user = self.execute('Any X WHERE X eid %(x)s', {'x':self.user().eid}).get_entity(0, 0)
- adeleid = self.execute('INSERT EmailAddress X: X address "toto@logilab.org", U use_email X WHERE U login "admin"')[0][0]
- self.commit()
- self.assertEqual(user._cw_related_cache, {})
- email = user.primary_email[0]
- self.assertEqual(sorted(user._cw_related_cache), ['primary_email_subject'])
- self.assertEqual(list(email._cw_related_cache), ['primary_email_object'])
- groups = user.in_group
- self.assertEqual(sorted(user._cw_related_cache), ['in_group_subject', 'primary_email_subject'])
- for group in groups:
- self.assertFalse('in_group_subject' in group._cw_related_cache, list(group._cw_related_cache))
- user.cw_clear_all_caches()
- user.related('in_group', entities=True)
- self.assertIn('in_group_subject', user._cw_related_cache)
- user.cw_clear_all_caches()
- user.related('in_group', targettypes=('CWGroup',), entities=True)
- self.assertNotIn('in_group_subject', user._cw_related_cache)
+ with self.admin_access.web_request() as req:
+ user = req.execute('Any X WHERE X eid %(x)s', {'x':req.user.eid}).get_entity(0, 0)
+ adeleid = req.execute('INSERT EmailAddress X: X address "toto@logilab.org", U use_email X WHERE U login "admin"')[0][0]
+ req.cnx.commit()
+ self.assertEqual(user._cw_related_cache, {})
+ email = user.primary_email[0]
+ self.assertEqual(sorted(user._cw_related_cache), ['primary_email_subject'])
+ self.assertEqual(list(email._cw_related_cache), ['primary_email_object'])
+ groups = user.in_group
+ self.assertEqual(sorted(user._cw_related_cache), ['in_group_subject', 'primary_email_subject'])
+ for group in groups:
+ self.assertNotIn('in_group_subject', group._cw_related_cache)
+ user.cw_clear_all_caches()
+ user.related('in_group', entities=True)
+ self.assertIn('in_group_subject', user._cw_related_cache)
+ user.cw_clear_all_caches()
+ user.related('in_group', targettypes=('CWGroup',), entities=True)
+ self.assertNotIn('in_group_subject', user._cw_related_cache)
def test_related_limit(self):
- req = self.request()
- p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
- for tag in u'abcd':
- req.create_entity('Tag', name=tag)
- self.execute('SET X tags Y WHERE X is Tag, Y is Personne')
- self.assertEqual(len(p.related('tags', 'object', limit=2)), 2)
- self.assertEqual(len(p.related('tags', 'object')), 4)
- p.cw_clear_all_caches()
- self.assertEqual(len(p.related('tags', 'object', entities=True, limit=2)), 2)
- self.assertEqual(len(p.related('tags', 'object', entities=True)), 4)
+ with self.admin_access.web_request() as req:
+ p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
+ for tag in u'abcd':
+ req.create_entity('Tag', name=tag)
+ req.execute('SET X tags Y WHERE X is Tag, Y is Personne')
+ self.assertEqual(len(p.related('tags', 'object', limit=2)), 2)
+ self.assertEqual(len(p.related('tags', 'object')), 4)
+ p.cw_clear_all_caches()
+ self.assertEqual(len(p.related('tags', 'object', entities=True, limit=2)), 2)
+ self.assertEqual(len(p.related('tags', 'object', entities=True)), 4)
def test_related_targettypes(self):
- req = self.request()
- p = req.create_entity('Personne', nom=u'Loxodonta', prenom=u'Babar')
- n = req.create_entity('Note', type=u'scratch', ecrit_par=p)
- t = req.create_entity('Tag', name=u'a tag', tags=(p, n))
- self.commit()
- req = self.request()
- t = req.entity_from_eid(t.eid)
- self.assertEqual(2, t.related('tags').rowcount)
- self.assertEqual(1, t.related('tags', targettypes=('Personne',)).rowcount)
- self.assertEqual(1, t.related('tags', targettypes=('Note',)).rowcount)
+ with self.admin_access.web_request() as req:
+ p = req.create_entity('Personne', nom=u'Loxodonta', prenom=u'Babar')
+ n = req.create_entity('Note', type=u'scratch', ecrit_par=p)
+ t = req.create_entity('Tag', name=u'a tag', tags=(p, n))
+ req.cnx.commit()
+ with self.admin_access.web_request() as req:
+ t = req.entity_from_eid(t.eid)
+ self.assertEqual(2, t.related('tags').rowcount)
+ self.assertEqual(1, t.related('tags', targettypes=('Personne',)).rowcount)
+ self.assertEqual(1, t.related('tags', targettypes=('Note',)).rowcount)
def test_cw_instantiate_relation(self):
- req = self.request()
- p1 = req.create_entity('Personne', nom=u'di')
- p2 = req.create_entity('Personne', nom=u'mascio')
- t = req.create_entity('Tag', name=u't0', tags=[])
- self.assertCountEqual(t.tags, [])
- t = req.create_entity('Tag', name=u't1', tags=p1)
- self.assertCountEqual(t.tags, [p1])
- t = req.create_entity('Tag', name=u't2', tags=p1.eid)
- self.assertCountEqual(t.tags, [p1])
- t = req.create_entity('Tag', name=u't3', tags=[p1, p2.eid])
- self.assertCountEqual(t.tags, [p1, p2])
+ with self.admin_access.web_request() as req:
+ p1 = req.create_entity('Personne', nom=u'di')
+ p2 = req.create_entity('Personne', nom=u'mascio')
+ t = req.create_entity('Tag', name=u't0', tags=[])
+ self.assertCountEqual(t.tags, [])
+ t = req.create_entity('Tag', name=u't1', tags=p1)
+ self.assertCountEqual(t.tags, [p1])
+ t = req.create_entity('Tag', name=u't2', tags=p1.eid)
+ self.assertCountEqual(t.tags, [p1])
+ t = req.create_entity('Tag', name=u't3', tags=[p1, p2.eid])
+ self.assertCountEqual(t.tags, [p1, p2])
def test_cw_instantiate_reverse_relation(self):
- req = self.request()
- t1 = req.create_entity('Tag', name=u't1')
- t2 = req.create_entity('Tag', name=u't2')
- p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=t1)
- self.assertCountEqual(p.reverse_tags, [t1])
- p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=t1.eid)
- self.assertCountEqual(p.reverse_tags, [t1])
- p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=[t1, t2.eid])
- self.assertCountEqual(p.reverse_tags, [t1, t2])
+ with self.admin_access.web_request() as req:
+ t1 = req.create_entity('Tag', name=u't1')
+ t2 = req.create_entity('Tag', name=u't2')
+ p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=t1)
+ self.assertCountEqual(p.reverse_tags, [t1])
+ p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=t1.eid)
+ self.assertCountEqual(p.reverse_tags, [t1])
+ p = req.create_entity('Personne', nom=u'di mascio', reverse_tags=[t1, t2.eid])
+ self.assertCountEqual(p.reverse_tags, [t1, t2])
def test_fetch_rql(self):
- user = self.user()
Personne = self.vreg['etypes'].etype_class('Personne')
Societe = self.vreg['etypes'].etype_class('Societe')
Note = self.vreg['etypes'].etype_class('Note')
@@ -204,47 +207,49 @@
cm.__enter__()
torestore.append(cm)
try:
- # testing basic fetch_attrs attribute
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB,AC ORDERBY AA '
- 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X modification_date AC')
- # testing unknown attributes
- Personne.fetch_attrs = ('bloug', 'beep')
- self.assertEqual(Personne.fetch_rql(user), 'Any X WHERE X is_instance_of Personne')
- # testing one non final relation
- Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB,AC,AD ORDERBY AA '
- 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD')
- # testing two non final relations
- Personne.fetch_attrs = ('nom', 'prenom', 'travaille', 'evaluee')
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB,AC,AD,AE ORDERBY AA '
- 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD, '
- 'X evaluee AE?')
- # testing one non final relation with recursion
- Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
- Societe.fetch_attrs = ('nom', 'evaluee')
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB,AC,AD,AE,AF ORDERBY AA,AF DESC '
- 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD, '
- 'AC evaluee AE?, AE modification_date AF'
- )
- # testing symmetric relation
- Personne.fetch_attrs = ('nom', 'connait')
- self.assertEqual(Personne.fetch_rql(user), 'Any X,AA,AB ORDERBY AA '
- 'WHERE X is_instance_of Personne, X nom AA, X connait AB?')
- # testing optional relation
- peschema.subjrels['travaille'].rdef(peschema, seschema).cardinality = '?*'
- Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
- Societe.fetch_attrs = ('nom',)
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB,AC,AD ORDERBY AA WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD')
- # testing relation with cardinality > 1
- peschema.subjrels['travaille'].rdef(peschema, seschema).cardinality = '**'
- self.assertEqual(Personne.fetch_rql(user),
- 'Any X,AA,AB ORDERBY AA WHERE X is_instance_of Personne, X nom AA, X prenom AB')
- # XXX test unauthorized attribute
+ with self.admin_access.web_request() as req:
+ user = req.user
+ # testing basic fetch_attrs attribute
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB,AC ORDERBY AA '
+ 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X modification_date AC')
+ # testing unknown attributes
+ Personne.fetch_attrs = ('bloug', 'beep')
+ self.assertEqual(Personne.fetch_rql(user), 'Any X WHERE X is_instance_of Personne')
+ # testing one non final relation
+ Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB,AC,AD ORDERBY AA '
+ 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD')
+ # testing two non final relations
+ Personne.fetch_attrs = ('nom', 'prenom', 'travaille', 'evaluee')
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB,AC,AD,AE ORDERBY AA '
+ 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD, '
+ 'X evaluee AE?')
+ # testing one non final relation with recursion
+ Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
+ Societe.fetch_attrs = ('nom', 'evaluee')
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB,AC,AD,AE,AF ORDERBY AA,AF DESC '
+ 'WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD, '
+ 'AC evaluee AE?, AE modification_date AF'
+ )
+ # testing symmetric relation
+ Personne.fetch_attrs = ('nom', 'connait')
+ self.assertEqual(Personne.fetch_rql(user), 'Any X,AA,AB ORDERBY AA '
+ 'WHERE X is_instance_of Personne, X nom AA, X connait AB?')
+ # testing optional relation
+ peschema.subjrels['travaille'].rdef(peschema, seschema).cardinality = '?*'
+ Personne.fetch_attrs = ('nom', 'prenom', 'travaille')
+ Societe.fetch_attrs = ('nom',)
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB,AC,AD ORDERBY AA WHERE X is_instance_of Personne, X nom AA, X prenom AB, X travaille AC?, AC nom AD')
+ # testing relation with cardinality > 1
+ peschema.subjrels['travaille'].rdef(peschema, seschema).cardinality = '**'
+ self.assertEqual(Personne.fetch_rql(user),
+ 'Any X,AA,AB ORDERBY AA WHERE X is_instance_of Personne, X nom AA, X prenom AB')
+ # XXX test unauthorized attribute
finally:
# fetch_attrs restored by generic tearDown
for cm in torestore:
@@ -258,97 +263,106 @@
Personne.fetch_attrs, Personne.cw_fetch_order = fetch_config(('nom', 'type'))
Note.fetch_attrs, Note.cw_fetch_order = fetch_config(('type',))
SubNote.fetch_attrs, SubNote.cw_fetch_order = fetch_config(('type',))
- p = self.request().create_entity('Personne', nom=u'pouet')
- self.assertEqual(p.cw_related_rql('evaluee'),
- 'Any X,AA,AB ORDERBY AA WHERE E eid %(x)s, E evaluee X, '
- 'X type AA, X modification_date AB')
- n = self.request().create_entity('Note')
- self.assertEqual(n.cw_related_rql('evaluee', role='object',
- targettypes=('Societe', 'Personne')),
- "Any X,AA ORDERBY AB DESC WHERE E eid %(x)s, X evaluee E, "
- "X is IN(Personne, Societe), X nom AA, "
- "X modification_date AB")
- Personne.fetch_attrs, Personne.cw_fetch_order = fetch_config(('nom', ))
- # XXX
- self.assertEqual(p.cw_related_rql('evaluee'),
- 'Any X,AA ORDERBY AA DESC '
- 'WHERE E eid %(x)s, E evaluee X, X modification_date AA')
+ with self.admin_access.web_request() as req:
+ p = req.create_entity('Personne', nom=u'pouet')
+ self.assertEqual(p.cw_related_rql('evaluee'),
+ 'Any X,AA,AB ORDERBY AA WHERE E eid %(x)s, E evaluee X, '
+ 'X type AA, X modification_date AB')
+ n = req.create_entity('Note')
+ self.assertEqual(n.cw_related_rql('evaluee', role='object',
+ targettypes=('Societe', 'Personne')),
+ "Any X,AA ORDERBY AB DESC WHERE E eid %(x)s, X evaluee E, "
+ "X is IN(Personne, Societe), X nom AA, "
+ "X modification_date AB")
+ Personne.fetch_attrs, Personne.cw_fetch_order = fetch_config(('nom', ))
+ # XXX
+ self.assertEqual(p.cw_related_rql('evaluee'),
+ 'Any X,AA ORDERBY AA DESC '
+ 'WHERE E eid %(x)s, E evaluee X, X modification_date AA')
- tag = self.vreg['etypes'].etype_class('Tag')(self.request())
- self.assertEqual(tag.cw_related_rql('tags', 'subject'),
- 'Any X,AA ORDERBY AA DESC '
- 'WHERE E eid %(x)s, E tags X, X modification_date AA')
- self.assertEqual(tag.cw_related_rql('tags', 'subject', ('Personne',)),
- 'Any X,AA,AB ORDERBY AA '
- 'WHERE E eid %(x)s, E tags X, X is Personne, X nom AA, '
- 'X modification_date AB')
+ tag = self.vreg['etypes'].etype_class('Tag')(req)
+ self.assertEqual(tag.cw_related_rql('tags', 'subject'),
+ 'Any X,AA ORDERBY AA DESC '
+ 'WHERE E eid %(x)s, E tags X, X modification_date AA')
+ self.assertEqual(tag.cw_related_rql('tags', 'subject', ('Personne',)),
+ 'Any X,AA,AB ORDERBY AA '
+ 'WHERE E eid %(x)s, E tags X, X is Personne, X nom AA, '
+ 'X modification_date AB')
def test_related_rql_ambiguous_cant_use_fetch_order(self):
- tag = self.vreg['etypes'].etype_class('Tag')(self.request())
- for ttype in self.schema['tags'].objects():
- self.vreg['etypes'].etype_class(ttype).fetch_attrs = ('modification_date',)
- self.assertEqual(tag.cw_related_rql('tags', 'subject'),
- 'Any X,AA ORDERBY AA DESC '
- 'WHERE E eid %(x)s, E tags X, X modification_date AA')
+ with self.admin_access.web_request() as req:
+ tag = self.vreg['etypes'].etype_class('Tag')(req)
+ for ttype in self.schema['tags'].objects():
+ self.vreg['etypes'].etype_class(ttype).fetch_attrs = ('modification_date',)
+ self.assertEqual(tag.cw_related_rql('tags', 'subject'),
+ 'Any X,AA ORDERBY AA DESC '
+ 'WHERE E eid %(x)s, E tags X, X modification_date AA')
def test_related_rql_fetch_ambiguous_rtype(self):
- soc_etype = self.vreg['etypes'].etype_class('Societe')
- soc = soc_etype(self.request())
- soc_etype.fetch_attrs = ('fournit',)
- self.vreg['etypes'].etype_class('Service').fetch_attrs = ('fabrique_par',)
- self.vreg['etypes'].etype_class('Produit').fetch_attrs = ('fabrique_par',)
- self.vreg['etypes'].etype_class('Usine').fetch_attrs = ('lieu',)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ('nom',)
- self.assertEqual(soc.cw_related_rql('fournit', 'subject'),
- 'Any X,A WHERE E eid %(x)s, E fournit X, X fabrique_par A')
+ etvreg = self.vreg['etypes']
+ soc_etype = etvreg.etype_class('Societe')
+ with self.admin_access.web_request() as req:
+ soc = soc_etype(req)
+ soc_etype.fetch_attrs = ('fournit',)
+ etvreg.etype_class('Service').fetch_attrs = ('fabrique_par',)
+ etvreg.etype_class('Produit').fetch_attrs = ('fabrique_par',)
+ etvreg.etype_class('Usine').fetch_attrs = ('lieu',)
+ etvreg.etype_class('Personne').fetch_attrs = ('nom',)
+ self.assertEqual(soc.cw_related_rql('fournit', 'subject'),
+ 'Any X,A WHERE E eid %(x)s, E fournit X, X fabrique_par A')
def test_unrelated_rql_security_1_manager(self):
- user = self.request().user
- rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
- self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
- 'WHERE NOT A use_email O, S eid %(x)s, '
- 'O is_instance_of EmailAddress, O address AA, O alias AB, O modification_date AC')
+ with self.admin_access.web_request() as req:
+ user = req.user
+ rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
+ self.assertEqual(rql,
+ 'Any O,AA,AB,AC ORDERBY AC DESC '
+ 'WHERE NOT A use_email O, S eid %(x)s, '
+ 'O is_instance_of EmailAddress, O address AA, O alias AB, '
+ 'O modification_date AC')
def test_unrelated_rql_security_1_user(self):
- req = self.request()
- self.create_user(req, 'toto')
- self.login('toto')
- user = req.user
- rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
- self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
- 'WHERE NOT A use_email O, S eid %(x)s, '
- 'O is_instance_of EmailAddress, O address AA, O alias AB, O modification_date AC')
- user = self.execute('Any X WHERE X login "admin"').get_entity(0, 0)
- rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
- self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
- 'WHERE NOT A use_email O, S eid %(x)s, '
- 'O is EmailAddress, O address AA, O alias AB, O modification_date AC, AD eid %(AE)s, '
- 'EXISTS(S identity AD, NOT AD in_group AF, AF name "guests", AF is CWGroup), A is CWUser')
+ with self.admin_access.web_request() as req:
+ self.create_user(req, 'toto')
+ with self.new_access('toto').web_request() as req:
+ user = req.user # XXX
+ rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
+ self.assertEqual(rql,
+ 'Any O,AA,AB,AC ORDERBY AC DESC '
+ 'WHERE NOT A use_email O, S eid %(x)s, '
+ 'O is_instance_of EmailAddress, O address AA, O alias AB, O modification_date AC')
+ user = req.execute('Any X WHERE X login "admin"').get_entity(0, 0)
+ rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
+ self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
+ 'WHERE NOT A use_email O, S eid %(x)s, '
+ 'O is EmailAddress, O address AA, O alias AB, O modification_date AC, AD eid %(AE)s, '
+ 'EXISTS(S identity AD, NOT AD in_group AF, AF name "guests", AF is CWGroup), A is CWUser')
def test_unrelated_rql_security_1_anon(self):
- self.login('anon')
- user = self.request().user
- rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
- self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
- 'WHERE NOT A use_email O, S eid %(x)s, '
- 'O is EmailAddress, O address AA, O alias AB, O modification_date AC, AD eid %(AE)s, '
- 'EXISTS(S identity AD, NOT AD in_group AF, AF name "guests", AF is CWGroup), A is CWUser')
+ with self.new_access('anon').web_request() as req:
+ user = req.user
+ rql = user.cw_unrelated_rql('use_email', 'EmailAddress', 'subject')[0]
+ self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC '
+ 'WHERE NOT A use_email O, S eid %(x)s, '
+ 'O is EmailAddress, O address AA, O alias AB, O modification_date AC, AD eid %(AE)s, '
+ 'EXISTS(S identity AD, NOT AD in_group AF, AF name "guests", AF is CWGroup), A is CWUser')
def test_unrelated_rql_security_2(self):
- email = self.execute('INSERT EmailAddress X: X address "hop"').get_entity(0, 0)
- rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
- self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
- 'WHERE NOT S use_email O, O eid %(x)s, S is_instance_of CWUser, '
- 'S login AA, S firstname AB, S surname AC, S modification_date AD')
- self.login('anon')
+ with self.admin_access.web_request() as req:
+ email = req.execute('INSERT EmailAddress X: X address "hop"').get_entity(0, 0)
+ rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
+ self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
+ 'WHERE NOT S use_email O, O eid %(x)s, S is_instance_of CWUser, '
+ 'S login AA, S firstname AB, S surname AC, S modification_date AD')
rperms = self.schema['EmailAddress'].permissions['read']
clear_cache(self.schema['EmailAddress'], 'get_groups')
clear_cache(self.schema['EmailAddress'], 'get_rqlexprs')
self.schema['EmailAddress'].permissions['read'] = ('managers', 'users', 'guests',)
try:
- email = self.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
- rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
- self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
+ with self.new_access('anon').web_request() as req:
+ email = req.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
+ rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
+ self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
'WHERE NOT S use_email O, O eid %(x)s, S is CWUser, '
'S login AA, S firstname AB, S surname AC, S modification_date AD, '
'AE eid %(AF)s, EXISTS(S identity AE, NOT AE in_group AG, AG name "guests", AG is CWGroup)')
@@ -359,25 +373,27 @@
def test_unrelated_rql_security_nonexistant(self):
- self.login('anon')
- email = self.vreg['etypes'].etype_class('EmailAddress')(self.request())
- rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
- self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
+ with self.new_access('anon').web_request() as req:
+ email = self.vreg['etypes'].etype_class('EmailAddress')(req)
+ rql = email.cw_unrelated_rql('use_email', 'CWUser', 'object')[0]
+ self.assertEqual(rql, 'Any S,AA,AB,AC,AD ORDERBY AA '
'WHERE S is CWUser, '
'S login AA, S firstname AB, S surname AC, S modification_date AD, '
'AE eid %(AF)s, EXISTS(S identity AE, NOT AE in_group AG, AG name "guests", AG is CWGroup)')
def test_unrelated_rql_constraints_creation_subject(self):
- person = self.vreg['etypes'].etype_class('Personne')(self.request())
- rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
- self.assertEqual(
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
+ self.assertEqual(
rql, 'Any O,AA,AB,AC ORDERBY AC DESC WHERE '
'O is_instance_of Personne, O nom AA, O prenom AB, O modification_date AC')
def test_unrelated_rql_constraints_creation_object(self):
- person = self.vreg['etypes'].etype_class('Personne')(self.request())
- rql = person.cw_unrelated_rql('connait', 'Personne', 'object')[0]
- self.assertEqual(
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ rql = person.cw_unrelated_rql('connait', 'Personne', 'object')[0]
+ self.assertEqual(
rql, 'Any S,AA,AB,AC ORDERBY AC DESC WHERE '
'S is Personne, S nom AA, S prenom AB, S modification_date AC, '
'NOT (S connait AD, AD nom "toto"), AD is Personne, '
@@ -389,25 +405,28 @@
rdef = self.schema['Personne'].rdef('connait')
perm_rrqle = RRQLExpression('U has_update_permission S')
with self.temporary_permissions((rdef, {'add': (perm_rrqle,)})):
- person = self.vreg['etypes'].etype_class('Personne')(self.request())
- rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
- self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC WHERE '
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
+ self.assertEqual(rql, 'Any O,AA,AB,AC ORDERBY AC DESC WHERE '
'O is_instance_of Personne, O nom AA, O prenom AB, '
'O modification_date AC')
def test_unrelated_rql_constraints_edition_subject(self):
- person = self.request().create_entity('Personne', nom=u'sylvain')
- rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
- self.assertEqual(
- rql, 'Any O,AA,AB,AC ORDERBY AC DESC WHERE '
+ with self.admin_access.web_request() as req:
+ person = req.create_entity('Personne', nom=u'sylvain')
+ rql = person.cw_unrelated_rql('connait', 'Personne', 'subject')[0]
+ self.assertEqual(
+ rql, 'Any O,AA,AB,AC ORDERBY AC DESC WHERE '
'NOT S connait O, S eid %(x)s, O is Personne, '
'O nom AA, O prenom AB, O modification_date AC, '
'NOT S identity O')
def test_unrelated_rql_constraints_edition_object(self):
- person = self.request().create_entity('Personne', nom=u'sylvain')
- rql = person.cw_unrelated_rql('connait', 'Personne', 'object')[0]
- self.assertEqual(
+ with self.admin_access.web_request() as req:
+ person = req.create_entity('Personne', nom=u'sylvain')
+ rql = person.cw_unrelated_rql('connait', 'Personne', 'object')[0]
+ self.assertEqual(
rql, 'Any S,AA,AB,AC ORDERBY AC DESC WHERE '
'NOT S connait O, O eid %(x)s, S is Personne, '
'S nom AA, S prenom AB, S modification_date AC, '
@@ -415,95 +434,95 @@
'EXISTS(S travaille AE, AE nom "tutu")')
def test_unrelated_rql_s_linkto_s(self):
- req = self.request()
- person = self.vreg['etypes'].etype_class('Personne')(req)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
- soc = req.create_entity('Societe', nom=u'logilab')
- lt_infos = {('actionnaire', 'subject'): [soc.eid]}
- rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject',
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
+ soc = req.create_entity('Societe', nom=u'logilab')
+ lt_infos = {('actionnaire', 'subject'): [soc.eid]}
+ rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject',
lt_infos=lt_infos)
- self.assertEqual(u'Any O ORDERBY O WHERE O is Personne, '
- u'EXISTS(AA eid %(SOC)s, O actionnaire AA)', rql)
- self.assertEqual({'SOC': soc.eid}, args)
+ self.assertEqual(u'Any O ORDERBY O WHERE O is Personne, '
+ u'EXISTS(AA eid %(SOC)s, O actionnaire AA)', rql)
+ self.assertEqual({'SOC': soc.eid}, args)
def test_unrelated_rql_s_linkto_o(self):
- req = self.request()
- person = self.vreg['etypes'].etype_class('Personne')(req)
- self.vreg['etypes'].etype_class('Societe').fetch_attrs = ()
- soc = req.create_entity('Societe', nom=u'logilab')
- lt_infos = {('contrat_exclusif', 'object'): [soc.eid]}
- rql, args = person.cw_unrelated_rql('actionnaire', 'Societe', 'subject',
- lt_infos=lt_infos)
- self.assertEqual(u'Any O ORDERBY O WHERE NOT A actionnaire O, '
- u'O is_instance_of Societe, NOT EXISTS(O eid %(O)s), '
- u'A is Personne', rql)
- self.assertEqual({'O': soc.eid}, args)
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ self.vreg['etypes'].etype_class('Societe').fetch_attrs = ()
+ soc = req.create_entity('Societe', nom=u'logilab')
+ lt_infos = {('contrat_exclusif', 'object'): [soc.eid]}
+ rql, args = person.cw_unrelated_rql('actionnaire', 'Societe', 'subject',
+ lt_infos=lt_infos)
+ self.assertEqual(u'Any O ORDERBY O WHERE NOT A actionnaire O, '
+ u'O is_instance_of Societe, NOT EXISTS(O eid %(O)s), '
+ u'A is Personne', rql)
+ self.assertEqual({'O': soc.eid}, args)
def test_unrelated_rql_o_linkto_s(self):
- req = self.request()
- soc = self.vreg['etypes'].etype_class('Societe')(req)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
- person = req.create_entity('Personne', nom=u'florent')
- lt_infos = {('contrat_exclusif', 'subject'): [person.eid]}
- rql, args = soc.cw_unrelated_rql('actionnaire', 'Personne', 'object',
- lt_infos=lt_infos)
- self.assertEqual(u'Any S ORDERBY S WHERE NOT S actionnaire A, '
- u'S is_instance_of Personne, NOT EXISTS(S eid %(S)s), '
- u'A is Societe', rql)
- self.assertEqual({'S': person.eid}, args)
+ with self.admin_access.web_request() as req:
+ soc = self.vreg['etypes'].etype_class('Societe')(req)
+ self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
+ person = req.create_entity('Personne', nom=u'florent')
+ lt_infos = {('contrat_exclusif', 'subject'): [person.eid]}
+ rql, args = soc.cw_unrelated_rql('actionnaire', 'Personne', 'object',
+ lt_infos=lt_infos)
+ self.assertEqual(u'Any S ORDERBY S WHERE NOT S actionnaire A, '
+ u'S is_instance_of Personne, NOT EXISTS(S eid %(S)s), '
+ u'A is Societe', rql)
+ self.assertEqual({'S': person.eid}, args)
def test_unrelated_rql_o_linkto_o(self):
- req = self.request()
- soc = self.vreg['etypes'].etype_class('Societe')(req)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
- person = req.create_entity('Personne', nom=u'florent')
- lt_infos = {('actionnaire', 'object'): [person.eid]}
- rql, args = soc.cw_unrelated_rql('dirige', 'Personne', 'object',
- lt_infos=lt_infos)
- self.assertEqual(u'Any S ORDERBY S WHERE NOT S dirige A, '
- u'S is_instance_of Personne, EXISTS(S eid %(S)s), '
- u'A is Societe', rql)
- self.assertEqual({'S': person.eid}, args)
+ with self.admin_access.web_request() as req:
+ soc = self.vreg['etypes'].etype_class('Societe')(req)
+ self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
+ person = req.create_entity('Personne', nom=u'florent')
+ lt_infos = {('actionnaire', 'object'): [person.eid]}
+ rql, args = soc.cw_unrelated_rql('dirige', 'Personne', 'object',
+ lt_infos=lt_infos)
+ self.assertEqual(u'Any S ORDERBY S WHERE NOT S dirige A, '
+ u'S is_instance_of Personne, EXISTS(S eid %(S)s), '
+ u'A is Societe', rql)
+ self.assertEqual({'S': person.eid}, args)
def test_unrelated_rql_s_linkto_s_no_info(self):
- req = self.request()
- person = self.vreg['etypes'].etype_class('Personne')(req)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
- soc = req.create_entity('Societe', nom=u'logilab')
- rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject')
- self.assertEqual(u'Any O ORDERBY O WHERE O is_instance_of Personne', rql)
- self.assertEqual({}, args)
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
+ soc = req.create_entity('Societe', nom=u'logilab')
+ rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject')
+ self.assertEqual(u'Any O ORDERBY O WHERE O is_instance_of Personne', rql)
+ self.assertEqual({}, args)
def test_unrelated_rql_s_linkto_s_unused_info(self):
- req = self.request()
- person = self.vreg['etypes'].etype_class('Personne')(req)
- self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
- other_p = req.create_entity('Personne', nom=u'titi')
- lt_infos = {('dirige', 'subject'): [other_p.eid]}
- rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject',
- lt_infos=lt_infos)
- self.assertEqual(u'Any O ORDERBY O WHERE O is_instance_of Personne', rql)
+ with self.admin_access.web_request() as req:
+ person = self.vreg['etypes'].etype_class('Personne')(req)
+ self.vreg['etypes'].etype_class('Personne').fetch_attrs = ()
+ other_p = req.create_entity('Personne', nom=u'titi')
+ lt_infos = {('dirige', 'subject'): [other_p.eid]}
+ rql, args = person.cw_unrelated_rql('associe', 'Personne', 'subject',
+ lt_infos=lt_infos)
+ self.assertEqual(u'Any O ORDERBY O WHERE O is_instance_of Personne', rql)
def test_unrelated_base(self):
- req = self.request()
- p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
- e = req.create_entity('Tag', name=u'x')
- related = [r.eid for r in e.tags]
- self.assertEqual(related, [])
- unrelated = [r[0] for r in e.unrelated('tags', 'Personne', 'subject')]
- self.assertTrue(p.eid in unrelated)
- self.execute('SET X tags Y WHERE X is Tag, Y is Personne')
- e = self.execute('Any X WHERE X is Tag').get_entity(0, 0)
- unrelated = [r[0] for r in e.unrelated('tags', 'Personne', 'subject')]
- self.assertFalse(p.eid in unrelated)
+ with self.admin_access.web_request() as req:
+ p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
+ e = req.create_entity('Tag', name=u'x')
+ related = [r.eid for r in e.tags]
+ self.assertEqual(related, [])
+ unrelated = [r[0] for r in e.unrelated('tags', 'Personne', 'subject')]
+ self.assertIn(p.eid, unrelated)
+ req.execute('SET X tags Y WHERE X is Tag, Y is Personne')
+ e = req.execute('Any X WHERE X is Tag').get_entity(0, 0)
+ unrelated = [r[0] for r in e.unrelated('tags', 'Personne', 'subject')]
+ self.assertFalse(p.eid in unrelated)
def test_unrelated_limit(self):
- req = self.request()
- e = req.create_entity('Tag', name=u'x')
- req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
- req.create_entity('Personne', nom=u'thenault', prenom=u'sylvain')
- self.assertEqual(len(e.unrelated('tags', 'Personne', 'subject', limit=1)),
- 1)
+ with self.admin_access.web_request() as req:
+ e = req.create_entity('Tag', name=u'x')
+ req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
+ req.create_entity('Personne', nom=u'thenault', prenom=u'sylvain')
+ self.assertEqual(len(e.unrelated('tags', 'Personne', 'subject', limit=1)),
+ 1)
def test_unrelated_security(self):
rperms = self.schema['EmailAddress'].permissions['read']
@@ -511,206 +530,210 @@
clear_cache(self.schema['EmailAddress'], 'get_rqlexprs')
self.schema['EmailAddress'].permissions['read'] = ('managers', 'users', 'guests',)
try:
- email = self.execute('INSERT EmailAddress X: X address "hop"').get_entity(0, 0)
- rset = email.unrelated('use_email', 'CWUser', 'object')
- self.assertEqual([x.login for x in rset.entities()], [u'admin', u'anon'])
- user = self.request().user
- rset = user.unrelated('use_email', 'EmailAddress', 'subject')
- self.assertEqual([x.address for x in rset.entities()], [u'hop'])
- req = self.request()
- self.create_user(req, 'toto')
- self.login('toto')
- email = self.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
- rset = email.unrelated('use_email', 'CWUser', 'object')
- self.assertEqual([x.login for x in rset.entities()], ['toto'])
- user = self.request().user
- rset = user.unrelated('use_email', 'EmailAddress', 'subject')
- self.assertEqual([x.address for x in rset.entities()], ['hop'])
- user = self.execute('Any X WHERE X login "admin"').get_entity(0, 0)
- rset = user.unrelated('use_email', 'EmailAddress', 'subject')
- self.assertEqual([x.address for x in rset.entities()], [])
- self.login('anon')
- email = self.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
- rset = email.unrelated('use_email', 'CWUser', 'object')
- self.assertEqual([x.login for x in rset.entities()], [])
- user = self.request().user
- rset = user.unrelated('use_email', 'EmailAddress', 'subject')
- self.assertEqual([x.address for x in rset.entities()], [])
+ with self.admin_access.web_request() as req:
+ email = req.execute('INSERT EmailAddress X: X address "hop"').get_entity(0, 0)
+ rset = email.unrelated('use_email', 'CWUser', 'object')
+ self.assertEqual([x.login for x in rset.entities()], [u'admin', u'anon'])
+ user = req.user
+ rset = user.unrelated('use_email', 'EmailAddress', 'subject')
+ self.assertEqual([x.address for x in rset.entities()], [u'hop'])
+ self.create_user(req, 'toto')
+ with self.new_access('toto').web_request() as req:
+ email = req.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
+ rset = email.unrelated('use_email', 'CWUser', 'object')
+ self.assertEqual([x.login for x in rset.entities()], ['toto'])
+ user = req.user
+ rset = user.unrelated('use_email', 'EmailAddress', 'subject')
+ self.assertEqual([x.address for x in rset.entities()], ['hop'])
+ user = req.execute('Any X WHERE X login "admin"').get_entity(0, 0)
+ rset = user.unrelated('use_email', 'EmailAddress', 'subject')
+ self.assertEqual([x.address for x in rset.entities()], [])
+ with self.new_access('anon').web_request() as req:
+ email = req.execute('Any X WHERE X eid %(x)s', {'x': email.eid}).get_entity(0, 0)
+ rset = email.unrelated('use_email', 'CWUser', 'object')
+ self.assertEqual([x.login for x in rset.entities()], [])
+ user = req.user
+ rset = user.unrelated('use_email', 'EmailAddress', 'subject')
+ self.assertEqual([x.address for x in rset.entities()], [])
finally:
clear_cache(self.schema['EmailAddress'], 'get_groups')
clear_cache(self.schema['EmailAddress'], 'get_rqlexprs')
self.schema['EmailAddress'].permissions['read'] = rperms
def test_unrelated_new_entity(self):
- e = self.vreg['etypes'].etype_class('CWUser')(self.request())
- unrelated = [r[0] for r in e.unrelated('in_group', 'CWGroup', 'subject')]
- # should be default groups but owners, i.e. managers, users, guests
- self.assertEqual(len(unrelated), 3)
+ with self.admin_access.web_request() as req:
+ e = self.vreg['etypes'].etype_class('CWUser')(req)
+ unrelated = [r[0] for r in e.unrelated('in_group', 'CWGroup', 'subject')]
+ # should be default groups but owners, i.e. managers, users, guests
+ self.assertEqual(len(unrelated), 3)
def test_printable_value_string(self):
- e = self.request().create_entity('Card', title=u'rest test', content=u'du :eid:`1:*ReST*`',
- content_format=u'text/rest')
- self.assertEqual(e.printable_value('content'),
- '<p>du <a class="reference" href="http://testing.fr/cubicweb/cwsource/system">*ReST*</a></p>')
- e.cw_attr_cache['content'] = 'du <em>html</em> <ref rql="CWUser X">users</ref>'
- e.cw_attr_cache['content_format'] = 'text/html'
- self.assertEqual(e.printable_value('content'),
- 'du <em>html</em> <a href="http://testing.fr/cubicweb/view?rql=CWUser%20X">users</a>')
- e.cw_attr_cache['content'] = 'du *texte*'
- e.cw_attr_cache['content_format'] = 'text/plain'
- self.assertEqual(e.printable_value('content'),
- '<p>\ndu *texte*<br/></p>')
- e.cw_attr_cache['title'] = 'zou'
- e.cw_attr_cache['content'] = '''\
+ with self.admin_access.web_request() as req:
+ e = req.create_entity('Card', title=u'rest test',
+ content=u'du :eid:`1:*ReST*`',
+ content_format=u'text/rest')
+ self.assertEqual(e.printable_value('content'),
+ '<p>du <a class="reference" href="http://testing.fr/cubicweb/cwsource/system">*ReST*</a></p>')
+ e.cw_attr_cache['content'] = 'du <em>html</em> <ref rql="CWUser X">users</ref>'
+ e.cw_attr_cache['content_format'] = 'text/html'
+ self.assertEqual(e.printable_value('content'),
+ 'du <em>html</em> <a href="http://testing.fr/cubicweb/view?rql=CWUser%20X">users</a>')
+ e.cw_attr_cache['content'] = 'du *texte*'
+ e.cw_attr_cache['content_format'] = 'text/plain'
+ self.assertEqual(e.printable_value('content'),
+ '<p>\ndu *texte*<br/></p>')
+ e.cw_attr_cache['title'] = 'zou'
+ e.cw_attr_cache['content'] = '''\
a title
=======
du :eid:`1:*ReST*`'''
- e.cw_attr_cache['content_format'] = 'text/rest'
- self.assertEqual(e.printable_value('content', format='text/plain'),
- e.cw_attr_cache['content'])
+ e.cw_attr_cache['content_format'] = 'text/rest'
+ self.assertEqual(e.printable_value('content', format='text/plain'),
+ e.cw_attr_cache['content'])
- e.cw_attr_cache['content'] = u'<b>yo (zou éà ;)</b>'
- e.cw_attr_cache['content_format'] = 'text/html'
- self.assertEqual(e.printable_value('content', format='text/plain').strip(),
- u'**yo (zou éà ;)**')
- if HAS_TAL:
- e.cw_attr_cache['content'] = '<h1 tal:content="self/title">titre</h1>'
- e.cw_attr_cache['content_format'] = 'text/cubicweb-page-template'
- self.assertEqual(e.printable_value('content'),
- '<h1>zou</h1>')
+ e.cw_attr_cache['content'] = u'<b>yo (zou éà ;)</b>'
+ e.cw_attr_cache['content_format'] = 'text/html'
+ self.assertEqual(e.printable_value('content', format='text/plain').strip(),
+ u'**yo (zou éà ;)**')
+ if HAS_TAL:
+ e.cw_attr_cache['content'] = '<h1 tal:content="self/title">titre</h1>'
+ e.cw_attr_cache['content_format'] = 'text/cubicweb-page-template'
+ self.assertEqual(e.printable_value('content'),
+ '<h1>zou</h1>')
def test_printable_value_bytes(self):
- req = self.request()
- e = req.create_entity('File', data=Binary('lambda x: 1'), data_format=u'text/x-python',
- data_encoding=u'ascii', data_name=u'toto.py')
- from cubicweb import mttransforms
- if mttransforms.HAS_PYGMENTS_TRANSFORMS:
- import pygments
- if tuple(int(i) for i in pygments.__version__.split('.')[:2]) >= (1, 3):
- self.assertEqual(e.printable_value('data'),
- '''<div class="highlight"><pre><span class="k">lambda</span> <span class="n">x</span><span class="p">:</span> <span class="mi">1</span>
+ with self.admin_access.web_request() as req:
+ e = req.create_entity('File', data=Binary('lambda x: 1'), data_format=u'text/x-python',
+ data_encoding=u'ascii', data_name=u'toto.py')
+ from cubicweb import mttransforms
+ if mttransforms.HAS_PYGMENTS_TRANSFORMS:
+ import pygments
+ if tuple(int(i) for i in pygments.__version__.split('.')[:2]) >= (1, 3):
+ self.assertEqual(e.printable_value('data'),
+ '''<div class="highlight"><pre><span class="k">lambda</span> <span class="n">x</span><span class="p">:</span> <span class="mi">1</span>
+</pre></div>''')
+ else:
+ self.assertEqual(e.printable_value('data'),
+ '''<div class="highlight"><pre><span class="k">lambda</span> <span class="n">x</span><span class="p">:</span> <span class="mf">1</span>
</pre></div>''')
else:
self.assertEqual(e.printable_value('data'),
- '''<div class="highlight"><pre><span class="k">lambda</span> <span class="n">x</span><span class="p">:</span> <span class="mf">1</span>
-</pre></div>''')
- else:
- self.assertEqual(e.printable_value('data'),
- '''<pre class="python">
-<span style="color: #C00000;">lambda</span> <span style="color: #000000;">x</span><span style="color: #0000C0;">:</span> <span style="color: #0080C0;">1</span>
+ '''<pre class="python">
+ <span style="color: #C00000;">lambda</span> <span style="color: #000000;">x</span><span style="color: #0000C0;">:</span> <span style="color: #0080C0;">1</span>
</pre>''')
- e = req.create_entity('File', data=Binary('*héhéhé*'), data_format=u'text/rest',
- data_encoding=u'utf-8', data_name=u'toto.txt')
- self.assertEqual(e.printable_value('data'),
- u'<p><em>héhéhé</em></p>')
+ e = req.create_entity('File', data=Binary('*héhéhé*'), data_format=u'text/rest',
+ data_encoding=u'utf-8', data_name=u'toto.txt')
+ self.assertEqual(e.printable_value('data'),
+ u'<p><em>héhéhé</em></p>')
def test_printable_value_bad_html(self):
"""make sure we don't crash if we try to render invalid XHTML strings"""
- req = self.request()
- e = req.create_entity('Card', title=u'bad html', content=u'<div>R&D<br>',
- content_format=u'text/html')
- tidy = lambda x: x.replace('\n', '')
- self.assertEqual(tidy(e.printable_value('content')),
- '<div>R&D<br/></div>')
- e.cw_attr_cache['content'] = u'yo !! R&D <div> pas fermé'
- self.assertEqual(tidy(e.printable_value('content')),
- u'yo !! R&D <div> pas fermé</div>')
- e.cw_attr_cache['content'] = u'R&D'
- self.assertEqual(tidy(e.printable_value('content')), u'R&D')
- e.cw_attr_cache['content'] = u'R&D;'
- self.assertEqual(tidy(e.printable_value('content')), u'R&D;')
- e.cw_attr_cache['content'] = u'yo !! R&D <div> pas fermé'
- self.assertEqual(tidy(e.printable_value('content')),
- u'yo !! R&D <div> pas fermé</div>')
- e.cw_attr_cache['content'] = u'été <div> été'
- self.assertEqual(tidy(e.printable_value('content')),
- u'été <div> été</div>')
- e.cw_attr_cache['content'] = u'C'est un exemple sérieux'
- self.assertEqual(tidy(e.printable_value('content')),
- u"C'est un exemple sérieux")
- # make sure valid xhtml is left untouched
- e.cw_attr_cache['content'] = u'<div>R&D<br/></div>'
- self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
- e.cw_attr_cache['content'] = u'<div>été</div>'
- self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
- e.cw_attr_cache['content'] = u'été'
- self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
- e.cw_attr_cache['content'] = u'hop\r\nhop\nhip\rmomo'
- self.assertEqual(e.printable_value('content'), u'hop\nhop\nhip\nmomo')
+ with self.admin_access.web_request() as req:
+ e = req.create_entity('Card', title=u'bad html', content=u'<div>R&D<br>',
+ content_format=u'text/html')
+ tidy = lambda x: x.replace('\n', '')
+ self.assertEqual(tidy(e.printable_value('content')),
+ '<div>R&D<br/></div>')
+ e.cw_attr_cache['content'] = u'yo !! R&D <div> pas fermé'
+ self.assertEqual(tidy(e.printable_value('content')),
+ u'yo !! R&D <div> pas fermé</div>')
+ e.cw_attr_cache['content'] = u'R&D'
+ self.assertEqual(tidy(e.printable_value('content')), u'R&D')
+ e.cw_attr_cache['content'] = u'R&D;'
+ self.assertEqual(tidy(e.printable_value('content')), u'R&D;')
+ e.cw_attr_cache['content'] = u'yo !! R&D <div> pas fermé'
+ self.assertEqual(tidy(e.printable_value('content')),
+ u'yo !! R&D <div> pas fermé</div>')
+ e.cw_attr_cache['content'] = u'été <div> été'
+ self.assertEqual(tidy(e.printable_value('content')),
+ u'été <div> été</div>')
+ e.cw_attr_cache['content'] = u'C'est un exemple sérieux'
+ self.assertEqual(tidy(e.printable_value('content')),
+ u"C'est un exemple sérieux")
+ # make sure valid xhtml is left untouched
+ e.cw_attr_cache['content'] = u'<div>R&D<br/></div>'
+ self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
+ e.cw_attr_cache['content'] = u'<div>été</div>'
+ self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
+ e.cw_attr_cache['content'] = u'été'
+ self.assertEqual(e.printable_value('content'), e.cw_attr_cache['content'])
+ e.cw_attr_cache['content'] = u'hop\r\nhop\nhip\rmomo'
+ self.assertEqual(e.printable_value('content'), u'hop\nhop\nhip\nmomo')
def test_printable_value_bad_html_ms(self):
- req = self.request()
- e = req.create_entity('Card', title=u'bad html', content=u'<div>R&D<br>',
- content_format=u'text/html')
- tidy = lambda x: x.replace('\n', '')
- e.cw_attr_cache['content'] = u'<div x:foo="bar">ms orifice produces weird html</div>'
- # Caution! current implementation of soup2xhtml strips first div element
- content = soup2xhtml(e.printable_value('content'), 'utf-8')
- self.assertMultiLineEqual(content, u'<div>ms orifice produces weird html</div>')
+ with self.admin_access.web_request() as req:
+ e = req.create_entity('Card', title=u'bad html', content=u'<div>R&D<br>',
+ content_format=u'text/html')
+ tidy = lambda x: x.replace('\n', '')
+ e.cw_attr_cache['content'] = u'<div x:foo="bar">ms orifice produces weird html</div>'
+ # Caution! current implementation of soup2xhtml strips first div element
+ content = soup2xhtml(e.printable_value('content'), 'utf-8')
+ self.assertMultiLineEqual(content, u'<div>ms orifice produces weird html</div>')
def test_fulltextindex(self):
- e = self.vreg['etypes'].etype_class('File')(self.request())
- e.cw_attr_cache['description'] = 'du <em>html</em>'
- e.cw_attr_cache['description_format'] = 'text/html'
- e.cw_attr_cache['data'] = Binary('some <em>data</em>')
- e.cw_attr_cache['data_name'] = 'an html file'
- e.cw_attr_cache['data_format'] = 'text/html'
- e.cw_attr_cache['data_encoding'] = 'ascii'
- e._cw.transaction_data = {} # XXX req should be a session
- words = e.cw_adapt_to('IFTIndexable').get_words()
- words['C'].sort()
- self.assertEqual({'C': sorted(['an', 'html', 'file', 'du', 'html', 'some', 'data'])},
- words)
+ with self.admin_access.web_request() as req:
+ e = self.vreg['etypes'].etype_class('File')(req)
+ e.cw_attr_cache['description'] = 'du <em>html</em>'
+ e.cw_attr_cache['description_format'] = 'text/html'
+ e.cw_attr_cache['data'] = Binary('some <em>data</em>')
+ e.cw_attr_cache['data_name'] = 'an html file'
+ e.cw_attr_cache['data_format'] = 'text/html'
+ e.cw_attr_cache['data_encoding'] = 'ascii'
+ e._cw.transaction_data = {} # XXX req should be a session
+ words = e.cw_adapt_to('IFTIndexable').get_words()
+ words['C'].sort()
+ self.assertEqual({'C': sorted(['an', 'html', 'file', 'du', 'html', 'some', 'data'])},
+ words)
def test_nonregr_relation_cache(self):
- req = self.request()
- p1 = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
- p2 = req.create_entity('Personne', nom=u'toto')
- self.execute('SET X evaluee Y WHERE X nom "di mascio", Y nom "toto"')
- self.assertEqual(p1.evaluee[0].nom, "toto")
- self.assertTrue(not p1.reverse_evaluee)
+ with self.admin_access.web_request() as req:
+ p1 = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
+ p2 = req.create_entity('Personne', nom=u'toto')
+ req.execute('SET X evaluee Y WHERE X nom "di mascio", Y nom "toto"')
+ self.assertEqual(p1.evaluee[0].nom, "toto")
+ self.assertTrue(not p1.reverse_evaluee)
def test_complete_relation(self):
- session = self.session
- eid = session.execute(
- 'INSERT TrInfo X: X comment "zou", X wf_info_for U, X from_state S1, X to_state S2 '
- 'WHERE U login "admin", S1 name "activated", S2 name "deactivated"')[0][0]
- trinfo = self.execute('Any X WHERE X eid %(x)s', {'x': eid}).get_entity(0, 0)
- trinfo.complete()
- self.assertTrue(isinstance(trinfo.cw_attr_cache['creation_date'], datetime))
- self.assertTrue(trinfo.cw_relation_cached('from_state', 'subject'))
- self.assertTrue(trinfo.cw_relation_cached('to_state', 'subject'))
- self.assertTrue(trinfo.cw_relation_cached('wf_info_for', 'subject'))
- self.assertEqual(trinfo.by_transition, ())
+ with self.admin_access.repo_cnx() as session:
+ eid = session.execute(
+ 'INSERT TrInfo X: X comment "zou", X wf_info_for U, X from_state S1, X to_state S2 '
+ 'WHERE U login "admin", S1 name "activated", S2 name "deactivated"')[0][0]
+ trinfo = session.execute('Any X WHERE X eid %(x)s', {'x': eid}).get_entity(0, 0)
+ trinfo.complete()
+ self.assertTrue(isinstance(trinfo.cw_attr_cache['creation_date'], datetime))
+ self.assertTrue(trinfo.cw_relation_cached('from_state', 'subject'))
+ self.assertTrue(trinfo.cw_relation_cached('to_state', 'subject'))
+ self.assertTrue(trinfo.cw_relation_cached('wf_info_for', 'subject'))
+ self.assertEqual(trinfo.by_transition, ())
def test_request_cache(self):
- req = self.request()
- user = self.execute('CWUser X WHERE X login "admin"', req=req).get_entity(0, 0)
- state = user.in_state[0]
- samestate = self.execute('State X WHERE X name "activated"', req=req).get_entity(0, 0)
- self.assertTrue(state is samestate)
+ with self.admin_access.web_request() as req:
+ user = req.execute('CWUser X WHERE X login "admin"').get_entity(0, 0)
+ state = user.in_state[0]
+ samestate = req.execute('State X WHERE X name "activated"').get_entity(0, 0)
+ self.assertTrue(state is samestate)
def test_rest_path(self):
- req = self.request()
- note = req.create_entity('Note', type=u'z')
- self.assertEqual(note.rest_path(), 'note/%s' % note.eid)
- # unique attr
- tag = req.create_entity('Tag', name=u'x')
- self.assertEqual(tag.rest_path(), 'tag/x')
- # test explicit rest_attr
- person = req.create_entity('Personne', prenom=u'john', nom=u'doe')
- self.assertEqual(person.rest_path(), 'personne/doe')
- # ambiguity test
- person2 = req.create_entity('Personne', prenom=u'remi', nom=u'doe')
- person.cw_clear_all_caches()
- self.assertEqual(person.rest_path(), unicode(person.eid))
- self.assertEqual(person2.rest_path(), unicode(person2.eid))
- # unique attr with None value (nom in this case)
- friend = req.create_entity('Ami', prenom=u'bob')
- self.assertEqual(friend.rest_path(), unicode(friend.eid))
+ with self.admin_access.web_request() as req:
+ note = req.create_entity('Note', type=u'z')
+ self.assertEqual(note.rest_path(), 'note/%s' % note.eid)
+ # unique attr
+ tag = req.create_entity('Tag', name=u'x')
+ self.assertEqual(tag.rest_path(), 'tag/x')
+ # test explicit rest_attr
+ person = req.create_entity('Personne', prenom=u'john', nom=u'doe')
+ self.assertEqual(person.rest_path(), 'personne/doe')
+ # ambiguity test
+ person2 = req.create_entity('Personne', prenom=u'remi', nom=u'doe')
+ person.cw_clear_all_caches()
+ self.assertEqual(person.rest_path(), unicode(person.eid))
+ self.assertEqual(person2.rest_path(), unicode(person2.eid))
+ # unique attr with None value (nom in this case)
+ friend = req.create_entity('Ami', prenom=u'bob')
+ self.assertEqual(friend.rest_path(), unicode(friend.eid))
def test_can_use_rest_path(self):
self.assertTrue(can_use_rest_path(u'zobi'))
@@ -720,66 +743,66 @@
self.assertFalse(can_use_rest_path(u'zo?bi'))
def test_cw_set_attributes(self):
- req = self.request()
- person = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
- self.assertEqual(person.prenom, u'adrien')
- self.assertEqual(person.nom, u'di mascio')
- person.cw_set(prenom=u'sylvain', nom=u'thénault')
- person = self.execute('Personne P').get_entity(0, 0) # XXX retreival needed ?
- self.assertEqual(person.prenom, u'sylvain')
- self.assertEqual(person.nom, u'thénault')
+ with self.admin_access.web_request() as req:
+ person = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien')
+ self.assertEqual(person.prenom, u'adrien')
+ self.assertEqual(person.nom, u'di mascio')
+ person.cw_set(prenom=u'sylvain', nom=u'thénault')
+ person = req.execute('Personne P').get_entity(0, 0) # XXX retreival needed ?
+ self.assertEqual(person.prenom, u'sylvain')
+ self.assertEqual(person.nom, u'thénault')
def test_cw_set_relations(self):
- req = self.request()
- person = req.create_entity('Personne', nom=u'chauvat', prenom=u'nicolas')
- note = req.create_entity('Note', type=u'x')
- note.cw_set(ecrit_par=person)
- note = req.create_entity('Note', type=u'y')
- note.cw_set(ecrit_par=person.eid)
- self.assertEqual(len(person.reverse_ecrit_par), 2)
+ with self.admin_access.web_request() as req:
+ person = req.create_entity('Personne', nom=u'chauvat', prenom=u'nicolas')
+ note = req.create_entity('Note', type=u'x')
+ note.cw_set(ecrit_par=person)
+ note = req.create_entity('Note', type=u'y')
+ note.cw_set(ecrit_par=person.eid)
+ self.assertEqual(len(person.reverse_ecrit_par), 2)
def test_metainformation_and_external_absolute_url(self):
- req = self.request()
- note = req.create_entity('Note', type=u'z')
- metainf = note.cw_metainformation()
- self.assertEqual(metainf, {'source': {'type': 'native', 'uri': 'system',
- 'use-cwuri-as-url': False},
- 'type': u'Note', 'extid': None})
- self.assertEqual(note.absolute_url(), 'http://testing.fr/cubicweb/note/%s' % note.eid)
- metainf['source'] = metainf['source'].copy()
- metainf['source']['base-url'] = 'http://cubicweb2.com/'
- metainf['extid'] = 1234
- self.assertEqual(note.absolute_url(), 'http://cubicweb2.com/note/1234')
+ with self.admin_access.web_request() as req:
+ note = req.create_entity('Note', type=u'z')
+ metainf = note.cw_metainformation()
+ self.assertEqual(metainf, {'source': {'type': 'native', 'uri': 'system',
+ 'use-cwuri-as-url': False},
+ 'type': u'Note', 'extid': None})
+ self.assertEqual(note.absolute_url(), 'http://testing.fr/cubicweb/note/%s' % note.eid)
+ metainf['source'] = metainf['source'].copy()
+ metainf['source']['base-url'] = 'http://cubicweb2.com/'
+ metainf['extid'] = 1234
+ self.assertEqual(note.absolute_url(), 'http://cubicweb2.com/note/1234')
def test_absolute_url_empty_field(self):
- req = self.request()
- card = req.create_entity('Card', wikiid=u'', title=u'test')
- self.assertEqual(card.absolute_url(),
- 'http://testing.fr/cubicweb/%s' % card.eid)
+ with self.admin_access.web_request() as req:
+ card = req.create_entity('Card', wikiid=u'', title=u'test')
+ self.assertEqual(card.absolute_url(),
+ 'http://testing.fr/cubicweb/%s' % card.eid)
def test_create_and_compare_entity(self):
- req = self.request()
- p1 = req.create_entity('Personne', nom=u'fayolle', prenom=u'alexandre')
- p2 = req.create_entity('Personne', nom=u'campeas', prenom=u'aurelien')
- note = req.create_entity('Note', type=u'z')
- req = self.request()
- p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien',
- connait=p1, evaluee=[p1, p2],
- reverse_ecrit_par=note)
- self.assertEqual(p.nom, 'di mascio')
- self.assertEqual([c.nom for c in p.connait], ['fayolle'])
- self.assertEqual(sorted([c.nom for c in p.evaluee]), ['campeas', 'fayolle'])
- self.assertEqual([c.type for c in p.reverse_ecrit_par], ['z'])
-
- req = self.request()
- auc = req.execute('Personne P WHERE P prenom "aurelien"').get_entity(0,0)
- persons = set()
- persons.add(p1)
- persons.add(p2)
- persons.add(auc)
- self.assertEqual(2, len(persons))
- self.assertNotEqual(p1, p2)
- self.assertEqual(p2, auc)
+ access = self.admin_access
+ with access.web_request() as req:
+ p1 = req.create_entity('Personne', nom=u'fayolle', prenom=u'alexandre')
+ p2 = req.create_entity('Personne', nom=u'campeas', prenom=u'aurelien')
+ note = req.create_entity('Note', type=u'z')
+ p = req.create_entity('Personne', nom=u'di mascio', prenom=u'adrien',
+ connait=p1, evaluee=[p1, p2],
+ reverse_ecrit_par=note)
+ self.assertEqual(p.nom, 'di mascio')
+ self.assertEqual([c.nom for c in p.connait], ['fayolle'])
+ self.assertEqual(sorted([c.nom for c in p.evaluee]), ['campeas', 'fayolle'])
+ self.assertEqual([c.type for c in p.reverse_ecrit_par], ['z'])
+ req.cnx.commit()
+ with access.web_request() as req:
+ auc = req.execute('Personne P WHERE P prenom "aurelien"').get_entity(0,0)
+ persons = set()
+ persons.add(p1)
+ persons.add(p2)
+ persons.add(auc)
+ self.assertEqual(2, len(persons))
+ self.assertNotEqual(p1, p2)
+ self.assertEqual(p2, auc)
if __name__ == '__main__':