{"action":"created","issue":{"url":"https://api.github.com/repos/cloudfoundry/bosh/issues/1828","repository_url":"https://api.github.com/repos/cloudfoundry/bosh","labels_url":"https://api.github.com/repos/cloudfoundry/bosh/issues/1828/labels{/name}","comments_url":"https://api.github.com/repos/cloudfoundry/bosh/issues/1828/comments","events_url":"https://api.github.com/repos/cloudfoundry/bosh/issues/1828/events","html_url":"https://github.com/cloudfoundry/bosh/pull/1828","id":272123293,"number":1828,"title":"Add rake task to dump postgresql schema","user":{"login":"manno","id":393653,"avatar_url":"https://avatars1.githubusercontent.com/u/393653?v=4","gravatar_id":"","url":"https://api.github.com/users/manno","html_url":"https://github.com/manno","followers_url":"https://api.github.com/users/manno/followers","following_url":"https://api.github.com/users/manno/following{/other_user}","gists_url":"https://api.github.com/users/manno/gists{/gist_id}","starred_url":"https://api.github.com/users/manno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/manno/subscriptions","organizations_url":"https://api.github.com/users/manno/orgs","repos_url":"https://api.github.com/users/manno/repos","events_url":"https://api.github.com/users/manno/events{/privacy}","received_events_url":"https://api.github.com/users/manno/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-11-08T09:06:01Z","updated_at":"2017-11-14T19:21:12Z","closed_at":"2017-11-14T19:21:12Z","author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/cloudfoundry/bosh/pulls/1828","html_url":"https://github.com/cloudfoundry/bosh/pull/1828","diff_url":"https://github.com/cloudfoundry/bosh/pull/1828.diff","patch_url":"https://github.com/cloudfoundry/bosh/pull/1828.patch"},"body":"This rake task should help with analyzing the database.\r\nNo more running integration tests and putting in a sleep statement or breakpoint, finding the right director database (the names are all hashes) and finally figuring out credentials just to look at the current schema SQL.\r\n\r\nInstead this task creates a database `director_latest_tmp`, runs migrations and dumps the schema to STDOUT and the file `https://github.com/manno/bosh/tree/performance-integration-test`.\r\n\r\nThe resulting database is missing test data of course, so for running `EXPLAIN ANALYZE` we  might still want to mess with integration test databases."},"comment":{"url":"https://api.github.com/repos/cloudfoundry/bosh/issues/comments/344368105","html_url":"https://github.com/cloudfoundry/bosh/pull/1828#issuecomment-344368105","issue_url":"https://api.github.com/repos/cloudfoundry/bosh/issues/1828","id":344368105,"user":{"login":"tjvman","id":16198666,"avatar_url":"https://avatars3.githubusercontent.com/u/16198666?v=4","gravatar_id":"","url":"https://api.github.com/users/tjvman","html_url":"https://github.com/tjvman","followers_url":"https://api.github.com/users/tjvman/followers","following_url":"https://api.github.com/users/tjvman/following{/other_user}","gists_url":"https://api.github.com/users/tjvman/gists{/gist_id}","starred_url":"https://api.github.com/users/tjvman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjvman/subscriptions","organizations_url":"https://api.github.com/users/tjvman/orgs","repos_url":"https://api.github.com/users/tjvman/repos","events_url":"https://api.github.com/users/tjvman/events{/privacy}","received_events_url":"https://api.github.com/users/tjvman/received_events","type":"User","site_admin":false},"created_at":"2017-11-14T19:21:12Z","updated_at":"2017-11-14T19:21:12Z","author_association":"CONTRIBUTOR","body":"Thanks for the contribution! \r\n\r\nWe have merged this locally, with some additional changes - we added very simple unit tests and removed the `schema` namespace. We also added another rake task which outputs the table descriptions for a human-readable way to see the current tables/columns."}}
{"actor":{"display_login":"tjvman"}}