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.
