def updateBooklist(self, booklist):
self.connect()
self.cursor.execute("update %s set books='%s' where name='%s'" % (self.booklist_table,
intListToString(booklist.books),
booklist.name))
self.close()
def updateAuthor(self, author):
self.connect()
self.cursor.execute(
"update %s set books='%s' where name='%s'" % (self.author_table, intListToString(author.books),
author.name))
self.close()
def addBooklist(self, booklist):
self.connect()
self.cursor.execute("insert into %s values('%s', '%s')" % (self.booklist_table, booklist.name,
intListToString(booklist.books)))
self.close()
def addAuthor(self, author):
self.connect()
self.cursor.execute("insert into %s values('%s', '%s')" % (self.author_table, author.name,
intListToString(author.books)))
self.close()