Skip to main content

No project description provided

Project description

sql-extract

Exports the results of Oracle sql code contained in a .sql file out to a csv file.

Usage

# with input file
sql-extract in_sql_file.sql -o output_file.csv

# with quick text
sql-extract -t "select 1 from dual" -o output_file.csv

# with named bind parameters
sql-extract -t "select * from phonebook where first_name=:fn and last_name=:ln" -b fn=Dennis ln=Nedry -o output_file.csv

# additional help
sql-extract -h

Parameters

Name Description Type Required
filename input .sql file name string yes
-o, --outfile output .csv file name string no
-d, --delimiter .csv delimiter string no
-c, --quotechar .csv quote character string no
-l, --login Oracle login string string no
-p, --password Oracle password string no
-t, --text SQL query text (instead of file) string no
-b, --bind-variables Any named bind parameters in the .sql file, must follow param=value convention list no
positional_variables any positional variables in the .sql file list no

Configuration

Store your Oracle login and password in full_login and db_password environment variables, respectively. Otherwise, you must use --login and --password to pass in your credential(s). You can alternatively store your login as an environment variable but not your password (or vice versa).

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sql_extract-0.3.1.tar.gz (5.4 kB view details)

Uploaded Source

Built Distribution

sql_extract-0.3.1-py3-none-any.whl (6.8 kB view details)

Uploaded Python 3

File details

Details for the file sql_extract-0.3.1.tar.gz.

File metadata

  • Download URL: sql_extract-0.3.1.tar.gz
  • Upload date:
  • Size: 5.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.2 CPython/3.7.4

File hashes

Hashes for sql_extract-0.3.1.tar.gz
Algorithm Hash digest
SHA256 e67385723db0b5dda2f0cf2379c24e48ae03e55cf9caeb204db7b6f9e1a9e2b4
MD5 bfff196c5937a5de3b4ec2709bf2c88e
BLAKE2b-256 29d8954dff282f1d6507dbc72f77b0dbd89ae27076392d2d690d383b7b448f8b

See more details on using hashes here.

File details

Details for the file sql_extract-0.3.1-py3-none-any.whl.

File metadata

  • Download URL: sql_extract-0.3.1-py3-none-any.whl
  • Upload date:
  • Size: 6.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.2 CPython/3.7.4

File hashes

Hashes for sql_extract-0.3.1-py3-none-any.whl
Algorithm Hash digest
SHA256 7ffb88dda42d244448194fd927e05d10287f72285f77240fe5c72fa6ff253d37
MD5 c039e3d9743a54dd9e5d69d132347f85
BLAKE2b-256 ffa7e6c4fd4e61416eae2c4318e6bf1213a50cf4aee58a64bd54e4ad5c2c957b

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page