0001-sql-run-migration-to-get-new-index-on-evolution-tabl.patch

Frédéric Péters, 01 janvier 2023 19:15

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

Subject: [PATCH] sql: run migration to get new index on evolution tables
 (#72859)

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

     # latest migration, number + description (description is not used
     # programmaticaly but will make sure git conflicts if two migrations are
     # separately added with the same number)
     SQL_LEVEL = (73, 'form tokens to db')
     SQL_LEVEL = (74, 'change evolution index to be on (fomdata_id, id)')
     def migrate_global_views(conn, cur):
-...
             # 61: use setweight on formdata & user indexation
             # 62: use setweight on formdata & user indexation (reapply)
             set_reindex('formdata', 'needed', conn=conn, cur=cur)
         if sql_level < 56:
         if sql_level < 74:
             from wcs.carddef import CardDef
             from wcs.formdef import FormDef
-...
             # 36: add index on formdata(user_id)
             # 45 & 46: add index on formdata(status)
             # 56: add GIN indexes to concerned_roles_array and actions_roles_array
             # 74: (late migration) change evolution index to be on (fomdata_id, id)
             for formdef in FormDef.select() + CardDef.select():
                 do_formdef_indexes(formdef, created=False, conn=conn, cur=cur)
         if sql_level < 30:
+    -

Produits Entr'ouvert » w.c.s.