{"action":"closed","number":564,"pull_request":{"url":"https://api.github.com/repos/facebook/osquery/pulls/564","id":26708543,"html_url":"https://github.com/facebook/osquery/pull/564","diff_url":"https://github.com/facebook/osquery/pull/564.diff","patch_url":"https://github.com/facebook/osquery/pull/564.patch","issue_url":"https://api.github.com/repos/facebook/osquery/issues/564","number":564,"state":"closed","locked":false,"title":"resurrect the deb_packages table","user":{"login":"maclennann","id":192728,"avatar_url":"https://avatars.githubusercontent.com/u/192728?v=3","gravatar_id":"","url":"https://api.github.com/users/maclennann","html_url":"https://github.com/maclennann","followers_url":"https://api.github.com/users/maclennann/followers","following_url":"https://api.github.com/users/maclennann/following{/other_user}","gists_url":"https://api.github.com/users/maclennann/gists{/gist_id}","starred_url":"https://api.github.com/users/maclennann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maclennann/subscriptions","organizations_url":"https://api.github.com/users/maclennann/orgs","repos_url":"https://api.github.com/users/maclennann/repos","events_url":"https://api.github.com/users/maclennann/events{/privacy}","received_events_url":"https://api.github.com/users/maclennann/received_events","type":"User","site_admin":false},"body":"This is an attempt to pick up where #324 / #325 left off.\r\n\r\nI basically resurrected everything as it stood from that PR with minor changes to get it compiling again. The only notable change is `:145` and `:146` - without closing the package DB between queries, `pkg_array_init_from_db` bombs out when it tries to load in each of the packages again thinking they're duplicates.\r\n\r\nI wasn't sure if there was any technical reason that #325 was closed, or if it was just inactivity. If there was any further work to be done for it, I'd be happy to take a crack.","created_at":"2014-12-30T23:10:01Z","updated_at":"2015-01-02T19:15:56Z","closed_at":"2015-01-02T19:15:56Z","merged_at":"2015-01-02T19:15:56Z","merge_commit_sha":"1fb1c66ea5fa0757971af9b5dd1d307092b6f21a","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/facebook/osquery/pulls/564/commits","review_comments_url":"https://api.github.com/repos/facebook/osquery/pulls/564/comments","review_comment_url":"https://api.github.com/repos/facebook/osquery/pulls/comments/{number}","comments_url":"https://api.github.com/repos/facebook/osquery/issues/564/comments","statuses_url":"https://api.github.com/repos/facebook/osquery/statuses/cf08d605f0aa8e13c5396a02cb35fe7510962382","head":{"label":"maclennann:deb_packages","ref":"deb_packages","sha":"cf08d605f0aa8e13c5396a02cb35fe7510962382","user":{"login":"maclennann","id":192728,"avatar_url":"https://avatars.githubusercontent.com/u/192728?v=3","gravatar_id":"","url":"https://api.github.com/users/maclennann","html_url":"https://github.com/maclennann","followers_url":"https://api.github.com/users/maclennann/followers","following_url":"https://api.github.com/users/maclennann/following{/other_user}","gists_url":"https://api.github.com/users/maclennann/gists{/gist_id}","starred_url":"https://api.github.com/users/maclennann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maclennann/subscriptions","organizations_url":"https://api.github.com/users/maclennann/orgs","repos_url":"https://api.github.com/users/maclennann/repos","events_url":"https://api.github.com/users/maclennann/events{/privacy}","received_events_url":"https://api.github.com/users/maclennann/received_events","type":"User","site_admin":false},"repo":{"id":28601952,"name":"osquery","full_name":"maclennann/osquery","owner":{"login":"maclennann","id":192728,"avatar_url":"https://avatars.githubusercontent.com/u/192728?v=3","gravatar_id":"","url":"https://api.github.com/users/maclennann","html_url":"https://github.com/maclennann","followers_url":"https://api.github.com/users/maclennann/followers","following_url":"https://api.github.com/users/maclennann/following{/other_user}","gists_url":"https://api.github.com/users/maclennann/gists{/gist_id}","starred_url":"https://api.github.com/users/maclennann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maclennann/subscriptions","organizations_url":"https://api.github.com/users/maclennann/orgs","repos_url":"https://api.github.com/users/maclennann/repos","events_url":"https://api.github.com/users/maclennann/events{/privacy}","received_events_url":"https://api.github.com/users/maclennann/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/maclennann/osquery","description":"SQL powered operating system instrumentation, monitoring, and analytics.","fork":true,"url":"https://api.github.com/repos/maclennann/osquery","forks_url":"https://api.github.com/repos/maclennann/osquery/forks","keys_url":"https://api.github.com/repos/maclennann/osquery/keys{/key_id}","collaborators_url":"https://api.github.com/repos/maclennann/osquery/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/maclennann/osquery/teams","hooks_url":"https://api.github.com/repos/maclennann/osquery/hooks","issue_events_url":"https://api.github.com/repos/maclennann/osquery/issues/events{/number}","events_url":"https://api.github.com/repos/maclennann/osquery/events","assignees_url":"https://api.github.com/repos/maclennann/osquery/assignees{/user}","branches_url":"https://api.github.com/repos/maclennann/osquery/branches{/branch}","tags_url":"https://api.github.com/repos/maclennann/osquery/tags","blobs_url":"https://api.github.com/repos/maclennann/osquery/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/maclennann/osquery/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/maclennann/osquery/git/refs{/sha}","trees_url":"https://api.github.com/repos/maclennann/osquery/git/trees{/sha}","statuses_url":"https://api.github.com/repos/maclennann/osquery/statuses/{sha}","languages_url":"https://api.github.com/repos/maclennann/osquery/languages","stargazers_url":"https://api.github.com/repos/maclennann/osquery/stargazers","contributors_url":"https://api.github.com/repos/maclennann/osquery/contributors","subscribers_url":"https://api.github.com/repos/maclennann/osquery/subscribers","subscription_url":"https://api.github.com/repos/maclennann/osquery/subscription","commits_url":"https://api.github.com/repos/maclennann/osquery/commits{/sha}","git_commits_url":"https://api.github.com/repos/maclennann/osquery/git/commits{/sha}","comments_url":"https://api.github.com/repos/maclennann/osquery/comments{/number}","issue_comment_url":"https://api.github.com/repos/maclennann/osquery/issues/comments/{number}","contents_url":"https://api.github.com/repos/maclennann/osquery/contents/{+path}","compare_url":"https://api.github.com/repos/maclennann/osquery/compare/{base}...{head}","merges_url":"https://api.github.com/repos/maclennann/osquery/merges","archive_url":"https://api.github.com/repos/maclennann/osquery/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/maclennann/osquery/downloads","issues_url":"https://api.github.com/repos/maclennann/osquery/issues{/number}","pulls_url":"https://api.github.com/repos/maclennann/osquery/pulls{/number}","milestones_url":"https://api.github.com/repos/maclennann/osquery/milestones{/number}","notifications_url":"https://api.github.com/repos/maclennann/osquery/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/maclennann/osquery/labels{/name}","releases_url":"https://api.github.com/repos/maclennann/osquery/releases{/id}","created_at":"2014-12-29T18:34:55Z","updated_at":"2014-12-30T20:15:59Z","pushed_at":"2015-01-02T18:30:20Z","git_url":"git://github.com/maclennann/osquery.git","ssh_url":"git@github.com:maclennann/osquery.git","clone_url":"https://github.com/maclennann/osquery.git","svn_url":"https://github.com/maclennann/osquery","homepage":"http://osquery.io","size":9494,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"facebook:master","ref":"master","sha":"94a0e531775f827cb77b99b3650cd9cfd1518dac","user":{"login":"facebook","id":69631,"avatar_url":"https://avatars.githubusercontent.com/u/69631?v=3","gravatar_id":"","url":"https://api.github.com/users/facebook","html_url":"https://github.com/facebook","followers_url":"https://api.github.com/users/facebook/followers","following_url":"https://api.github.com/users/facebook/following{/other_user}","gists_url":"https://api.github.com/users/facebook/gists{/gist_id}","starred_url":"https://api.github.com/users/facebook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/facebook/subscriptions","organizations_url":"https://api.github.com/users/facebook/orgs","repos_url":"https://api.github.com/users/facebook/repos","events_url":"https://api.github.com/users/facebook/events{/privacy}","received_events_url":"https://api.github.com/users/facebook/received_events","type":"Organization","site_admin":false},"repo":{"id":22394357,"name":"osquery","full_name":"facebook/osquery","owner":{"login":"facebook","id":69631,"avatar_url":"https://avatars.githubusercontent.com/u/69631?v=3","gravatar_id":"","url":"https://api.github.com/users/facebook","html_url":"https://github.com/facebook","followers_url":"https://api.github.com/users/facebook/followers","following_url":"https://api.github.com/users/facebook/following{/other_user}","gists_url":"https://api.github.com/users/facebook/gists{/gist_id}","starred_url":"https://api.github.com/users/facebook/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/facebook/subscriptions","organizations_url":"https://api.github.com/users/facebook/orgs","repos_url":"https://api.github.com/users/facebook/repos","events_url":"https://api.github.com/users/facebook/events{/privacy}","received_events_url":"https://api.github.com/users/facebook/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/facebook/osquery","description":"SQL powered operating system instrumentation, monitoring, and analytics.","fork":false,"url":"https://api.github.com/repos/facebook/osquery","forks_url":"https://api.github.com/repos/facebook/osquery/forks","keys_url":"https://api.github.com/repos/facebook/osquery/keys{/key_id}","collaborators_url":"https://api.github.com/repos/facebook/osquery/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/facebook/osquery/teams","hooks_url":"https://api.github.com/repos/facebook/osquery/hooks","issue_events_url":"https://api.github.com/repos/facebook/osquery/issues/events{/number}","events_url":"https://api.github.com/repos/facebook/osquery/events","assignees_url":"https://api.github.com/repos/facebook/osquery/assignees{/user}","branches_url":"https://api.github.com/repos/facebook/osquery/branches{/branch}","tags_url":"https://api.github.com/repos/facebook/osquery/tags","blobs_url":"https://api.github.com/repos/facebook/osquery/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/facebook/osquery/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/facebook/osquery/git/refs{/sha}","trees_url":"https://api.github.com/repos/facebook/osquery/git/trees{/sha}","statuses_url":"https://api.github.com/repos/facebook/osquery/statuses/{sha}","languages_url":"https://api.github.com/repos/facebook/osquery/languages","stargazers_url":"https://api.github.com/repos/facebook/osquery/stargazers","contributors_url":"https://api.github.com/repos/facebook/osquery/contributors","subscribers_url":"https://api.github.com/repos/facebook/osquery/subscribers","subscription_url":"https://api.github.com/repos/facebook/osquery/subscription","commits_url":"https://api.github.com/repos/facebook/osquery/commits{/sha}","git_commits_url":"https://api.github.com/repos/facebook/osquery/git/commits{/sha}","comments_url":"https://api.github.com/repos/facebook/osquery/comments{/number}","issue_comment_url":"https://api.github.com/repos/facebook/osquery/issues/comments/{number}","contents_url":"https://api.github.com/repos/facebook/osquery/contents/{+path}","compare_url":"https://api.github.com/repos/facebook/osquery/compare/{base}...{head}","merges_url":"https://api.github.com/repos/facebook/osquery/merges","archive_url":"https://api.github.com/repos/facebook/osquery/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/facebook/osquery/downloads","issues_url":"https://api.github.com/repos/facebook/osquery/issues{/number}","pulls_url":"https://api.github.com/repos/facebook/osquery/pulls{/number}","milestones_url":"https://api.github.com/repos/facebook/osquery/milestones{/number}","notifications_url":"https://api.github.com/repos/facebook/osquery/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/facebook/osquery/labels{/name}","releases_url":"https://api.github.com/repos/facebook/osquery/releases{/id}","created_at":"2014-07-29T20:27:33Z","updated_at":"2015-01-02T15:35:38Z","pushed_at":"2015-01-02T19:15:56Z","git_url":"git://github.com/facebook/osquery.git","ssh_url":"git@github.com:facebook/osquery.git","clone_url":"https://github.com/facebook/osquery.git","svn_url":"https://github.com/facebook/osquery","homepage":"http://osquery.io","size":9494,"stargazers_count":3436,"watchers_count":3436,"language":"C++","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":231,"mirror_url":null,"open_issues_count":56,"forks":231,"open_issues":56,"watchers":3436,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/facebook/osquery/pulls/564"},"html":{"href":"https://github.com/facebook/osquery/pull/564"},"issue":{"href":"https://api.github.com/repos/facebook/osquery/issues/564"},"comments":{"href":"https://api.github.com/repos/facebook/osquery/issues/564/comments"},"review_comments":{"href":"https://api.github.com/repos/facebook/osquery/pulls/564/comments"},"review_comment":{"href":"https://api.github.com/repos/facebook/osquery/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/facebook/osquery/pulls/564/commits"},"statuses":{"href":"https://api.github.com/repos/facebook/osquery/statuses/cf08d605f0aa8e13c5396a02cb35fe7510962382"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"theopolis","id":981645,"avatar_url":"https://avatars.githubusercontent.com/u/981645?v=3","gravatar_id":"","url":"https://api.github.com/users/theopolis","html_url":"https://github.com/theopolis","followers_url":"https://api.github.com/users/theopolis/followers","following_url":"https://api.github.com/users/theopolis/following{/other_user}","gists_url":"https://api.github.com/users/theopolis/gists{/gist_id}","starred_url":"https://api.github.com/users/theopolis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theopolis/subscriptions","organizations_url":"https://api.github.com/users/theopolis/orgs","repos_url":"https://api.github.com/users/theopolis/repos","events_url":"https://api.github.com/users/theopolis/events{/privacy}","received_events_url":"https://api.github.com/users/theopolis/received_events","type":"User","site_admin":false},"comments":9,"review_comments":10,"commits":5,"additions":215,"deletions":1,"changed_files":4}}