I realized the data gets updated but it takes around 15 seconds which I think it is what the model1.py routinely runs. This is a problem for me because I want it to run faster.
On Tuesday, 8 December 2015 13:37:42 UTC-5, Richard wrote: > > Notice if you chage your module file you need to restart web2py... Or user > track change feature, but in the past it was broken don't know if now it > works properly... > http://web2py.com/books/default/chapter/29/04/the-core?search=track_changes > > On Tue, Dec 8, 2015 at 1:33 PM, Aydin S <[email protected] <javascript:>> > wrote: > >> In other words, module1 does not seem to run unless I refresh the >> website. >> >> On Tuesday, 8 December 2015 13:28:26 UTC-5, Aydin S wrote: >>> >>> Here is what I have: >>> >>> In model db.py I have: >>> >>> db.define_table('Table1', >>> Field('var1', 'integer'), >>> from module1 import insert_record >>> insert_record(db) >>> >>> and in a module1 I write on the database and also get access to the >>> database: >>> >>> from gluon import current >>> def insert_record(db): >>> db = current.db >>> test1 = 2 #for example >>> db.Table1.insert(var=test1) >>> test2 = db().select(db.Table1.var1, orderby=~db.Table1.id, >>> limitby=(0, 1))[0].var1 >>> >>> Then test2 is used to show up on a display. test2 changes because var1 >>> changes. The problem is that test2 does seem to get updated when var1 >>> changes without refreshing the website (I refresh the databases). Is it >>> because this action is in the models? Should I use scheduler to do this? >>> >>> On Tuesday, 8 December 2015 13:15:38 UTC-5, Richard wrote: >>>> >>>> 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] <javascript:>. >> 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.
