{"action":"created","comment":{"url":"https://api.github.com/repos/cantino/huginn/pulls/comments/94232674","pull_request_review_id":14763827,"id":94232674,"diff_hunk":"@@ -11,7 +11,7 @@ def change\n     add_index :users, :confirmation_token,   unique: true\n \n     if ENV['REQUIRE_CONFIRMED_EMAIL'] != 'true' && ActiveRecord::Base.connection.column_exists?(:users, :confirmed_at)\n-      User.update_all('confirmed_at = NOW()')\n+      User.update_all(:confirmed_at => DateTime.now)","path":"db/migrate/20160301113717_add_confirmable_attributes_to_users.rb","position":null,"original_position":5,"commit_id":"471414519f8b43a98786b14bc72c021471bd9445","original_commit_id":"daa2a0006fe6c89cfb44294f175a62b176047b2a","user":{"login":"Phyks","id":3856586,"avatar_url":"https://avatars.githubusercontent.com/u/3856586?v=3","gravatar_id":"","url":"https://api.github.com/users/Phyks","html_url":"https://github.com/Phyks","followers_url":"https://api.github.com/users/Phyks/followers","following_url":"https://api.github.com/users/Phyks/following{/other_user}","gists_url":"https://api.github.com/users/Phyks/gists{/gist_id}","starred_url":"https://api.github.com/users/Phyks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Phyks/subscriptions","organizations_url":"https://api.github.com/users/Phyks/orgs","repos_url":"https://api.github.com/users/Phyks/repos","events_url":"https://api.github.com/users/Phyks/events{/privacy}","received_events_url":"https://api.github.com/users/Phyks/received_events","type":"User","site_admin":false},"body":"No problem. I am quite new to Ruby, my coding might not be optimal, sorry :/ Should be fixed.","created_at":"2016-12-30T14:52:26Z","updated_at":"2016-12-30T14:52:26Z","html_url":"https://github.com/cantino/huginn/pull/1842#discussion_r94232674","pull_request_url":"https://api.github.com/repos/cantino/huginn/pulls/1842","_links":{"self":{"href":"https://api.github.com/repos/cantino/huginn/pulls/comments/94232674"},"html":{"href":"https://github.com/cantino/huginn/pull/1842#discussion_r94232674"},"pull_request":{"href":"https://api.github.com/repos/cantino/huginn/pulls/1842"}}},"pull_request":{"url":"https://api.github.com/repos/cantino/huginn/pulls/1842","id":99595064,"html_url":"https://github.com/cantino/huginn/pull/1842","diff_url":"https://github.com/cantino/huginn/pull/1842.diff","patch_url":"https://github.com/cantino/huginn/pull/1842.patch","issue_url":"https://api.github.com/repos/cantino/huginn/issues/1842","number":1842,"state":"open","locked":false,"title":"Make migrations compatible with SQLite","user":{"login":"Phyks","id":3856586,"avatar_url":"https://avatars.githubusercontent.com/u/3856586?v=3","gravatar_id":"","url":"https://api.github.com/users/Phyks","html_url":"https://github.com/Phyks","followers_url":"https://api.github.com/users/Phyks/followers","following_url":"https://api.github.com/users/Phyks/following{/other_user}","gists_url":"https://api.github.com/users/Phyks/gists{/gist_id}","starred_url":"https://api.github.com/users/Phyks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Phyks/subscriptions","organizations_url":"https://api.github.com/users/Phyks/orgs","repos_url":"https://api.github.com/users/Phyks/repos","events_url":"https://api.github.com/users/Phyks/events{/privacy}","received_events_url":"https://api.github.com/users/Phyks/received_events","type":"User","site_admin":false},"body":"Hi,\r\n\r\nI wanted to quickly setup a demo instance of `huginn` to have a look and see if it could match my use case. I did not have a running MySQL or PostgreSQL instance to use for this purpose, and wishes `huginn` worked out of the box with `sqlite3` database, cutting any dependency on specific databases.\r\n\r\nNot sure if this may be something of interest for others, that is interesting to get merged, but this PR makes all the migrations work with SQLite, and huginn should be working with SQLite as a db backend afterwards, at least as far as I could see during my tests.","created_at":"2016-12-28T21:35:20Z","updated_at":"2016-12-30T14:52:26Z","closed_at":null,"merged_at":null,"merge_commit_sha":"454b5579c2fd4453446ca527584d2f884e0b03c3","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/cantino/huginn/pulls/1842/commits","review_comments_url":"https://api.github.com/repos/cantino/huginn/pulls/1842/comments","review_comment_url":"https://api.github.com/repos/cantino/huginn/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cantino/huginn/issues/1842/comments","statuses_url":"https://api.github.com/repos/cantino/huginn/statuses/471414519f8b43a98786b14bc72c021471bd9445","head":{"label":"Phyks:sqlite","ref":"sqlite","sha":"471414519f8b43a98786b14bc72c021471bd9445","user":{"login":"Phyks","id":3856586,"avatar_url":"https://avatars.githubusercontent.com/u/3856586?v=3","gravatar_id":"","url":"https://api.github.com/users/Phyks","html_url":"https://github.com/Phyks","followers_url":"https://api.github.com/users/Phyks/followers","following_url":"https://api.github.com/users/Phyks/following{/other_user}","gists_url":"https://api.github.com/users/Phyks/gists{/gist_id}","starred_url":"https://api.github.com/users/Phyks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Phyks/subscriptions","organizations_url":"https://api.github.com/users/Phyks/orgs","repos_url":"https://api.github.com/users/Phyks/repos","events_url":"https://api.github.com/users/Phyks/events{/privacy}","received_events_url":"https://api.github.com/users/Phyks/received_events","type":"User","site_admin":false},"repo":{"id":77561960,"name":"huginn","full_name":"Phyks/huginn","owner":{"login":"Phyks","id":3856586,"avatar_url":"https://avatars.githubusercontent.com/u/3856586?v=3","gravatar_id":"","url":"https://api.github.com/users/Phyks","html_url":"https://github.com/Phyks","followers_url":"https://api.github.com/users/Phyks/followers","following_url":"https://api.github.com/users/Phyks/following{/other_user}","gists_url":"https://api.github.com/users/Phyks/gists{/gist_id}","starred_url":"https://api.github.com/users/Phyks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Phyks/subscriptions","organizations_url":"https://api.github.com/users/Phyks/orgs","repos_url":"https://api.github.com/users/Phyks/repos","events_url":"https://api.github.com/users/Phyks/events{/privacy}","received_events_url":"https://api.github.com/users/Phyks/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Phyks/huginn","description":"Create agents that monitor and act on your behalf.  Your agents are standing by!","fork":true,"url":"https://api.github.com/repos/Phyks/huginn","forks_url":"https://api.github.com/repos/Phyks/huginn/forks","keys_url":"https://api.github.com/repos/Phyks/huginn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Phyks/huginn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Phyks/huginn/teams","hooks_url":"https://api.github.com/repos/Phyks/huginn/hooks","issue_events_url":"https://api.github.com/repos/Phyks/huginn/issues/events{/number}","events_url":"https://api.github.com/repos/Phyks/huginn/events","assignees_url":"https://api.github.com/repos/Phyks/huginn/assignees{/user}","branches_url":"https://api.github.com/repos/Phyks/huginn/branches{/branch}","tags_url":"https://api.github.com/repos/Phyks/huginn/tags","blobs_url":"https://api.github.com/repos/Phyks/huginn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Phyks/huginn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Phyks/huginn/git/refs{/sha}","trees_url":"https://api.github.com/repos/Phyks/huginn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Phyks/huginn/statuses/{sha}","languages_url":"https://api.github.com/repos/Phyks/huginn/languages","stargazers_url":"https://api.github.com/repos/Phyks/huginn/stargazers","contributors_url":"https://api.github.com/repos/Phyks/huginn/contributors","subscribers_url":"https://api.github.com/repos/Phyks/huginn/subscribers","subscription_url":"https://api.github.com/repos/Phyks/huginn/subscription","commits_url":"https://api.github.com/repos/Phyks/huginn/commits{/sha}","git_commits_url":"https://api.github.com/repos/Phyks/huginn/git/commits{/sha}","comments_url":"https://api.github.com/repos/Phyks/huginn/comments{/number}","issue_comment_url":"https://api.github.com/repos/Phyks/huginn/issues/comments{/number}","contents_url":"https://api.github.com/repos/Phyks/huginn/contents/{+path}","compare_url":"https://api.github.com/repos/Phyks/huginn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Phyks/huginn/merges","archive_url":"https://api.github.com/repos/Phyks/huginn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Phyks/huginn/downloads","issues_url":"https://api.github.com/repos/Phyks/huginn/issues{/number}","pulls_url":"https://api.github.com/repos/Phyks/huginn/pulls{/number}","milestones_url":"https://api.github.com/repos/Phyks/huginn/milestones{/number}","notifications_url":"https://api.github.com/repos/Phyks/huginn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Phyks/huginn/labels{/name}","releases_url":"https://api.github.com/repos/Phyks/huginn/releases{/id}","deployments_url":"https://api.github.com/repos/Phyks/huginn/deployments","created_at":"2016-12-28T21:18:58Z","updated_at":"2016-12-28T21:19:01Z","pushed_at":"2016-12-30T14:51:38Z","git_url":"git://github.com/Phyks/huginn.git","ssh_url":"git@github.com:Phyks/huginn.git","clone_url":"https://github.com/Phyks/huginn.git","svn_url":"https://github.com/Phyks/huginn","homepage":"","size":6821,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"cantino:master","ref":"master","sha":"71b1bf0a10032b591f96d042351889ecb9345ad5","user":{"login":"cantino","id":83835,"avatar_url":"https://avatars.githubusercontent.com/u/83835?v=3","gravatar_id":"","url":"https://api.github.com/users/cantino","html_url":"https://github.com/cantino","followers_url":"https://api.github.com/users/cantino/followers","following_url":"https://api.github.com/users/cantino/following{/other_user}","gists_url":"https://api.github.com/users/cantino/gists{/gist_id}","starred_url":"https://api.github.com/users/cantino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cantino/subscriptions","organizations_url":"https://api.github.com/users/cantino/orgs","repos_url":"https://api.github.com/users/cantino/repos","events_url":"https://api.github.com/users/cantino/events{/privacy}","received_events_url":"https://api.github.com/users/cantino/received_events","type":"User","site_admin":false},"repo":{"id":8681349,"name":"huginn","full_name":"cantino/huginn","owner":{"login":"cantino","id":83835,"avatar_url":"https://avatars.githubusercontent.com/u/83835?v=3","gravatar_id":"","url":"https://api.github.com/users/cantino","html_url":"https://github.com/cantino","followers_url":"https://api.github.com/users/cantino/followers","following_url":"https://api.github.com/users/cantino/following{/other_user}","gists_url":"https://api.github.com/users/cantino/gists{/gist_id}","starred_url":"https://api.github.com/users/cantino/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cantino/subscriptions","organizations_url":"https://api.github.com/users/cantino/orgs","repos_url":"https://api.github.com/users/cantino/repos","events_url":"https://api.github.com/users/cantino/events{/privacy}","received_events_url":"https://api.github.com/users/cantino/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cantino/huginn","description":"Create agents that monitor and act on your behalf.  Your agents are standing by!","fork":false,"url":"https://api.github.com/repos/cantino/huginn","forks_url":"https://api.github.com/repos/cantino/huginn/forks","keys_url":"https://api.github.com/repos/cantino/huginn/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cantino/huginn/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cantino/huginn/teams","hooks_url":"https://api.github.com/repos/cantino/huginn/hooks","issue_events_url":"https://api.github.com/repos/cantino/huginn/issues/events{/number}","events_url":"https://api.github.com/repos/cantino/huginn/events","assignees_url":"https://api.github.com/repos/cantino/huginn/assignees{/user}","branches_url":"https://api.github.com/repos/cantino/huginn/branches{/branch}","tags_url":"https://api.github.com/repos/cantino/huginn/tags","blobs_url":"https://api.github.com/repos/cantino/huginn/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cantino/huginn/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cantino/huginn/git/refs{/sha}","trees_url":"https://api.github.com/repos/cantino/huginn/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cantino/huginn/statuses/{sha}","languages_url":"https://api.github.com/repos/cantino/huginn/languages","stargazers_url":"https://api.github.com/repos/cantino/huginn/stargazers","contributors_url":"https://api.github.com/repos/cantino/huginn/contributors","subscribers_url":"https://api.github.com/repos/cantino/huginn/subscribers","subscription_url":"https://api.github.com/repos/cantino/huginn/subscription","commits_url":"https://api.github.com/repos/cantino/huginn/commits{/sha}","git_commits_url":"https://api.github.com/repos/cantino/huginn/git/commits{/sha}","comments_url":"https://api.github.com/repos/cantino/huginn/comments{/number}","issue_comment_url":"https://api.github.com/repos/cantino/huginn/issues/comments{/number}","contents_url":"https://api.github.com/repos/cantino/huginn/contents/{+path}","compare_url":"https://api.github.com/repos/cantino/huginn/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cantino/huginn/merges","archive_url":"https://api.github.com/repos/cantino/huginn/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cantino/huginn/downloads","issues_url":"https://api.github.com/repos/cantino/huginn/issues{/number}","pulls_url":"https://api.github.com/repos/cantino/huginn/pulls{/number}","milestones_url":"https://api.github.com/repos/cantino/huginn/milestones{/number}","notifications_url":"https://api.github.com/repos/cantino/huginn/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cantino/huginn/labels{/name}","releases_url":"https://api.github.com/repos/cantino/huginn/releases{/id}","deployments_url":"https://api.github.com/repos/cantino/huginn/deployments","created_at":"2013-03-10T06:00:31Z","updated_at":"2016-12-30T14:00:52Z","pushed_at":"2016-12-30T14:51:41Z","git_url":"git://github.com/cantino/huginn.git","ssh_url":"git@github.com:cantino/huginn.git","clone_url":"https://github.com/cantino/huginn.git","svn_url":"https://github.com/cantino/huginn","homepage":"","size":6828,"stargazers_count":15393,"watchers_count":15393,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1676,"mirror_url":null,"open_issues_count":279,"forks":1676,"open_issues":279,"watchers":15393,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cantino/huginn/pulls/1842"},"html":{"href":"https://github.com/cantino/huginn/pull/1842"},"issue":{"href":"https://api.github.com/repos/cantino/huginn/issues/1842"},"comments":{"href":"https://api.github.com/repos/cantino/huginn/issues/1842/comments"},"review_comments":{"href":"https://api.github.com/repos/cantino/huginn/pulls/1842/comments"},"review_comment":{"href":"https://api.github.com/repos/cantino/huginn/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cantino/huginn/pulls/1842/commits"},"statuses":{"href":"https://api.github.com/repos/cantino/huginn/statuses/471414519f8b43a98786b14bc72c021471bd9445"}}}}
{"actor":{"display_login":"Phyks"}}