import sqlite3

import xml.etree.ElementTree as et

def insert_person(conn, first_name, last_name, profession):

curs = conn.cursor()

curs.execute("insert into person (first_name, last_name, profession) values (?, ?, ?)",

(first_name, last_name, profession))

conn.commit()

def person_from_element(element):

first = element.find('firstName').text

last = element.find('lastName').text

prof = element.find('profession').text

return first, last, prof

if __name__=="__main__":

conn = sqlite3.connect('people.sqlite3')

people = et.parse('people.xml')

for element in people.findall("person"):

first, last, prof = popdb.person_from_element(element)

popdb.insert_person(conn, first, last, prof)