Script 2db1d0557b06_fill_ended_on_column_in_action_table_py
[hide private]
[frames] | no frames]

Source Code for Script script-2db1d0557b06_fill_ended_on_column_in_action_table_py

 1  """ 
 2  fill ended_on column in Action table 
 3   
 4  Revision ID: 2db1d0557b06 
 5  Revises: 4ed794df3bbb 
 6  Create Date: 2019-12-10 08:40:15.126168 
 7  """ 
 8   
 9  import sqlalchemy as sa 
10  from alembic import op 
11   
12   
13  revision = '2db1d0557b06' 
14  down_revision = '4ed794df3bbb' 
15   
16 -def upgrade():
17 op.execute( 18 'UPDATE action SET ended_on = created_on + 5\ 19 WHERE (result = 1 or result = 2) AND ended_on IS NULL' 20 )
21
22 -def downgrade():
23 pass
24