blob: cfb123658f9dc078986bd9cad213c29edab91043 [file] [log] [blame]
Vnaumov323df962017-10-01 15:56:10 +03001classes:
2 - system.postgresql.client
3parameters:
4 _param:
5 sfdc_db_host: ${_param:haproxy_postgresql_bind_host}
6 sfdc_db_user: sfdc
Vnaumov323df962017-10-01 15:56:10 +03007 sfdc_login_id: 14
8 sfdc_application_id: 4
9 postgresql:
10 client:
11 server:
12 server01:
13 database:
Mikhail Ivanovcd2359a2018-04-18 17:49:01 +040014 pushkin:
Vnaumov323df962017-10-01 15:56:10 +030015 init:
16 maintenance_db: pushkin
17 force: true
18 queries:
19 - INSERT INTO login VALUES (${_param:sfdc_login_id}, ${_param:sfdc_application_id}) ON CONFLICT (id) DO UPDATE SET id = excluded.id;
20 - 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;