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/202009301842_create_venue_table.py | 35 ++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 animism-align/cli/app/sql/versions/202009301842_create_venue_table.py (limited to 'animism-align/cli/app/sql/versions/202009301842_create_venue_table.py') diff --git a/animism-align/cli/app/sql/versions/202009301842_create_venue_table.py b/animism-align/cli/app/sql/versions/202009301842_create_venue_table.py new file mode 100644 index 0000000..17505fc --- /dev/null +++ b/animism-align/cli/app/sql/versions/202009301842_create_venue_table.py @@ -0,0 +1,35 @@ +"""create venue table + +Revision ID: a21872d09bbc +Revises: 2eb39d4c2aea +Create Date: 2020-09-30 18:42:37.865663 + +""" +from alembic import op +import sqlalchemy as sa +import sqlalchemy_utc + + +# revision identifiers, used by Alembic. +revision = 'a21872d09bbc' +down_revision = '2eb39d4c2aea' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.create_table('venue', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('title', sa.String(length=256, _expect_unicode=True), nullable=False), + sa.Column('date', sa.String(length=256, _expect_unicode=True), nullable=False), + sa.Column('settings', sa.JSON(), nullable=True), + sa.PrimaryKeyConstraint('id') + ) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_table('venue') + # ### end Alembic commands ### -- cgit v1.2.3-70-g09d2