Skip to content

python database export script. It takes a sql statement an generates csv or xml output. There are several options to customize the output.

License

Notifications You must be signed in to change notification settings

bisbeb/pyexport

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Usage: 
Tool to export data from a relational database to different formats. Currently it is possible to export
data from oracle, mysql or postgres databases to csv and xml. There will be support for json as soon as
possible. Because a the moment minidom is used to construct the xml, in case of a large result set the
performance will suffer on systems with not enought RAM. have fun... :)
    

Options:
  -h, --help            show this help message and exit
  -o , --output=
                        output file
  -f , --format=
                        output format [csv, xml, json]
  -s , --sql=
                        sql file
  -e , --timestamp=
                        add timestamp to export file, must be a valid python
                        datetime format
  -z, --force           force overwriting of existing files

  Database options:
    -d , --database=
                        database type [oracle, mysql, postgres]
    -u , --username=
                        database username
    -w , --password=
                        database password
    -b , --host=
                        database hostname
    -n , --dbname=
                        database name, in case of oracle it's the sid

  Generic export options:
    -r , --newline=
                        newline character used for export, defaults to unix
                        style
    -a , --dateformat=
                        dateformat, it's a valid python date format

  CSV export options:
    -l , --delimiter=
                        delimiter used for csv export, defaults to ,
    -c , --quotechar=
                        quote charcater used for csv export, defaults to "
    -q , --quote=
                        quote style [none, minimal, string, all]

  XML export options:
    -p, --pretty        pretty print xml
    -i , --indent=
                        indent character

  JSON export options:
  

About

python database export script. It takes a sql statement an generates csv or xml output. There are several options to customize the output.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages