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}