Difficult to say without seeing the code, you may need db.commit() or not. Richard
On Tue, Dec 8, 2015 at 1:05 PM, Aydin S <[email protected]> wrote: > I got another question if you could help. > The database does not get updated without I refresh the website in this > scenario. I don't know why it is, do I need to use commit() somewhere or > since this is in the models it will not run as the variable inside the > module changes? Do I have to use scheduler? Any idea? > > On Monday, 7 December 2015 18:56:10 UTC-5, Hans Soflao wrote: >> >> Thanks Anthony and Richard. >> Yes, my variable was inside the module and was not a global one. Thanks >> for the link, I am running the variable inside the function and it is local. >> I tested the code and it worked. >> >> On Monday, December 7, 2015 at 12:44:40 PM UTC-5, Richard wrote: >>> >>> @Hans, what is your question about variable in module exactly? >>> >>> What you did seems correct to me... >>> >>> About "db = current.db" be aware of that : >>> http://web2py.com/books/default/chapter/29/04/the-core#Warning--Do-not-use-the-current-object-in-global-scope-in-a-module >>> >>> On Mon, Dec 7, 2015 at 12:13 PM, Hans Soflao <[email protected]> wrote: >>> >>>> Thank you, I used the method Anthony mentioned and it worked. >>>> Now a follow up question, in order to have access to database in this >>>> module to assign var1 (defined in the database) to var2 (defined in the >>>> module) what is the best method? >>>> >>>> For instance to have access to the latest row of data in the table1 >>>> defined in the model as >>>> db.define_table('Table1', >>>> Field('F1', 'integer')) >>>> >>>> should I have in the model the following?: >>>> >>>> from gluon import current >>>> current.db = db >>>> >>>> and in the module module1.py?: >>>> >>>> def module1(): >>>> db = current.db >>>> var2=db().select(db.Table1.var1, orderby=~db.Table1.id, >>>> limitby=(0, 1))[0].var1 >>>> >>>> Thanks >>>> >>>> >>>> >>>> On Friday, December 4, 2015 at 9:39:35 AM UTC-5, Aydin S wrote: >>>> >>>>> This might be asked before and I already found a similar question in >>>>> here: https://groups.google.com/forum/#!topic/web2py/0k0Fvw6fmb8 >>>>> but this seemed a bit confusing. How to write on database from within >>>>> a module? >>>>> I have a table defined in db.py (model) as follows: >>>>> db.define_table('Table1', >>>>> Field('F1', 'integer')) >>>>> >>>>> Now I have a variable var1 in the module module1.py that I want to >>>>> write it into F1. >>>>> >>>>> var1=2 >>>>> >>>>> Is this similar approach to read a variable from database in a module? >>>>> >>>>> >>>>> >>>>> -- >>>> 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. >>>> >>> >>> -- > 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. > -- 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.
