diff options
Diffstat (limited to 'migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py')
-rw-r--r-- | migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py | 79 |
1 files changed, 39 insertions, 40 deletions
diff --git a/migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py b/migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py index 8f2b015c..20c760e9 100644 --- a/migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py +++ b/migrations/versions/b329a1a7366f_add_new_tables_for_the_bookmarks_and_.py @@ -7,8 +7,8 @@ Create Date: 2017-05-23 21:42:37.636307 """ # revision identifiers, used by Alembic. -revision = 'b329a1a7366f' -down_revision = '2c5cc05216fa' +revision = "b329a1a7366f" +down_revision = "2c5cc05216fa" branch_labels = None depends_on = None @@ -18,48 +18,47 @@ import sqlalchemy as sa def upgrade(): - op.drop_table('tag') - op.create_table('article_tag', - sa.Column('text', sa.String(), nullable=False), - sa.Column('article_id', sa.Integer(), nullable=False), - sa.ForeignKeyConstraint(['article_id'], ['article.id'], - ondelete='CASCADE'), - sa.PrimaryKeyConstraint('text', 'article_id') + op.drop_table("tag") + op.create_table( + "article_tag", + sa.Column("text", sa.String(), nullable=False), + sa.Column("article_id", sa.Integer(), nullable=False), + sa.ForeignKeyConstraint(["article_id"], ["article.id"], ondelete="CASCADE"), + sa.PrimaryKeyConstraint("text", "article_id"), ) - op.create_table('bookmark', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('href', sa.String(), default=""), - sa.Column('title', sa.String(), default=""), - sa.Column('description', sa.String(), default=""), - sa.Column('shared', sa.Boolean(), default=False), - sa.Column('to_read', sa.Boolean(), default=False), - sa.Column('time', sa.DateTime(), default=datetime.utcnow), - sa.Column('user_id', sa.Integer(), nullable=False), - sa.ForeignKeyConstraint(['user_id'], ['user.id'], - ondelete='CASCADE'), - sa.PrimaryKeyConstraint('id') + op.create_table( + "bookmark", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("href", sa.String(), default=""), + sa.Column("title", sa.String(), default=""), + sa.Column("description", sa.String(), default=""), + sa.Column("shared", sa.Boolean(), default=False), + sa.Column("to_read", sa.Boolean(), default=False), + sa.Column("time", sa.DateTime(), default=datetime.utcnow), + sa.Column("user_id", sa.Integer(), nullable=False), + sa.ForeignKeyConstraint(["user_id"], ["user.id"], ondelete="CASCADE"), + sa.PrimaryKeyConstraint("id"), ) - op.create_table('bookmark_tag', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('text', sa.String(), nullable=False), - sa.Column('user_id', sa.Integer(), nullable=False), - sa.Column('bookmark_id', sa.Integer(), nullable=False), - sa.ForeignKeyConstraint(['bookmark_id'], ['bookmark.id'], - ondelete='CASCADE'), - sa.ForeignKeyConstraint(['user_id'], ['user.id'], - ondelete='CASCADE'), - sa.PrimaryKeyConstraint('id') + op.create_table( + "bookmark_tag", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("text", sa.String(), nullable=False), + sa.Column("user_id", sa.Integer(), nullable=False), + sa.Column("bookmark_id", sa.Integer(), nullable=False), + sa.ForeignKeyConstraint(["bookmark_id"], ["bookmark.id"], ondelete="CASCADE"), + sa.ForeignKeyConstraint(["user_id"], ["user.id"], ondelete="CASCADE"), + sa.PrimaryKeyConstraint("id"), ) def downgrade(): - op.drop_table('article_tag') - op.drop_table('bookmark_tag') - op.drop_table('bookmark') - op.create_table('tag', - sa.Column('text', sa.String(), nullable=False), - sa.Column('article_id', sa.Integer(), nullable=False), - sa.ForeignKeyConstraint(['article_id'], ['article.id'], - ondelete='CASCADE'), - sa.PrimaryKeyConstraint('text', 'article_id') + op.drop_table("article_tag") + op.drop_table("bookmark_tag") + op.drop_table("bookmark") + op.create_table( + "tag", + sa.Column("text", sa.String(), nullable=False), + sa.Column("article_id", sa.Integer(), nullable=False), + sa.ForeignKeyConstraint(["article_id"], ["article.id"], ondelete="CASCADE"), + sa.PrimaryKeyConstraint("text", "article_id"), ) |