[issue2551235] add sql subcommand to roundup-admin (use roundup-admin to change sqlite journal mode)

New submission from John Rouillard:

Add a sql command to roundup-admin to allow running sql commands against the database.

Specific use case is to toggle sqlite db from delete to wal journal mode and back.
The admin/upgrading documentation uses sqlite3. If sqlite3 is not installed
(e.g in a docker container) Roundup should provide some alternate method.

If the sql command is run against a non-sql backend it should return an appropriate
error.

Open question:

  should the sql command allow arbitrary sql, or should it be filtered (e.g. to rule
  out dropping tables)?

----------
components: Command-line interface
messages: 7652
nosy: rouilj
priority: normal
severity: normal
status: new
title: add sql subcommand to roundup-admin (use roundup-admin to change sqlite journal mode)
type: rfe

_________________________________________________
Roundup tracker <[email protected]>
<https://issues.roundup-tracker.org/issue2551235>
_________________________________________________