For helpful usages, when needing a query exported to a human readable
formatted report, export_to_csv needs to allow to call the represent
function.
diff -r 3a3a4c079479 gluon/sql.py
--- a/gluon/sql.py Wed Dec 16 13:09:19 2009 -0600
+++ b/gluon/sql.py Thu Dec 17 12:21:00 2009 -0600
@@ -3367,6 +3367,7 @@
delimiter = kwargs.get('delimiter', ',')
quotechar = kwargs.get('quotechar', '"')
quoting = kwargs.get('quoting', csv.QUOTE_MINIMAL)
+ represent = kwargs.get('represent', False)
writer = csv.writer(ofile, delimiter=delimiter,
quotechar=quotechar, quoting=quoting)
# a proper csv starting with the column names
@@ -3395,10 +3396,17 @@
row.append(record._extra[col])
else:
(t, f) = col.split('.')
+ if isinstance(record.get(t, None), (Row,dict)):
row.append(none_exception(record[t][f]))
else:
+ if represent:
+ if self.db[t][f].represent:
+
row.append(none_exception(self.db[t][f].represent(record[f])))
+ else:
+ row.append(none_exception(record[f]))
+ else:
+ row.append(none_exception(record[f]))
writer.writerow(row)
def __str__(self):
-Thadeus
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
