def handle(self, *args, **kwargs):
c = get_context()
take_down_ec2(c)
tags = {"Project": "aws-initial-testing",
"Use": "messing-around",
"ResponsibleParty": settings.AWS_RESPONSIBLE_PARTY,
}
my_security_group = settings.AWS_SECURITY_GROUP_NAME
print create_new_db_cluster(c, [my_security_group], tags)
def handle(self, *args, **kwargs):
c = get_context()
take_down_ec2(c)
tags = {
"Project": "aws-initial-testing",
"Use": "messing-around",
"ResponsibleParty": settings.AWS_RESPONSIBLE_PARTY,
}
my_security_group = settings.AWS_SECURITY_GROUP_NAME
print create_new_db_cluster(c, [my_security_group], tags)
def get_database_config_for_project(c, project, use):
existing_data = BuildData.objects.filter(project=project,
use=use)
db_host = db_user = db_pass = None
for data in existing_data:
if "database" == data.role and "hostname" == data.data_field:
db_host = data.value
if "database" == data.role and "username" == data.data_field:
db_user = data.value
if "database" == data.role and "password" == data.data_field:
db_pass = data.value
if not db_host or not db_user or not db_pass:
tags = {"Project": project,
"Use": use,
"ResponsibleParty": settings.AWS_RESPONSIBLE_PARTY,
}
my_security_group = settings.AWS_SECURITY_GROUP_NAME
# Create the db cluster
data = create_new_db_cluster(c, [my_security_group], tags)
# Create the myuw db - tables will be created later
add_database_to_host_id(c, "myuw", data["master"]["id"],
data["master"]["password"])
myuw_password = generate_password()
# Create the user our app will use to connect to the db
add_user_to_database(c, "myuw_user", "%", myuw_password, "myuw",
data["master"]["id"], data["master"]["password"])
instance = get_instance(c, data["master"]["id"])
ip_address = instance.private_ip_address
BuildData.objects.get_or_create(project="myuw", use="aws_mess_around",
role="database", data_field="username",
defaults={"value": "myuw_user"})
BuildData.objects.get_or_create(project="myuw", use="aws_mess_around",
role="database", data_field="password",
defaults={"value": myuw_password})
BuildData.objects.get_or_create(project="myuw", use="aws_mess_around",
role="database", data_field="hostname",
defaults={"value": ip_address})
db_host = ip_address
db_user = "******"
db_pass = myuw_password
return {"host": db_host, "username": db_user, "password": db_pass}
def get_database_config_for_project(c, project, use):
existing_data = BuildData.objects.filter(project=project, use=use)
db_host = db_user = db_pass = None
for data in existing_data:
if "database" == data.role and "hostname" == data.data_field:
db_host = data.value
if "database" == data.role and "username" == data.data_field:
db_user = data.value
if "database" == data.role and "password" == data.data_field:
db_pass = data.value
if not db_host or not db_user or not db_pass:
tags = {
"Project": project,
"Use": use,
"ResponsibleParty": settings.AWS_RESPONSIBLE_PARTY,
}
my_security_group = settings.AWS_SECURITY_GROUP_NAME
# Create the db cluster
data = create_new_db_cluster(c, [my_security_group], tags)
# Create the myuw db - tables will be created later
add_database_to_host_id(c, "myuw", data["master"]["id"],
data["master"]["password"])
myuw_password = generate_password()
# Create the user our app will use to connect to the db
add_user_to_database(c, "myuw_user", "%", myuw_password, "myuw",
data["master"]["id"], data["master"]["password"])
instance = get_instance(c, data["master"]["id"])
ip_address = instance.private_ip_address
BuildData.objects.get_or_create(project="myuw",
use="aws_mess_around",
role="database",
data_field="username",
defaults={"value": "myuw_user"})
BuildData.objects.get_or_create(project="myuw",
use="aws_mess_around",
role="database",
data_field="password",
defaults={"value": myuw_password})
BuildData.objects.get_or_create(project="myuw",
use="aws_mess_around",
role="database",
data_field="hostname",
defaults={"value": ip_address})
db_host = ip_address
db_user = "******"
db_pass = myuw_password
return {"host": db_host, "username": db_user, "password": db_pass}