[copr] master: [frontend] split creating of SQL functions to two separate commands (e9a1a44)
by frostyx＠fedoraproject.org
Repository : http://git.fedorahosted.org/cgit/copr.git
On branch : master
>---------------------------------------------------------------
commit e9a1a44531cea963cbfdd1de4277c3a3d86fa84d
Author: Jakub Kadl����k <jkadlcik(a)redhat.com>
Date: Mon Jan 4 14:10:01 2016 +0100
[frontend] split creating of SQL functions to two separate commands
>---------------------------------------------------------------
.../19ca0c14096e_status_to_order_function.py | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/frontend/coprs_frontend/alembic/versions/19ca0c14096e_status_to_order_function.py b/frontend/coprs_frontend/alembic/versions/19ca0c14096e_status_to_order_function.py
index 97f0be0..4a4c666 100644
--- a/frontend/coprs_frontend/alembic/versions/19ca0c14096e_status_to_order_function.py
+++ b/frontend/coprs_frontend/alembic/versions/19ca0c14096e_status_to_order_function.py
@@ -15,7 +15,7 @@ import sqlalchemy as sa
def upgrade():
- query_functions = """
+ status_to_order = """
CREATE OR REPLACE FUNCTION status_to_order (x integer)
RETURNS integer AS $$ BEGIN
RETURN CASE WHEN x = 0 THEN 0
@@ -28,7 +28,9 @@ RETURNS integer AS $$ BEGIN
ELSE 1000
END; END;
$$ LANGUAGE plpgsql;
+"""
+ order_to_status = """
CREATE OR REPLACE FUNCTION order_to_status (x integer)
RETURNS integer AS $$ BEGIN
RETURN CASE WHEN x = 0 THEN 0
@@ -42,8 +44,10 @@ RETURNS integer AS $$ BEGIN
END; END;
$$ LANGUAGE plpgsql;
"""
+
if op.get_bind().dialect.name == "postgresql":
- op.execute(sa.text(query_functions))
+ op.execute(status_to_order)
+ op.execute(order_to_status)
def downgrade():
8 years, 4 months
[copr] master: [frontend] adjust python path to fix 'alembic history' (f0554f7)
by frostyx＠fedoraproject.org
Repository : http://git.fedorahosted.org/cgit/copr.git
On branch : master
>---------------------------------------------------------------
commit f0554f72f959a36b3d6173e9874b0e269af63cf4
Author: Jakub Kadl����k <jkadlcik(a)redhat.com>
Date: Mon Jan 4 13:01:30 2016 +0100
[frontend] adjust python path to fix 'alembic history'
>---------------------------------------------------------------
.../3ec22e1db75a_add_openid_group_column.py | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/frontend/coprs_frontend/alembic/versions/3ec22e1db75a_add_openid_group_column.py b/frontend/coprs_frontend/alembic/versions/3ec22e1db75a_add_openid_group_column.py
index bcbce64..ca198fe 100644
--- a/frontend/coprs_frontend/alembic/versions/3ec22e1db75a_add_openid_group_column.py
+++ b/frontend/coprs_frontend/alembic/versions/3ec22e1db75a_add_openid_group_column.py
@@ -12,6 +12,11 @@ down_revision = '3f4966a9cc0'
from alembic import op
import sqlalchemy as sa
+
+import os
+import sys
+here = os.path.dirname(os.path.realpath(__file__))
+sys.path.append(os.path.dirname(os.path.dirname(here)))
from coprs.helpers import JSONEncodedDict
def upgrade():
8 years, 4 months