パラメータシートから AWS CloudFormation テンプレートを自動で作成する

def convert(source_dir: str) -> list:
    book = openpyxl.load_workbook(source_dir)
    ws = book.worksheets[0]
    # Read Key and Value
    data_from_ps = []
    # Read from row 1
    for row in ws.rows:
        # list型として各行の値を格納
        key = []
        for col_num in range(len(row)):
            # 条件：値が存在するセルのみ取り込み（最終列を除く）
            if col_num != (len(row) - 1) and (row[col_num].value == None or row[col_num].value == ""):
                pass
            else:
                key.append(row[col_num].value)
        data_from_ps.append(key)
    book.close()
    return data_from_ps

class AWSApiGatewayAccount:
    def __init__(self):
        self.logical_id = ""
        self.type = "AWS::ApiGateway::Account"
        self.properties = {
            "CloudWatchRoleArn" : ""
        }

    # Setter
    def set_resource(self, data: list) -> None:
        for i in range(len(data)):
            # 各項目から設定項目・値を取得
            setting_type = data[i][len(data[i])-2]
            setting_value = data[i][len(data[i])-1]
            # 項目に応じて値を格納
            if not setting_value:
                continue
            if setting_type == "Logical ID":
                self.logical_id = setting_value
            elif setting_type == "CloudWatchRoleArn":
                self.properties["CloudWatchRoleArn"] = setting_value

def output(source: dict, file_name: str) -> None:
    with open(file_name, "w") as f:
        yaml.dump(source, f, sort_keys=False)
    with open(file_name, "r") as f:
        contents = f.read()
    contents = contents.replace("'", "")
    # *はクォーテーションで括っていないとエラー
    contents = contents.replace(" *", " '*'")
    with open(file_name, "w") as f:
        f.write(contents)

def convert(yaml_path: str, stack_name: str) -> None:
    f = open(yaml_path, "r")
    template_body = f.read()
    f.close()
    cfn = boto3.client("cloudformation")
    response = cfn.create_stack(
        StackName=stack_name,
        TemplateBody=template_body,
        Capabilities=[
            "CAPABILITY_NAMED_IAM",
        ],
    )

    waiter = cfn.get_waiter("stack_create_complete")
    waiter.wait(StackName=stack_name)

    # Get properties from AWS
    def get_resource(self, logical_resource_id: str, physical_resource_id: str, stack_name: str) -> None:
        # 構成情報の取得
        client = boto3.client("apigateway")
        response = client.get_account()
        self.logical_id = logical_resource_id
        self.properties["CloudWatchRoleArn"] = response["cloudwatchRoleArn"]

    # 2つのリソースファイルの結果を一つにまとめる
    def summarize_properties(self, cfn_template: dict) -> dict:
        logical_ids = [self.logical_id, cfn_template.logical_id]
        summary = template.summary.Summary(logical_ids, self.type)
        if self.properties["CloudWatchRoleArn"]:
            key = summary.key_default.copy()
            key.append("CloudWatchRoleArn")
            value = [self.properties["CloudWatchRoleArn"], cfn_template.properties["CloudWatchRoleArn"]]
            summary.properties[tuple(key)] = value
        return summary

def compare(all_resources: list) -> list:
    compared_resources = all_resources.copy()
    # 1つずつのリソースの値を比較
    for resource in compared_resources:
        property = resource.properties
        # 1つずつの設定値を比較
        for key, values in property.items():
            # 設定値の型により処理を分岐
            if type(values[0]) == list:
                for val in values:
                    result = val[0] == val[1]
                    val.append(result)
            else:
                # 設定値の確認
                result = values[0] == values[1]
                values.append(result)
            property[key] = values
    return compared_resources