cubicweb: comparison server/test/unittest

equal deleted inserted replaced

-:eccd1885d42e
+:71c143c0ada3
 def teardown_module(*args):
 Repository.get_versions = orig_get_versions
 class CoreHooksTC(RepositoryBasedTC):
 def test_delete_internal_entities(self):
 self.assertRaises(RepositoryError, self.execute,
 'DELETE CWEType X WHERE X name "CWEType"')
 self.assertRaises(RepositoryError, self.execute,
 'DELETE CWRType X WHERE X name "relation_type"')
 self.execute('DELETE X in_group Y WHERE X login "toto", Y name "users"')
 self.assertRaises(ValidationError, self.commit)
 self.execute('DELETE X in_group Y WHERE X login "toto"')
 self.execute('SET X in_group Y WHERE X login "toto", Y name "guests"')
 self.commit()
 def test_delete_required_relations_object(self):
 self.skip('no sample in the schema ! YAGNI ? Kermaat ?')
 def test_static_vocabulary_check(self):
 self.assertRaises(ValidationError,
 self.execute,
 'SET X composite "whatever" WHERE X from_entity FE, FE name "CWUser", X relation_type RT, RT name "in_group"')
 def test_missing_required_relations_subject_inline(self):
 # missing in_group relation
 self.execute('INSERT CWUser X: X login "toto", X upassword "hop"')
 self.assertRaises(ValidationError,
 self.commit)
 def test_delete_if_singlecard1(self):
 eeid = self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P '
 'WHERE Y is EmailAddress, P is EmailPart')[0][0]
 self.execute('SET X sender Y WHERE X is Email, Y is EmailAddress')
 rset = self.execute('Any S WHERE X sender S, X eid %s' % eeid)
 self.assertEquals(len(rset), 1)
 def test_composite_1(self):
 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"')
 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"')
 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P '
 'WHERE Y is EmailAddress, P is EmailPart')
 rset = self.execute('Any X WHERE X is EmailPart')
 self.assertEquals(len(rset), 1)
 self.commit()
 rset = self.execute('Any X WHERE X is EmailPart')
 self.assertEquals(len(rset), 0)
 def test_composite_2(self):
 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"')
 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"')
 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P '
 'WHERE Y is EmailAddress, P is EmailPart')
 self.execute('DELETE Email X')
 self.execute('DELETE EmailPart X')
 self.commit()
 rset = self.execute('Any X WHERE X is EmailPart')
 self.assertEquals(len(rset), 0)
 def test_composite_redirection(self):
 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"')
 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"')
 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P '
 'WHERE Y is EmailAddress, P is EmailPart')
 entity = self.execute('Any A WHERE A eid %s' % entity.eid).get_entity(0, 0)
 self.assertEquals(entity.descr, u'yo')
 self.execute('SET A descr "R&D<p>yo" WHERE A eid %s' % entity.eid)
 entity = self.execute('Any A WHERE A eid %s' % entity.eid).get_entity(0, 0)
 self.assertEquals(entity.descr, u'R&amp;D<p>yo</p>')
 class UserGroupHooksTC(RepositoryBasedTC):
 def test_user_synchronization(self):
 self.create_user('toto', password='hop', commit=False)
 self.assertRaises(AuthenticationError,
 self.repo.connect, u'toto', 'hop')
 self.commit()
 def test_no_created_by_on_deleted_entity(self):
 eid = self.execute('INSERT EmailAddress X: X address "toto@logilab.fr"')[0][0]
 self.execute('DELETE EmailAddress X WHERE X eid %s' % eid)
 self.commit()
 self.failIf(self.execute('Any X WHERE X created_by Y, X eid >= %(x)s', {'x': eid}))
 class CWPropertyHooksTC(RepositoryBasedTC):
 def test_unexistant_eproperty(self):
 ex = self.assertRaises(ValidationError,
 self.execute, 'INSERT CWProperty X: X pkey "bla.bla", X value "hop", X for_user U')
 self.assertEquals(ex.errors, {'pkey': 'unknown property key'})
 ex = self.assertRaises(ValidationError,
 self.execute, 'INSERT CWProperty X: X pkey "bla.bla", X value "hop"')
 self.assertEquals(ex.errors, {'pkey': 'unknown property key'})
 def test_site_wide_eproperty(self):
 ex = self.assertRaises(ValidationError,
 self.execute, 'INSERT CWProperty X: X pkey "ui.site-title", X value "hop", X for_user U')
 self.assertEquals(ex.errors, {'for_user': "site-wide property can't be set for user"})
 def test_bad_type_eproperty(self):
 ex = self.assertRaises(ValidationError,
 self.execute, 'INSERT CWProperty X: X pkey "ui.language", X value "hop", X for_user U')
 self.assertEquals(ex.errors, {'value': u'unauthorized value'})
 ex = self.assertRaises(ValidationError,
 self.execute, 'INSERT CWProperty X: X pkey "ui.language", X value "hop"')
 self.assertEquals(ex.errors, {'value': u'unauthorized value'})
 class SchemaHooksTC(RepositoryBasedTC):
 def test_duplicate_etype_error(self):
 # check we can't add a CWEType or CWRType entity if it already exists one
 # with the same name
 #
 # according to hook order, we'll get a repository or validation error
 self.assertRaises((ValidationError, RepositoryError),
 self.execute, 'INSERT CWEType X: X name "Societe"')
 self.assertRaises((ValidationError, RepositoryError),
 self.execute, 'INSERT CWRType X: X name "in_group"')
 def test_validation_unique_constraint(self):
 self.assertRaises(ValidationError,
 self.execute, 'INSERT CWUser X: X login "admin"')
 try:
 self.execute('INSERT CWUser X: X login "admin"')
 repo.config._cubes = None
 repo.fill_schema()
 RepositoryBasedTC.setUp(self)
 def index_exists(self, etype, attr, unique=False):
 dbhelper = self.session.pool.source('system').dbhelper
 sqlcursor = self.session.pool['system']
 return dbhelper.index_exists(sqlcursor, SQL_PREFIX + etype, SQL_PREFIX + attr, unique=unique)
 def test_base(self):
 schema = self.repo.schema
 dbhelper = self.session.pool.source('system').dbhelper
 sqlcursor = self.session.pool['system']
 self.failIf(schema.has_entity('Societe2'))
 self.failIf(schema.has_entity('concerne2'))
 # schema should be update on insertion (after commit)
 self.execute('INSERT CWEType X: X name "Societe2", X description "", X meta FALSE, X final FALSE')
 self.failIf('subdiv' in snames)
 snames = [name for name, in self.execute('Any N WHERE S is_instance_of Societe, S nom N')]
 self.failUnless('subdiv' in snames)
 snames = [name for name, in self.execute('Any N WHERE S is_instance_of Division, S nom N')]
 self.failUnless('subdiv' in snames)
 def test_perms_synchronization_1(self):
 schema = self.repo.schema
 self.assertEquals(schema['CWUser'].get_groups('read'), set(('managers', 'users')))
 self.failUnless(self.execute('Any X, Y WHERE X is CWEType, X name "CWUser", Y is CWGroup, Y name "users"')[0])
 self.execute('DELETE X read_permission Y WHERE X is CWEType, X name "CWUser", Y name "users"')
 % (eeid, groupeids[0], groupeids[1]))
 self.commit()
 self.execute('Any X WHERE X is CWEType, X name "CWEType"')
 # schema modification hooks tests #########################################
 def test_uninline_relation(self):
 dbhelper = self.session.pool.source('system').dbhelper
 sqlcursor = self.session.pool['system']
 # Personne inline2 Affaire inline
 # insert a person without inline2 relation (not mandatory)
 self.execute('INSERT Personne X: X nom "toto"')
 peid = self.execute('INSERT Personne X: X nom "tutu"')[0][0]
 rset = self.execute('Any X, Y WHERE X inline2 Y')
 self.assertEquals(len(rset), 1)
 self.assertEquals(rset.rows[0], [peid, aeid])
 def test_indexed_change(self):
 dbhelper = self.session.pool.source('system').dbhelper
 sqlcursor = self.session.pool['system']
 try:
 self.execute('SET X indexed TRUE WHERE X relation_type R, R name "sujet"')
 self.failIf(self.schema['sujet'].rproperty('Affaire', 'String', 'indexed'))
 self.failIf(self.index_exists('Affaire', 'sujet'))
 self.commit()
 self.failIf(self.schema['sujet'].rproperty('Affaire', 'String', 'indexed'))
 self.failIf(self.index_exists('Affaire', 'sujet'))
 def test_unique_change(self):
 dbhelper = self.session.pool.source('system').dbhelper
 sqlcursor = self.session.pool['system']
 try:
 try:
 self.execute('INSERT CWConstraint X: X cstrtype CT, DEF constrained_by X '
 'WHERE CT name "UniqueConstraint", DEF relation_type RT, DEF from_entity E,'
 self.failUnless(self.schema['Affaire'].has_unique_values('sujet'))
 self.failUnless(self.index_exists('Affaire', 'sujet', unique=True))
 self.commit()
 self.failIf(self.schema['Affaire'].has_unique_values('sujet'))
 self.failIf(self.index_exists('Affaire', 'sujet', unique=True))
 class WorkflowHooksTC(RepositoryBasedTC):
 def setUp(self):
 RepositoryBasedTC.setUp(self)
 # give access to users group on the user's wf transitions
 # so we can test wf enforcing on euser (managers don't have anymore this
 # enforcement
 self.execute('SET X require_group G WHERE G name "users", X transition_of ET, ET name "CWUser"')
 self.commit()
 def tearDown(self):
 self.execute('DELETE X require_group G WHERE G name "users", X transition_of ET, ET name "CWUser"')
 self.commit()
 RepositoryBasedTC.tearDown(self)
 {'x' : ueid}))
 self.commit()
 initialstate = self.execute('Any N WHERE S name N, X in_state S, X eid %(x)s',
 {'x' : ueid})[0][0]
 self.assertEquals(initialstate, u'activated')
 def test_initial_state(self):
 cnx = self.login('stduser')
 cu = cnx.cursor()
 self.assertRaises(ValidationError, cu.execute,
 'INSERT CWUser X: X login "badaboum", X upassword %(pwd)s, '
 cnx.close()
 # though managers can do whatever he want
 self.execute('INSERT CWUser X: X login "badaboum", X upassword %(pwd)s, '
 'X in_state S, X in_group G WHERE S name "deactivated", G name "users"', {'pwd': 'oops'})
 self.commit()
 # test that the workflow is correctly enforced
 def test_transition_checking1(self):
 cnx = self.login('stduser')
 cu = cnx.cursor()
 ueid = cnx.user(self.current_session()).eid
 self.assertRaises(ValidationError,
 cu.execute, 'SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 {'x': ueid, 's': self.s_activated}, 'x')
 cnx.close()
 def test_transition_checking2(self):
 cnx = self.login('stduser')
 cu = cnx.cursor()
 ueid = cnx.user(self.current_session()).eid
 self.assertRaises(ValidationError,
 cu.execute, 'SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 {'x': ueid, 's': self.s_dummy}, 'x')
 cnx.close()
 def test_transition_checking3(self):
 cnx = self.login('stduser')
 cu = cnx.cursor()
 ueid = cnx.user(self.current_session()).eid
 cu.execute('SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 # get back now
 cu.execute('SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 {'x': ueid, 's': self.s_activated}, 'x')
 cnx.commit()
 cnx.close()
 def test_transition_checking4(self):
 cnx = self.login('stduser')
 cu = cnx.cursor()
 ueid = cnx.user(self.current_session()).eid
 cu.execute('SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 tr = rset.get_entity(1, 0)
 #tr.complete()
 self.assertEquals(tr.comment, None)
 self.assertEquals(tr.from_state[0].eid, self.s_activated)
 self.assertEquals(tr.to_state[0].eid, self.s_deactivated)
 self.session.set_shared_data('trcomment', u'il est pas sage celui-la')
 self.session.set_shared_data('trcommentformat', u'text/plain')
 self.execute('SET X in_state S WHERE X eid %(x)s, S eid %(s)s',
 {'x': ueid, 's': self.s_activated}, 'x')
 self.commit()
 self.create_user('toto')
 cnx = self.login('toto')
 cu = cnx.cursor()
 self.failUnless(cu.execute("INSERT Note X: X type 'a', X in_state S WHERE S name 'todo'"))
 cnx.commit()
 if __name__ == '__main__':
 unittest_main()

branch	tls-sprint
changeset 1787	71c143c0ada3
parent 1398	5fe84a5f7035
child 1977	606923dff11b
child 1981	e6eed4324357