mirrors
/
nano
mirror of git://git.sv.gnu.org/nano.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
nano/syntax/sql.nanorc

54 lines
2.4 KiB
Plaintext
Raw Permalink Normal View History

syntax: sql: condense some regexes, and reduce their number
2020-04-26 18:21:32 +03:00
## Syntax highlighting for (Postgres) SQL scripts.
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
syntaxes: mention the original author of most of the syntax files The names of the authors were retrieved from: git log -p --follow syntax/<name>.nanorc and from: git log -p --follow --all -- doc/nanorc.sample For some files the original author is unclear, or the file is/was too small to mention an author for.
2024-06-08 12:28:06 +03:00
## Original author: Devrim Gündüz
syntax: sql: remove alien stuff -- it was copied mostly from ruby syntax Regular expressions in SQL are not written between // or %r{}, strings are not written between <> or %Q{} or anything similar, and comments do not start with # -- and officially not with // either, but some dialects seem to allow it. This fixes https://savannah.gnu.org/bugs/?61381. Bug existed since version 2.4.2, since the SQL syntax was included.
2021-10-25 18:40:24 +03:00
syntax sql "\.sql$"
new feature: comment/uncomment current line or selected lines This allows for commenting or uncommenting a line or a bunch of lines with a single keystroke (default binding: M-3). The characters used for commenting/uncommenting are specified by the active syntax file. Reviewed-by: Benno Schulenberg <bensberg@justemail.net> Signed-off-by: Mike Scalora <mike@scalora.org>
2016-05-25 23:13:50 +03:00
comment "-- "
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
# Types.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #0a4 "\<(integer|int[248]|(big|small)?(int|serial)|decimal|numeric|real|double precision)\>"
icolor #0a4 "\<(bit( varying)?|boolean|bytea|enum|money|tsquery|tsvector|uuid|xml)\>"
icolor #0a4 "\<(char|varchar|character( varying)?|text|cidr|inet|macaddr8?)\>"
icolor #0a4 "\<(date|interval|time(stamp)?( with(out)? time zone)?)\>"
icolor #0a4 "\<(box|circle|line|lseg|path|point|polygon)\>"
icolor #0a4 "\<(date|int[48]|num|ts|tstz)range\>"
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
# SQL keywords.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #48c "\<(ABORT|AGGREGATE|ALL|ALTER|ANALYZE|AND|ANY|AS|BEGIN|BETWEEN|CAST|CHECKPOINT)\>"
icolor #48c "\<(CLOSE|CLUSTER|COLLATION|COMMENT|COMMIT|CONSTRAINTS?|CONVERSION|COPY|CREATE)\>"
icolor #48c "\<(DATABASE|DEALLOCATE|DECLARE|DEFAULT|DELETE|DISCARD|DISTINCT|DO|DOMAIN|DROP)\>"
syntax: sql: add a few more missing keywords, like TRUE and FALSE Also, don't first scare-color stuff between double quotes, as it seems some dialects put certain calculations between them too.
2021-12-07 14:23:29 +03:00
icolor #48c "\<(END|EXCEPT|EXECUTE|EXISTS|EXPLAIN|EXTENSION|FALSE|FETCH|FOREIGN (DATA WRAPPER|SCHEMA|TABLE))\>"
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #48c "\<(FROM|FUNCTION|GRANT|GROUP( BY)?|HAVING|IN|INDEX|INSERT|INTERSECT|INTO|IS)\>"
icolor #48c "\<(NATURAL )?(INNER |OUTER |CROSS |(LEFT|RIGHT|FULL)( OUTER)? )?JOIN\>"
icolor #48c "\<((PRIMARY|FOREIGN) KEY|LANGUAGE|LOAD|LIKE|LOCK|MOVE|NOT|NOTIFY|NULL)\>"
syntax: sql: add a few more missing keywords, like TRUE and FALSE Also, don't first scare-color stuff between double quotes, as it seems some dialects put certain calculations between them too.
2021-12-07 14:23:29 +03:00
icolor #48c "\<(ON|ONLY|OPERATOR( CLASS| FAMILY)?|OR|ORDER BY|PREPARED?|PRIVILEGES|PROCEDURE)\>"
icolor #48c "\<(REFERENCES|RELEASE|REPLACE|RESET|RETURN(S|ING)|REVOKE|ROLE|ROLLBACK|RULE|SAVEPOINT|SCHEMA)\>"
icolor #48c "\<(SELECT|SEQUENCE|SERVER|SESSION AUTHORIZATION|SET|SHOW|SIMILAR|START|SYSTEM)\>"
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #48c "\<(TABLE(SPACE)?|TEXT SEARCH (CONFIGURATION|DICTIONARY|PARSER|TEMPLATE))\>"
syntax: sql: add a few more missing keywords, like TRUE and FALSE Also, don't first scare-color stuff between double quotes, as it seems some dialects put certain calculations between them too.
2021-12-07 14:23:29 +03:00
icolor #48c "\<(TO|TRANSACTION|(EVENT )?TRIGGER|TRUE|TRUNCATE|TYPE|UNION|UNIQUE|UPDATE|USER( MAPPING)?|USING)\>"
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #48c "\<(VACUUM|VALUES|((REFRESH )?MATERIALIZED )?VIEW|WHERE|WITH)\>"
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
syntax: sql: colorize as flow control only keywords that clearly are such Drop things that were recolored afterward (like CLASS and DEFAULT). Also, move these coloring rules to after the other keywords so that things like "END IF" will stay colored as a whole. Reference: https://www.postgresql.org/docs/current/plpgsql-control-structures.html
2021-10-26 16:48:51 +03:00
# Flow control.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
icolor #cc0 "\<(CASE|WHEN|IF|THEN|ELSE|ELSE?IF|LOOP|CONTINUE|EXIT)\>"
icolor #cc0 "\<(FOR|FOREACH|IN|WHILE|END (CASE|IF|LOOP))\>"
icolor #a4a "\<(RAISE|EXCEPTION|NOTICE|RETURN)\>"
syntax: sql: colorize as flow control only keywords that clearly are such Drop things that were recolored afterward (like CLASS and DEFAULT). Also, move these coloring rules to after the other keywords so that things like "END IF" will stay colored as a whole. Reference: https://www.postgresql.org/docs/current/plpgsql-control-structures.html
2021-10-26 16:48:51 +03:00
syntax: sql: add a few more missing keywords, like TRUE and FALSE Also, don't first scare-color stuff between double quotes, as it seems some dialects put certain calculations between them too.
2021-12-07 14:23:29 +03:00
# Quoted identifiers.
syntax: sql: colorize only single-quoted things as strings SQL does not know double-quoted strings. Double quotes can be used around identifiers, to prevent them being interpreted as keywords. References: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-02 13:18:57 +03:00
color normal ""[[:alpha:]_][[:alnum:]_$]*""
# Strings.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
color #4c0 "'([^']|\\')*'"
syntax: sql: colorize only single-quoted things as strings SQL does not know double-quoted strings. Double quotes can be used around identifiers, to prevent them being interpreted as keywords. References: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-02 13:18:57 +03:00
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
# Trailing whitespace.
color ,green "[[:space:]]+$"
# Comments.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
color italic,#c44 "(--|//).*"
color italic,#c44 start="/\*" end="\*/"
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
# PostgreSQL default schemas.
syntax: sql: colorize strings differently than types Also, colorize comments more readably (on a dark background), and schemas less yelling, and languages more distinct from keywords. And add a few more keywords, like IS and NULL.
2021-12-04 14:05:58 +03:00
color grey "\<(pg_catalog|public)\>"
Adding one file: syntax highlighting for PostgreSQL. Original file by Devrim Gündüz. (Tweaked by Benno.) git-svn-id: svn://svn.savannah.gnu.org/nano/trunk/nano@5226 35c25a1d-7b9e-4130-9fde-d3aeb78583b8
2015-05-20 21:57:18 +03:00
# PostgreSQL PLs.
syntax: sql: colorize keywords regardless of case, and tweak the colors Make types a bluish green, for more contrast with strings, so that the latter can be made greener, for more contrast with the yellow keywords. Make the main keywords bluer and less bright, and unbold and soften the yellow ones. Soften the comments too. Reference for case-insensitivity: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
2021-12-07 12:08:43 +03:00
color #c08 "\<(SQL|pl(java|perlu?|pgsql|py|pythonu?|r|ruby|scheme|sh|tcl))\>"