{"action":"created","comment":{"url":"https://api.github.com/repos/mozilla/activity-streams/pulls/comments/54112920","id":54112920,"diff_hunk":"@@ -194,17 +194,27 @@ Links.prototype = {\n       limit = HISTORY_RESULTS_LIMIT;\n     }\n \n-    let sqlQuery =  `SELECT moz_places.url as url, moz_favicons.data as favicon, mime_type as mimeType,\n-                            title, frecency, last_visit_date as lastVisitDate,  \"history\"  as type\n+    let sqlQuery =  `SELECT moz_places.url as url,\n+                            moz_favicons.data as favicon,\n+                            moz_favicons.mime_type as mimeType,\n+                            moz_places.title,\n+                            moz_places.frecency,\n+                            moz_places.last_visit_date as lastVisitDate,\n+                            \"history\"  as type,\n+                            moz_bookmarks.guid as bookmarkGuid,\n+                            moz_bookmarks.dateAdded / 1000 as bookmarkDateCreated","path":"lib/PlacesProvider.js","position":14,"original_position":14,"commit_id":"2213d8f7a86d7c6e4e3625afe884e2dd3940de9d","original_commit_id":"2213d8f7a86d7c6e4e3625afe884e2dd3940de9d","user":{"login":"k88hudson","id":1455535,"avatar_url":"https://avatars.githubusercontent.com/u/1455535?v=3","gravatar_id":"","url":"https://api.github.com/users/k88hudson","html_url":"https://github.com/k88hudson","followers_url":"https://api.github.com/users/k88hudson/followers","following_url":"https://api.github.com/users/k88hudson/following{/other_user}","gists_url":"https://api.github.com/users/k88hudson/gists{/gist_id}","starred_url":"https://api.github.com/users/k88hudson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k88hudson/subscriptions","organizations_url":"https://api.github.com/users/k88hudson/orgs","repos_url":"https://api.github.com/users/k88hudson/repos","events_url":"https://api.github.com/users/k88hudson/events{/privacy}","received_events_url":"https://api.github.com/users/k88hudson/received_events","type":"User","site_admin":false},"body":"not for this ticket/now obviously but would be nice to have","created_at":"2016-02-25T15:36:09Z","updated_at":"2016-02-25T15:36:09Z","html_url":"https://github.com/mozilla/activity-streams/pull/186#discussion_r54112920","pull_request_url":"https://api.github.com/repos/mozilla/activity-streams/pulls/186","_links":{"self":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/comments/54112920"},"html":{"href":"https://github.com/mozilla/activity-streams/pull/186#discussion_r54112920"},"pull_request":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/186"}}},"pull_request":{"url":"https://api.github.com/repos/mozilla/activity-streams/pulls/186","id":60416168,"html_url":"https://github.com/mozilla/activity-streams/pull/186","diff_url":"https://github.com/mozilla/activity-streams/pull/186.diff","patch_url":"https://github.com/mozilla/activity-streams/pull/186.patch","issue_url":"https://api.github.com/repos/mozilla/activity-streams/issues/186","number":186,"state":"open","locked":false,"title":"Closes  #165 - Add bookmark status to Recent Links API query","user":{"login":"mzhilyaev","id":999285,"avatar_url":"https://avatars.githubusercontent.com/u/999285?v=3","gravatar_id":"","url":"https://api.github.com/users/mzhilyaev","html_url":"https://github.com/mzhilyaev","followers_url":"https://api.github.com/users/mzhilyaev/followers","following_url":"https://api.github.com/users/mzhilyaev/following{/other_user}","gists_url":"https://api.github.com/users/mzhilyaev/gists{/gist_id}","starred_url":"https://api.github.com/users/mzhilyaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzhilyaev/subscriptions","organizations_url":"https://api.github.com/users/mzhilyaev/orgs","repos_url":"https://api.github.com/users/mzhilyaev/repos","events_url":"https://api.github.com/users/mzhilyaev/events{/privacy}","received_events_url":"https://api.github.com/users/mzhilyaev/received_events","type":"User","site_admin":false},"body":"Fixes #165 ","created_at":"2016-02-23T21:51:11Z","updated_at":"2016-02-25T15:36:09Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2f6e7514af48b541aaffe7ecfdcff754c7ff6429","assignee":{"login":"mzhilyaev","id":999285,"avatar_url":"https://avatars.githubusercontent.com/u/999285?v=3","gravatar_id":"","url":"https://api.github.com/users/mzhilyaev","html_url":"https://github.com/mzhilyaev","followers_url":"https://api.github.com/users/mzhilyaev/followers","following_url":"https://api.github.com/users/mzhilyaev/following{/other_user}","gists_url":"https://api.github.com/users/mzhilyaev/gists{/gist_id}","starred_url":"https://api.github.com/users/mzhilyaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzhilyaev/subscriptions","organizations_url":"https://api.github.com/users/mzhilyaev/orgs","repos_url":"https://api.github.com/users/mzhilyaev/repos","events_url":"https://api.github.com/users/mzhilyaev/events{/privacy}","received_events_url":"https://api.github.com/users/mzhilyaev/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/mozilla/activity-streams/pulls/186/commits","review_comments_url":"https://api.github.com/repos/mozilla/activity-streams/pulls/186/comments","review_comment_url":"https://api.github.com/repos/mozilla/activity-streams/pulls/comments{/number}","comments_url":"https://api.github.com/repos/mozilla/activity-streams/issues/186/comments","statuses_url":"https://api.github.com/repos/mozilla/activity-streams/statuses/2213d8f7a86d7c6e4e3625afe884e2dd3940de9d","head":{"label":"mozilla:Bug165_BookmarkStatus","ref":"Bug165_BookmarkStatus","sha":"2213d8f7a86d7c6e4e3625afe884e2dd3940de9d","user":{"login":"mozilla","id":131524,"avatar_url":"https://avatars.githubusercontent.com/u/131524?v=3","gravatar_id":"","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"repo":{"id":50695589,"name":"activity-streams","full_name":"mozilla/activity-streams","owner":{"login":"mozilla","id":131524,"avatar_url":"https://avatars.githubusercontent.com/u/131524?v=3","gravatar_id":"","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mozilla/activity-streams","description":" MVP prototype add-on for activity streams","fork":false,"url":"https://api.github.com/repos/mozilla/activity-streams","forks_url":"https://api.github.com/repos/mozilla/activity-streams/forks","keys_url":"https://api.github.com/repos/mozilla/activity-streams/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mozilla/activity-streams/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mozilla/activity-streams/teams","hooks_url":"https://api.github.com/repos/mozilla/activity-streams/hooks","issue_events_url":"https://api.github.com/repos/mozilla/activity-streams/issues/events{/number}","events_url":"https://api.github.com/repos/mozilla/activity-streams/events","assignees_url":"https://api.github.com/repos/mozilla/activity-streams/assignees{/user}","branches_url":"https://api.github.com/repos/mozilla/activity-streams/branches{/branch}","tags_url":"https://api.github.com/repos/mozilla/activity-streams/tags","blobs_url":"https://api.github.com/repos/mozilla/activity-streams/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mozilla/activity-streams/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mozilla/activity-streams/git/refs{/sha}","trees_url":"https://api.github.com/repos/mozilla/activity-streams/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mozilla/activity-streams/statuses/{sha}","languages_url":"https://api.github.com/repos/mozilla/activity-streams/languages","stargazers_url":"https://api.github.com/repos/mozilla/activity-streams/stargazers","contributors_url":"https://api.github.com/repos/mozilla/activity-streams/contributors","subscribers_url":"https://api.github.com/repos/mozilla/activity-streams/subscribers","subscription_url":"https://api.github.com/repos/mozilla/activity-streams/subscription","commits_url":"https://api.github.com/repos/mozilla/activity-streams/commits{/sha}","git_commits_url":"https://api.github.com/repos/mozilla/activity-streams/git/commits{/sha}","comments_url":"https://api.github.com/repos/mozilla/activity-streams/comments{/number}","issue_comment_url":"https://api.github.com/repos/mozilla/activity-streams/issues/comments{/number}","contents_url":"https://api.github.com/repos/mozilla/activity-streams/contents/{+path}","compare_url":"https://api.github.com/repos/mozilla/activity-streams/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mozilla/activity-streams/merges","archive_url":"https://api.github.com/repos/mozilla/activity-streams/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mozilla/activity-streams/downloads","issues_url":"https://api.github.com/repos/mozilla/activity-streams/issues{/number}","pulls_url":"https://api.github.com/repos/mozilla/activity-streams/pulls{/number}","milestones_url":"https://api.github.com/repos/mozilla/activity-streams/milestones{/number}","notifications_url":"https://api.github.com/repos/mozilla/activity-streams/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mozilla/activity-streams/labels{/name}","releases_url":"https://api.github.com/repos/mozilla/activity-streams/releases{/id}","deployments_url":"https://api.github.com/repos/mozilla/activity-streams/deployments","created_at":"2016-01-29T22:28:26Z","updated_at":"2016-02-20T17:35:36Z","pushed_at":"2016-02-25T15:32:58Z","git_url":"git://github.com/mozilla/activity-streams.git","ssh_url":"git@github.com:mozilla/activity-streams.git","clone_url":"https://github.com/mozilla/activity-streams.git","svn_url":"https://github.com/mozilla/activity-streams","homepage":"","size":464,"stargazers_count":9,"watchers_count":9,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":67,"forks":4,"open_issues":67,"watchers":9,"default_branch":"master"}},"base":{"label":"mozilla:master","ref":"master","sha":"77c0ec335b0b33a50b1ee1c8e3837181c0a0ac9a","user":{"login":"mozilla","id":131524,"avatar_url":"https://avatars.githubusercontent.com/u/131524?v=3","gravatar_id":"","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"repo":{"id":50695589,"name":"activity-streams","full_name":"mozilla/activity-streams","owner":{"login":"mozilla","id":131524,"avatar_url":"https://avatars.githubusercontent.com/u/131524?v=3","gravatar_id":"","url":"https://api.github.com/users/mozilla","html_url":"https://github.com/mozilla","followers_url":"https://api.github.com/users/mozilla/followers","following_url":"https://api.github.com/users/mozilla/following{/other_user}","gists_url":"https://api.github.com/users/mozilla/gists{/gist_id}","starred_url":"https://api.github.com/users/mozilla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mozilla/subscriptions","organizations_url":"https://api.github.com/users/mozilla/orgs","repos_url":"https://api.github.com/users/mozilla/repos","events_url":"https://api.github.com/users/mozilla/events{/privacy}","received_events_url":"https://api.github.com/users/mozilla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mozilla/activity-streams","description":" MVP prototype add-on for activity streams","fork":false,"url":"https://api.github.com/repos/mozilla/activity-streams","forks_url":"https://api.github.com/repos/mozilla/activity-streams/forks","keys_url":"https://api.github.com/repos/mozilla/activity-streams/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mozilla/activity-streams/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mozilla/activity-streams/teams","hooks_url":"https://api.github.com/repos/mozilla/activity-streams/hooks","issue_events_url":"https://api.github.com/repos/mozilla/activity-streams/issues/events{/number}","events_url":"https://api.github.com/repos/mozilla/activity-streams/events","assignees_url":"https://api.github.com/repos/mozilla/activity-streams/assignees{/user}","branches_url":"https://api.github.com/repos/mozilla/activity-streams/branches{/branch}","tags_url":"https://api.github.com/repos/mozilla/activity-streams/tags","blobs_url":"https://api.github.com/repos/mozilla/activity-streams/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mozilla/activity-streams/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mozilla/activity-streams/git/refs{/sha}","trees_url":"https://api.github.com/repos/mozilla/activity-streams/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mozilla/activity-streams/statuses/{sha}","languages_url":"https://api.github.com/repos/mozilla/activity-streams/languages","stargazers_url":"https://api.github.com/repos/mozilla/activity-streams/stargazers","contributors_url":"https://api.github.com/repos/mozilla/activity-streams/contributors","subscribers_url":"https://api.github.com/repos/mozilla/activity-streams/subscribers","subscription_url":"https://api.github.com/repos/mozilla/activity-streams/subscription","commits_url":"https://api.github.com/repos/mozilla/activity-streams/commits{/sha}","git_commits_url":"https://api.github.com/repos/mozilla/activity-streams/git/commits{/sha}","comments_url":"https://api.github.com/repos/mozilla/activity-streams/comments{/number}","issue_comment_url":"https://api.github.com/repos/mozilla/activity-streams/issues/comments{/number}","contents_url":"https://api.github.com/repos/mozilla/activity-streams/contents/{+path}","compare_url":"https://api.github.com/repos/mozilla/activity-streams/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mozilla/activity-streams/merges","archive_url":"https://api.github.com/repos/mozilla/activity-streams/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mozilla/activity-streams/downloads","issues_url":"https://api.github.com/repos/mozilla/activity-streams/issues{/number}","pulls_url":"https://api.github.com/repos/mozilla/activity-streams/pulls{/number}","milestones_url":"https://api.github.com/repos/mozilla/activity-streams/milestones{/number}","notifications_url":"https://api.github.com/repos/mozilla/activity-streams/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mozilla/activity-streams/labels{/name}","releases_url":"https://api.github.com/repos/mozilla/activity-streams/releases{/id}","deployments_url":"https://api.github.com/repos/mozilla/activity-streams/deployments","created_at":"2016-01-29T22:28:26Z","updated_at":"2016-02-20T17:35:36Z","pushed_at":"2016-02-25T15:32:58Z","git_url":"git://github.com/mozilla/activity-streams.git","ssh_url":"git@github.com:mozilla/activity-streams.git","clone_url":"https://github.com/mozilla/activity-streams.git","svn_url":"https://github.com/mozilla/activity-streams","homepage":"","size":464,"stargazers_count":9,"watchers_count":9,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":67,"forks":4,"open_issues":67,"watchers":9,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/186"},"html":{"href":"https://github.com/mozilla/activity-streams/pull/186"},"issue":{"href":"https://api.github.com/repos/mozilla/activity-streams/issues/186"},"comments":{"href":"https://api.github.com/repos/mozilla/activity-streams/issues/186/comments"},"review_comments":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/186/comments"},"review_comment":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/mozilla/activity-streams/pulls/186/commits"},"statuses":{"href":"https://api.github.com/repos/mozilla/activity-streams/statuses/2213d8f7a86d7c6e4e3625afe884e2dd3940de9d"}}}}