Thanks a lot.
It worked.
Regards
On Thursday, February 27, 2020 at 8:46:00 PM UTC+3, Jim S wrote:
>
> Try commenting out
>
> db = DAL("sqlite://xstorage.db", folder=os.path.join(os.path.dirname(
> __file__), "databases"))
>
> in models.py
>
> Do you already have that in common.py?
>
> In your controller you're importing db from common, but the instance in
> common doesn't have any tables defined. You redefined db in models.py and
> added the table to that instance of it.
>
> I think the solution is to move the statement above from models.py to
> common.py
>
> -Jim
>
>
>
>
> On Thursday, February 27, 2020 at 11:29:39 AM UTC-6, Maurice Waka wrote:
>>
>> In my models, I have:
>>
>> import os
>> import datetime as dt
>> from datetime import datetime, timedelta, date
>> from py4web import action, request, DAL, Field, Session, Cache, user_in
>> from py4web.utils.auth import Auth
>> from py4web import action, request, abort, redirect, URL, Field
>> from py4web.utils.form import Form, FormStyleBulma
>> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>> from pydal.validators import * #IS_NOT_EMPTY, IS_INT_IN_RANGE,
>> IS_IN_SET, IS_IN_DB, IS_EMAIL, IS_MATCH
>> from pydal.validators import *
>> from . common import db, session, T, cache, authenticated,
>> unauthenticated, Field
>> from pydal.validators import *
>>
>> # exposes services necessary to access the db.thing via ajax
>> publisher = Publisher(db, policy=ALLOW_ALL_POLICY)
>> # define session and cache objects
>> session = Session(secret="some secret")
>> cache = Cache(size=1000)
>>
>> # define database and tables
>> db = DAL("sqlite://xstorage.db", folder=os.path.join(os.path.dirname(
>> __file__), "databases"))
>>
>> auth = Auth(session, db)
>> # (configure here)
>> auth.enable()
>>
>> db.define_table('answers',
>> Field('author', 'reference auth_user', default=auth.
>> user_id, writable=False, readable=False),
>> Field("message", 'text', requires=IS_NOT_EMPTY(), notnull
>> =False),
>> auth.signature
>> )
>>
>>
>>
>> In the controller:
>>
>>
>> from pydal.validators import *
>> from datetime import datetime, timedelta, date
>> from py4web.utils.auth import Auth
>> from py4web.utils.form import Form, FormStyleBulma
>> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>> from .common import db, session, T, cache, auth, logger, authenticated,
>> unauthenticated
>> from py4web import action, request, DAL, Field, Session, Cache, user_in,
>> abort, redirect, URL, Translator
>> from pydal.validators import IS_NOT_EMPTY, IS_INT_IN_RANGE, IS_IN_SET,
>> IS_IN_DB, IS_EMAIL, IS_MATCH
>> from yatl.helpers import A, TEXTAREA, INPUT, TR, TD, TABLE, DIV, LABEL,
>> FORM, SELECT, OPTION, P, H1, H2, H3, H4, H5, HTML, BODY
>> from . wellness_main import report
>> from . r_image import img_report
>>
>> auth = Auth(session, db)
>> # (configure here)
>> auth.enable()
>>
>>
>> @authenticated()
>> @action.uses(session, db, T, auth.user)
>> def index():
>> yesterday = dt.datetime.utcnow() - dt.timedelta(days=1)
>> db(db.answers.modified_on < yesterday).delete()
>> """Avoid an empty table"""
>> user = db(db.posts.author== auth.user_id).select(db.posts.id,
>> db.posts.author, orderby=~db.posts.id, limitby=(0,1)).first()
>> if user.author if user else None == auth.user_id:
>> pass
>> ....more code..
>> return dict(...)
>>
>> Regards
>>
>>
>> On Thursday, February 27, 2020 at 8:09:00 PM UTC+3, Jim S wrote:
>>>
>>> Yes, I am aware of that, but what file is that in? You didn't specify.
>>> Is that in the same controller the other snippet is in? If so, then you're
>>> redfining db and the table in your controller which in your second to last
>>> line of your post you say you're not doing.
>>>
>>> I'm confused... I'd like to help, but need a clear picture of a minimal
>>> common.py, models.py and your controller that reproduces this error.
>>>
>>> -Jim
>>>
>>> On Thursday, February 27, 2020 at 10:05:28 AM UTC-6, Maurice Waka wrote:
>>>>
>>>> I already have that, see above code second last line on imports
>>>>
>>>> On Thursday, February 27, 2020 at 4:35:25 PM UTC+3, Jim S wrote:
>>>>>
>>>>> Where is db being defined in your controller? Are you importing it
>>>>> from common?
>>>>>
>>>>> In my controller I have
>>>>>
>>>>> from ..common import db, session, T, cache, auth, logger
>>>>>
>>>>> and later
>>>>>
>>>>> @action.uses("applications/index.html", session, db, T, auth.user)
>>>>> def index():
>>>>> page['sub_title'] = A('MENU', _href=URL('index'))
>>>>> return dict(page=page)
>>>>>
>>>>> Does that help? If not, can you post a minimal common.py, models.py
>>>>> and your controller?
>>>>>
>>>>> -Jim
>>>>>
>>>>> On Thursday, February 27, 2020 at 5:55:23 AM UTC-6, Maurice Waka wrote:
>>>>>>
>>>>>> Hello, from this code, I have already defined my table in models as
>>>>>> follows:
>>>>>>
>>>>>> import os
>>>>>> import datetime as dt
>>>>>> from datetime import datetime, timedelta, date
>>>>>> from py4web import action, request, DAL, Field, Session, Cache,
>>>>>> user_in
>>>>>> from py4web.utils.auth import Auth
>>>>>> from py4web import action, request, abort, redirect, URL, Field
>>>>>> from py4web.utils.form import Form, FormStyleBulma
>>>>>> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>>>>>> from pydal.validators import * #IS_NOT_EMPTY, IS_INT_IN_RANGE,
>>>>>> IS_IN_SET, IS_IN_DB, IS_EMAIL, IS_MATCH
>>>>>> from pydal.validators import *
>>>>>> from . common import db, session, T, cache, authenticated,
>>>>>> unauthenticated, Field
>>>>>> from pydal.validators import *
>>>>>>
>>>>>>
>>>>>> ### Define your table below
>>>>>>
>>>>>>
>>>>>> # exposes services necessary to access the db.thing via ajax
>>>>>> publisher = Publisher(db, policy=ALLOW_ALL_POLICY)
>>>>>> # define session and cache objects
>>>>>> session = Session(secret="some secret")
>>>>>> cache = Cache(size=1000)
>>>>>>
>>>>>>
>>>>>> # define database and tables
>>>>>> #connection = sqlite.connect('cache.db', timeout=10)
>>>>>> db = DAL("sqlite://xstorage.db", folder=os.path.join(os.path.dirname(
>>>>>> __file__), "databases"))#db = DAL("sqlite://storage.db",
>>>>>> folder=os.path.join(os.path.dirname(__file__), "databases"))
>>>>>> #db = DAL(
>>>>>> "postgres://mauricewaka:b3th32dau2a##@localhost:5432/py4db",
>>>>>> migrate=False)
>>>>>> auth = Auth(session, db)
>>>>>> # (configure here)
>>>>>> auth.enable()
>>>>>>
>>>>>>
>>>>>> db.define_table('answers',
>>>>>> Field('author', 'reference auth_user', default=auth.
>>>>>> user_id, writable=False, readable=False),
>>>>>> Field("message", 'text', requires=IS_NOT_EMPTY(),
>>>>>> notnull=False),
>>>>>> auth.signature
>>>>>> )
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> In the controllers, this is my code:
>>>>>>
>>>>>> @authenticated()
>>>>>> @action.uses(auth.user)
>>>>>> def index():
>>>>>>
>>>>>> ...some code...
>>>>>> yesterday = dt.datetime.utcnow() - dt.timedelta(days=1)
>>>>>>
>>>>>> db(db.answers.modified_on < yesterday).delete()
>>>>>> ...some more code....
>>>>>>
>>>>>>
>>>>>>
>>>>>> But I get this errors:
>>>>>> Traceback (most recent call last):
>>>>>> File "/home/maurice/py4web/py4web/core.py", line 551, in wrapper
>>>>>> ret = func(*func_args, **func_kwargs)
>>>>>> File "/home/maurice/py4web/py4web/core.py", line 512, in wrapper
>>>>>> ret = func(*args, **kwargs)
>>>>>> File "/home/maurice/py4web/py4web/core.py", line 512, in wrapper
>>>>>> ret = func(*args, **kwargs)
>>>>>> File "apps/scaffoldx/controllers.py", line 571, in index
>>>>>> db(db.answers.modified_on < yesterday).delete()
>>>>>> File
>>>>>> "/home/maurice/.local/lib/python3.6/site-packages/pydal/base.py",
>>>>>> line 763, in __getattr__
>>>>>> return BasicStorage.__getattribute__(self, key)
>>>>>> AttributeError: 'DAL' object has no attribute 'answers'
>>>>>>
>>>>>>
>>>>>>
>>>>>> What could be wrong here and how can I solve it?
>>>>>>
>>>>>> N/B
>>>>>>
>>>>>> I have tried to define the table inside the controller code with an
>>>>>> error coming as : 'table already defined'. When I remove the definition
>>>>>> then the above error comes.
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>>
--
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/6e23e2f5-0ada-45d4-aed0-eb4425930d54%40googlegroups.com.
