import csv
import json
import codecs
from certificate import Certificate
from io import StringIO


def convert(csv_string):
    csv_stuff = StringIO(csv_string)
    csv_reader = csv.reader(csv_stuff, delimiter=";")
    data = {}
    for rows in csv_reader:
        if rows[0]:
            cur_row = rows[0].strip()
            if cur_row.find("Svar") != -1:
                cur_row = "questions"
            if cur_row not in data:
                data[cur_row] = []
        if rows[1] != '':
            data[cur_row].append(f'text:{rows[1].strip()}')
    return Certificate.from_dict(data)


if __name__ == "__main__":
    cert = convert("opg1_dansk.csv")
    print(cert)