Colorize sqlite3 CLI

[StanFromIreland]

Feature or enhancement

Proposal:

I will open a pr once #133393 is complete.

General idea is to follow repl color scheme:

sqlite>: repl magenta (i.e. >>>)
keywords: repl keyword blue (i.e. def)
.quit/.help: repl turquoise (i.e. exit)
rest: no color

Has this already been discussed elsewhere?

This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

No response

Linked PRs

• gh-133447: Add basic color to sqlite3 CLI #133461

---

• gh-133934: Improve sqlite3 .help message #135224

[hugovk]

See also theming support, which will hopefully be merged soon: issue #133346 / PR #133347.

[ambv]

I like how Stan is already talking in terms of semantic classes.

[StanFromIreland]

Unfortunately the code currently uses a subclass of InteractiveConsole (color support anytime soon? ;-) so I would have to write a raw_input, but that still has to wait for the other pr ideally.

For now I will open a pr adding color to the line starts as it is not depending on the pr. (Progressing like pyrepl coloring...)

[StanFromIreland]

This is not in the sqlite3 project.

cc @ezio-melotti Can the project be set up to add them when the label is used topic-sqlite3, it would be a good test for the github workflow-like automations for projects that we discussed earlier?

[ezio-melotti]

Done!

Details

I enabled the auto-add workflow:

which matches 7 issues -- including this one -- but doesn't add them unless they are updated or newly created:

Note: after enabling the workflow and posting this message, the issue wasn't added to the workflow, so I added it manually. The GitHub docs are not clear on what "updated" means (apparently posting a message doesn't count as an update).

Note: I initially added in:title to the auto-add workflow query, but I got an error stating that it's invalid. Even after removing it, the query matches 7 issues, even though when I follow the "See 7 existing issues" link I get 50 issues. I now reported this issue to GitHub.

[StanFromIreland]

posting this message, the issue wasn't added to the workflow

That is odd, maybe it only checks on title modifications?

I initially added in:title to the auto-add workflow query, but I got an error stating that it's invalid.

We could add on the label addition instead like other projects.