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))