Well, the problem is when the ticket is saved, self.db points to <DAL uri="google:sql://******:novello-solutionworkshop:novello-solutionworkshop/novello_test"> but when load() is called, it points to <DAL uri="gae">.
Where the admin application DAL is defined? On Thursday, January 3, 2013 11:47:38 AM UTC-2, Felipe Meirelles wrote: > > 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)? >>>> >>>> --
