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
10 revision = '149da7c4ac2f'
11 down_revision = '3a9905ed8ffd'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
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
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