15 seconds... how many tables does your app has? I think you are doing something wrong somewhere...
Richard On Tue, Dec 8, 2015 at 1:53 PM, Aydin S <[email protected]> wrote: > 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]> 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]. >>> 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.
