import csv
import datetime
from .models import InvoiceItem


def read_timesheet():
    with open('timesheet.csv', newline='') as csvfile:
        reader = csv.reader(csvfile, delimiter=';')
        counter = 0
        f = "%Y-%m-%d %H:%M:%S"
        for row in reader:
            if counter > 0:
                print(row[4])
                timer = row[0]+' '+row[1]
                timerer = row[0]+' '+row[2]
                time_start = datetime.datetime.strptime(timer, f)
                time_end = datetime.datetime.strptime(timerer, f)
                InvoiceItem.objects.get_or_create(
                    time_start=time_start,
                    time_end=time_end,
                    work_done=row[4]
                )
            counter = counter + 1