A shell for doing simple SQL queries to any database supported by SQLAlchemy
Project description
The program takes one argument: a SQLAlchemy database URL of the form: dialect+driver://username:password@host:port/database (see the SQLAlchemy docs on database URLs for more info). You may need to install additional packages for your database driver of choice (e.g.: mysql-python, psycopg2, pymssql, etc.)
Here’s some basic usage:
$ sqlalchemy_sql_shell usage: sqlalchemy_sql_shell [-h] url sqlalchemy_sql_shell: error: too few arguments $ sqlalchemy_sql_shell sqlite:/// SQL> CREATE TABLE people ( first_name VARCHAR(128), last_name VARCHAR(128) ); SQL> INSERT INTO people VALUES ( 'John', 'Doe' ), ('Mike', 'Smith'), ('Guido', 'van Rossum'); result.rowcount = 3 SQL> SELECT * FROM people; +------------+------------+ | first_name | last_name | +============+============+ | John | Doe | | Mike | Smith | | Guido | van Rossum | +------------+------------+
Multi-line queries are supported; A semi-colon signifies the end of the query:
SQL> SELECT * ...> FROM people ...> ; +------------+------------+ | first_name | last_name | +============+============+ | John | Doe | | Mike | Smith | | Guido | van Rossum | +------------+------------+
You can also pipe queries into the command for quick one-liners:
$ echo "SELECT 1 + 2;" | sqlalchemy_sql_shell sqlite:/// +-------+ | 1 + 2 | +=======+ | 3 | +-------+
Or redirect stdin:
$ cat samples/queries.sql SELECT 1 + 2; SELECT 3 + 4; SELECT 5 + 6; $ sqlalchemy_sql_shell sqlite:/// < samples/queries.sql +-------+ | 1 + 2 | +=======+ | 3 | +-------+ +-------+ | 3 + 4 | +=======+ | 7 | +-------+ +-------+ | 5 + 6 | +=======+ | 11 | +-------+
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
Close
Hashes for sqlalchemy_sql_shell-0.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 44e680eefe63f29dad1aadc99b087039685efe69d5f90b2e562c2f0c39a56d44 |
|
MD5 | 962b96a6ef5b562ccd0b7b03fed004a9 |
|
BLAKE2b-256 | dd6e67daff62fa014ece502b8af0eb9cab1dfa2e04d356fcad1dd21aef59719c |