# CSV Importer
import csv   #zum Lesen von CSV Dateien
from sqlite3 import *

def insert(a, b, c, d, e):
    with connect("personen.db") as con:
        cursor = con.cursor()
        sql = """INSERT INTO person 
                 (familienname, vorname, wohnort, geschlecht, 'alter') 
                 VALUES 
                 ('%s', '%s', '%s', '%s',  %d)""" %(a, b, c, d, e)
        cursor.execute(sql)

with open('personenohneheader.csv') as csvfile:
    readCSV = csv.reader(csvfile, delimiter=';')    #Felder durch Strichpunkt getrennt
  
    for row in readCSV:
        print("Zeile: ", row)  
        insert(row[0], row[1], row[2], row[3], int(row[4]))