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.1.0.tar.gz
(2.4 kB
view hashes)
Built Distribution
Close
Hashes for sql_format-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 289a57bfe42fa18ebe03f901a1215e39dd266403f7cbb32b85b446d3bb761e11 |
|
MD5 | 3be217bf341e1c5d47a38f8d5ed91b02 |
|
BLAKE2b-256 | 56044f97223e41a58498729cd8cdef41c56b8da3869851900f58c0c32922ace8 |