diff options
Diffstat (limited to 'src/migrations/versions')
9 files changed, 0 insertions, 277 deletions
diff --git a/src/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py b/src/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py deleted file mode 100644 index 035646c6..00000000 --- a/src/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py +++ /dev/null @@ -1,34 +0,0 @@ -"""changed the type of the column 'last_modified' to string. - -Revision ID: 17dcb75f3fe -Revises: cde34831ea -Create Date: 2015-03-10 14:20:53.676344 - -""" - -# revision identifiers, used by Alembic. -revision = '17dcb75f3fe' -down_revision = 'cde34831ea' - -from datetime import datetime -import conf -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - unix_start = datetime(1970, 1, 1) - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_column('feed', 'last_modified') - op.add_column('feed', sa.Column('last_modified', sa.String(), - nullable=True, default=unix_start, - server_default=str(unix_start))) - - -def downgrade(): - unix_start = datetime(1970, 1, 1) - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_column('feed', 'last_modified') - op.add_column('feed', sa.Column('last_modified', sa.DateTime(), - nullable=True, default=unix_start, - server_default=unix_start)) diff --git a/src/migrations/versions/19bdaa6208e_add_icon_column.py b/src/migrations/versions/19bdaa6208e_add_icon_column.py deleted file mode 100644 index 2efa376f..00000000 --- a/src/migrations/versions/19bdaa6208e_add_icon_column.py +++ /dev/null @@ -1,26 +0,0 @@ -"""adding icon columns - -Revision ID: 19bdaa6208e -Revises: 422da2d0234 -Create Date: 2015-07-03 12:09:58.596010 - -""" - -# revision identifiers, used by Alembic. -revision = '19bdaa6208e' -down_revision = '422da2d0234' - -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - ### commands auto generated by Alembic - please adjust! ### - op.add_column('feed', sa.Column('icon', sa.String(), nullable=True)) - ### end Alembic commands ### - - -def downgrade(): - ### commands auto generated by Alembic - please adjust! ### - op.drop_column('feed', 'icon') - ### end Alembic commands ### diff --git a/src/migrations/versions/1b750a389c22_remove_email_notification_column.py b/src/migrations/versions/1b750a389c22_remove_email_notification_column.py deleted file mode 100644 index 71529855..00000000 --- a/src/migrations/versions/1b750a389c22_remove_email_notification_column.py +++ /dev/null @@ -1,25 +0,0 @@ -"""remove email_notification column - -Revision ID: 1b750a389c22 -Revises: 48f561c0ce6 -Create Date: 2015-02-25 23:01:07.253429 - -""" - -# revision identifiers, used by Alembic. -revision = '1b750a389c22' -down_revision = '48f561c0ce6' - -import conf -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_column('feed', 'email_notification') - - -def downgrade(): - op.add_column('feed', sa.Column('email_notification', sa.Boolean(), - default=False)) diff --git a/src/migrations/versions/25ca960a207_mv_icons_from_feed_tbl_to_icon_tbl.py b/src/migrations/versions/25ca960a207_mv_icons_from_feed_tbl_to_icon_tbl.py deleted file mode 100644 index 2c8eeda5..00000000 --- a/src/migrations/versions/25ca960a207_mv_icons_from_feed_tbl_to_icon_tbl.py +++ /dev/null @@ -1,36 +0,0 @@ -"""moving icons to their own table - -Revision ID: 25ca960a207 -Revises: 19bdaa6208e -Create Date: 2015-08-03 14:36:21.626411 - -""" - -# revision identifiers, used by Alembic. -revision = '25ca960a207' -down_revision = '19bdaa6208e' - -from alembic import op -import sqlalchemy as sa - -import conf - - -def upgrade(): - op.create_table('icon', - sa.Column('url', sa.String(), nullable=False), - sa.Column('content', sa.String(), nullable=True), - sa.Column('mimetype', sa.String(), nullable=True), - sa.PrimaryKeyConstraint('url')) - op.add_column('feed', sa.Column('icon_url', sa.String(), nullable=True)) - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.create_foreign_key(None, 'feed', 'icon', ['icon_url'], ['url']) - op.drop_column('feed', 'icon') - - -def downgrade(): - op.add_column('feed', sa.Column('icon', sa.VARCHAR(), nullable=True)) - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_constraint(None, 'feed', type_='foreignkey') - op.drop_column('feed', 'icon_url') - op.drop_table('icon') diff --git a/src/migrations/versions/3f83bfe93fc_adding_category.py b/src/migrations/versions/3f83bfe93fc_adding_category.py deleted file mode 100644 index b8412418..00000000 --- a/src/migrations/versions/3f83bfe93fc_adding_category.py +++ /dev/null @@ -1,42 +0,0 @@ -"""adding category - -Revision ID: 3f83bfe93fc -Revises: 25ca960a207 -Create Date: 2015-09-01 14:15:04.212563 -""" - -# revision identifiers, used by Alembic. -revision = '3f83bfe93fc' -down_revision = 'db64b766362f' - -import conf -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - op.create_table('category', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('name', sa.String(), nullable=True), - sa.Column('user_id', sa.Integer(), nullable=True), - sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), - sa.PrimaryKeyConstraint('id')) - op.add_column('article', - sa.Column('category_id', sa.Integer(), nullable=True)) - op.add_column('feed', - sa.Column('category_id', sa.Integer(), nullable=True)) - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.create_foreign_key(None, 'article', 'category', - ['category_id'], ['id']) - op.create_foreign_key(None, 'feed', 'category', - ['category_id'], ['id']) - - -def downgrade(): - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_constraint(None, 'feed', type_='foreignkey') - op.drop_constraint(None, 'feed', type_='foreignkey') - op.drop_column('feed', 'category_id') - op.drop_constraint(None, 'article', type_='foreignkey') - op.drop_column('article', 'category_id') - op.drop_table('category') diff --git a/src/migrations/versions/422da2d0234_adding_filters_field.py b/src/migrations/versions/422da2d0234_adding_filters_field.py deleted file mode 100644 index bcbdf042..00000000 --- a/src/migrations/versions/422da2d0234_adding_filters_field.py +++ /dev/null @@ -1,22 +0,0 @@ -"""adding filters field - -Revision ID: 422da2d0234 -Revises: 17dcb75f3fe -Create Date: 2015-05-18 23:03:15.809549 - -""" - -# revision identifiers, used by Alembic. -revision = '422da2d0234' -down_revision = '17dcb75f3fe' - -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - op.add_column('feed', sa.Column('filters', sa.PickleType(), nullable=True)) - - -def downgrade(): - op.drop_column('feed', 'filters') diff --git a/src/migrations/versions/48f561c0ce6_add_column_entry_id.py b/src/migrations/versions/48f561c0ce6_add_column_entry_id.py deleted file mode 100644 index f464849a..00000000 --- a/src/migrations/versions/48f561c0ce6_add_column_entry_id.py +++ /dev/null @@ -1,26 +0,0 @@ -"""add column entry_id - -Revision ID: 48f561c0ce6 -Revises: -Create Date: 2015-02-18 21:17:19.346998 - -""" - -# revision identifiers, used by Alembic. -revision = '48f561c0ce6' -down_revision = None -branch_labels = None -depends_on = None - -import conf -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - op.add_column('article', sa.Column('entry_id', sa.String(), nullable=True)) - - -def downgrade(): - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_column('article', 'entry_id') diff --git a/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py b/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py deleted file mode 100644 index 8763f925..00000000 --- a/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py +++ /dev/null @@ -1,44 +0,0 @@ -"""adding feed and user attributes for better feed retreiving - -Revision ID: cde34831ea -Revises: 1b750a389c22 -Create Date: 2015-03-04 22:59:44.665979 - -""" - -# revision identifiers, used by Alembic. -revision = 'cde34831ea' -down_revision = '1b750a389c22' -import conf -from datetime import datetime - -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - unix_start = datetime(1970, 1, 1) - # commands auto generated by Alembic - please adjust! ### - op.add_column('feed', sa.Column('error_count', sa.Integer(), nullable=True, - default=0, server_default="0")) - op.add_column('feed', sa.Column('last_error', sa.String(), nullable=True)) - op.add_column('feed', sa.Column('last_modified', sa.DateTime(), - nullable=True, default=unix_start, server_default=str(unix_start))) - op.add_column('feed', sa.Column('last_retrieved', sa.DateTime(), - nullable=True, default=unix_start, server_default=str(unix_start))) - op.add_column('feed', sa.Column('etag', sa.String(), nullable=True)) - op.add_column('user', sa.Column('refresh_rate', sa.Integer(), - nullable=True, default=60)) - # end Alembic commands ### - - -def downgrade(): - # commands auto generated by Alembic - please adjust! ### - if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: - op.drop_column('user', 'refresh_rate') - op.drop_column('feed', 'last_modified') - op.drop_column('feed', 'last_error') - op.drop_column('feed', 'error_count') - op.drop_column('feed', 'last_retrieved') - op.drop_column('feed', 'etag') - # end Alembic commands ### diff --git a/src/migrations/versions/db64b766362f_add_notes_column_for_articles.py b/src/migrations/versions/db64b766362f_add_notes_column_for_articles.py deleted file mode 100644 index 3d25b004..00000000 --- a/src/migrations/versions/db64b766362f_add_notes_column_for_articles.py +++ /dev/null @@ -1,22 +0,0 @@ -"""Add notes column for articles. - -Revision ID: db64b766362f -Revises: 25ca960a207 -Create Date: 2016-01-06 19:03:25.511074 - -""" - -# revision identifiers, used by Alembic. -revision = 'db64b766362f' -down_revision = '25ca960a207' - -from alembic import op -import sqlalchemy as sa - - -def upgrade(): - op.add_column('article', sa.Column('notes', sa.String(), nullable=True)) - - -def downgrade(): - op.drop_column('article', 'notes') |