{"action":"created","issue":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/5558","labels_url":"https://api.github.com/repos/dmwm/WMCore/issues/5558/labels{/name}","comments_url":"https://api.github.com/repos/dmwm/WMCore/issues/5558/comments","events_url":"https://api.github.com/repos/dmwm/WMCore/issues/5558/events","html_url":"https://github.com/dmwm/WMCore/pull/5558","id":53683110,"number":5558,"title":"some preliminary work for a copy-delete type subscription","user":{"login":"hufnagel","id":1798355,"avatar_url":"https://avatars.githubusercontent.com/u/1798355?v=3","gravatar_id":"","url":"https://api.github.com/users/hufnagel","html_url":"https://github.com/hufnagel","followers_url":"https://api.github.com/users/hufnagel/followers","following_url":"https://api.github.com/users/hufnagel/following{/other_user}","gists_url":"https://api.github.com/users/hufnagel/gists{/gist_id}","starred_url":"https://api.github.com/users/hufnagel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hufnagel/subscriptions","organizations_url":"https://api.github.com/users/hufnagel/orgs","repos_url":"https://api.github.com/users/hufnagel/repos","events_url":"https://api.github.com/users/hufnagel/events{/privacy}","received_events_url":"https://api.github.com/users/hufnagel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-07T21:15:35Z","updated_at":"2015-01-07T21:16:58Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dmwm/WMCore/pulls/5558","html_url":"https://github.com/dmwm/WMCore/pull/5558","diff_url":"https://github.com/dmwm/WMCore/pull/5558.diff","patch_url":"https://github.com/dmwm/WMCore/pull/5558.patch"},"body":"Normally there are only two subscription modes supported, copy or move.\r\nWe want to implement a delayed move, consisting of a copy first, followed by\r\na delete from the source site once the workflow creating the data is done.\r\n\r\nThese are some prelimary changes for this. The main changes are in the schema,\r\nadding a delete_blocks column to dbsbuffer_dataset_subscription and a\r\ndeleted column to dbsbuffer_block. To make this work, we also needed to\r\nadd a FK constrained dataset_id column to dbsbuffer_block, which then\r\nforced us to make some code changes to properly fill this.\r\n\r\nThese code changes then triggered some neccessary cleanup work. Tried to\r\nkeep it as minimal as possible though for now, more is to come."},"comment":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/comments/69093511","html_url":"https://github.com/dmwm/WMCore/pull/5558#issuecomment-69093511","issue_url":"https://api.github.com/repos/dmwm/WMCore/issues/5558","id":69093511,"user":{"login":"hufnagel","id":1798355,"avatar_url":"https://avatars.githubusercontent.com/u/1798355?v=3","gravatar_id":"","url":"https://api.github.com/users/hufnagel","html_url":"https://github.com/hufnagel","followers_url":"https://api.github.com/users/hufnagel/followers","following_url":"https://api.github.com/users/hufnagel/following{/other_user}","gists_url":"https://api.github.com/users/hufnagel/gists{/gist_id}","starred_url":"https://api.github.com/users/hufnagel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hufnagel/subscriptions","organizations_url":"https://api.github.com/users/hufnagel/orgs","repos_url":"https://api.github.com/users/hufnagel/repos","events_url":"https://api.github.com/users/hufnagel/events{/privacy}","received_events_url":"https://api.github.com/users/hufnagel/received_events","type":"User","site_admin":false},"created_at":"2015-01-07T21:16:58Z","updated_at":"2015-01-07T21:16:58Z","body":"@ticoann , can you review ? I don't want to necessarily have this merged yet, but I would like for someone to have a look to see if this makes sense. This is actually functional, it did survive a Tier0 replay with many datasets and blocks inserted into DBS3 and PhEDEx. No idea about breaking unit tests though..."}}