Script 149da7c4ac2f_bz1361641_py
[hide private]
[frames] | no frames]

Source Code for Script script-149da7c4ac2f_bz1361641_py

 1  """Bug 1361641 - Status in build table shows wrong values 
 2   
 3  Revision ID: 149da7c4ac2f 
 4  Revises: 3a9905ed8ffd 
 5  Create Date: 2016-09-30 07:32:51.553858 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '149da7c4ac2f' 
11  down_revision = '3a9905ed8ffd' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 query_functions = """ 19 CREATE OR REPLACE FUNCTION status_to_order (x integer) 20 RETURNS integer AS $$ BEGIN 21 RETURN CASE WHEN x = 3 THEN 1 22 WHEN x = 6 THEN 2 23 WHEN x = 7 THEN 3 24 WHEN x = 4 THEN 4 25 WHEN x = 0 THEN 5 26 WHEN x = 1 THEN 6 27 WHEN x = 5 THEN 7 28 WHEN x = 2 THEN 8 29 ELSE x 30 END; END; 31 $$ LANGUAGE plpgsql; 32 33 CREATE OR REPLACE FUNCTION order_to_status (x integer) 34 RETURNS integer AS $$ BEGIN 35 RETURN CASE WHEN x = 1 THEN 3 36 WHEN x = 2 THEN 6 37 WHEN x = 3 THEN 7 38 WHEN x = 4 THEN 4 39 WHEN x = 5 THEN 0 40 WHEN x = 6 THEN 1 41 WHEN x = 7 THEN 5 42 WHEN x = 8 THEN 2 43 ELSE x 44 END; END; 45 $$ LANGUAGE plpgsql; 46 """ 47 op.execute(sa.text(query_functions))
48 49
50 -def downgrade():
51 query_functions = """ 52 CREATE OR REPLACE FUNCTION status_to_order (x integer) 53 RETURNS integer AS $$ BEGIN 54 RETURN CASE WHEN x = 0 THEN 0 55 WHEN x = 3 THEN 1 56 WHEN x = 6 THEN 2 57 WHEN x = 7 THEN 3 58 WHEN x = 4 THEN 4 59 WHEN x = 1 THEN 5 60 WHEN x = 5 THEN 6 61 WHEN x = 2 THEN 7 62 ELSE x 63 END; END; 64 $$ LANGUAGE plpgsql; 65 66 CREATE OR REPLACE FUNCTION order_to_status (x integer) 67 RETURNS integer AS $$ BEGIN 68 RETURN CASE WHEN x = 0 THEN 0 69 WHEN x = 1 THEN 3 70 WHEN x = 2 THEN 6 71 WHEN x = 3 THEN 7 72 WHEN x = 4 THEN 4 73 WHEN x = 5 THEN 1 74 WHEN x = 6 THEN 5 75 WHEN x = 7 THEN 2 76 ELSE x 77 END; END; 78 $$ LANGUAGE plpgsql; 79 """ 80 op.execute(sa.text(query_functions))
81