Script 15852f9e313f_add_forked_status_for_build_chroot_py
[hide private]
[frames] | no frames]

Source Code for Script script-15852f9e313f_add_forked_status_for_build_chroot_py

 1  """add forked status for build_chroot 
 2   
 3  Revision ID: 15852f9e313f 
 4  Revises: 419a626c25e6 
 5  Create Date: 2016-10-06 09:07:06.487213 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '15852f9e313f' 
11  down_revision = '419a626c25e6' 
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 WHEN x = 8 THEN 9 30 ELSE x 31 END; END; 32 $$ LANGUAGE plpgsql; 33 34 CREATE OR REPLACE FUNCTION order_to_status (x integer) 35 RETURNS integer AS $$ BEGIN 36 RETURN CASE WHEN x = 1 THEN 3 37 WHEN x = 2 THEN 6 38 WHEN x = 3 THEN 7 39 WHEN x = 4 THEN 4 40 WHEN x = 5 THEN 0 41 WHEN x = 6 THEN 1 42 WHEN x = 7 THEN 5 43 WHEN x = 8 THEN 2 44 WHEN x = 9 THEN 8 45 ELSE x 46 END; END; 47 $$ LANGUAGE plpgsql; 48 """ 49 op.execute(sa.text(query_functions))
50 51
52 -def downgrade():
53 query_functions = """ 54 CREATE OR REPLACE FUNCTION status_to_order (x integer) 55 RETURNS integer AS $$ BEGIN 56 RETURN CASE WHEN x = 3 THEN 1 57 WHEN x = 6 THEN 2 58 WHEN x = 7 THEN 3 59 WHEN x = 4 THEN 4 60 WHEN x = 0 THEN 5 61 WHEN x = 1 THEN 6 62 WHEN x = 5 THEN 7 63 WHEN x = 2 THEN 8 64 ELSE x 65 END; END; 66 $$ LANGUAGE plpgsql; 67 68 CREATE OR REPLACE FUNCTION order_to_status (x integer) 69 RETURNS integer AS $$ BEGIN 70 RETURN CASE WHEN x = 1 THEN 3 71 WHEN x = 2 THEN 6 72 WHEN x = 3 THEN 7 73 WHEN x = 4 THEN 4 74 WHEN x = 5 THEN 0 75 WHEN x = 6 THEN 1 76 WHEN x = 7 THEN 5 77 WHEN x = 8 THEN 2 78 ELSE x 79 END; END; 80 $$ LANGUAGE plpgsql; 81 """ 82 op.execute(sa.text(query_functions))
83