[copr] master: Only update existing coprs using ts_vector for postgresql (9f5ad77)

bkabrda at fedoraproject.org bkabrda at fedoraproject.org
Fri Feb 1 13:22:37 UTC 2013


Repository : http://git.fedorahosted.org/cgit/copr.git

On branch  : master

>---------------------------------------------------------------

commit 9f5ad77960f00a5cbbc1170e4266d90288dbeafc
Author: Bohuslav Kabrda <bkabrda at redhat.com>
Date:   Fri Feb 1 12:30:18 2013 +0100

    Only update existing coprs using ts_vector for postgresql


>---------------------------------------------------------------

 .../versions/3a035889852c_add_copr_fulltext.py     |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/coprs_frontend/alembic/versions/3a035889852c_add_copr_fulltext.py b/coprs_frontend/alembic/versions/3a035889852c_add_copr_fulltext.py
index ac0c71a..c7292ff 100644
--- a/coprs_frontend/alembic/versions/3a035889852c_add_copr_fulltext.py
+++ b/coprs_frontend/alembic/versions/3a035889852c_add_copr_fulltext.py
@@ -22,10 +22,10 @@ def upgrade():
 
     session = sa.orm.sessionmaker(bind=op.get_bind())()
     metadata = sa.MetaData()
-    op.execute("UPDATE copr \
-                SET copr_ts_col = to_tsvector('pg_catalog.english', coalesce(name, '') || ' ' || \
-                    coalesce(description, '') || ' ' || coalesce(instructions, ''))")
     if op.get_bind().dialect.name == 'postgresql':
+        op.execute("UPDATE copr \
+                    SET copr_ts_col = to_tsvector('pg_catalog.english', coalesce(name, '') || ' ' || \
+                        coalesce(description, '') || ' ' || coalesce(instructions, ''))")
         # no need to coalesce here, the trigger doesn't need it
         op.execute("CREATE TRIGGER copr_ts_update BEFORE INSERT OR UPDATE \
                     ON copr \



More information about the copr-devel mailing list