[reportlab-users] Use With SQLite3

[Rich Shepard]

On Tue, 20 Feb 2007, Paul McNett wrote:


> Well, it is pretty simple. ...



> cur.execute("select * from test")

> rs = cur.fetchall()

> dict_cursor = []

> for rec in rs:

>   d = {}

>   for idx, fld in enumerate(cur.description):

>     d[fld[0]] = rec[idx]

>   dict_cursor.append(d)


   It certainly is.

   Now I'll play with the ReportDesigner and figure out how to print a report
of model parameters. There are a dozen tables, so I suppose the table name
would be the group name and the field values would be in the detail. The
model name, other descriptive information, and the date/time the report is
generated would be in the header.

Thank you,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863