I am not sure I understand the context here. Why do you have two dal uri? What load function?
On Thursday, 3 January 2013 08:31:45 UTC-6, Felipe Meirelles wrote: > > 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)? >>>>> >>>>> --
