This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author rhettinger
Recipients rhettinger
Date 2018-05-07.01:46:57
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1525657620.33.0.682650639539.issue33436@psf.upfronthosting.co.za>
In-reply-to
Content
To facilitate rapid experimentation with SQL queries, add a shell to run commands and display results.

Attached is minimal proof-of-concept modeled loosely on the Linux sqlite3 REPL.  Here's a sample session:

    SQLite version 2.6.0

     Enter "help" for usage hints

    sqlite> open Irises.db
    sqlite> select distinct species from irises
    ('Iris-setosa',)
    ('Iris-versicolor',)
    ('Iris-virginica',)
    sqlite> select species, avg(pet_len), avg(sep_len) from irises group by species
    ('Iris-setosa', 1.464, 5.005999999999999)
    ('Iris-versicolor', 4.26, 5.936)
    ('Iris-virginica', 5.552, 6.587999999999998)
    sqlite> select count(*) from irises
    (150,)
    sqlite> quit
History
Date User Action Args
2018-05-07 01:47:00rhettingersetrecipients: + rhettinger
2018-05-07 01:47:00rhettingersetmessageid: <1525657620.33.0.682650639539.issue33436@psf.upfronthosting.co.za>
2018-05-07 01:47:00rhettingerlinkissue33436 messages
2018-05-07 01:46:59rhettingercreate