def insert_owner_pet()

in courses/understanding_spanner/cloud-functions/spanner_save_pets/main.py [0:0]

• 23 lines of code
• 3 McCabe index (conditional complexity)

    def insert_owner_pet(transaction, data, owner_exists):
        try:
            row_ct = 0
            params = { "owner_id": owner_id,
            "owner_name": data["OwnerName"],
            "pet_id": pet_id,
            "pet_name": data["PetName"],
            "pet_type": data["PetType"],
            "breed": data["Breed"],
                         }

            param_types = { "owner_id": spanner.param_types.STRING,
                            "owner_name": spanner.param_types.STRING,
                            "pet_id": spanner.param_types.STRING,
                            "pet_name": spanner.param_types.STRING,
                            "pet_type": spanner.param_types.STRING,
                            "breed": spanner.param_types.STRING,
                            }

            # Only add the Owner if they don't exist already
            if not owner_exists:
                row_ct = transaction.execute_update(
                    """INSERT Owners (OwnerID, OwnerName) VALUES (@owner_id, @owner_name)""",
                    params=params,
                    param_types=param_types,)

                # Add the pet
            row_ct += transaction.execute_update(