Highlighting of SQL inside strings
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 32/100
Research direction
No files or tests are named. Reproduce the two Python string examples in the supported editor integrations, then inspect the Python string-handling and SQL-highlighting entry points to understand why CREATE TABLE differs from INSERT. Done means SQL keywords receive consistent highlighting in both examples without breaking ordinary Python strings.
Written by the indexing model from the issue text.
Description
The stock Python package performs syntax highlighting inside strings containing SQL commands. That's rather useful, even though the implementation might need some more work. In this example:
create = 'CREATE TABLE test (id INT, name TEXT);'
insert = 'INSERT INTO test VALUES (1, "Bob")'
in the second line, words recognized as SQL are highlighted, but not in the first one, where "CREATE TABLE" has the same color as the non-reserved names.
(Actually, as you can see, even Github's Markdown does it, with exactly the same behavior, so perhaps something is wrong with the first line, although it does execute properly)
Do you consider this a useful addition?
- Dominant language
- JavaScript
- Stars
- 1.4k
- Forks
- 98
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from MagicStack/MagicPython
-
Difficulty 3/5 1-2 days Newbie friendliness 58/100
MagicStack/MagicPython#275 · 1 reaction ·
-
Difficulty 3/5 1-2 days Newbie friendliness 48/100
MagicStack/MagicPython#273 · 7 reactions ·
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
MagicStack/MagicPython#269 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 42/100
MagicStack/MagicPython#267 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 42/100
MagicStack/MagicPython#265 · 2 comments ·
All issues in MagicStack/MagicPython
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
palladius/rails8-app-on-gcp#145 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
dotenvx/dotenv-vscode#139 ·
-
test-change-proposal
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
web-platform-tests/interop#1455 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
corsairdev/corsair#1764 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100