diff options
Diffstat (limited to 'cli/app/sql/models/tile.py')
| -rw-r--r-- | cli/app/sql/models/tile.py | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/cli/app/sql/models/tile.py b/cli/app/sql/models/tile.py index 01b3fab..85ee1bf 100644 --- a/cli/app/sql/models/tile.py +++ b/cli/app/sql/models/tile.py @@ -1,18 +1,20 @@ -from sqlalchemy import create_engine, Table, Column, Text, String, Integer, DateTime, JSON +from sqlalchemy import create_engine, Table, Column, Text, String, Integer, DateTime, JSON, ForeignKey +from sqlalchemy.orm import relationship import sqlalchemy.sql.functions as func from sqlalchemy_utc import UtcDateTime, utcnow from wtforms_alchemy import ModelForm from app.sql.common import db, Base, Session +# from app.sql.models.graph import Graph +# from app.sql.models.page import Page -from app.utils.file_utils import sha256_tree from app.settings import app_cfg from os.path import join class Tile(Base): """Table for storing references to tiles""" - __tablename__ = 'tiles' + __tablename__ = 'tile' id = Column(Integer, primary_key=True) graph_id = Column(Integer, ForeignKey('graph.id'), nullable=True) page_id = Column(Integer, ForeignKey('page.id'), nullable=True) @@ -20,7 +22,7 @@ class Tile(Base): type = Column(String(16, convert_unicode=True), nullable=False) settings = Column(JSON, default={}, nullable=True) created_at = Column(UtcDateTime(), default=utcnow()) - updated_at = Column(UtcDateTime(), default=utcnow()) + updated_at = Column(UtcDateTime(), onupdate=utcnow()) def toJSON(self): return { @@ -34,10 +36,9 @@ class Tile(Base): 'updated_at': self.updated_at, } - class TileForm(ModelForm): class Meta: model = Tile - exclude = ['graph_id', 'page_id', 'target_page_id', 'settings', 'created_at', 'updated_at'] + # exclude = ['graph_id', 'page_id', 'target_page_id', 'settings', 'created_at', 'updated_at'] def get_session(): return Session() |
