from py4web import action, request, DAL, Field, Session, Cache, user_in, abort, redirect, URL, Field
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 yatl.helpers import INPUT, H1, HTML, BODY, A
from pydal.validators import *
db.define_table('answers',
Field('author', 'reference auth_user', default=auth.user_id, readable=False, writable=False),
Field('userId','reference auth_user',unique=True,readable=False,writable=False),
Field('quest', 'text', requires=IS_NOT_EMPTY(),),
auth.signature
)
db.define_table('posts',
Field('author', 'reference auth_user', default=auth.user_id, writable=False, readable=False),
Field("message", 'text', requires=IS_NOT_EMPTY(), notnull=False),
auth.signature
)
@authenticated()
def index():
codes = []
del codes[:]
r = []
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
else: