db.export_to_csv_file will only contain the raw data, it will not include any of the database specific things (such as indexies, mysql/postgres users, stored procedures, sequence stores, etc...)
-- Thadeus On Fri, Dec 10, 2010 at 5:24 PM, mdipierro <[email protected]> wrote: > if you do > > > db.export_to_csv_file(open('myfile.csv','wb')) > > you get a csv dump of the db and you do > > db.import_from_csv_file(open('myfile.csv','rb')) > > you get a restore. The myfile.csv is a csv file and it is not specific > of one db engine. > > Massimo > > > > On Dec 10, 4:38 pm, Richard <[email protected]> wrote: > > I have a CSV file and want to generate dumps of the data for sqlite, > > mysql, postgres, etc. > > > > My current workflow is to insert the data in each database and then use > > mysqldump, etc to generate the dump files. > > > > I read that the DAL is now a standalone module - great! > > Is it possible to use the DAL to purely generate the required SQL for a > > database without actually inserting or even installing the database? >
