async def create_from_csv(db: Session = Depends(get_db)):
with open('data.csv') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
for row in csv_reader:
car = Car()
car.hsn = row[0] # Herstellerschlüsselnummer
car.hkt = row[1] # Herstellerklartext
car.tsn = row[2] # Typschlüsselnummer
car.hn = row[3] # Handelsname
car.anzahl = row[4] # Anzahl
db.add(car)
db.commit()
return "all good"
