Thank you for the replies,
Just to be sure I understand you, are you suggesting doing something like
the following instead?
>>default.py
def entry_point()
db = get_db()
# use database
>>db.py
from gluon.packages.dal.pydal import DAL, Field
def get_db()
db = DAL("sqlite://storage.sqlite")
db.define_table(
"test",
Field("myid", default=DEFAULT_VALUE, length=15),
Field("name", default=DEFAULT_VALUE, length=15),
Field("code", default=DEFAULT_VALUE, length=2),
)
return db
On Monday, February 6, 2017 at 12:17:03 PM UTC-8, Anthony wrote:
>
> On Friday, February 3, 2017 at 4:05:55 PM UTC-5, MarkEdson AtWork wrote:
>>
>> I found a similar issue with a db.py module with code like this in it...
>>
>> from gluon.packages.dal.pydal import DAL, Field
>> db = DAL("sqlite://storage.sqlite")
>> db.define_table(
>> "test",
>> Field("myid", default=DEFAULT_VALUE, length=15),
>> Field("name", default=DEFAULT_VALUE, length=15),
>> Field("code", default=DEFAULT_VALUE, length=2),
>> )
>>
>>
> How are you using that module within your app?
>
> Most likely, you should not be defining the db object at the top level of
> your module. If you do that, you will have a single db object that lives
> across all requests. The problem with that is if you dynamically change any
> attributes of any models in some requests (e.g., temporarily changing the
> default value or validator of a field), those changes will persist across
> all requests (until changed again somewhere else).
>
> Instead, you should define the db object and its models for each request.
> If you want to keep the code in a module, put it inside of functions or
> classes and call those functions/classes from your app's model or
> controller code.
>
> Anthony
>
--
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.
