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