{"action":"created","issue":{"url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/19","repository_url":"https://api.github.com/repos/cybergreen-net/aggregator","labels_url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/19/comments","events_url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/19/events","html_url":"https://github.com/cybergreen-net/aggregator/issues/19","id":185892103,"number":19,"title":"Automate setup and teardown of Redshift","user":{"login":"rgrp","id":180658,"avatar_url":"https://avatars.githubusercontent.com/u/180658?v=3","gravatar_id":"","url":"https://api.github.com/users/rgrp","html_url":"https://github.com/rgrp","followers_url":"https://api.github.com/users/rgrp/followers","following_url":"https://api.github.com/users/rgrp/following{/other_user}","gists_url":"https://api.github.com/users/rgrp/gists{/gist_id}","starred_url":"https://api.github.com/users/rgrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgrp/subscriptions","organizations_url":"https://api.github.com/users/rgrp/orgs","repos_url":"https://api.github.com/users/rgrp/repos","events_url":"https://api.github.com/users/rgrp/events{/privacy}","received_events_url":"https://api.github.com/users/rgrp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-10-28T10:38:48Z","updated_at":"2016-11-08T09:46:57Z","closed_at":null,"body":"Options for how we do this:\n- terraform\n- boto\n\nWant to be able to call this from python code ... \n- [ ] Research options\n- [ ] Implement given option!\n"},"comment":{"url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/comments/259091589","html_url":"https://github.com/cybergreen-net/aggregator/issues/19#issuecomment-259091589","issue_url":"https://api.github.com/repos/cybergreen-net/aggregator/issues/19","id":259091589,"user":{"login":"zelima","id":15143785,"avatar_url":"https://avatars.githubusercontent.com/u/15143785?v=3","gravatar_id":"","url":"https://api.github.com/users/zelima","html_url":"https://github.com/zelima","followers_url":"https://api.github.com/users/zelima/followers","following_url":"https://api.github.com/users/zelima/following{/other_user}","gists_url":"https://api.github.com/users/zelima/gists{/gist_id}","starred_url":"https://api.github.com/users/zelima/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zelima/subscriptions","organizations_url":"https://api.github.com/users/zelima/orgs","repos_url":"https://api.github.com/users/zelima/repos","events_url":"https://api.github.com/users/zelima/events{/privacy}","received_events_url":"https://api.github.com/users/zelima/received_events","type":"User","site_admin":false},"created_at":"2016-11-08T09:46:57Z","updated_at":"2016-11-08T09:46:57Z","body":"As application development stages are divided in two parts - `dev` and `prod`, besides creating new cluster, there's need of creating second database. Neither of them can give us an option to do that, as said in  [Boto3 docs](boto3.readthedocs.io/en/latest/reference/services/redshift.html#Redshift.Client.create_cluster)\r\n\r\n> To create additional databases after the cluster is created, connect to the cluster with a SQL client and use SQL commands to create a database. For more information, go to Create a Database in the Amazon Redshift Database Developer Guide.\r\n\r\nConsidering that, we'll have to use python code to create second db in any case.\r\nSo rather than splitting code in to two different scripts, I would recommend to stick with one python script and Use Boto3"}}
{"actor":{"display_login":"zelima"}}