{"action":"created","issue":{"url":"https://api.github.com/repos/dCache/dcache/issues/2405","repository_url":"https://api.github.com/repos/dCache/dcache","labels_url":"https://api.github.com/repos/dCache/dcache/issues/2405/labels{/name}","comments_url":"https://api.github.com/repos/dCache/dcache/issues/2405/comments","events_url":"https://api.github.com/repos/dCache/dcache/issues/2405/events","html_url":"https://github.com/dCache/dcache/pull/2405","id":154799656,"number":2405,"title":"billing: additional fixes to insert triggers","user":{"login":"DmitryLitvintsev","id":2091655,"avatar_url":"https://avatars.githubusercontent.com/u/2091655?v=3","gravatar_id":"","url":"https://api.github.com/users/DmitryLitvintsev","html_url":"https://github.com/DmitryLitvintsev","followers_url":"https://api.github.com/users/DmitryLitvintsev/followers","following_url":"https://api.github.com/users/DmitryLitvintsev/following{/other_user}","gists_url":"https://api.github.com/users/DmitryLitvintsev/gists{/gist_id}","starred_url":"https://api.github.com/users/DmitryLitvintsev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DmitryLitvintsev/subscriptions","organizations_url":"https://api.github.com/users/DmitryLitvintsev/orgs","repos_url":"https://api.github.com/users/DmitryLitvintsev/repos","events_url":"https://api.github.com/users/DmitryLitvintsev/events{/privacy}","received_events_url":"https://api.github.com/users/DmitryLitvintsev/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-05-13T21:02:41Z","updated_at":"2016-05-19T14:23:20Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dCache/dcache/pulls/2405","html_url":"https://github.com/dCache/dcache/pull/2405","diff_url":"https://github.com/dCache/dcache/pull/2405.diff","patch_url":"https://github.com/dCache/dcache/pull/2405.patch"},"body":"Motivation:\r\n\r\nPatch https://rb.dcache.org/r/9222/ fixed issue only partially.\r\nA case when no entries exist in a daily tables was not covered.\r\nAdditionally, wrong date was inserted when a zero entry is made\r\n(it has to be previous date not current date)\r\n\r\nModification:\r\n\r\nThis patch fixes this issue and refactors triggers to be more DRY.\r\n\r\nResult:\r\n\r\nInserts have been shown to be fast on heavy loaded system. Particularly\r\ncorner cases were tested by truncating summary tables.\r\n\r\nRB : https://rb.dcache.org/r/9273/\r\nAcked-by: Al Rossi <arossi@fnal.gov>\r\n\r\nRequest: trunk\r\nRequest: 2.15\r\nRequest: 2.14\r\nRequest: 2.13\r\nRequest: 2.12\r\n\r\nRequire-book: no\r\nRequire-notes: no\r\n(cherry picked from commit 84480cf83e1c8cf1d652e7ab6e005ba1dd7a57a8)"},"comment":{"url":"https://api.github.com/repos/dCache/dcache/issues/comments/220339615","html_url":"https://github.com/dCache/dcache/pull/2405#issuecomment-220339615","issue_url":"https://api.github.com/repos/dCache/dcache/issues/2405","id":220339615,"user":{"login":"DmitryLitvintsev","id":2091655,"avatar_url":"https://avatars.githubusercontent.com/u/2091655?v=3","gravatar_id":"","url":"https://api.github.com/users/DmitryLitvintsev","html_url":"https://github.com/DmitryLitvintsev","followers_url":"https://api.github.com/users/DmitryLitvintsev/followers","following_url":"https://api.github.com/users/DmitryLitvintsev/following{/other_user}","gists_url":"https://api.github.com/users/DmitryLitvintsev/gists{/gist_id}","starred_url":"https://api.github.com/users/DmitryLitvintsev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DmitryLitvintsev/subscriptions","organizations_url":"https://api.github.com/users/DmitryLitvintsev/orgs","repos_url":"https://api.github.com/users/DmitryLitvintsev/repos","events_url":"https://api.github.com/users/DmitryLitvintsev/events{/privacy}","received_events_url":"https://api.github.com/users/DmitryLitvintsev/received_events","type":"User","site_admin":false},"created_at":"2016-05-19T14:23:20Z","updated_at":"2016-05-19T14:23:20Z","body":"Hi Marina, \r\n\r\nWhat \"retest this please\" means?\r\n \r\nAre there any issues with this pool request?\r\n"}}