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] > <javascript:>> 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] <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.
