Coverage for watcher/db/sqlalchemy/alembic/versions/d098df6021e2_cron_support_for_audit.py: 80%

1"""Add cron support for audit table 

2 

3Revision ID: d098df6021e2 

4Revises: 0f6042416884 

5Create Date: 2017-06-08 16:21:35.746752 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10 

11# revision identifiers, used by Alembic. 

12revision = 'd098df6021e2' 

13down_revision = '0f6042416884' 

14 

15 

16def upgrade(): 

17 op.alter_column('audits', 'interval', existing_type=sa.String(36), 

18 nullable=True) 

19 op.add_column('audits', 

20 sa.Column('next_run_time', sa.DateTime(), nullable=True)) 

21 

22 

23def downgrade(): 

24 op.alter_column('audits', 'interval', existing_type=sa.Integer(), 

25 nullable=True) 

26 op.drop_column('audits', 'next_run_time')