It seems that change
14bcad629eb2b73266b11b4c9dbf63499c73d38b<https://github.com/web2py/web2py/commit/14bcad629eb2b73266b11b4c9dbf63499c73d38b>
modified
the way SQLTABLE handled column names by using this regex for table.field:
REGEX_TABLE_DOT_FIELD = re.compile('^(\w+)\.([^.]+)$')
This has caused a backwards compatibility problem when doing the following:
In [1]: count = db.auth_user.id.count()
In [2]: a = db().select(db.auth_user.first_name, count,
groupby=db.auth_user.first_name)
In [3]: SQLTABLE(a)
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
/Users/oldgrutz/Documents/SPA/Kvasir/grutz-kvasir-virtenv/web2py/applications/kvgrutz/models/scheduler.py
in <module>()
----> 1 SQLTABLE(a)
/Users/oldgrutz/Documents/SPA/Kvasir/grutz-kvasir-virtenv/web2py/gluon/sqlhtml.py
in __init__(self, sqlrows, linkto, upload, orderby, headers, truncate,
columns, th_link, extracolumns, selectid, renderstyle, cid, colgroup,
**attributes)
2912 return
2913 if not columns:
-> 2914 columns =
['.'.join(sqlrows.db._adapter.REGEX_TABLE_DOT_FIELD.match(c).groups()) for
c in sqlrows.colnames]
2915 if headers == 'fieldname:capitalize':
2916 headers = {}
AttributeError: 'NoneType' object has no attribute 'groups'
In [4]:
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
