[Tutor] Query dictionaries with sql-like syntax

Sandip Bhattacharya sandip at lug-delhi.org
Wed Jul 13 10:23:57 CEST 2005

Negroup - wrote:
> Hi all, I hope my questions makes sense..
> I'm trying to migrate a lot of data from an accounting system software
> to another using Python. Software A stores datas inside sql tables,
> software B too, with a different db structure.
> My idea has been to export sensible tables from db A, store them in
> python dictionaries, process/elaborate these dictionaries, and
> generate files containing data in a format that is importable from
> system B. Yes, it could seem a good idea.. however now I must handle a
> lot of dictionaries with a lot of related data.

Why dont you use python-sqlite to dump your data? You might need to
modify your sql slightly(depending on your current db), but rest is all sql.

- Sandip

Sandip Bhattacharya  *    Puroga Technologies   *     sandip at puroga.com
Work: http://www.puroga.com  *   Home/Blog: http://www.sandipb.net/blog

PGP/GPG Signature: 51A4 6C57 4BC6 8C82 6A65 AE78 B1A1 2280 A129 0FF3

More information about the Tutor mailing list