exporting in XML

53 views
Skip to first unread message

Massimo Di Pierro

unread,
Mar 28, 2008, 9:50:03 PM3/28/08
to michaelangela, web...@googlegroups.com
My Michael,

great blog you have!

I see you are interested in exporting tables in XML. Here is how you
can do it (using the version in trunk):

def export_xml(rows):
idx=range(len(rows.colnames))
colnames=[item.replace('.','_') for item in rows.colnames]
records=[]
for row in rows.response: records.append(TAG['record'](*[TAG
[colnames[i]](row[i]) for i in idx]))
return str(TAG['records'](*records))

Here is how you would use it:

assuming:
db=SQLDB('sqlite://test.db')
db.define_table('mytable',SQLField('myfield'))
for i in range(100): db.mytable.aaa.insert(myfield=i)

def index():
response.headers['Content-Type']='application/xml'
return export_xml(db().select(db.mytable.ALL))


Reply all
Reply to author
Forward
0 new messages