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 --- .../versions/202009301833_create_episodes_table.py | 37 ++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py (limited to 'animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py') 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 new file mode 100644 index 0000000..46d626b --- /dev/null +++ b/animism-align/cli/app/sql/versions/202009301833_create_episodes_table.py @@ -0,0 +1,37 @@ +"""create episodes table + +Revision ID: 2eb39d4c2aea +Revises: 1e3c915ef21f +Create Date: 2020-09-30 18:33:26.620856 + +""" +from alembic import op +import sqlalchemy as sa +import sqlalchemy_utc + + +# revision identifiers, used by Alembic. +revision = '2eb39d4c2aea' +down_revision = '1e3c915ef21f' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.create_table('episode', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('episode_number', sa.Integer(), nullable=False), + sa.Column('title', sa.String(length=256, _expect_unicode=True), nullable=False), + 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') + ) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('episode') + # ### end Alembic commands ### -- cgit v1.2.3-70-g09d2