diff options
| -rw-r--r-- | insert_update_pricelist.ktr | 96 |
1 files changed, 95 insertions, 1 deletions
diff --git a/insert_update_pricelist.ktr b/insert_update_pricelist.ktr index 335cd76..e97d644 100644 --- a/insert_update_pricelist.ktr +++ b/insert_update_pricelist.ktr @@ -488,6 +488,57 @@ </attributes> </connection> <connection> + <name>erp indoteknik local</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>indoteknik_20230914</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</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> + <connection> <name>erp indoteknik production (localhost)</name> <server>localhost</server> <type>POSTGRESQL</type> @@ -547,6 +598,11 @@ <to>Insert / update 3</to> <enabled>Y</enabled> </hop> + <hop> + <from>Insert / update 3</from> + <to>Execute SQL script</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>Add constants</name> @@ -753,7 +809,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production (localhost)</connection> + <connection>erp indoteknik local</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -1990,6 +2046,44 @@ order by product_id</sql> <draw>Y</draw> </GUI> </step> + <step> + <name>Execute SQL script</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17022;</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1120</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |