diff options
author | Cédric Bonhomme <cedric@cedricbonhomme.org> | 2016-02-03 19:23:39 +0100 |
---|---|---|
committer | Cédric Bonhomme <cedric@cedricbonhomme.org> | 2016-02-03 19:23:39 +0100 |
commit | a065a2c873e80ea933b5cb6ef542ad7a759714e1 (patch) | |
tree | 0b2f3e61764afc8589187383d7751bf84181650e /migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py | |
parent | alembic patch (diff) | |
download | newspipe-a065a2c873e80ea933b5cb6ef542ad7a759714e1.tar.gz newspipe-a065a2c873e80ea933b5cb6ef542ad7a759714e1.tar.bz2 newspipe-a065a2c873e80ea933b5cb6ef542ad7a759714e1.zip |
carpy tests for alembic...
Diffstat (limited to 'migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py')
-rw-r--r-- | migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py b/migrations/versions/17dcb75f3fe_changed_the_type_of_the_column_last_.py new file mode 100644 index 00000000..035646c6 --- /dev/null +++ b/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)) |