0002-CustomView-index-the-formdef_id-column-we-are-going-.patch

Pierre Ducroquet, 22 août 2022 15:56

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

Subject: [PATCH 2/2] CustomView: index the formdef_id column we are going to
 use more (#68324)

 wcs/sql.py | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

         for field in existing_fields - needed_fields:
             cur.execute('''ALTER TABLE %s DROP COLUMN %s''' % (table_name, field))
         # add indexes
         cur.execute(
             '''SELECT indexname
                 FROM pg_indexes
                 WHERE schemaname = 'public'
                   AND tablename = %s''',
             (table_name,),
+        )
         existing_indexes = {x[0] for x in cur.fetchall()}
         if ('%s_formdef_id' % table_name) not in existing_indexes:
             cur.execute(
                 '''CREATE INDEX %s_formdef_id ON %s(formdef_id)'''
                 % (table_name, table_name)
+            )
         conn.commit()
         cur.close()
+    -

Produits Entr'ouvert » w.c.s.