storing data from xml to database using python

[koil70]

1) I need to save the data from xml file to database and display the saved data in UI.2) I am using mysql for database.my xml file is \[code\]<!-- books.xml --><catalog> <book isbn="1-880985-26-8"> <title>The Consumer</title> <author>M. Gira</author> </book> <book isbn="0-679775-43-9"> <title>The Wind-Up Bird Chronicle</title> <author>Haruki Murakami</author> </book> <book isbn="0-679775-13-6"> <title>Deccon Chronicle</title> <author>Kulkarni</author> </book> <book isbn="0-679775-93-6"> <title>Python</title> <author>David varner</author> </book></catalog>\[/code\]How to write views.py or filename.py to perform the above operation.I am new to python & xml.Can i get the help from experts.actually in my bookhandler.py i did this,\[code\]from sqlalchemy import *from sqlalchemy.orm import *import xml.sax.handlerpg_db = create_engine('postgres:///testdb?user=homer')metadata = http://stackoverflow.com/questions/15784208/MetaData(pg_db)books_table = Table('books', metadata, autoload=True)class Book(object): passmapper(Book, books_table)class BookHandler(xml.sax.handler.ContentHandler): def __init__(self): self.buffer = "" self.inField = 0 self.session = create_session(bind=pg_db) def startElement(self, name, attributes): if name == "book": self.isbn = attributes["isbn"] elif name == "title": self.inField = 1 elif name == "author": self.inField = 1 def characters(self, data): if self.inField: self.buffer += data def endElement(self, name): if name == "book": self.session.begin() self.newbook = Book() self.newbook.isbn = self.isbn self.newbook.title = self.title self.newbook.author = self.author self.session.save(self.newbook) self.session.commit() elif name == "title": self.inField = 0 self.title = self.buffer elif name == "author": self.inField = 0 self.author = self.buffer self.buffer = ""\[/code\]my models.py for storing data is \[code\]class Book(models.Model): ISBN=models.AutoField(primary_key=True,unique=True) title=models.CharField(max_length=30) author=models.CharField(max_length=40)\[/code\]I runned the app,but i am not getting the result.