summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-09-19 10:55:10 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-09-19 10:55:10 +0700
commit0ee46cbe530976dbac58929eb2bccc4b3057fafe (patch)
tree6a919f3407b392247e97f69a7a1cfc3392610d51
parent8c9037d3c5ca9b0b29c316537b8a75a9725b65b2 (diff)
support boolean insert
-rw-r--r--calculate_price_after_disc.ktr2
-rw-r--r--import_brand.ktr2
-rw-r--r--import_price_group.ktr2
-rw-r--r--import_product_product.ktr2
-rw-r--r--import_purchase_order.ktr2
-rw-r--r--import_purchase_pricelist.ktr2
-rw-r--r--insert_update_pricelist.ktr9
-rw-r--r--insert_update_pricelist1.ktr2
-rw-r--r--insert_update_pricelist2.ktr2
-rw-r--r--insert_update_pricelist3.ktr2
-rw-r--r--insert_update_pricelist4.ktr2
-rw-r--r--insert_update_pricelist5.ktr2
-rw-r--r--run_single_ktr.sh2
-rw-r--r--update_count_trx_po_product.ktr2
-rw-r--r--update_count_trx_po_vendor.ktr2
15 files changed, 21 insertions, 16 deletions
diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 77feab1..3e205a6 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/import_brand.ktr b/import_brand.ktr
index 61d0430..b476286 100644
--- a/import_brand.ktr
+++ b/import_brand.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/import_price_group.ktr b/import_price_group.ktr
index 9a7b65c..c97a55b 100644
--- a/import_price_group.ktr
+++ b/import_price_group.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/import_product_product.ktr b/import_product_product.ktr
index 79735f9..fbb17ab 100644
--- a/import_product_product.ktr
+++ b/import_product_product.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr
index fbf52ba..a667e57 100644
--- a/import_purchase_order.ktr
+++ b/import_purchase_order.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr
index 9913d22..320fc73 100644
--- a/import_purchase_pricelist.ktr
+++ b/import_purchase_pricelist.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr
index 9448d2b..4150a36 100644
--- a/insert_update_pricelist.ktr
+++ b/insert_update_pricelist.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
@@ -636,7 +636,7 @@
<set_empty_string>N</set_empty_string>
</field>
<field>
- <name>active</name>
+ <name>active_const</name>
<type>Boolean</type>
<format/>
<currency/>
@@ -903,6 +903,11 @@
<rename>base_const</rename>
<update>Y</update>
</value>
+ <value>
+ <name>active</name>
+ <rename>active_const</rename>
+ <update>Y</update>
+ </value>
</lookup>
<attributes/>
<cluster_schema/>
diff --git a/insert_update_pricelist1.ktr b/insert_update_pricelist1.ktr
index e1cd441..a3f0bd5 100644
--- a/insert_update_pricelist1.ktr
+++ b/insert_update_pricelist1.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr
index 4ef582e..6455631 100644
--- a/insert_update_pricelist2.ktr
+++ b/insert_update_pricelist2.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/insert_update_pricelist3.ktr b/insert_update_pricelist3.ktr
index 46050ba..55cee04 100644
--- a/insert_update_pricelist3.ktr
+++ b/insert_update_pricelist3.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/insert_update_pricelist4.ktr b/insert_update_pricelist4.ktr
index 6215699..f8671b5 100644
--- a/insert_update_pricelist4.ktr
+++ b/insert_update_pricelist4.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/insert_update_pricelist5.ktr b/insert_update_pricelist5.ktr
index d51d629..f37b744 100644
--- a/insert_update_pricelist5.ktr
+++ b/insert_update_pricelist5.ktr
@@ -475,7 +475,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/run_single_ktr.sh b/run_single_ktr.sh
index c5c7596..311bb01 100644
--- a/run_single_ktr.sh
+++ b/run_single_ktr.sh
@@ -1 +1 @@
-sh /home/stephan/data-integration/pan.sh -file="/home/stephan/transformation-job-bi/calculate_price_after_disc.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log"
+sh /home/stephan/data-integration/pan.sh -level="Debug" -file="/home/stephan/transformation-job-bi/insert_update_pricelist.ktr" > "/home/stephan/transformation-job-bi/log/run_single_ktr.log"
diff --git a/update_count_trx_po_product.ktr b/update_count_trx_po_product.ktr
index 515f468..19e0f2e 100644
--- a/update_count_trx_po_product.ktr
+++ b/update_count_trx_po_product.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
diff --git a/update_count_trx_po_vendor.ktr b/update_count_trx_po_vendor.ktr
index 2dc4f32..44d0ca4 100644
--- a/update_count_trx_po_vendor.ktr
+++ b/update_count_trx_po_vendor.ktr
@@ -474,7 +474,7 @@
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
- <attribute>N</attribute>
+ <attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>