201611190919_d87cea4e995d_remove_timezone_info_from_birthday_field.py 786 B

123456789101112131415161718192021222324252627
  1. """remove timezone info from birthday field
  2. Revision ID: d87cea4e995d
  3. Revises: d9530a529b3f
  4. Create Date: 2016-11-19 09:19:28.000276
  5. """
  6. # revision identifiers, used by Alembic.
  7. from alembic import op
  8. import sqlalchemy as sa
  9. import flaskbb
  10. revision = 'd87cea4e995d'
  11. down_revision = 'd9530a529b3f'
  12. def upgrade():
  13. # user/models.py
  14. with op.batch_alter_table('users') as batch_op:
  15. batch_op.alter_column('birthday', type_=sa.DateTime(), existing_type=flaskbb.utils.database.UTCDateTime(timezone=True), existing_nullable=True)
  16. def downgrade():
  17. # user/models.py
  18. with op.batch_alter_table('users') as batch_op:
  19. batch_op.alter_column('birthday', existing_type=sa.DateTime(), type_=flaskbb.utils.database.UTCDateTime(timezone=True), existing_nullable=True)