From b35e9773198ef2d8b37c4ca223f08147db47de0b Mon Sep 17 00:00:00 2001 From: François Schmidts Date: Sat, 12 Dec 2015 21:14:28 +0100 Subject: moving the root of source code from / to /src/ --- ...34831ea_adding_feed_and_user_attributes_for_.py | 44 ++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py (limited to 'src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py') 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 ### -- cgit