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
10 revision = '15852f9e313f'
11 down_revision = '419a626c25e6'
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 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
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