import json


def insert_organization(cursor, info):
    """organization情報登録

    Args:
        cursor (mysql.connector.cursor): カーソル
        info (Dict)): organization情報のJson形式

    Returns:
        int: organization_id
        
    """
    # insert実行
    cursor.execute('INSERT INTO organization ( organization_name, additional_information )' \
                   ' VALUES ( %(organization_name)s, %(additional_information)s )',
        {
            'organization_name' : info['organization_name'],
            'additional_information' : json.dumps(info['additional_information'])
        }
    )
    # 追加したワークスペースIDをreturn
    return cursor.lastrowid