0032282: WhiteList / Ignore Database Validation for Foreign Key constraint in database validation for C_OrderLine columns

# HG changeset patch
# User Atul Gaware <atul.gaware@openbravo.com>
# Date 1455599676 -19800
#      Tue Feb 16 10:44:36 2016 +0530
# Node ID 71e6846a5626f5a027e7eabf87be9a9ade169546
# Parent  8410c9a28ed6a05345aabec9362e2400ecb3bf19
Fixes Issue 32205: Deleting a line on the order line window
takes long on environment with big amount of data

Foreign keys for following columns to the same table orderline 
removed
- ref_orderline_id
- quotationline_id
- bom_parent_id

diff -r 8410c9a28ed6 -r 71e6846a5626 src-db/database/model/tables/C_ORDERLINE.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml	Wed Feb 17 12:35:01 2016 +0530
+++ b/src-db/database/model/tables/C_ORDERLINE.xml	Tue Feb 16 10:44:36 2016 +0530
@@ -290,9 +290,6 @@
       <foreign-key foreignTable="AD_ORG" name="C_ORDERLINE_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_BOMPARENTID">
-        <reference local="BOM_PARENT_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="C_BPARTNER" name="C_ORDERLINE_C_BPARTNER">
         <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/>
       </foreign-key>
@@ -347,15 +344,9 @@
       <foreign-key foreignTable="M_WAREHOUSE" name="C_ORDERLINE_M_WAREHOUSE">
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_QUOTATION">
-        <reference local="QUOTATIONLINE_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="S_RESOURCEASSIGNMENT" name="C_ORDERLINE_S_RESOURCEASSIGNME">
         <reference local="S_RESOURCEASSIGNMENT_ID" foreign="S_RESOURCEASSIGNMENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ORDERLINE" name="C_ORDERLINE_SOPOREF">
-        <reference local="REF_ORDERLINE_ID" foreign="C_ORDERLINE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="USER1" name="C_ORDERLINE_USER1">
         <reference local="USER1_ID" foreign="USER1_ID"/>
       </foreign-key>

# HG changeset patch
# User Atul Gaware <atul.gaware@openbravo.com>
# Date 1455692701 -19800
#      Wed Feb 17 12:35:01 2016 +0530
# Node ID 8410c9a28ed6a05345aabec9362e2400ecb3bf19
# Parent  244ceec1c92eaec08180907d4e6c6b61dce9374e
Fixes Issue 32282:Support for partial indexes

Added specific case to skip db validation for foreign key
columns in c_orderline table
- ref_orderline_id
- quotationline_id
- bom_parent_id

diff -r 244ceec1c92e -r 8410c9a28ed6 src/org/openbravo/service/system/DatabaseValidator.java
--- a/src/org/openbravo/service/system/DatabaseValidator.java	Tue Feb 16 10:45:01 2016 +0530
+++ b/src/org/openbravo/service/system/DatabaseValidator.java	Wed Feb 17 12:35:01 2016 +0530
@@ -11,7 +11,7 @@
  * under the License. 
  * The Original Code is Openbravo ERP. 
  * The Initial Developer of the Original Code is Openbravo SLU 
- * All portions are Copyright (C) 2009-2014 Openbravo SLU 
+ * All portions are Copyright (C) 2009-2016 Openbravo SLU 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -415,6 +415,14 @@
           continue;
         }
 
+        // ignore this specific case
+        if (entity.getTableName().equalsIgnoreCase("c_orderline")
+            && (colName.equalsIgnoreCase("ref_orderline_id")
+                || colName.equalsIgnoreCase("quotationline_id") || colName
+                  .equalsIgnoreCase("bom_parent_id"))) {
+          continue;
+        }
+
         // ignore ad_audit_trail as fk's are omitted on purpose
         if (entity.getTableName().equalsIgnoreCase("ad_audit_trail")) {
           continue;