{"action":"created","issue":{"url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/64","repository_url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine","labels_url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/64/comments","events_url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/64/events","html_url":"https://github.com/RedHatInsights/vulnerability-engine/pull/64","id":387413063,"node_id":"MDExOlB1bGxSZXF1ZXN0MjM1OTA3MTM4","number":64,"title":"Introduce filtering, sorting and pagination support","user":{"login":"jdobes","id":6650196,"node_id":"MDQ6VXNlcjY2NTAxOTY=","avatar_url":"https://avatars0.githubusercontent.com/u/6650196?v=4","gravatar_id":"","url":"https://api.github.com/users/jdobes","html_url":"https://github.com/jdobes","followers_url":"https://api.github.com/users/jdobes/followers","following_url":"https://api.github.com/users/jdobes/following{/other_user}","gists_url":"https://api.github.com/users/jdobes/gists{/gist_id}","starred_url":"https://api.github.com/users/jdobes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdobes/subscriptions","organizations_url":"https://api.github.com/users/jdobes/orgs","repos_url":"https://api.github.com/users/jdobes/repos","events_url":"https://api.github.com/users/jdobes/events{/privacy}","received_events_url":"https://api.github.com/users/jdobes/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"tkasparek","id":6339153,"node_id":"MDQ6VXNlcjYzMzkxNTM=","avatar_url":"https://avatars2.githubusercontent.com/u/6339153?v=4","gravatar_id":"","url":"https://api.github.com/users/tkasparek","html_url":"https://github.com/tkasparek","followers_url":"https://api.github.com/users/tkasparek/followers","following_url":"https://api.github.com/users/tkasparek/following{/other_user}","gists_url":"https://api.github.com/users/tkasparek/gists{/gist_id}","starred_url":"https://api.github.com/users/tkasparek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkasparek/subscriptions","organizations_url":"https://api.github.com/users/tkasparek/orgs","repos_url":"https://api.github.com/users/tkasparek/repos","events_url":"https://api.github.com/users/tkasparek/events{/privacy}","received_events_url":"https://api.github.com/users/tkasparek/received_events","type":"User","site_admin":false},"assignees":[{"login":"tkasparek","id":6339153,"node_id":"MDQ6VXNlcjYzMzkxNTM=","avatar_url":"https://avatars2.githubusercontent.com/u/6339153?v=4","gravatar_id":"","url":"https://api.github.com/users/tkasparek","html_url":"https://github.com/tkasparek","followers_url":"https://api.github.com/users/tkasparek/followers","following_url":"https://api.github.com/users/tkasparek/following{/other_user}","gists_url":"https://api.github.com/users/tkasparek/gists{/gist_id}","starred_url":"https://api.github.com/users/tkasparek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkasparek/subscriptions","organizations_url":"https://api.github.com/users/tkasparek/orgs","repos_url":"https://api.github.com/users/tkasparek/repos","events_url":"https://api.github.com/users/tkasparek/events{/privacy}","received_events_url":"https://api.github.com/users/tkasparek/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-12-04T18:06:16Z","updated_at":"2018-12-05T09:52:28Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/pulls/64","html_url":"https://github.com/RedHatInsights/vulnerability-engine/pull/64","diff_url":"https://github.com/RedHatInsights/vulnerability-engine/pull/64.diff","patch_url":"https://github.com/RedHatInsights/vulnerability-engine/pull/64.patch"},"body":"- using peewee ORM to easily build queries\r\n- currently only 2 lists APIs in manager:\r\n  - /r/insights/platform/vulnerability/v1/vulnerabilities/cves\r\n  - /r/insights/platform/vulnerability/v1/vulnerabilities/errorkeys\r\n- only single filtering value supported currently (but can be searched in multiple DB columns)\r\n- example usage:\r\n`./scripts/3scale-mock curl -k \"https://vulnerability-engine-manager-vulnerability.192.168.42.14.nip.io/r/insights/platform/vulnerability/v1/vulnerabilities/cves?filter=speculative%20execution%20of%20instructions&sort=-cvss_score,public_date&page_size=2&page=2\" | python -m json.tool`\r\n- example output:\r\n```\r\n{\r\n    \"data\": [\r\n        {\r\n            \"attributes\": {\r\n                \"celebrity\": true,\r\n                \"cvss_score\": \"5.500\",\r\n                \"description\": \"An industry-wide issue was found in the way many modern microprocessor designs have implemented speculative execution of instructions (a commonly used performance optimization). There are three primary variants of the issue which differ in the way the speculative execution can be exploited. Variant CVE-2017-5753 triggers the speculative execution by performing a bounds-check bypass. It relies on the presence of a precisely-defined instruction sequence in the privileged code as well as the fact that memory accesses may cause allocation into the microprocessor's data cache even for speculatively executed instructions that never actually commit (retire). As a result, an unprivileged attacker could use this flaw to cross the syscall boundary and read privileged memory by conducting targeted cache side-channel attacks.\",\r\n                \"impact\": \"Important\",\r\n                \"public_date\": \"2018-01-03T00:00:00+00:00\",\r\n                \"synopsis\": \"CVE-2017-5753\",\r\n                \"systems_affected\": 2\r\n            },\r\n            \"id\": \"CVE-2017-5753\",\r\n            \"type\": \"cve\"\r\n        }\r\n    ],\r\n    \"meta\": {\r\n        \"filter\": \"speculative execution of instructions\",\r\n        \"page\": 2,\r\n        \"page_size\": 2,\r\n        \"pages\": 2,\r\n        \"sort\": \"-cvss_score,+public_date\",\r\n        \"total_items\": 3\r\n    }\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/comments/444425479","html_url":"https://github.com/RedHatInsights/vulnerability-engine/pull/64#issuecomment-444425479","issue_url":"https://api.github.com/repos/RedHatInsights/vulnerability-engine/issues/64","id":444425479,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NDQyNTQ3OQ==","user":{"login":"tkasparek","id":6339153,"node_id":"MDQ6VXNlcjYzMzkxNTM=","avatar_url":"https://avatars2.githubusercontent.com/u/6339153?v=4","gravatar_id":"","url":"https://api.github.com/users/tkasparek","html_url":"https://github.com/tkasparek","followers_url":"https://api.github.com/users/tkasparek/followers","following_url":"https://api.github.com/users/tkasparek/following{/other_user}","gists_url":"https://api.github.com/users/tkasparek/gists{/gist_id}","starred_url":"https://api.github.com/users/tkasparek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkasparek/subscriptions","organizations_url":"https://api.github.com/users/tkasparek/orgs","repos_url":"https://api.github.com/users/tkasparek/repos","events_url":"https://api.github.com/users/tkasparek/events{/privacy}","received_events_url":"https://api.github.com/users/tkasparek/received_events","type":"User","site_admin":false},"created_at":"2018-12-05T09:52:28Z","updated_at":"2018-12-05T09:52:28Z","author_association":"CONTRIBUTOR","body":"Is there a possibility to sort by id?"}}
{"actor":{"display_login":"tkasparek"}}