diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
| commit | 76a5f56f324986a18ced12d01214670fdc18663e (patch) | |
| tree | 77d73102aa001cdc78c2424db76509c9c58290e7 /insert_update_pricelist2.ktr | |
| parent | 9828160c003af8915fd837f2ae4d3271387ea8e3 (diff) | |
refactor again
Diffstat (limited to 'insert_update_pricelist2.ktr')
| -rw-r--r-- | insert_update_pricelist2.ktr | 58 |
1 files changed, 13 insertions, 45 deletions
diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr index dd0f6ea..87064c4 100644 --- a/insert_update_pricelist2.ktr +++ b/insert_update_pricelist2.ktr @@ -437,14 +437,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -475,11 +475,11 @@ </attribute> <attribute> <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -488,54 +488,22 @@ </attributes> </connection> <connection> - <name>erp indoteknik local</name> + <name>erp indoteknik production (localhost)</name> <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230914</database> + <database>erp_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> <attributes> <attribute> - <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code> - <attribute>N</attribute> - </attribute> - <attribute> - <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code> - <attribute>N</attribute> - </attribute> - <attribute> - <code>IS_CLUSTERED</code> - <attribute>N</attribute> - </attribute> - <attribute> <code>PORT_NUMBER</code> <attribute>5432</attribute> </attribute> - <attribute> - <code>PRESERVE_RESERVED_WORD_CASE</code> - <attribute>Y</attribute> - </attribute> - <attribute> - <code>QUOTE_ALL_FIELDS</code> - <attribute>N</attribute> - </attribute> - <attribute> - <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> - <attribute>Y</attribute> - </attribute> - <attribute> - <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> - </attribute> - <attribute> - <code>USE_POOLING</code> - <attribute>N</attribute> - </attribute> </attributes> </connection> <order> @@ -785,7 +753,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> + <connection>erp indoteknik production (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -884,7 +852,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> + <connection>erp indoteknik production (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -927,7 +895,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> + <connection>erp indoteknik production (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -1036,7 +1004,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <sql>select pc.product_id, p.template_id, round(price_before_disc) as price_before_disc, disc_tier1, disc_tier2, disc_tier3, disc_tier4, disc_tier5, round(price_tier1) as price_tier1, round(price_tier2) as price_tier2, @@ -1377,7 +1345,7 @@ order by product_id</sql> <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from product_pricelist_item where pricelist_id = 17024 order by product_id</sql> <limit>0</limit> <lookup/> |