From 0ee46cbe530976dbac58929eb2bccc4b3057fafe Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 19 Sep 2023 10:55:10 +0700 Subject: support boolean insert --- calculate_price_after_disc.ktr | 2 +- import_brand.ktr | 2 +- import_price_group.ktr | 2 +- import_product_product.ktr | 2 +- import_purchase_order.ktr | 2 +- import_purchase_pricelist.ktr | 2 +- insert_update_pricelist.ktr | 9 +++++++-- insert_update_pricelist1.ktr | 2 +- insert_update_pricelist2.ktr | 2 +- insert_update_pricelist3.ktr | 2 +- insert_update_pricelist4.ktr | 2 +- insert_update_pricelist5.ktr | 2 +- run_single_ktr.sh | 2 +- update_count_trx_po_product.ktr | 2 +- update_count_trx_po_vendor.ktr | 2 +- 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE @@ -636,7 +636,7 @@ N - active + active_const Boolean @@ -903,6 +903,11 @@ base_const Y + + active + active_const + Y + 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE 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 @@ SUPPORTS_BOOLEAN_DATA_TYPE - N + Y SUPPORTS_TIMESTAMP_DATA_TYPE -- cgit v1.2.3