Command line program that executes SQL queries and stores results in Excel files
Project description
SQL to Excel converter
Command line program that executes SQL queries and stores results in Excel files
Free software: Apache Software License 2.0
Features
Support for PostgreSQL, MySQL, Oracle, MSSQL, and SQLite
Accepts multiple SQL query files
Each SQL query will be written into a different sheet
Parametrized queries
Parametrized output filename
Installation
To install all you need to do is run:
$ pip install --upgrade sqlexceller
Usage Help
usage: sqlexceller [-h] [-v] [--output OUTPUT] [--db_connection_info URL] [--param PARAMS] file [file ...] sqlexceller tool The tool will execute SQL queries and generate an Excel file with the results. positional arguments: file SQL Query file optional arguments: -h, --help show this help message and exit -v, --version show program's version number and exit --output OUTPUT, -o OUTPUT Output file --db_connection_info URL, -d URL DB connection information as an URL in the form of dialect[+driver]://username:password@host:port/database. --param PARAMS, -p PARAMS Adds a parameter for the SQL queries. Parameter must be specified as a key=value pair. This argument can be repeated as many times as necessary. Available dialects and drivers are: - postgresql: - psycopg2 - pg8000 - mysql: - mysqldb - mysqlconnector - oursql - oracle: - cx_oracle - mssql: - pyodbc - pymssql - sqlite There are some default parameters that will always be present: - NUM_QUERY - QUERY_NAME - DATE - DAY - MONTH - YEAR Usage examples: - Execute a simple query on a SQLite DB. sqlexceller query.sql -d sqlite:///example.db - Execute multiple queries with 2 different parameters and a custom output file on a PostgreSQL DB: Contents of query1.sql: SELECT * FROM stocks where transaction = :transaction; Contents of query2.sql: SELECT * FROM stocks where transaction = :transaction and product = :product; sqlexceller query1.sql query2.sql -p transaction=BUY -p product=HAT \ -o "report :trans (:MONTH-:DAY).xlsx" \ -d postgresql://user:password@localhost/mydatabase Generated file will be something like: "report BUY (10-16).xlsx"
Reporting an issue
If you’ve found an issue with sqlexceller here’s how you can report the problem:
Preferred method is filing a bug on GitHub:
Go to project’s issue tracker on GitHub
Search for existing issues using the search field at the top of the page
File a new issue with information on the problem
Thanks for helping make sqlexceller better
If you don’t have a GitHub account and don’t wish to create one you can just drop me an email.
History
0.1.1 (2018-03-17)
Fix #1: Exception on empty result set from query
0.1.0 (2016-10-16)
First release on PyPI.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file sqlexceller-0.1.1.tar.gz
.
File metadata
- Download URL: sqlexceller-0.1.1.tar.gz
- Upload date:
- Size: 20.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | ae36d0311e59b2a27ce76dfa4a7745d63777208a40d13d4f70dbcd3147647365 |
|
MD5 | 04fd285aa77ff07902965f3ae7671ee0 |
|
BLAKE2b-256 | fb7bda7e8191dce5416bd7549c527bbfc6c343cd19e5aaada91939aad5860a25 |
File details
Details for the file sqlexceller-0.1.1-py2.py3-none-any.whl
.
File metadata
- Download URL: sqlexceller-0.1.1-py2.py3-none-any.whl
- Upload date:
- Size: 8.8 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9aeaad58b242a362c5bf8394a8a5e7ac3f52f42f4809e02c46e968f08e5b3cbb |
|
MD5 | 20373ed46f4246a7dc3877338aa64d41 |
|
BLAKE2b-256 | 481bf230dceea1550b6c60ed62f7957b6cb3274fc738ab2520c2ff71370230e1 |