0001-sql-add-an-index-on-formdata-id-column-34174.patch

Frédéric Péters, 19 juin 2019 16:42

Voir les différences: en ligne côte à côte

Subject: [PATCH] sql: add an index on formdata id column (#34174)

 wcs/sql.py | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

         if concurrently:
             create_index = 'CREATE INDEX CONCURRENTLY'
         if not table_name + '_id' in existing_indexes:
             cur.execute('''%s %s_id ON %s (id)''' % (create_index, table_name, table_name))
         if not evolutions_table_name + '_fid' in existing_indexes:
             cur.execute('''%s %s_fid ON %s (formdata_id)''' % (
                 create_index, evolutions_table_name, evolutions_table_name))
-...
         return result
     SQL_LEVEL = 32
     SQL_LEVEL = 33
     def migrate_global_views(conn, cur):
         cur.execute('''SELECT COUNT(*) FROM information_schema.tables
-...
             # 29: add evolution parts to full-text index
             # 31: add user_label to formdata
             set_reindex('formdata', 'needed', conn=conn, cur=cur)
         if sql_level < 24:
         if sql_level < 33:
             from wcs.formdef import FormDef
             # 24: add index on evolution(formdata_id)
             # 33: add index on form(id)
             for formdef in FormDef.select():
                 do_formdef_indexes(formdef, created=False, conn=conn, cur=cur)
         if sql_level < 32:
+    -

Produits Entr'ouvert » w.c.s.