From 70d1b24d2eb249561766d78a49109667933982ea Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Wed, 8 Jul 2020 00:35:58 +0200 Subject: add fields to media --- animism-align/cli/app/sql/models/media.py | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'animism-align/cli/app/sql/models') diff --git a/animism-align/cli/app/sql/models/media.py b/animism-align/cli/app/sql/models/media.py index 6b615c9..27a1498 100644 --- a/animism-align/cli/app/sql/models/media.py +++ b/animism-align/cli/app/sql/models/media.py @@ -13,12 +13,28 @@ class Media(Base): __tablename__ = 'media' id = Column(Integer, primary_key=True) type = Column(String(16, convert_unicode=True), nullable=False) + url = Column(String(256, convert_unicode=True), nullable=True) + title = Column(String(256, convert_unicode=True), nullable=True) + author = Column(String(256, convert_unicode=True), nullable=True) + pre_title = Column(String(256, convert_unicode=True), nullable=True) + translated_title = Column(String(256, convert_unicode=True), nullable=True) + date = Column(String(256, convert_unicode=True), nullable=True) + source = Column(String(256, convert_unicode=True), nullable=True) + start_ts = Column(Float, nullable=True) settings = Column(JSON, default={}, nullable=True) def toJSON(self): return { 'id': self.id, 'type': self.type, + 'url': self.url, + 'title': self.title, + 'pre_title': self.pre_title, + 'translated_title': self.translated_title, + 'date': self.date, + 'source': self.source, + 'author': self.author, + 'start_ts': self.start_ts, 'settings': self.settings, } -- cgit v1.2.3-70-g09d2