e769c033e5c9_replace_last_delete_with_next_delete.py 文件源码

def downgrade():
    op.add_column('accounts', sa.Column('last_delete', postgresql.TIMESTAMP(), server_default=sa.text("'1970-01-01 00:00:00'::timestamp without time zone"), autoincrement=False, nullable=True))
    op.execute('UPDATE accounts SET last__delete = next_delete - policy_delete_every;')
    op.create_index('ix_accounts_last_delete', 'accounts', ['last_delete'], unique=False)
    op.drop_index(op.f('ix_accounts_next_delete'), table_name='accounts')
    op.drop_column('accounts', 'next_delete')