Skip to content

Latest commit

 

History

History
55 lines (48 loc) · 2.27 KB

README.md

File metadata and controls

55 lines (48 loc) · 2.27 KB
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: