{"action":"created","issue":{"url":"https://api.github.com/repos/square/keywhiz/issues/270","repository_url":"https://api.github.com/repos/square/keywhiz","labels_url":"https://api.github.com/repos/square/keywhiz/issues/270/labels{/name}","comments_url":"https://api.github.com/repos/square/keywhiz/issues/270/comments","events_url":"https://api.github.com/repos/square/keywhiz/issues/270/events","html_url":"https://github.com/square/keywhiz/pull/270","id":179359795,"number":270,"title":"Adds a lastSeen field to clients, and updates it when client is seen","user":{"login":"stfinney","id":3021851,"avatar_url":"https://avatars.githubusercontent.com/u/3021851?v=3","gravatar_id":"","url":"https://api.github.com/users/stfinney","html_url":"https://github.com/stfinney","followers_url":"https://api.github.com/users/stfinney/followers","following_url":"https://api.github.com/users/stfinney/following{/other_user}","gists_url":"https://api.github.com/users/stfinney/gists{/gist_id}","starred_url":"https://api.github.com/users/stfinney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stfinney/subscriptions","organizations_url":"https://api.github.com/users/stfinney/orgs","repos_url":"https://api.github.com/users/stfinney/repos","events_url":"https://api.github.com/users/stfinney/events{/privacy}","received_events_url":"https://api.github.com/users/stfinney/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"mcpherrinm","id":47425,"avatar_url":"https://avatars.githubusercontent.com/u/47425?v=3","gravatar_id":"","url":"https://api.github.com/users/mcpherrinm","html_url":"https://github.com/mcpherrinm","followers_url":"https://api.github.com/users/mcpherrinm/followers","following_url":"https://api.github.com/users/mcpherrinm/following{/other_user}","gists_url":"https://api.github.com/users/mcpherrinm/gists{/gist_id}","starred_url":"https://api.github.com/users/mcpherrinm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mcpherrinm/subscriptions","organizations_url":"https://api.github.com/users/mcpherrinm/orgs","repos_url":"https://api.github.com/users/mcpherrinm/repos","events_url":"https://api.github.com/users/mcpherrinm/events{/privacy}","received_events_url":"https://api.github.com/users/mcpherrinm/received_events","type":"User","site_admin":false},"assignees":[{"login":"mcpherrinm","id":47425,"avatar_url":"https://avatars.githubusercontent.com/u/47425?v=3","gravatar_id":"","url":"https://api.github.com/users/mcpherrinm","html_url":"https://github.com/mcpherrinm","followers_url":"https://api.github.com/users/mcpherrinm/followers","following_url":"https://api.github.com/users/mcpherrinm/following{/other_user}","gists_url":"https://api.github.com/users/mcpherrinm/gists{/gist_id}","starred_url":"https://api.github.com/users/mcpherrinm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mcpherrinm/subscriptions","organizations_url":"https://api.github.com/users/mcpherrinm/orgs","repos_url":"https://api.github.com/users/mcpherrinm/repos","events_url":"https://api.github.com/users/mcpherrinm/events{/privacy}","received_events_url":"https://api.github.com/users/mcpherrinm/received_events","type":"User","site_admin":false},{"login":"worldwise001","id":320682,"avatar_url":"https://avatars.githubusercontent.com/u/320682?v=3","gravatar_id":"","url":"https://api.github.com/users/worldwise001","html_url":"https://github.com/worldwise001","followers_url":"https://api.github.com/users/worldwise001/followers","following_url":"https://api.github.com/users/worldwise001/following{/other_user}","gists_url":"https://api.github.com/users/worldwise001/gists{/gist_id}","starred_url":"https://api.github.com/users/worldwise001/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/worldwise001/subscriptions","organizations_url":"https://api.github.com/users/worldwise001/orgs","repos_url":"https://api.github.com/users/worldwise001/repos","events_url":"https://api.github.com/users/worldwise001/events{/privacy}","received_events_url":"https://api.github.com/users/worldwise001/received_events","type":"User","site_admin":false},{"login":"alokmenghrajani","id":441307,"avatar_url":"https://avatars.githubusercontent.com/u/441307?v=3","gravatar_id":"","url":"https://api.github.com/users/alokmenghrajani","html_url":"https://github.com/alokmenghrajani","followers_url":"https://api.github.com/users/alokmenghrajani/followers","following_url":"https://api.github.com/users/alokmenghrajani/following{/other_user}","gists_url":"https://api.github.com/users/alokmenghrajani/gists{/gist_id}","starred_url":"https://api.github.com/users/alokmenghrajani/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alokmenghrajani/subscriptions","organizations_url":"https://api.github.com/users/alokmenghrajani/orgs","repos_url":"https://api.github.com/users/alokmenghrajani/repos","events_url":"https://api.github.com/users/alokmenghrajani/events{/privacy}","received_events_url":"https://api.github.com/users/alokmenghrajani/received_events","type":"User","site_admin":false},{"login":"csstaub","id":639883,"avatar_url":"https://avatars.githubusercontent.com/u/639883?v=3","gravatar_id":"","url":"https://api.github.com/users/csstaub","html_url":"https://github.com/csstaub","followers_url":"https://api.github.com/users/csstaub/followers","following_url":"https://api.github.com/users/csstaub/following{/other_user}","gists_url":"https://api.github.com/users/csstaub/gists{/gist_id}","starred_url":"https://api.github.com/users/csstaub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csstaub/subscriptions","organizations_url":"https://api.github.com/users/csstaub/orgs","repos_url":"https://api.github.com/users/csstaub/repos","events_url":"https://api.github.com/users/csstaub/events{/privacy}","received_events_url":"https://api.github.com/users/csstaub/received_events","type":"User","site_admin":false},{"login":"stfinney","id":3021851,"avatar_url":"https://avatars.githubusercontent.com/u/3021851?v=3","gravatar_id":"","url":"https://api.github.com/users/stfinney","html_url":"https://github.com/stfinney","followers_url":"https://api.github.com/users/stfinney/followers","following_url":"https://api.github.com/users/stfinney/following{/other_user}","gists_url":"https://api.github.com/users/stfinney/gists{/gist_id}","starred_url":"https://api.github.com/users/stfinney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stfinney/subscriptions","organizations_url":"https://api.github.com/users/stfinney/orgs","repos_url":"https://api.github.com/users/stfinney/repos","events_url":"https://api.github.com/users/stfinney/events{/privacy}","received_events_url":"https://api.github.com/users/stfinney/received_events","type":"User","site_admin":false},{"login":"jbpeirce","id":13395970,"avatar_url":"https://avatars.githubusercontent.com/u/13395970?v=3","gravatar_id":"","url":"https://api.github.com/users/jbpeirce","html_url":"https://github.com/jbpeirce","followers_url":"https://api.github.com/users/jbpeirce/followers","following_url":"https://api.github.com/users/jbpeirce/following{/other_user}","gists_url":"https://api.github.com/users/jbpeirce/gists{/gist_id}","starred_url":"https://api.github.com/users/jbpeirce/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbpeirce/subscriptions","organizations_url":"https://api.github.com/users/jbpeirce/orgs","repos_url":"https://api.github.com/users/jbpeirce/repos","events_url":"https://api.github.com/users/jbpeirce/events{/privacy}","received_events_url":"https://api.github.com/users/jbpeirce/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2016-09-26T23:11:30Z","updated_at":"2016-09-29T22:49:10Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/square/keywhiz/pulls/270","html_url":"https://github.com/square/keywhiz/pull/270","diff_url":"https://github.com/square/keywhiz/pull/270.diff","patch_url":"https://github.com/square/keywhiz/pull/270.patch"},"body":"Client lastSeen is updated in ClientAuthFactory, which produces the client object for every API endpoint."},"comment":{"url":"https://api.github.com/repos/square/keywhiz/issues/comments/250614346","html_url":"https://github.com/square/keywhiz/pull/270#issuecomment-250614346","issue_url":"https://api.github.com/repos/square/keywhiz/issues/270","id":250614346,"user":{"login":"csstaub","id":639883,"avatar_url":"https://avatars.githubusercontent.com/u/639883?v=3","gravatar_id":"","url":"https://api.github.com/users/csstaub","html_url":"https://github.com/csstaub","followers_url":"https://api.github.com/users/csstaub/followers","following_url":"https://api.github.com/users/csstaub/following{/other_user}","gists_url":"https://api.github.com/users/csstaub/gists{/gist_id}","starred_url":"https://api.github.com/users/csstaub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csstaub/subscriptions","organizations_url":"https://api.github.com/users/csstaub/orgs","repos_url":"https://api.github.com/users/csstaub/repos","events_url":"https://api.github.com/users/csstaub/events{/privacy}","received_events_url":"https://api.github.com/users/csstaub/received_events","type":"User","site_admin":false},"created_at":"2016-09-29T22:49:10Z","updated_at":"2016-09-29T22:49:10Z","body":":( \r\n```\r\norg.jooq.exception.DataAccessException: SQL [update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int)]; Cannot parse \"TIMESTAMP\" constant \"1475185281\"; SQL statement:\r\nupdate CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int) [22007-187]\r\n\tat org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:275)\r\n```"}}
{"actor":{"display_login":"csstaub"}}