WebshopApi: trigram indices und Hinweiss darauf in der UPGRADE Datei.

diff --git a/doc/UPGRADE b/doc/UPGRADE
index 4d8054dd316875edcba58a6a9cfe047131b5e8f0..806016b4d6a35c759a982733072a22cd9c329b3c 100644 (file)
--- a/doc/UPGRADE
+++ b/doc/UPGRADE
@@ -22,6 +22,12 @@ Upgrade auf v3.5.1
     CREATE EXTENSION IF NOT EXISTS pg_trgm;
     \q
 
     CREATE EXTENSION IF NOT EXISTS pg_trgm;
     \q
 

+    Wenn die Extension installiert ist können in den beiden Dateien
+    - sql/Pg-upgrade2/trigram_indices_webshop.sql
+    - sql/Pg-upgrade2/trigram_indices.sql
+    das ignore auf 0 gesetzt werden und beide Dateien werden dann beim Anmelden eingespielt.
+    Die Trigramindices sind ein Performancegewinn bei größeren Datenbanken
+

 Upgrade auf v3.5.0
 ===========================
 
 Upgrade auf v3.5.0
 ===========================
 

diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql
index 87af0e8524fce15a7b247bd99a321e3b01b098ac..c8b58e5e95c2d2d2593f410a7a75dced03ad218d 100644 (file)
--- a/sql/Pg-upgrade2/trigram_indices.sql
+++ b/sql/Pg-upgrade2/trigram_indices.sql
@@ -4,7 +4,6 @@
 -- @encoding: utf-8
 -- @ignore: 1
 
 -- @encoding: utf-8
 -- @ignore: 1
 

--- CREATE EXTENSION IF NOT EXISTS pg_trgm;

 
 CREATE INDEX customer_customernumber_gin_trgm_idx    ON customer        USING gin (customernumber          gin_trgm_ops);
 CREATE INDEX customer_name_gin_trgm_idx              ON customer        USING gin (name                    gin_trgm_ops);
 
 CREATE INDEX customer_customernumber_gin_trgm_idx    ON customer        USING gin (customernumber          gin_trgm_ops);
 CREATE INDEX customer_name_gin_trgm_idx              ON customer        USING gin (name                    gin_trgm_ops);

diff --git a/templates/webpages/shop_order/show.html b/templates/webpages/shop_order/show.html
index 561bba8b5d73d859b9547eedb212e1110cea515f..112ffbdefe801e2a9e24b58ba43cb1173d3d7792 100644 (file)
--- a/templates/webpages/shop_order/show.html
+++ b/templates/webpages/shop_order/show.html
@@ -185,7 +185,7 @@
       </tr>
       <tr class="listrow">
       [% FOREACH pos = IMPORT.shop_order_items %]
       </tr>
       <tr class="listrow">
       [% FOREACH pos = IMPORT.shop_order_items %]

-        <td>[% loop.index+1                                      %]</td>
+        <td>[% loop.index+1                                    %]</td>

         <td>[% HTML.escape(pos.partnumber)                     %]</td>
         <td>[% HTML.escape(pos.description)                    %]</td>
         <td>[% pos.quantity_as_number                          %]</td>
         <td>[% HTML.escape(pos.partnumber)                     %]</td>
         <td>[% HTML.escape(pos.description)                    %]</td>
         <td>[% pos.quantity_as_number                          %]</td>