{"action":"closed","issue":{"url":"https://api.github.com/repos/konigio/konig/issues/694","repository_url":"https://api.github.com/repos/konigio/konig","labels_url":"https://api.github.com/repos/konigio/konig/issues/694/labels{/name}","comments_url":"https://api.github.com/repos/konigio/konig/issues/694/comments","events_url":"https://api.github.com/repos/konigio/konig/issues/694/events","html_url":"https://github.com/konigio/konig/issues/694","id":292484554,"number":694,"title":"Generate Google Cloud SQL Artifacts","user":{"login":"gmcfall","id":1863752,"avatar_url":"https://avatars3.githubusercontent.com/u/1863752?v=4","gravatar_id":"","url":"https://api.github.com/users/gmcfall","html_url":"https://github.com/gmcfall","followers_url":"https://api.github.com/users/gmcfall/followers","following_url":"https://api.github.com/users/gmcfall/following{/other_user}","gists_url":"https://api.github.com/users/gmcfall/gists{/gist_id}","starred_url":"https://api.github.com/users/gmcfall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gmcfall/subscriptions","organizations_url":"https://api.github.com/users/gmcfall/orgs","repos_url":"https://api.github.com/users/gmcfall/repos","events_url":"https://api.github.com/users/gmcfall/events{/privacy}","received_events_url":"https://api.github.com/users/gmcfall/received_events","type":"User","site_admin":false},"labels":[{"id":757360619,"url":"https://api.github.com/repos/konigio/konig/labels/in%20progress","name":"in progress","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":{"login":"gmcfall","id":1863752,"avatar_url":"https://avatars3.githubusercontent.com/u/1863752?v=4","gravatar_id":"","url":"https://api.github.com/users/gmcfall","html_url":"https://github.com/gmcfall","followers_url":"https://api.github.com/users/gmcfall/followers","following_url":"https://api.github.com/users/gmcfall/following{/other_user}","gists_url":"https://api.github.com/users/gmcfall/gists{/gist_id}","starred_url":"https://api.github.com/users/gmcfall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gmcfall/subscriptions","organizations_url":"https://api.github.com/users/gmcfall/orgs","repos_url":"https://api.github.com/users/gmcfall/repos","events_url":"https://api.github.com/users/gmcfall/events{/privacy}","received_events_url":"https://api.github.com/users/gmcfall/received_events","type":"User","site_admin":false},"assignees":[{"login":"gmcfall","id":1863752,"avatar_url":"https://avatars3.githubusercontent.com/u/1863752?v=4","gravatar_id":"","url":"https://api.github.com/users/gmcfall","html_url":"https://github.com/gmcfall","followers_url":"https://api.github.com/users/gmcfall/followers","following_url":"https://api.github.com/users/gmcfall/following{/other_user}","gists_url":"https://api.github.com/users/gmcfall/gists{/gist_id}","starred_url":"https://api.github.com/users/gmcfall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gmcfall/subscriptions","organizations_url":"https://api.github.com/users/gmcfall/orgs","repos_url":"https://api.github.com/users/gmcfall/repos","events_url":"https://api.github.com/users/gmcfall/events{/privacy}","received_events_url":"https://api.github.com/users/gmcfall/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/konigio/konig/milestones/6","html_url":"https://github.com/konigio/konig/milestone/6","labels_url":"https://api.github.com/repos/konigio/konig/milestones/6/labels","id":3045397,"number":6,"title":"Iteration 5","description":"","creator":{"login":"gmcfall","id":1863752,"avatar_url":"https://avatars3.githubusercontent.com/u/1863752?v=4","gravatar_id":"","url":"https://api.github.com/users/gmcfall","html_url":"https://github.com/gmcfall","followers_url":"https://api.github.com/users/gmcfall/followers","following_url":"https://api.github.com/users/gmcfall/following{/other_user}","gists_url":"https://api.github.com/users/gmcfall/gists{/gist_id}","starred_url":"https://api.github.com/users/gmcfall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gmcfall/subscriptions","organizations_url":"https://api.github.com/users/gmcfall/orgs","repos_url":"https://api.github.com/users/gmcfall/repos","events_url":"https://api.github.com/users/gmcfall/events{/privacy}","received_events_url":"https://api.github.com/users/gmcfall/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":6,"state":"open","created_at":"2018-01-18T12:59:23Z","updated_at":"2018-02-01T16:37:59Z","due_on":"2018-02-01T08:00:00Z","closed_at":null},"comments":1,"created_at":"2018-01-29T17:01:53Z","updated_at":"2018-02-01T16:37:59Z","closed_at":"2018-02-01T16:37:59Z","author_association":"CONTRIBUTOR","body":"I want the Konig Schemagen Maven Plugin to generate artifacts for Google Cloud SQL.\r\n\r\n### Acceptance Criteria\r\n* For each Google Cloud SQL instance, the tool shall generate a JSON document at `gcp/cloudsql/instances/${instanceName}.json` with contents of the form:\r\n\r\n```\r\n{\r\n  \"selfLink\" : \"https://www.googleapis.com/sql/v1beta4/projects/${gcpProjectId}/instances/exampleInstance\",\r\n  \"name\" : \"exampleInstance\",\r\n  \"backendType\" : \"SECOND_GEN\",\r\n  \"instanceType\" : \"CLOUD_SQL_INSTANCE\",\r\n  \"databaseVersion\" : \"MYSQL_5_7\",\r\n  \"region\" : \"us-central\"\r\n}\r\n```\r\n\r\n* For each Google Cloud SQL database, the tool shall generate a JSON document at `gcp/cloudsql/databases/${instanceName}_${databaseName}.json` with contents of the form:\r\n```\r\n{\r\n  \"selfLink\" : \"https://www.googleapis.com/sql/v1beta4/projects/${gcpProjectId}/instances/exampleInstance/databases/exampleDatabase\",\r\n  \"instance\" : \"exampleInstance\",\r\n  \"name\" : \"exampleDatabase\"\r\n}\r\n```\r\n* For each Google Cloud SQL Table, the tool shall generate a JSON document at `gcp/cloudsql/tables/${instanceName}_${databaseName}_${tableName}.json` with contents of the form:\r\n\r\n```\r\n{\r\n  \"selfLink\" : \"https://www.googleapis.com/sql/v1beta4/projects/${gcpProjectId}/instances/exampleInstance/databases/exampleDatabase/tables/exampleTable\",\r\n  \"instance\" : \"exampleInstance\",\r\n  \"database\" : \"exampleDatabase\",\r\n  \"ddlFile\" : \"Foo.sql\"\r\n}\r\n```\r\n\r\n* For each Google Cloud SQL Table, the tool shall generate a SQL DDL file  at `gcp/cloudsql/tables/${instanceName}_${databaseName}_${tableName}.sql` which contains a SQL DDL `CREATE TABLE...` statement.\r\n\r\n\r\n"}}
{"actor":{"display_login":"gmcfall"}}