{"action":"closed","issue":{"url":"https://api.github.com/repos/Sinar/telus/issues/5","repository_url":"https://api.github.com/repos/Sinar/telus","labels_url":"https://api.github.com/repos/Sinar/telus/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/Sinar/telus/issues/5/comments","events_url":"https://api.github.com/repos/Sinar/telus/issues/5/events","html_url":"https://github.com/Sinar/telus/issues/5","id":248237664,"number":5,"title":"Combine data from database or record file and JSON data from API","user":{"login":"kmubiin","id":30212524,"avatar_url":"https://avatars3.githubusercontent.com/u/30212524?v=4","gravatar_id":"","url":"https://api.github.com/users/kmubiin","html_url":"https://github.com/kmubiin","followers_url":"https://api.github.com/users/kmubiin/followers","following_url":"https://api.github.com/users/kmubiin/following{/other_user}","gists_url":"https://api.github.com/users/kmubiin/gists{/gist_id}","starred_url":"https://api.github.com/users/kmubiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmubiin/subscriptions","organizations_url":"https://api.github.com/users/kmubiin/orgs","repos_url":"https://api.github.com/users/kmubiin/repos","events_url":"https://api.github.com/users/kmubiin/events{/privacy}","received_events_url":"https://api.github.com/users/kmubiin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"kmubiin","id":30212524,"avatar_url":"https://avatars3.githubusercontent.com/u/30212524?v=4","gravatar_id":"","url":"https://api.github.com/users/kmubiin","html_url":"https://github.com/kmubiin","followers_url":"https://api.github.com/users/kmubiin/followers","following_url":"https://api.github.com/users/kmubiin/following{/other_user}","gists_url":"https://api.github.com/users/kmubiin/gists{/gist_id}","starred_url":"https://api.github.com/users/kmubiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmubiin/subscriptions","organizations_url":"https://api.github.com/users/kmubiin/orgs","repos_url":"https://api.github.com/users/kmubiin/repos","events_url":"https://api.github.com/users/kmubiin/events{/privacy}","received_events_url":"https://api.github.com/users/kmubiin/received_events","type":"User","site_admin":false},"assignees":[{"login":"kmubiin","id":30212524,"avatar_url":"https://avatars3.githubusercontent.com/u/30212524?v=4","gravatar_id":"","url":"https://api.github.com/users/kmubiin","html_url":"https://github.com/kmubiin","followers_url":"https://api.github.com/users/kmubiin/followers","following_url":"https://api.github.com/users/kmubiin/following{/other_user}","gists_url":"https://api.github.com/users/kmubiin/gists{/gist_id}","starred_url":"https://api.github.com/users/kmubiin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmubiin/subscriptions","organizations_url":"https://api.github.com/users/kmubiin/orgs","repos_url":"https://api.github.com/users/kmubiin/repos","events_url":"https://api.github.com/users/kmubiin/events{/privacy}","received_events_url":"https://api.github.com/users/kmubiin/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2017-08-06T10:02:49Z","updated_at":"2017-09-22T09:15:31Z","closed_at":"2017-09-22T09:15:31Z","author_association":"COLLABORATOR","body":"This follows after #4 that prepares SQLite database or MongoDB record file.\r\n\r\nThe following would be the steps to achieve combined data.\r\n\r\n1. Prepare JSON data using dummy record (nested elements to contain three separate dictionaries i.e. \"contracts\": {}, \"persons\": {}, \"organizations\": {} and at least one common filed i.e. \"name\" in respective dictionaries)\r\n2. Store JSON data from 1 to SQLite/MongoDB (using tested method in previous issue)\r\n3. Fetch JSON data from API (nested element contain common field i.e. \"name\" with 2) and hold temporarily as 'dict' type variable (*not* nested list, no need 'for-loop')\r\n4. Compare common field i.e. \"name\" from 2 and 3, if matching, then fetch particular fields from 2 and insert these particular fields into 3\r\n5. Output as JSON literal after combining particular fields in 4\r\n\r\n**UPDATE** The steps above were not clearly defined (no idea without real data) when this issue was first posted. As such, the steps above are subject to changes.\r\n\r\n**REMARKS** So far the remaining issue that follows after this, is to implement REST API. Additionally, use of toolkit that provides ORM may be tested to speed up coding whilst improving codes later. The toolkit is useful only when dealing with SQLite database for easier access to data."}}
{"actor":{"display_login":"kmubiin"}}