import os
import datetime as dt
from datetime import datetime, timedelta, date
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, 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:
db.posts.insert(message="Welcome "+auth_user.first_name+'.'+' Thank
you for signing in with us. Blah blah blah.', author=auth.user_id,
created_by=auth.user_id, modified_by=auth.user_id)
db.commit()
On Sunday, February 23, 2020 at 8:28:28 PM UTC+3, Val K wrote:
>
> Show your code, please
--
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/c8e0ba24-bb0d-4329-a1ad-d183079dc55f%40googlegroups.com.
