{"action":"created","issue":{"url":"https://api.github.com/repos/qwat/qwat-data-model/issues/61","labels_url":"https://api.github.com/repos/qwat/qwat-data-model/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/qwat/qwat-data-model/issues/61/comments","events_url":"https://api.github.com/repos/qwat/qwat-data-model/issues/61/events","html_url":"https://github.com/qwat/qwat-data-model/pull/61","id":108272647,"number":61,"title":"remove non std. materials, added water_meter flow_meter for chamber","user":{"login":"tudorbarascu","id":3179646,"avatar_url":"https://avatars.githubusercontent.com/u/3179646?v=3","gravatar_id":"","url":"https://api.github.com/users/tudorbarascu","html_url":"https://github.com/tudorbarascu","followers_url":"https://api.github.com/users/tudorbarascu/followers","following_url":"https://api.github.com/users/tudorbarascu/following{/other_user}","gists_url":"https://api.github.com/users/tudorbarascu/gists{/gist_id}","starred_url":"https://api.github.com/users/tudorbarascu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tudorbarascu/subscriptions","organizations_url":"https://api.github.com/users/tudorbarascu/orgs","repos_url":"https://api.github.com/users/tudorbarascu/repos","events_url":"https://api.github.com/users/tudorbarascu/events{/privacy}","received_events_url":"https://api.github.com/users/tudorbarascu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-09-25T06:39:32Z","updated_at":"2015-10-12T06:06:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/qwat/qwat-data-model/pulls/61","html_url":"https://github.com/qwat/qwat-data-model/pull/61","diff_url":"https://github.com/qwat/qwat-data-model/pull/61.diff","patch_url":"https://github.com/qwat/qwat-data-model/pull/61.patch"},"body":"As sometimes people in production refer to the approximate\r\nexternal diameter (for steep pipes) instead of the DN,\r\nthis commit ensures the correct materials can be corelated\r\nwith their DN.\r\n\r\nAlso removed pipe material with steel DN75, DN70, DN120, DN 180\r\n\r\nI couldn't find them in any standard\r\n\r\nFor migration matching in case anyone has saved pipes with the \"wrong\" materials:\r\n\r\nDN120     5103 should go into 5104      (DN125)\r\nDN180     5107 should go into 5106      (DN175)\r\nDN70       5117 should go into 5116      (DN65, DE 73)\r\nDN75       5118 should go into 5116      (DN65, DE 73)\r\n\r\nSomething like this should work:\r\n`update qwat_od.pipe set fk_material = 5116 where fk_material in (5117, 5118);`"},"comment":{"url":"https://api.github.com/repos/qwat/qwat-data-model/issues/comments/147298315","html_url":"https://github.com/qwat/qwat-data-model/pull/61#issuecomment-147298315","issue_url":"https://api.github.com/repos/qwat/qwat-data-model/issues/61","id":147298315,"user":{"login":"tudorbarascu","id":3179646,"avatar_url":"https://avatars.githubusercontent.com/u/3179646?v=3","gravatar_id":"","url":"https://api.github.com/users/tudorbarascu","html_url":"https://github.com/tudorbarascu","followers_url":"https://api.github.com/users/tudorbarascu/followers","following_url":"https://api.github.com/users/tudorbarascu/following{/other_user}","gists_url":"https://api.github.com/users/tudorbarascu/gists{/gist_id}","starred_url":"https://api.github.com/users/tudorbarascu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tudorbarascu/subscriptions","organizations_url":"https://api.github.com/users/tudorbarascu/orgs","repos_url":"https://api.github.com/users/tudorbarascu/repos","events_url":"https://api.github.com/users/tudorbarascu/events{/privacy}","received_events_url":"https://api.github.com/users/tudorbarascu/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T06:06:17Z","updated_at":"2015-10-12T06:06:17Z","body":"do you think I should split this pull between the material removals and the other commits so that they won't wait in queue?"}}