| Vnaumov | 323df96 | 2017-10-01 15:56:10 +0300 | [diff] [blame] | 1 | classes: |
| 2 | - system.postgresql.client |
| 3 | parameters: |
| 4 | _param: |
| 5 | sfdc_db_host: ${_param:haproxy_postgresql_bind_host} |
| 6 | sfdc_db_user: sfdc |
| 7 | sfdc_db_user_password: sfdc |
| 8 | sfdc_login_id: 14 |
| 9 | sfdc_application_id: 4 |
| 10 | postgresql: |
| 11 | client: |
| 12 | server: |
| 13 | server01: |
| 14 | database: |
| Mikhail Ivanov | cd2359a | 2018-04-18 17:49:01 +0400 | [diff] [blame] | 15 | pushkin: |
| Vnaumov | 323df96 | 2017-10-01 15:56:10 +0300 | [diff] [blame] | 16 | init: |
| 17 | maintenance_db: pushkin |
| 18 | force: true |
| 19 | queries: |
| 20 | - INSERT INTO login VALUES (${_param:sfdc_login_id}, ${_param:sfdc_application_id}) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |
| 21 | - INSERT INTO device VALUES (${_param:sfdc_application_id}, ${_param:sfdc_login_id}, 42, 'salesforce_service', NULL, 1, NULL) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |