SQL export in zope

MatthewWilkes (Matthew Wilkes) — Wed, 08 Mar 2006 08:24:28 GMT

Takes the result of a Zope SQL query, and an ordered list of field names, and outputs a CSV file as the resultant web page. Should be called like this:

return context.sql.ordered-sql2csv(context.sql.exportOrders().dictionaries(), ["fullname","email","phone","address","town","postcode","children","adults","comments"])



## Script (Python) "ordered-sql2csv"

##bind container=container

##bind context=context

##bind namespace=

##bind script=script

##bind subpath=traverse_subpath

##parameters=sql, fo

##title=

##

container.REQUEST.RESPONSE.setHeader("Content-Type", "text/csv", 0)

sep = ""

for dk in fo:

  container.REQUEST.RESPONSE.write(sep + dk)

  sep = ","

sep = "\n"



for rec in sql:

  for i in range(0,len(fo)):

    data=rec[fo[i]]

    dl = str(data).split(',')

    data1 = " ".join(dl)

    container.REQUEST.RESPONSE.write(sep + str(data1))

    sep = ","

  sep="\n"

DZone Snippets: csv code

SQL export in zope