import os

from py4web import DAL, Cache, Condition, Field, Session, action, request

# define session and cache objects
session = Session()
cache = Cache(size=1000)

# define database and tables
db = DAL(
    "sqlite://storage.db", folder=os.path.join(os.path.dirname(__file__), "databases")
)
db.define_table("todo", Field("info"))
db.commit()

# an example of a custom requirement
user_in_session = Condition(lambda: session.get("user", False))


# example index page using session, template and vue.js
@action("index")  # the function below is exposed as a GET action
@action.uses("index.html", session)  # we use the template index.html and session
def index():
    session["counter"] = session.get("counter", 0) + 1
    session["user"] = {"id": 1}  # store a user in session
    return dict(session=session)


# example of GET/POST/DELETE RESTful APIs


@action("api", method="GET")  # a GET API function
@action.uses(session, db)  # we load the session and db
@action.uses(user_in_session)  # then check we have a valid user in session
def todo():
    return dict(items=db(db.todo).select(orderby=~db.todo.id).as_list())


@action("api", method="POST")
@action.uses(session, db)
@action.uses(user_in_session)
def todo():
    return dict(id=db.todo.insert(info=request.json.get("info")))


@action("api/<id:int>", method="DELETE")
@action.uses(session, db)
@action.uses(user_in_session)
def todo(id):
    db(db.todo.id == id).delete()
    return dict()


# example of caching
@action("uuid")
@cache.memoize(expiration=5)  # here we cache the result for 5 seconds
def uuid():
    import uuid

    return str(uuid.uuid4())