| Vladislav Naumov | 2a0b7a1 | 2017-08-03 12:56:32 +0300 | [diff] [blame] | 1 | classes: |
| 2 | - system.postgresql.client |
| 3 | parameters: |
| 4 | _param: |
| 5 | janmonkey_db_host: ${_param:haproxy_postgresql_bind_host} |
| 6 | janmonkey_db_user: janmonkey |
| Vladislav Naumov | 2a0b7a1 | 2017-08-03 12:56:32 +0300 | [diff] [blame] | 7 | janmonkey_login_id: 12 |
| 8 | janmonkey_application_id: 2 |
| 9 | postgresql: |
| 10 | client: |
| 11 | server: |
| 12 | server01: |
| 13 | database: |
| Mikhail Ivanov | cd2359a | 2018-04-18 17:49:01 +0400 | [diff] [blame] | 14 | pushkin: |
| Vladislav Naumov | 2a0b7a1 | 2017-08-03 12:56:32 +0300 | [diff] [blame] | 15 | init: |
| 16 | maintenance_db: pushkin |
| 17 | force: true |
| 18 | queries: |
| 19 | - INSERT INTO login VALUES (${_param:janmonkey_login_id}, ${_param:janmonkey_application_id}) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |
| 20 | - INSERT INTO device VALUES (${_param:janmonkey_application_id}, ${_param:janmonkey_login_id}, 42, 'janitor_audit_service', NULL, 1, NULL) ON CONFLICT (id) DO UPDATE SET id = excluded.id; |