diff options
Diffstat (limited to 'src/migrations/versions')
7 files changed, 213 insertions, 0 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 new file mode 100644 index 00000000..035646c6 --- /dev/null +++ b/src/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py @@ -0,0 +1,34 @@ +"""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 new file mode 100644 index 00000000..2efa376f --- /dev/null +++ b/src/migrations/versions/19bdaa6208e_add_icon_column.py @@ -0,0 +1,26 @@ +"""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 new file mode 100644 index 00000000..71529855 --- /dev/null +++ b/src/migrations/versions/1b750a389c22_remove_email_notification_column.py @@ -0,0 +1,25 @@ +"""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 new file mode 100644 index 00000000..2c8eeda5 --- /dev/null +++ b/src/migrations/versions/25ca960a207_mv_icons_from_feed_tbl_to_icon_tbl.py @@ -0,0 +1,36 @@ +"""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/422da2d0234_adding_filters_field.py b/src/migrations/versions/422da2d0234_adding_filters_field.py new file mode 100644 index 00000000..bcbdf042 --- /dev/null +++ b/src/migrations/versions/422da2d0234_adding_filters_field.py @@ -0,0 +1,22 @@ +"""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 new file mode 100644 index 00000000..f464849a --- /dev/null +++ b/src/migrations/versions/48f561c0ce6_add_column_entry_id.py @@ -0,0 +1,26 @@ +"""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 new file mode 100644 index 00000000..116fdaa1 --- /dev/null +++ b/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py @@ -0,0 +1,44 @@ +"""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' + +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 ### |