{"action":"created","issue":{"url":"https://api.github.com/repos/google/ggrc-core/issues/4225","repository_url":"https://api.github.com/repos/google/ggrc-core","labels_url":"https://api.github.com/repos/google/ggrc-core/issues/4225/labels{/name}","comments_url":"https://api.github.com/repos/google/ggrc-core/issues/4225/comments","events_url":"https://api.github.com/repos/google/ggrc-core/issues/4225/events","html_url":"https://github.com/google/ggrc-core/pull/4225","id":168280977,"number":4225,"title":"QUICK-FIX Update created_at and updated_at columns","user":{"login":"kr41","id":961059,"avatar_url":"https://avatars.githubusercontent.com/u/961059?v=3","gravatar_id":"","url":"https://api.github.com/users/kr41","html_url":"https://github.com/kr41","followers_url":"https://api.github.com/users/kr41/followers","following_url":"https://api.github.com/users/kr41/following{/other_user}","gists_url":"https://api.github.com/users/kr41/gists{/gist_id}","starred_url":"https://api.github.com/users/kr41/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kr41/subscriptions","organizations_url":"https://api.github.com/users/kr41/orgs","repos_url":"https://api.github.com/users/kr41/repos","events_url":"https://api.github.com/users/kr41/events{/privacy}","received_events_url":"https://api.github.com/users/kr41/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/google/ggrc-core/labels/migration","name":"migration","color":"0052cc"},{"url":"https://api.github.com/repos/google/ggrc-core/labels/question","name":"question","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/google/ggrc-core/milestones/21","html_url":"https://github.com/google/ggrc-core/milestones/0.9.7-Quince","labels_url":"https://api.github.com/repos/google/ggrc-core/milestones/21/labels","id":1845906,"number":21,"title":"0.9.7-Quince","description":"","creator":{"login":"Smotko","id":513444,"avatar_url":"https://avatars.githubusercontent.com/u/513444?v=3","gravatar_id":"","url":"https://api.github.com/users/Smotko","html_url":"https://github.com/Smotko","followers_url":"https://api.github.com/users/Smotko/followers","following_url":"https://api.github.com/users/Smotko/following{/other_user}","gists_url":"https://api.github.com/users/Smotko/gists{/gist_id}","starred_url":"https://api.github.com/users/Smotko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Smotko/subscriptions","organizations_url":"https://api.github.com/users/Smotko/orgs","repos_url":"https://api.github.com/users/Smotko/repos","events_url":"https://api.github.com/users/Smotko/events{/privacy}","received_events_url":"https://api.github.com/users/Smotko/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":171,"state":"open","created_at":"2016-06-23T17:56:25Z","updated_at":"2016-08-03T10:16:54Z","due_on":"2016-08-14T22:00:00Z","closed_at":null},"comments":10,"created_at":"2016-07-29T09:01:33Z","updated_at":"2016-08-03T10:41:31Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/google/ggrc-core/pulls/4225","html_url":"https://github.com/google/ggrc-core/pull/4225","diff_url":"https://github.com/google/ggrc-core/pull/4225.diff","patch_url":"https://github.com/google/ggrc-core/pull/4225.patch"},"body":"It turns created_at and updated_at columns to not nullable.\r\nMigrations set all created_at, which contain NULL, to current timestamp,\r\nand all updated_at, which contain NULL, to value from created_at."},"comment":{"url":"https://api.github.com/repos/google/ggrc-core/issues/comments/237203798","html_url":"https://github.com/google/ggrc-core/pull/4225#issuecomment-237203798","issue_url":"https://api.github.com/repos/google/ggrc-core/issues/4225","id":237203798,"user":{"login":"kr41","id":961059,"avatar_url":"https://avatars.githubusercontent.com/u/961059?v=3","gravatar_id":"","url":"https://api.github.com/users/kr41","html_url":"https://github.com/kr41","followers_url":"https://api.github.com/users/kr41/followers","following_url":"https://api.github.com/users/kr41/following{/other_user}","gists_url":"https://api.github.com/users/kr41/gists{/gist_id}","starred_url":"https://api.github.com/users/kr41/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kr41/subscriptions","organizations_url":"https://api.github.com/users/kr41/orgs","repos_url":"https://api.github.com/users/kr41/repos","events_url":"https://api.github.com/users/kr41/events{/privacy}","received_events_url":"https://api.github.com/users/kr41/received_events","type":"User","site_admin":false},"created_at":"2016-08-03T10:41:30Z","updated_at":"2016-08-03T10:41:30Z","body":"@Smotko I updated the code. There is only one big migration in `ggrc` module, it explicitly marked as `(SLOW!)`. It goes through all tables, updates `NULL` values to concrete ones, and finally turns `updated_at` and `created_at` to `NOT NULL`. And there are two small migrations in `ggrc_basic_permissions` and `ggrc_workflows`. Each one fixes rows from single table. These rows are added by previous migrations after the big one applied. For instance, it happens on executing `db_reset` command, which firstly executes all migrations from `ggrc` module, then executes migrations from other ones."}}
{"actor":{"display_login":"kr41"}}