misc/migration/3.9.0_Any.py
author Alexandre Fayolle <alexandre.fayolle@logilab.fr>
Fri, 26 Aug 2011 17:14:37 +0200
brancholdstable
changeset 7753 681ef2a664dd
parent 5768 1e73a466aa69
permissions -rw-r--r--
work around cursor.rowcount not returning anything useful before 1st fetch with mssql (closes #1910869) use select count(*) from table to get the number of rows
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
5768
1e73a466aa69 [fti] support for fti ranking: has_text query results sorted by relevance, and provides a way to control weight per entity / entity's attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     1
if repo.system_source.dbdriver == 'postgres':
1e73a466aa69 [fti] support for fti ranking: has_text query results sorted by relevance, and provides a way to control weight per entity / entity's attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     2
    sql('ALTER TABLE appears ADD COLUMN weight float')
1e73a466aa69 [fti] support for fti ranking: has_text query results sorted by relevance, and provides a way to control weight per entity / entity's attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     3
    sql('UPDATE appears SET weight=1.0 ')