Skip to content
Outputs the Result Set of a SQL Query as a JSON listing.
Python Shell Makefile
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
templates ignore *.swp files Nov 7, 2019
.gitignore
COPYING
Makefile
Procfile
README
dbq.py
examples.sh Update examples.sh Oct 20, 2019
flaskapp.py
requirements.txt
utils.py

README

dbq.py
======

api
---

Parameters:

    "connection_string" 

    Must be a valid connection string. dbq.py uses SQLAlchemy, so test it on your
    own machine first and ensure that the webserver can reach the database host.

    "sql_query"

    The query to run on the database.

cli
---

Usage: dbq.py [OPTIONS]

  This little Python script runs SQL statements on databases from the
  command-line.

  You must pass in a valid connection string.

  The raw query overrides the file query.

Options:
  --conn TEXT      Connection string.
  --file FILENAME  SQL query file.
  --sql TEXT       Raw query.
  --help           Show this message and exit.
You can’t perform that action at this time.