Format your SQL statements using the sql-pretty-printer API
Project description
sql-format
Format your SQL statements using the sql-pretty-printer API.
Dependencies
This project uses the following modules:
Installation
To install, download the repository via:
git clone https://github.com/rrickgauer/sql-format.git
Usage
In the sql-format directory, use:
python sql-format.py
Example
sql-format will take the following SQL statement:
select Songs.id, Songs.title, Artists.name from Songs left join Artists on Songs.artist_id = Artists.id where Songs.id > 100 order by Songs.title desc limit 20;
and turns it into this:
SELECT Songs.id,
Songs.title,
Artists.name
FROM Songs
LEFT JOIN Artists
ON Songs.artist_id = Artists.id
WHERE Songs.id > 100
ORDER BY Songs.title DESC
LIMIT 20;
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-format-0.0.5.tar.gz
(2.5 kB
view hashes)
Built Distribution
Close
Hashes for sql_format-0.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1638c7d2852709c97b2143ee208507a6a47cfda503d02cd3e28d49fdfe6f3781 |
|
MD5 | 1bb16431f41ed2e2d17c1124bc5ad776 |
|
BLAKE2b-256 | adce8956b6b0f61c11867e045dd5f707f01755c02e99e229b24d489512dc8a9b |