[Erp5-report] ERP5 r24757: 2296 Tests, 1 Errors, 6 Failures

nobody at svn.erp5.org nobody at svn.erp5.org
Tue Dec 2 16:41:13 CET 2008


Test Suite: ERP5
Revision: 24757
Result: FAIL

All tests: 2296
Failures: 6
Errors: 1


The following tests failed:

  testERP5Web                                        (1 errors)
   Make sure that getDocumentValueList works.

  testERP5Catalog                                    (5 failures)
   test_SearchedStringIsNotStripped (testERP5Catalog.TestERP5Catalog)
   test_SubDocumentsWithAcquireLocalRoleSecurityIndexing (testERP5Catalog.TestERP5Catalog)
   test_complex_query (testERP5Catalog.TestERP5Catalog)
   test_multipleRelatedKeyDoMultipleJoins (testERP5Catalog.TestERP5Catalog)
   test_sortOnRelatedKeyWithUnsetRelation (testERP5Catalog.TestERP5Catalog)

  testCMFCategory                                    (1 failures)
   test_getSingleCategoryAcquiredMembershipListOnParent (testCMFCategory.TestCMFCategory)
-------------- next part --------------

ERROR: Make sure that getDocumentValueList works.
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5/tests/testERP5Web.py", line 890, in test_15_getDocumentValueList
    sort_on=[('translated_portal_type', 'ascending')])
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5/Document/WebSection.py", line 257, in getDocumentValueList
    fallback_script_id='WebSection_getDocumentValueList')(**kw)
  File "/usr/lib/erp5/lib/python/Shared/DC/Scripts/Bindings.py", line 311, in __call__
    return self._bindAndExec(args, kw, None)
  File "/usr/lib/erp5/lib/python/Shared/DC/Scripts/Bindings.py", line 348, in _bindAndExec
    return self._exec(bound_data, args, kw)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/tests/ERP5TypeTestCase.py", line 986, in _exec
    return PythonScript_exec(self, *args)
  File "/usr/lib/erp5/lib/python/Products/PythonScripts/PythonScript.py", line 324, in _exec
    result = f(*args, **kw)
  File "Script (Python)", line 3, in WebSection_getDocumentValueList
  File "/usr/lib/erp5/lib/python/AccessControl/ZopeGuards.py", line 341, in guarded_apply
    return builtin_guarded_apply(func, args, kws)
  File "/usr/lib/erp5/lib/python/AccessControl/ZopeGuards.py", line 363, in builtin_guarded_apply
    return func(*arglist, **argdict)
  File "/usr/lib/erp5/lib/python/Shared/DC/Scripts/Bindings.py", line 311, in __call__
    return self._bindAndExec(args, kw, None)
  File "/usr/lib/erp5/lib/python/Shared/DC/Scripts/Bindings.py", line 348, in _bindAndExec
    return self._exec(bound_data, args, kw)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/tests/ERP5TypeTestCase.py", line 986, in _exec
    return PythonScript_exec(self, *args)
  File "/usr/lib/erp5/lib/python/Products/PythonScripts/PythonScript.py", line 324, in _exec
    result = f(*args, **kw)
  File "Script (Python)", line 68, in WebSection_getDocumentValueListBase
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/patches/DA.py", line 220, in DA__call__
    result=DB__.query(query, self.max_rows_)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ZMySQLDA/db.py", line 295, in query
    return self._access_db(method_id='query', args=args, kw=kw)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ZMySQLDA/db.py", line 286, in _access_db
    return getattr(db, method_id)(*args, **kw)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ZMySQLDA/db.py", line 421, in query
    c = self._query(qs)
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ZMySQLDA/db.py", line 396, in _query
    raise OperationalError(m[0], '%s: %s' % (m[1], query))
