I'm Back!!!
Thank to all the help full information I've got a simpler method to get the
info I want for my reports.
The following works like a charm with one exception:
I my apps db directory I have the following file getTimeSummaryDataset.py
which id called by the FrmReportTimeSummary.py file in the ui directory and
it looks like this:
<code>
#-*- coding: utf-8 -*-
import datetime
import decimal
import dabo
def getTimeSummaryDataSet():
import sqlite3
conn=sqlite3.connect('/home/theedo/Programs/Dabo/2010-timeEditionBackup.edb')
crs = conn.cursor()
crs.execute("select customerID, projectID,
sum(strftime('%s',toTime)-strftime('%s',fromTime)) from records GROUP BY
customerID,projectID")
ds = []
for cust in crs.fetchall():
dsentry = {'customerID':cust[0], 'projectID': cust[1],
'durationtotal': cust[2],}
ds.append(dsentry)
return ds
</code>
The only issue now is, how do I do joins in sqlite as I have in my bizobjs
file so that I can use customer.name (customer table) and
project.name(project table) instead of just the customerID and
projectID that are
available in the records table.
Anyone? Bueler?
Thanks in advance
Carey
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
