postgresql/client/pushkin/janitor_monkey.yml

classes:
  - system.postgresql.client
parameters:
  _param:
    janmonkey_db_host: ${_param:haproxy_postgresql_bind_host}
    janmonkey_db_user: janmonkey
    janmonkey_login_id: 12
    janmonkey_application_id: 2
  postgresql:
    client:
      server:
        server01:
          database:
            pushkin:
              init:
                maintenance_db: pushkin
                force: true
                queries:
                - INSERT INTO login VALUES (${_param:janmonkey_login_id}, ${_param:janmonkey_application_id}) ON CONFLICT (id) DO UPDATE SET id = excluded.id;
                - 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;