OperationalError: (1054, 'Unknown column \'related_translation_0.translated_message\' in \'order clause\': SELECT\n  catalog.path AS path, catalog.uid AS uid, catalog.modification_date,\n  catalog.reference, catalog.int_index,  catalog.creation_date , catalog.title, \n  catalog.priority\nFROM\n  (\n    SELECT\n      catalog.uid, catalog.path, catalog.int_index, catalog.modification_date,\n      catalog.reference, my_versioning.language, my_versioning.version,\n      catalog.creation_date, catalog.title\n      , MAX(CONCAT(CASE my_versioning.language\n                                       WHEN  \'en\' THEN \'3\'\n                                       WHEN \'en\' THEN \'2\'\n                                       ELSE \'1\' END,\n                            my_versioning.version)) AS priority\n    FROM\n                catalog AS catalog,\n                translation AS related_translation_0,\n            versioning AS my_versioning\n    WHERE\n      my_versioning.uid = catalog.uid\n                AND (((catalog.security_uid IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)) OR (((((((catalog.viewable_owner = \'zope\'))))))))) AND (((((catalog.portal_type = \'Document\'))))) AND ((((((catalog.validation_state = \'released\')))) OR ((((catalog.validation_state = \'released_alive\')))) OR ((((catalog.validation_state = \'published\')))) OR ((((catalog.validation_state = \'published_alive\')))) OR ((((catalog.validation_state = \'shared\')))) OR ((((catalog.validation_state = \'shared_alive\')))) OR ((((catalog.validation_state = \'public\')))) OR ((((catalog.validation_state = \'validated\')))))) AND (related_translation_0.original_message = catalog.portal_type\n AND related_translation_0.message_context = "portal_type"\n AND related_translation_0.language = \'en\')\n            AND my_versioning.language = \'en\' \n    GROUP BY\n      catalog.uid\n    ORDER BY\n      priority DESC\n  ) AS catalog, versioning AS my_versioning\n     WHERE\n          catalog.uid = my_versioning.uid\n     GROUP BY\n       catalog.reference\n     HAVING \n         MAX(CONCAT(CASE my_versioning.language\n                                       WHEN  \'en\' THEN \'3\'\n                                       WHEN \'en\' THEN \'2\'\n                                       ELSE \'1\' END,\n                            my_versioning.version)) = catalog.priority\n  ORDER BY\n   related_translation_0.translated_message\n\n  LIMIT 1000')



FAIL: test_SearchedStringIsNotStripped (testERP5Catalog.TestERP5Catalog)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2715, in test_SearchedStringIsNotStripped
    compareSet(' foo', [second_doc])
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2713, in compareSet
    self.assertSameSet(document_list, [x.getObject() for x in result])
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/tests/ERP5TypeTestCase.py", line 546, in failIfDifferentSet
    self.failUnless(i in b, msg)
AssertionError: [<Organisation at /erp5_portal_87898169f8a6babfe15e14cbf4d59bab/organisation_module/86>] != [<Organisation at /erp5_portal_87898169f8a6babfe15e14cbf4d59bab/organisation_module/85>]



FAIL: test_SubDocumentsWithAcquireLocalRoleSecurityIndexing (testERP5Catalog.TestERP5Catalog)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 1974, in test_SubDocumentsWithAcquireLocalRoleSecurityIndexing
    self.assertSameSet([obj, ], [x.getObject() for x in result])
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/tests/ERP5TypeTestCase.py", line 546, in failIfDifferentSet
    self.failUnless(i in b, msg)
AssertionError: [<Url at /erp5_portal_87898169f8a6babfe15e14cbf4d59bab/organisation_module/88/1>] != []



FAIL: test_complex_query (testERP5Catalog.TestERP5Catalog)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2261, in test_complex_query
    self.assertEqual(len(catalog(query=query)), 3)
AssertionError: 2 != 3



FAIL: test_multipleRelatedKeyDoMultipleJoins (testERP5Catalog.TestERP5Catalog)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2818, in test_multipleRelatedKeyDoMultipleJoins
    operator='AND'))
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2776, in check
    '%s:\nExpected: %r\nGot: %r' % (description,
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Type/tests/ERP5TypeTestCase.py", line 546, in failIfDifferentSet
    self.failUnless(i in b, msg)
AssertionError: site_reference="foo" AND site_description="bar":
Expected: ['object_1', 'object_12', 'object_13', 'object_14', 'object_23']
Got: ['object_14', 'object_13', 'object_12', 'object_1']



FAIL: test_sortOnRelatedKeyWithUnsetRelation (testERP5Catalog.TestERP5Catalog)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/ERP5Catalog/tests/testERP5Catalog.py", line 2753, in test_sortOnRelatedKeyWithUnsetRelation
    len(person_module.searchFolder(sort_on=[('subordination_title', 'ascending')])))
AssertionError: 2 != 1



FAIL: test_getSingleCategoryAcquiredMembershipListOnParent (testCMFCategory.TestCMFCategory)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/erp5/lib/python/Testing/ZopeTestCase/profiler.py", line 98, in __call__
    testMethod()
  File "/home/buildbot/buildbot_slave/full.ERP5/build/unit_test/Products/CMFCategory/tests/testCMFCategory.py", line 973, in test_getSingleCategoryAcquiredMembershipListOnParent
    portal_type='Person Module'))
AssertionError: ['person_module'] != [<Folder at /erp5_portal_375fd2e06bb46325945c05a27d83aefb/person_module>]



More information about the Erp5-report mailing list