{"action":"created","issue":{"url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/12","repository_url":"https://api.github.com/repos/Icinga/icingaweb2-module-director","labels_url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/12/labels{/name}","comments_url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/12/comments","events_url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/12/events","html_url":"https://github.com/Icinga/icingaweb2-module-director/pull/12","id":158516749,"number":12,"title":"Housekeeping: Adapt DELETE commands for Postgresql","user":{"login":"rzerres","id":5363156,"avatar_url":"https://avatars.githubusercontent.com/u/5363156?v=3","gravatar_id":"","url":"https://api.github.com/users/rzerres","html_url":"https://github.com/rzerres","followers_url":"https://api.github.com/users/rzerres/followers","following_url":"https://api.github.com/users/rzerres/following{/other_user}","gists_url":"https://api.github.com/users/rzerres/gists{/gist_id}","starred_url":"https://api.github.com/users/rzerres/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rzerres/subscriptions","organizations_url":"https://api.github.com/users/rzerres/orgs","repos_url":"https://api.github.com/users/rzerres/repos","events_url":"https://api.github.com/users/rzerres/events{/privacy}","received_events_url":"https://api.github.com/users/rzerres/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-06-04T18:15:07Z","updated_at":"2016-06-17T18:51:29Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/pulls/12","html_url":"https://github.com/Icinga/icingaweb2-module-director/pull/12","diff_url":"https://github.com/Icinga/icingaweb2-module-director/pull/12.diff","patch_url":"https://github.com/Icinga/icingaweb2-module-director/pull/12.patch"},"body":"Hey Team,\r\n\r\nI do use icingaweb2-module-director on a Postgresql Instance (v9.5.2). While testing, a master-satellite-node constallation i have generated lots of db-entries. Wanted to clean up a bit, withouth starting from scratch. So I got around the housekeeping functions. \r\n\r\nHence until latest commit  in master (85cda6da9bbd78af6fc893aaf1d93c09a988db29) all functions that actually would delete rows (eg 'icingacli help housekeeping run unusedFiles') will return with an error. The counting functions work out as expected (Count column is filled correct). \r\n\r\nPlease review my pull request. It will fix the job for my installation.\r\nPostgres does not directly support an INNER JOIN on Delete requests. I pached the code in the following manner: When functions are called, check the connection Database Type (getDbType) and communicate with adequate syntax.  \r\n\r\nAny comments are welcome.\r\nRalf "},"comment":{"url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/comments/226851565","html_url":"https://github.com/Icinga/icingaweb2-module-director/pull/12#issuecomment-226851565","issue_url":"https://api.github.com/repos/Icinga/icingaweb2-module-director/issues/12","id":226851565,"user":{"login":"Thomas-Gelf","id":553008,"avatar_url":"https://avatars.githubusercontent.com/u/553008?v=3","gravatar_id":"","url":"https://api.github.com/users/Thomas-Gelf","html_url":"https://github.com/Thomas-Gelf","followers_url":"https://api.github.com/users/Thomas-Gelf/followers","following_url":"https://api.github.com/users/Thomas-Gelf/following{/other_user}","gists_url":"https://api.github.com/users/Thomas-Gelf/gists{/gist_id}","starred_url":"https://api.github.com/users/Thomas-Gelf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Thomas-Gelf/subscriptions","organizations_url":"https://api.github.com/users/Thomas-Gelf/orgs","repos_url":"https://api.github.com/users/Thomas-Gelf/repos","events_url":"https://api.github.com/users/Thomas-Gelf/events{/privacy}","received_events_url":"https://api.github.com/users/Thomas-Gelf/received_events","type":"User","site_admin":false},"created_at":"2016-06-17T18:51:29Z","updated_at":"2016-06-17T18:51:29Z","body":"Sorry, I completely forgot about this as there was no related issue on https://dev.icinga.org. I remembered that \"someone told me\" about such problems, but I wasn't able to find any trace of it. Today someone opened related PostgreSQL issues and I got a notification for a completely unrelated pull request from Github - and so I finally stumbled over this again.\r\n\r\nThanks for reporting it and thank you for your patches, I'll review them ASAP.\r\n\r\nCheers,\r\nThomas"}}
{"actor":{"display_login":"Thomas-Gelf"}}