from sqlite3 import *

def insert(a, b, c, d, e):
    with connect("schule.db") as con:
        cursor = con.cursor()
        sql = """INSERT INTO person 
                 (familienname, vorname, wohnort, geschlecht, jahrgang) 
                 VALUES 
                 ('%s', '%s', '%s', '%s',  %d)""" %(a, b, c, d, e)
        cursor.execute(sql)    
           
insert('Meier', 'Peter', 'Gümligen', 'm', 2001)
insert('Flückiger', 'Marc', 'Bern', 'm', 2003)
insert('Huber', 'Anna', 'Bern', 'w', 2003)
insert('Bauer', 'Paul', 'Muri', 'm', 2000)
insert('Zwahlen', 'Noe', 'Ostermundigen', 'm', 2002)
insert('Meier', 'Nina', 'Wohlen', 'w', 2001)
print("Done")