{"action":"created","issue":{"url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/113","repository_url":"https://api.github.com/repos/davidmckenzie/pagermon","labels_url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/113/labels{/name}","comments_url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/113/comments","events_url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/113/events","html_url":"https://github.com/davidmckenzie/pagermon/pull/113","id":376242256,"node_id":"MDExOlB1bGxSZXF1ZXN0MjI3NTA0NDU2","number":113,"title":"Add Telegram Support - Bump to version 0.1.9","user":{"login":"DanrwAU","id":26653344,"node_id":"MDQ6VXNlcjI2NjUzMzQ0","avatar_url":"https://avatars0.githubusercontent.com/u/26653344?v=4","gravatar_id":"","url":"https://api.github.com/users/DanrwAU","html_url":"https://github.com/DanrwAU","followers_url":"https://api.github.com/users/DanrwAU/followers","following_url":"https://api.github.com/users/DanrwAU/following{/other_user}","gists_url":"https://api.github.com/users/DanrwAU/gists{/gist_id}","starred_url":"https://api.github.com/users/DanrwAU/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DanrwAU/subscriptions","organizations_url":"https://api.github.com/users/DanrwAU/orgs","repos_url":"https://api.github.com/users/DanrwAU/repos","events_url":"https://api.github.com/users/DanrwAU/events{/privacy}","received_events_url":"https://api.github.com/users/DanrwAU/received_events","type":"User","site_admin":false},"labels":[{"id":620384362,"node_id":"MDU6TGFiZWw2MjAzODQzNjI=","url":"https://api.github.com/repos/davidmckenzie/pagermon/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-11-01T03:42:27Z","updated_at":"2018-11-02T22:03:09Z","closed_at":null,"author_association":"COLLABORATOR","pull_request":{"url":"https://api.github.com/repos/davidmckenzie/pagermon/pulls/113","html_url":"https://github.com/davidmckenzie/pagermon/pull/113","diff_url":"https://github.com/davidmckenzie/pagermon/pull/113.diff","patch_url":"https://github.com/davidmckenzie/pagermon/pull/113.patch"},"body":"Adds Telegram support as a notification provider.\r\n\r\nRequires the following on existing databases\r\n\r\n```\r\nALTER TABLE capcodes ADD COLUMN telegram INTEGER DEFAULT 0; \r\nALTER TABLE capcodes ADD COLUMN telechat TEXT;\r\n```"},"comment":{"url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/comments/435522547","html_url":"https://github.com/davidmckenzie/pagermon/pull/113#issuecomment-435522547","issue_url":"https://api.github.com/repos/davidmckenzie/pagermon/issues/113","id":435522547,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNTUyMjU0Nw==","user":{"login":"davidmckenzie","id":1100348,"node_id":"MDQ6VXNlcjExMDAzNDg=","avatar_url":"https://avatars3.githubusercontent.com/u/1100348?v=4","gravatar_id":"","url":"https://api.github.com/users/davidmckenzie","html_url":"https://github.com/davidmckenzie","followers_url":"https://api.github.com/users/davidmckenzie/followers","following_url":"https://api.github.com/users/davidmckenzie/following{/other_user}","gists_url":"https://api.github.com/users/davidmckenzie/gists{/gist_id}","starred_url":"https://api.github.com/users/davidmckenzie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidmckenzie/subscriptions","organizations_url":"https://api.github.com/users/davidmckenzie/orgs","repos_url":"https://api.github.com/users/davidmckenzie/repos","events_url":"https://api.github.com/users/davidmckenzie/events{/privacy}","received_events_url":"https://api.github.com/users/davidmckenzie/received_events","type":"User","site_admin":false},"created_at":"2018-11-02T22:03:09Z","updated_at":"2018-11-02T22:03:09Z","author_association":"OWNER","body":"You guys wanna review again? I've pulled the DB stuff out and added some logic to upgrade the DB schema when required.\r\n\r\nIt's controlled by the 'release' int in app.js, so all we need to do to push an update to schema is update that number and add the relevant bits into db.js. It will attempt to add missing columns as required. If more complex schema changes are required, we can probably add some logic in there to drop and recreate the tables.\r\n\r\nAlso moved the `t` definition up to the top - I haven't tested this bit yet, only tested the DB upgrade bits"}}
{"actor":{"display_login":"davidmckenzie"}}