diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-25 17:14:19 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-25 17:14:19 +0700 |
| commit | 7c2ba0700b40056c27b0af747dc32a6cd6a19e16 (patch) | |
| tree | 022ed7cde0ae3c01d06f917afe9e1f1d87da83f9 /import_account_move_line.ktr | |
| parent | 2b6d84bdf139f8f99ac554dc7b00db2d2df2c079 (diff) | |
change database
Diffstat (limited to 'import_account_move_line.ktr')
| -rw-r--r-- | import_account_move_line.ktr | 65 |
1 files changed, 58 insertions, 7 deletions
diff --git a/import_account_move_line.ktr b/import_account_move_line.ktr index 6dd6931..c7c6040 100644 --- a/import_account_move_line.ktr +++ b/import_account_move_line.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>erp indoteknik local</name> + <name>dw bi indoteknik (localhost)</name> <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> - <database>indoteknik_20230914</database> + <database>dw_bi_indoteknik</database> <port>5432</port> - <username>stephan</username> - <password>Encrypted 2be98afc86aa7f2e4cb0aba75ce9aaed4</password> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,9 +478,60 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <connection> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>erp_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <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>N</attribute> + </attribute> + <attribute> <code>USE_POOLING</code> <attribute>N</attribute> </attribute> @@ -504,8 +555,8 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> - <sql>select * from account_move_line where write_date >= (now() - '5 days'::interval)</sql> + <connection>erp indoteknik production (localhost)</connection> + <sql>select * from account_move_line</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1896,7 +1947,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik local</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> |