pyxmdb Database utility to import/export delimited text files (e.g. CSV)
Download

pyxmdb Ranking & Summary

pyxmdb Tags

database export import database importer export text database exporter

pyxmdb Description

Database utility to import/export delimited text files (e.g. CSV) pyxmdb is an open source Python based tool that will allow developers to import and export delimited text files (e.g. CSV) to virtually any DBMS that Python supports. All DBMS specific information is stored in a user modifiable config file. Here are some key features of "pyxmdb": · import or export from/to a comma delimited text file into/from a MySQL, Oracle, PostgreSQL, Ingres or SQLite database. · flexible logging which can be altered via a config file · additional DBMS support can be added via a config file (no code changes required) · import has support for auto commit after every "x" rows · import can abort the process after "x" many errors · export can write out a header record as the first row · import can skip the first row if it is a header record · export will take any valid SQL select statement and write the result to the output file · import has some flexibility for mapping fields in the source file to columns in the destination table · has been test on both Linux (FC7) and Windows (XP) with Python 2.4 and 2.5 · import can read from STDIN if no filename given · export can write to STDOUT if no filename given · --presql parameter for specifying an SQL command to run before the import/export · --postsql parameter for specifying an SQL command to run after the import/export · support for reading/writing compressed files (gzip and bzip2) · using the --presqlfile, --postsqlfile, or --sqlfile; you can provide a .sql file with commands to run for the pre / post / main SQL parameters. Requirements: · Python 2.4 or later What's New in This Release: · Minor bug fix. During the code cleanup for v0.6 I accidentally broke support for using the "--sqlfile" command line parameter during an export.

pyxmdb Related Software