Sure, I figured the reason against adding it to SQLDB was because it adds
web2py specific meta information. I will send you the new patch in a minute.

-Thadeus




On Tue, Nov 3, 2009 at 2:39 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:

>
> thanks, can you email it to me plase. Can you also add the options to
> SQLDB.export_to_csv
>
> On Nov 3, 2:36 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
> > Here is a patch to allow Rows.export_to_csv file to specify the
> quotechar,
> > delimiter, and quoting type.
> >
> > Mainly, I needed support for QOUTE_NONNUMERIC so that my data could
> import
> > to Microsoft Access.
> >
> > Massimo I will email you the diff file.
> >
> > Basically, now you can do
> >
> > Rows.export_to_csv_file(ofile, delimiter='|', qoutechar='"',
> > qouting=csv.QOUTE_NONNUMERIC)
> >
> > Index: gluon/sql.py
> > ===================================================================
> > --- gluon/sql.py    (revision 1381)
> > +++ gluon/sql.py    (working copy)
> > @@ -3235,14 +3235,19 @@
> >          for i in xrange(len(self)):
> >              yield self[i]
> >
> > -    def export_to_csv_file(self, ofile, null='<NULL>'):
> > +    def export_to_csv_file(self, ofile, null='<NULL>', *args, **kwargs):
> >          """
> >          export data to csv, the first line contains the column names
> >
> >          :param ofile: where the csv must be exported to
> >          :param null: how null values must be represented (default
> '<NULL>')
> >          """
> > -        writer = csv.writer(ofile)
> > +        delimiter = kwargs.get('delimiter', ',')
> > +        quotechar = kwargs.get('quotechar', '"')
> > +        quoting = kwargs.get('quoting', csv.QUOTE_MINIMAL)
> > +
> > +        writer = csv.writer(ofile, delimiter=delimiter,
> > quotechar=quotechar, quoting=quoting)
> > +
> >          # a proper csv starting with the column names
> >          writer.writerow(self.colnames)
> >
> > -Thadeus
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to