From 9dba744407f61a56efb8e63bbfa50ade6e847acf Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Wed, 30 Sep 2020 18:48:54 +0200 Subject: update episodes table form. add venues table and CRUD --- animism-align/cli/app/sql/models/episode.py | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'animism-align/cli/app/sql/models/episode.py') diff --git a/animism-align/cli/app/sql/models/episode.py b/animism-align/cli/app/sql/models/episode.py index a13c674..34402b8 100644 --- a/animism-align/cli/app/sql/models/episode.py +++ b/animism-align/cli/app/sql/models/episode.py @@ -1,4 +1,4 @@ -from sqlalchemy import create_engine, Table, Column, Text, String, Integer, Float, DateTime, JSON, ForeignKey +from sqlalchemy import create_engine, Table, Column, Text, String, Integer, Boolean, Float, DateTime, JSON, ForeignKey from sqlalchemy.orm import relationship import sqlalchemy.sql.functions as func from sqlalchemy_utc import UtcDateTime, utcnow @@ -15,6 +15,7 @@ class Episode(Base): episode_number = Column(Integer, primary_key=True) title = Column(String(256, convert_unicode=True), nullable=False) release_date = Column(String(256, convert_unicode=True), primary_key=True) + is_live = Column(Boolean, default=False) settings = Column(JSON, default={}, nullable=True) def toJSON(self): @@ -23,6 +24,16 @@ class Episode(Base): 'episode_number': self.episode_number, 'title': self.type, 'release_date': self.release_date, + 'is_live': self.is_live, + } + + def toFullJSON(self): + return { + 'id': self.id, + 'episode_number': self.episode_number, + 'title': self.type, + 'release_date': self.release_date, + 'is_live': self.is_live, 'settings': self.settings, } -- cgit v1.2.3-70-g09d2