Actualy, it is displaying the SQL as: select [<gluon.dal.Field object at 0x126F9290>, <gluon.dal.Field object at 0x126F9170>, <gluon.dal.Field object at 0x126F9190>, <gluon.dal.Field object at 0x126F9210>] where <Query [(ticket_id = u'127.0.0.1.2013-01-03.13-22-37.4b65b4db-1e4f-48f1-baca-5f0201fdb53a':<type 'unicode'>)]>
On Thursday, January 3, 2013 11:36:15 AM UTC-2, Felipe Meirelles wrote: > > Just added a self.db.commit() after the insert command, and it worked as > spected, but the load() function cant retrieve the ticket data... > > I've tried to inspect the select stmt with _select(), but it dosent > returns the SQL. Any ideas? > > On Thursday, January 3, 2013 11:07:04 AM UTC-2, Felipe Meirelles wrote: >> >> Massimo, just figured it out: >> >> Using App Engine + Lazy Tables results on _get_table() in restricted.py >> line 77 returning None as the tablename all the times. >> >> So I tried to set lazy_tables = False, then the table is found, but when >> >> table.insert(ticket_id=ticket_id, >> ticket_data=cPickle.dumps(ticket_data), >> created_datetime=request.now) >> >> is called, it returns the right ID, but is not inserted on the database... >> >> Can you guys take a look? >> >> Thanks >> >> >> On Tuesday, December 18, 2012 2:52:56 PM UTC-2, Massimo Di Pierro wrote: >>> >>> If there is no ticket here is a problem talking to database or other >>> internal web2py error, not an application error. Please check for traceback >>> in the app engine logs. >>> >>> On Tuesday, 18 December 2012 06:08:56 UTC-6, Felipe Meirelles wrote: >>>> >>>> Hi, I'm using GAE + Cloud SQL but every time I get an error, there is >>>> no ticket. Can I set web2py to save tickets to database as in Google NoSQL >>>> (big table)? >>> >>> --
