summaryrefslogtreecommitdiff
path: root/animism-align/cli
diff options
context:
space:
mode:
Diffstat (limited to 'animism-align/cli')
-rw-r--r--animism-align/cli/app/sql/models/episode.py8
-rw-r--r--animism-align/cli/app/sql/models/venue.py4
-rw-r--r--animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py2
3 files changed, 7 insertions, 7 deletions
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 ###