Bug 858122 - Job matrix doesn't work with sqlalchemy 0.7
Summary: Job matrix doesn't work with sqlalchemy 0.7
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: web UI
Version: 0.9
Hardware: Unspecified
OS: Unspecified
low
unspecified
Target Milestone: ---
Assignee: Amit Saha
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-09-18 02:52 UTC by Dan Callaghan
Modified: 2019-05-22 13:44 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-10-11 23:50:20 UTC
Embargoed:


Attachments (Terms of Use)

Description Dan Callaghan 2012-09-18 02:52:43 UTC
2012-09-18 11:55:37,836 cherrypy.msg INFO HTTP: Page handler: <bound method JobMatrix.index of <bkr.server.job_matrix.JobMatrix instance at 0x4680f80>>
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/CherryPy-2.3.0-py2.7.egg/cherrypy/_cphttptools.py", line 121, in _run
    self.main()
  File "/usr/lib/python2.7/site-packages/CherryPy-2.3.0-py2.7.egg/cherrypy/_cphttptools.py", line 264, in main
    body = page_handler(*virtual_path, **self.params)
  File "<string>", line 3, in index
  File "/usr/lib/python2.7/site-packages/turbogears/controllers.py", line 361, in expose
    *args, **kw)
  File "<generated code>", line 0, in run_with_transaction
  File "/usr/lib/python2.7/site-packages/peak/rules/core.py", line 153, in __call__
    return self.body(*args, **kw)
  File "/usr/lib/python2.7/site-packages/turbogears/database.py", line 458, in sa_rwt
    retval = func(*args, **kw)
  File "/usr/lib/python2.7/site-packages/turbogears/controllers.py", line 244, in _expose
    @abstract()
  File "<generated code>", line 0, in _expose
  File "/usr/lib/python2.7/site-packages/peak/rules/core.py", line 153, in __call__
    return self.body(*args, **kw)
  File "/usr/lib/python2.7/site-packages/turbogears/controllers.py", line 390, in <lambda>
    fragment, options, args, kw)))
  File "/usr/lib/python2.7/site-packages/turbogears/controllers.py", line 425, in _execute_func
    output = errorhandling.try_call(func, *args, **kw)
  File "/usr/lib/python2.7/site-packages/turbogears/errorhandling.py", line 77, in try_call
    return func(self, *args, **kw)
  File "/home/dcallagh/work/beaker/Server/bkr/server/job_matrix.py", line 52, in index
    matrix_options['whiteboard_options'] = self.get_whiteboard_options(kw.get('filter'), selected=kw.get('whiteboard'))
  File "/home/dcallagh/work/beaker/Server/bkr/server/job_matrix.py", line 105, in get_whiteboard_options
    query = query.group_by([model.Job.whiteboard]). \
  File "<string>", line 1, in <lambda>
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 50, in generate
    fn(self, *args[1:], **kw)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 1253, in group_by
    criterion = self._adapt_col_list(criterion)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 204, in _adapt_col_list
    for o in cols
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 1409, in _literal_as_text
    "SQL expression object or string expected."
ArgumentError: SQL expression object or string expected.

Comment 1 Amit Saha 2012-09-24 02:44:08 UTC
In Gerrit: http://gerrit.beaker-project.org/#/c/1366/

Comment 3 Dan Callaghan 2012-10-11 23:50:20 UTC
Beaker 0.9.4 has been released.


Note You need to log in before you can comment on or make changes to this bug.