From 674b1e8379e4a8ca566927b9b9fcdf0764fb7ac8 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Wed, 30 Sep 2020 20:06:49 +0200 Subject: storing venues --- animism-align/cli/app/sql/models/episode.py | 8 ++++---- animism-align/cli/app/sql/models/venue.py | 4 ++-- .../cli/app/sql/versions/202009301833_create_episodes_table.py | 2 +- 3 files changed, 7 insertions(+), 7 deletions(-) (limited to 'animism-align/cli') diff --git a/animism-align/cli/app/sql/models/episode.py b/animism-align/cli/app/sql/models/episode.py index 34402b8..bbede50 100644 --- a/animism-align/cli/app/sql/models/episode.py +++ b/animism-align/cli/app/sql/models/episode.py @@ -12,9 +12,9 @@ class Episode(Base): """Table for storing episodes and their metadata""" __tablename__ = 'episode' id = Column(Integer, primary_key=True) - episode_number = Column(Integer, primary_key=True) + episode_number = Column(Integer) title = Column(String(256, convert_unicode=True), nullable=False) - release_date = Column(String(256, convert_unicode=True), primary_key=True) + release_date = Column(String(256, convert_unicode=True)) is_live = Column(Boolean, default=False) settings = Column(JSON, default={}, nullable=True) @@ -22,7 +22,7 @@ class Episode(Base): return { 'id': self.id, 'episode_number': self.episode_number, - 'title': self.type, + 'title': self.title, 'release_date': self.release_date, 'is_live': self.is_live, } @@ -31,7 +31,7 @@ class Episode(Base): return { 'id': self.id, 'episode_number': self.episode_number, - 'title': self.type, + 'title': self.title, 'release_date': self.release_date, 'is_live': self.is_live, 'settings': self.settings, diff --git a/animism-align/cli/app/sql/models/venue.py b/animism-align/cli/app/sql/models/venue.py index 992adea..74a928c 100644 --- a/animism-align/cli/app/sql/models/venue.py +++ b/animism-align/cli/app/sql/models/venue.py @@ -19,8 +19,8 @@ class Venue(Base): def toJSON(self): return { 'id': self.id, - 'title': self.type, - 'date': self.type, + 'title': self.title, + 'date': self.date, 'settings': self.settings, } diff --git a/animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py b/animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py index 46d626b..6a25e68 100644 --- a/animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py +++ b/animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py @@ -26,7 +26,7 @@ def upgrade(): sa.Column('release_date', sa.String(length=256, _expect_unicode=True), nullable=False), sa.Column('is_live', sa.Boolean(), nullable=True), sa.Column('settings', sa.JSON(), nullable=True), - sa.PrimaryKeyConstraint('id', 'episode_number', 'release_date') + sa.PrimaryKeyConstraint('id') ) # ### end Alembic commands ### -- cgit v1.2.3-70-g09d2