Great!! that worked. Thanks
On Tue, Jan 19, 2010 at 3:55 PM, Thadeus Burgess <[email protected]>wrote: > import cStringIO > > mystr = cStringIO.StringIO() > > db.export_to_csv_file(mystr) > > # set content headers > > return mystr.getvalue() > > -Thadeus > > > > > > On Tue, Jan 19, 2010 at 5:15 PM, Miguel Goncalves > <[email protected]> wrote: > > Hi > > > > Since I am running on GAE I guess the open(...) will not work. > > Instead I am trying to add exportToCsvAll function to the appadmin.py of > my > > application. > > > > I assume I have to iterate through all the tables, export them to csv > into a > > string and then return the string. > > > > Question is how do I export each table? I am doing: > > > > def exportToCsvAll(): > > import gluon.contenttype > > response.headers['Content-Type'] = > gluon.contenttype.contenttype('.csv') > > response.headers['Content-disposition'] = 'attachment; > > filename=%s_db.csv' % "MLinks" > > res = "" > > for table in databases['db']: > > res = res + str(table.select()) > > > > return res > > > > the table.select() does not seem to be correct. > > Obviously table is of type gluon.contrib.qql.Table and what I need to do > a > > select is a SQLDB object. > > How to I get this object? > > > > thanks > > Miguel > > > > > > On Sun, Jan 17, 2010 at 11:51 PM, mdipierro <[email protected]> > wrote: > >> > >> db.export_to_csv_file(open(filename,'w')) > >> > >> > >> db.import_from_csv_file(open(filename,'r')) > >> > >> > >> On Jan 18, 1:18 am, Miguel <[email protected]> wrote: > >> > Hi > >> > > >> > Is there an easy way to export and import (.csv) all the tables of a > >> > given application at once? > >> > In the admin UI I can export tables individually but I did not find a > >> > way of exporting all at them at once. > >> > > >> > It would be really useful for testing and while working on the same > >> > application across multiple computers. > >> > > >> > Thanks > >> > -Miguel > >> > >> -- > >> 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]<web2py%[email protected]> > . > >> For more options, visit this group at > >> http://groups.google.com/group/web2py?hl=en. > >> > >> > >> > > > > -- > > 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]<web2py%[email protected]> > . > > For more options, visit this group at > > http://groups.google.com/group/web2py?hl=en. > > > > -- > 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]<web2py%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > > -- 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.
