search

ahmadawais / shades-of-purple-vscode

🦄 Shades of Purple offers a hand-picked selection of bold and vibrant shades of purple that will transform your code into a visually stunning masterpiece. With its carefully crafted color palette, this theme brings a sense of style, elegance, and whimsy to your favorite code editor, making your coding sessions a delightful journey of creativity.
https://marketplace.visualstudio.com/items?itemName=ahmadawais.shades-of-purple
Other
733 stars 62 forks source link

Syntax highlighting for SQL strings #33

Closed sfrench87 closed 5 years ago

sfrench87 commented 5 years ago

It would be great to get SQL strings fully supported, with highlighting of functions/keywords etc.

ahmadawais commented 5 years ago

Give me code examples with code so I can test and make it better. Both pics and code.

sfrench87 commented 5 years ago

Hi, i've attached screenshots of sop and monokai pro, to show the difference.

$test = "SELECT req_id, cCode, inst, course_isn-10000 AS course_isn, venue, areaName, courseTitle, DATE_FORMAT(startDate, '%D %b %Y')
  AS startDate, endDate, dow, startTime, endTime, noWeeks, tutor, fee, concessions, courseArea, publicSite, whoFor, whatLearn, content, equipment, workOutside, assessment, whatNext, otherCosts, brochureText, teachMethod, webEnrol
  FROM SETUPConfirmedWeb W
  INNER JOIN SETUPCourseArea A ON W.courseArea = A.area_id
  WHERE courseTitle = (SELECT courseTitle FROM SETUPConfirmedWeb WHERE req_id = $IDS) AND venue = (SELECT venue FROM SETUPConfirmedWeb WHERE req_id = $IDS)
    AND TIMESTAMPDIFF(DAY, NOW(), startDate) >= -60 AND publicSite = 1"

Capture Capture2

sfrench87 commented 5 years ago

Hi i've come up with a few changes that work for me, if it helps at all plus a small regex string fix

{ "scope": ["source.sql"], "settings": { "foreground": "#ffffffff" } }, { "scope": ["source.sql keyword.other"], "settings": { "foreground": "#ff9d00ff" } }, { "scope": ["source.sql support.function"], "settings": { "foreground": "#FAD000" } }, { "name": "RegExp String", "scope": ["string.regexp", "string.regexp keyword.other"], "settings": { "foreground": "#ffffffff" } } Capture2 Capture

ahmadawais commented 5 years ago

DONE Published ahmadawais.shades-of-purple@4.13.0

You should see the changes in the latest version. Thanks for the help.

P.S. You can always write a five-star review as sort of an appreciation for all the time I put into this theme — if interested click here to do that → Rating