0L4u4V9V

1import xml.etree.ElementTree as ET
2import sqlite3
3conn = sqlite3.connect ('dvds.sqlite')
4cur = conn.cursor()
5
6cur.executescript('''
7DROP TABLE IF EXISTS Films;
8
9CREATE TABLE Films (
10    id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
11	title  TEXT UNIQUE,
12	genre  TEXT,
13	cert   INTEGER
14	
15);
16
17''')
18
19fname = raw_input('Enter file name: ')
20if ( len(fname) < 1 ) : fname = 'dvds.xml'
21   
22stuff = ET.parse(fname)
23for entry in stuff.findall('film'):
24    title = entry.find('title').text
25    genre = entry.find('genre').text
26    cert = entry.find('certificate').text
27
28    print title, genre, cert
29	
30    cur.execute('''INSERT OR IGNORE INTO Films (title, genre, cert) 
31		VALUES ( ?, ?, ? )''', ( title, genre, cert ) )
32   
33conn.commit()