[Tutor] sqlite3 format data from tables
David
david at abbottdavid.com
Sat May 23 17:51:38 CEST 2009
I have a budget program I am using to learn from.
http://linuxcrazy.pastebin.com/f3b301daf
I can not figure out how to get the transaction details to return so
that it looks nice. It returns like this now.
Your transaction History is: [(1, u'Food', -100), (2, u'Deposit', -200),
(3, u'Deposit', 500), (4, u'Python Book', -50)]
Here is how it gets to that point;
def get_transactions(self):
ct=self.connection.cursor()
ct.execute("select * from transact;")
return ct.fetchall()
def report_transactions(self):
return self.database.get_transactions()
def display_transactions(self):
print "Your transaction History is:",self.bl.report_transactions()
self.menu[5]=("Transaction History",self.display_transactions)
Can I use the numbers 1,2,3,4 as a way to return the history?
Thanks, I hope I explained it correctly :)
-david
--
Powered by Gentoo GNU/Linux
http://linuxcrazy.com
More information about the Tutor
mailing list