[syncschema hooks] simplify core types definition be reusing schema sets (remove typos on the way)
# -*- coding: utf-8 -*-# copyright 2003-2010 LOGILAB S.A. (Paris, FRANCE), all rights reserved.# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr## This file is part of CubicWeb.## CubicWeb is free software: you can redistribute it and/or modify it under the# terms of the GNU Lesser General Public License as published by the Free# Software Foundation, either version 2.1 of the License, or (at your option)# any later version.## CubicWeb is distributed in the hope that it will be useful, but WITHOUT# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS# FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more# details.## You should have received a copy of the GNU Lesser General Public License along# with CubicWeb. If not, see <http://www.gnu.org/licenses/>."""functional tests for core hooksnote: most schemahooks.py hooks are actually tested in unittest_migrations.py"""fromlogilab.common.testlibimportTestCase,unittest_mainfromdatetimeimportdatetimefromcubicwebimportValidationError,AuthenticationError,BadConnectionIdfromcubicweb.devtools.testlibimportCubicWebTCclassCoreHooksTC(CubicWebTC):deftest_delete_internal_entities(self):self.assertRaises(ValidationError,self.execute,'DELETE CWEType X WHERE X name "CWEType"')self.assertRaises(ValidationError,self.execute,'DELETE CWRType X WHERE X name "relation_type"')self.assertRaises(ValidationError,self.execute,'DELETE CWGroup X WHERE X name "owners"')deftest_delete_required_relations_subject(self):self.execute('INSERT CWUser X: X login "toto", X upassword "hop", X in_group Y ''WHERE Y name "users"')self.commit()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()deftest_delete_required_relations_object(self):self.skip('no sample in the schema ! YAGNI ? Kermaat ?')deftest_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"')deftest_missing_required_relations_subject_inline(self):# missing in_group relationself.execute('INSERT CWUser X: X login "toto", X upassword "hop"')self.assertRaises(ValidationError,self.commit)deftest_inlined(self):self.assertEquals(self.repo.schema['sender'].inlined,True)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"')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)deftest_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')self.failUnless(self.execute('Email X WHERE X sender Y'))self.commit()self.execute('DELETE Email X')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)deftest_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.commit()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)deftest_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')self.execute('INSERT Email X: X messageid "<2345>", X subject "test2", X sender Y, X recipients Y ''WHERE Y is EmailAddress')self.commit()self.execute('DELETE X parts Y WHERE X messageid "<1234>"')self.execute('SET X parts Y WHERE X messageid "<2345>"')self.commit()rset=self.execute('Any X WHERE X is EmailPart')self.assertEquals(len(rset),1)self.assertEquals(rset.get_entity(0,0).reverse_parts[0].messageid,'<2345>')deftest_unsatisfied_constraints(self):releid=self.execute('SET U in_group G WHERE G name "owners", U login "admin"')[0][0]ex=self.assertRaises(ValidationError,self.commit)self.assertEquals(ex.errors,{'in_group-object':u'RQLConstraint NOT O name "owners" failed'})deftest_html_tidy_hook(self):req=self.request()entity=req.create_entity('Workflow',name=u'wf1',description_format=u'text/html',description=u'yo')self.assertEquals(entity.description,u'yo')entity=req.create_entity('Workflow',name=u'wf2',description_format=u'text/html',description=u'<b>yo')self.assertEquals(entity.description,u'<b>yo</b>')entity=req.create_entity('Workflow',name=u'wf3',description_format=u'text/html',description=u'<b>yo</b>')self.assertEquals(entity.description,u'<b>yo</b>')entity=req.create_entity('Workflow',name=u'wf4',description_format=u'text/html',description=u'<b>R&D</b>')self.assertEquals(entity.description,u'<b>R&D</b>')entity=req.create_entity('Workflow',name=u'wf5',description_format=u'text/html',description=u"<div>c'est <b>l'été")self.assertEquals(entity.description,u"<div>c'est <b>l'été</b></div>")deftest_nonregr_html_tidy_hook_no_update(self):entity=self.request().create_entity('Workflow',name=u'wf1',description_format=u'text/html',description=u'yo')entity.set_attributes(name=u'wf2')self.assertEquals(entity.description,u'yo')entity.set_attributes(description=u'R&D<p>yo')entity.pop('description')self.assertEquals(entity.description,u'R&D<p>yo</p>')deftest_metadata_cwuri(self):entity=self.request().create_entity('Workflow',name=u'wf1')self.assertEquals(entity.cwuri,self.repo.config['base-url']+'eid/%s'%entity.eid)deftest_metadata_creation_modification_date(self):_now=datetime.now()entity=self.request().create_entity('Workflow',name=u'wf1')self.assertEquals((entity.creation_date-_now).seconds,0)self.assertEquals((entity.modification_date-_now).seconds,0)deftest_metadata_created_by(self):entity=self.request().create_entity('Bookmark',title=u'wf1',path=u'/view')self.commit()# fire operationsself.assertEquals(len(entity.created_by),1)# make sure we have only one creatorself.assertEquals(entity.created_by[0].eid,self.session.user.eid)deftest_metadata_owned_by(self):entity=self.request().create_entity('Bookmark',title=u'wf1',path=u'/view')self.commit()# fire operationsself.assertEquals(len(entity.owned_by),1)# make sure we have only one ownerself.assertEquals(entity.owned_by[0].eid,self.session.user.eid)deftest_user_login_stripped(self):u=self.create_user(' joe ')tname=self.execute('Any L WHERE E login L, E eid %(e)s',{'e':u.eid})[0][0]self.assertEquals(tname,'joe')self.execute('SET X login " jijoe " WHERE X eid %(x)s',{'x':u.eid})tname=self.execute('Any L WHERE E login L, E eid %(e)s',{'e':u.eid})[0][0]self.assertEquals(tname,'jijoe')classUserGroupHooksTC(CubicWebTC):deftest_user_synchronization(self):self.create_user('toto',password='hop',commit=False)self.assertRaises(AuthenticationError,self.repo.connect,u'toto',password='hop')self.commit()cnxid=self.repo.connect(u'toto',password='hop')self.failIfEqual(cnxid,self.session.id)self.execute('DELETE CWUser X WHERE X login "toto"')self.repo.execute(cnxid,'State X')self.commit()self.assertRaises(BadConnectionId,self.repo.execute,cnxid,'State X')deftest_user_group_synchronization(self):user=self.session.userself.assertEquals(user.groups,set(('managers',)))self.execute('SET X in_group G WHERE X eid %s, G name "guests"'%user.eid)self.assertEquals(user.groups,set(('managers',)))self.commit()self.assertEquals(user.groups,set(('managers','guests')))self.execute('DELETE X in_group G WHERE X eid %s, G name "guests"'%user.eid)self.assertEquals(user.groups,set(('managers','guests')))self.commit()self.assertEquals(user.groups,set(('managers',)))deftest_user_composite_owner(self):ueid=self.create_user('toto').eid# composite of euser should be owned by the euser regardless of who created itself.execute('INSERT EmailAddress X: X address "toto@logilab.fr", U use_email X ''WHERE U login "toto"')self.commit()self.assertEquals(self.execute('Any A WHERE X owned_by U, U use_email X,''U login "toto", X address A')[0][0],'toto@logilab.fr')deftest_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}))classCWPropertyHooksTC(CubicWebTC):deftest_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-subject':'unknown property key'})ex=self.assertRaises(ValidationError,self.execute,'INSERT CWProperty X: X pkey "bla.bla", X value "hop"')self.assertEquals(ex.errors,{'pkey-subject':'unknown property key'})deftest_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-subject':"site-wide property can't be set for user"})deftest_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-subject':u'unauthorized value'})ex=self.assertRaises(ValidationError,self.execute,'INSERT CWProperty X: X pkey "ui.language", X value "hop"')self.assertEquals(ex.errors,{'value-subject':u'unauthorized value'})classSchemaHooksTC(CubicWebTC):deftest_duplicate_etype_error(self):# check we can't add a CWEType or CWRType entity if it already exists one# with the same nameself.assertRaises(ValidationError,self.execute,'INSERT CWEType X: X name "CWUser"')self.assertRaises(ValidationError,self.execute,'INSERT CWRType X: X name "in_group"')deftest_validation_unique_constraint(self):self.assertRaises(ValidationError,self.execute,'INSERT CWUser X: X login "admin"')try:self.execute('INSERT CWUser X: X login "admin"')exceptValidationError,ex:self.assertIsInstance(ex.entity,int)self.assertEquals(ex.errors,{'login-subject':'the value "admin" is already used, use another one'})if__name__=='__main__':unittest_main()