The unified diff between revisions [d24eea5a..] and [da1bae7f..] is displayed below. It can also be downloaded as a raw diff.

#
#
# patch "Chart.py"
#  from [f01bb2a292e14dae573939fe0fad2dc305cc6e11]
#    to [a5bd9d90d2992bfe97ff659060552c03b16a601e]
#
# patch "SQLTemplates.py"
#  from [819862410d7d14aea08e6d162e6d15c964556089]
#    to [0a461ad0a72d4dfa518a60f9e14413741325f344]
#
============================================================
--- Chart.py	f01bb2a292e14dae573939fe0fad2dc305cc6e11
+++ Chart.py	a5bd9d90d2992bfe97ff659060552c03b16a601e
@@ -25,10 +25,21 @@ class Chart:
 		return cursor.lastrowid

 	def details(self, ledgerid):
-		# FIXME return real details from db
-		return ["womble",0,"womble"]
+		db = self.store.db
+		cursor = db.cursor()

+		cursor.execute(chart_sql['ledgerdetails'] % (ledgerid,))
+
+		return cursor.fetchone()
+
 	def list(self):
+		db = self.store.db
+		cursor = db.cursor()
+
+
+		list = []
+
+		for row in cursor.execute(chart_sql['ledgerlist']):
+			list.append(row[0])
+
+		return list
-		# FIXME return real details from db
-		return []
-
============================================================
--- SQLTemplates.py	819862410d7d14aea08e6d162e6d15c964556089
+++ SQLTemplates.py	0a461ad0a72d4dfa518a60f9e14413741325f344
@@ -13,4 +13,6 @@ chart_sql['newledger'] = "INSERT INTO CH
 chart_sql = {}

 chart_sql['newledger'] = "INSERT INTO CHART (details, debitbalance, info) VALUES (?, ?, ?)"
+chart_sql['ledgerdetails'] = "SELECT accountid, details, debitbalance,info FROM CHART WHERE accountid='%s'"
+chart_sql['ledgerlist'] = "SELECT accountid FROM CHART"