Example: In [1]: k = db.konsulta(3514998)
In [2]: k.ok Out[2]: 1L (I change the ok value of this record id DB in mysql's console (and committed it) for 2, for example. Then came back to my web2py shell and again: In [3]: k = db.konsulta(3514998) In [4]: k.ok Out[4]: 1L If I leave console and repeat that I get: In [1]: k = db.konsulta(3514998) In [2]: k.ok Out[2]: 2L I'd like to get the updated value (2) without leave and return to shell.... Thanks... On Friday, April 1, 2016 at 5:02:58 PM UTC-3, Niphlod wrote: > > please clarify. if you fetch it back isn't modified, so how can you tell > the data is actually "modified in the DB" ? > > On Friday, April 1, 2016 at 6:21:46 PM UTC+2, Marcello wrote: >> >> Yes. Sure... the data is modified in the DB. >> >> >> On Friday, April 1, 2016 at 12:14:51 PM UTC-3, Niphlod wrote: >>> >>> sure the other process has commit()ed the changes ? that's what >>> transactions are for: until a change is commit()ed, no changes are visible. >>> >>> >>> BTW: mysql has the weirdest default setting of not allowing to see >>> changes from OTHER processes until the process which reads commit()s itself >>> (which may be your case). >>> Try to call db.commit() on the "shell" process even if you didn't issue >>> any update() statement yet. The restriction explained earlier still >>> applies: if the other process doesn't commit(), your shell will still see >>> no changes at all. >>> >>> On Friday, April 1, 2016 at 5:07:52 PM UTC+2, Marcello wrote: >>>> >>>> I tried it. >>>> It gives me the old value. >>>> I have to leave the shell and enter again to refresh it... >>>> >>>> This is my problem >>>> >>>> >>>> >>>> On Friday, April 1, 2016 at 11:53:52 AM UTC-3, Niphlod wrote: >>>>> >>>>> yep, you need to re-select it ... >>>>> >>>>> On Friday, April 1, 2016 at 3:26:39 PM UTC+2, Marcello wrote: >>>>>> >>>>>> Hello, >>>>>> >>>>>> I have a function that I call in a shell... >>>>>> I load a record from a database and do some stuff.. >>>>>> >>>>>> Problem is that in the meantime the record may be modified in the >>>>>> server... >>>>>> >>>>>> Is there a way to reload the record from the database to track >>>>>> possible changes ?? >>>>>> (I'm using mysql) >>>>>> >>>>>> >>>>>> Thanks, >>>>>> >>>>>> Marcello >>>>>> >>>>> -- 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.
