models.py

from app import db
from sqlalchemy import func, types
from sqlalchemy.dialects import postgresql


class JSONCache(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    key = db.Column(db.String, nullable=False, index=True)
    data = db.Column(postgresql.JSONB, nullable=False)
    timestamp = db.Column(types.TIMESTAMP, server_default=func.now(), nullable=False)

    __mapper_args__ = {"order_by": timestamp.desc()}