Its weird the application seems to work fine but cant create a select() at
the console. The queries in the controllers doesnt fail.
This is the db definition:
if not request.env.web2py_runtime_gae:
db = DAL("mysql://root:@localhost/mydb", pool_size = 10, check_reserved=
None, migrate=True)
import copy
db._adapter.types = copy.copy(db._adapter.types)
db._adapter.types['boolean']='BIT(1)'
db._adapter.TRUE = 1
db._adapter.FALSE = 0
And when i try to execute rows = db(mytable).select() at the interactive
console i get the following traceback.
In [8]: rows = db(db.mytable).select()
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
D:\web2py\applications\myapp\models\05_forms.py in <module>()
----> 1 rows = db(db.mytable).select()
D:\web2py\gluon\packages\dal\pydal\base.pyc in __getattr__(self, key)
904 tablename, fields, args = self._LAZY_TABLES.pop(key)
905 return self.lazy_define_table(tablename, *fields, **args
)
--> 906 return super(DAL, self).__getattr__(key)
907
908 def __setattr__(self, key, value):
D:\web2py\gluon\packages\dal\pydal\helpers\classes.pyc in __getattr__(self,
key)
28 return self.__dict__.__getitem__(str(key))
29 except:
---> 30 raise AttributeError
31
32 __setitem__ = object.__setattr__
AttributeError:
Before the adapter change, ive droped the database and the migrations so it
starts fresh again.
All the tables has auth.signature so theres a boolean there.
Ill try tinyint but its not ideal.
--
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/d/optout.
