Spade
Mini Shell
| Directory:~$ /home/lmsyaran/public_html/j3/media/editors/codemirror/mode/sql/ |
| [Home] [System Details] [Kill Me] |
// CodeMirror, copyright (c) by Marijn Haverbeke and others
// Distributed under an MIT license: https://codemirror.net/LICENSE
(function(mod) {
if (typeof exports == "object" && typeof module ==
"object") // CommonJS
mod(require("../../lib/codemirror"));
else if (typeof define == "function" && define.amd) //
AMD
define(["../../lib/codemirror"], mod);
else // Plain browser env
mod(CodeMirror);
})(function(CodeMirror) {
"use strict";
CodeMirror.defineMode("sql", function(config, parserConfig) {
var client = parserConfig.client || {},
atoms = parserConfig.atoms || {"false": true,
"true": true, "null": true},
builtin = parserConfig.builtin || set(defaultBuiltin),
keywords = parserConfig.keywords || set(sqlKeywords),
operatorChars = parserConfig.operatorChars ||
/^[*+\-%<>!=&|~^\/]/,
support = parserConfig.support || {},
hooks = parserConfig.hooks || {},
dateSQL = parserConfig.dateSQL || {"date" : true,
"time" : true, "timestamp" : true},
backslashStringEscapes = parserConfig.backslashStringEscapes !==
false,
brackets = parserConfig.brackets || /^[\{}\(\)\[\]]/,
punctuation = parserConfig.punctuation || /^[;.,:]/
function tokenBase(stream, state) {
var ch = stream.next();
// call hooks from the mime type
if (hooks[ch]) {
var result = hooks[ch](stream, state);
if (result !== false) return result;
}
if (support.hexNumber &&
((ch == "0" && stream.match(/^[xX][0-9a-fA-F]+/))
|| (ch == "x" || ch == "X") &&
stream.match(/^'[0-9a-fA-F]+'/))) {
// hex
// ref:
http://dev.mysql.com/doc/refman/5.5/en/hexadecimal-literals.html
return "number";
} else if (support.binaryNumber &&
(((ch == "b" || ch == "B") &&
stream.match(/^'[01]+'/))
|| (ch == "0" && stream.match(/^b[01]+/)))) {
// bitstring
// ref:
http://dev.mysql.com/doc/refman/5.5/en/bit-field-literals.html
return "number";
} else if (ch.charCodeAt(0) > 47 && ch.charCodeAt(0) <
58) {
// numbers
// ref: http://dev.mysql.com/doc/refman/5.5/en/number-literals.html
stream.match(/^[0-9]*(\.[0-9]+)?([eE][-+]?[0-9]+)?/);
support.decimallessFloat && stream.match(/^\.(?!\.)/);
return "number";
} else if (ch == "?" && (stream.eatSpace() ||
stream.eol() || stream.eat(";"))) {
// placeholders
return "variable-3";
} else if (ch == "'" || (ch == '"'
&& support.doubleQuote)) {
// strings
// ref: http://dev.mysql.com/doc/refman/5.5/en/string-literals.html
state.tokenize = tokenLiteral(ch);
return state.tokenize(stream, state);
} else if ((((support.nCharCast && (ch == "n" || ch
== "N"))
|| (support.charsetCast && ch == "_" &&
stream.match(/[a-z][a-z0-9]*/i)))
&& (stream.peek() == "'" || stream.peek() ==
'"'))) {
// charset casting: _utf8'str', N'str',
n'str'
// ref: http://dev.mysql.com/doc/refman/5.5/en/string-literals.html
return "keyword";
} else if (support.escapeConstant && (ch == "e" || ch
== "E")
&& (stream.peek() == "'" || (stream.peek()
== '"' && support.doubleQuote))) {
// escape constant: E'str', e'str'
// ref:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS-ESCAPE
state.tokenize = function(stream, state) {
return (state.tokenize = tokenLiteral(stream.next(), true))(stream,
state);
}
return "keyword";
} else if (support.commentSlashSlash && ch == "/"
&& stream.eat("/")) {
// 1-line comment
stream.skipToEnd();
return "comment";
} else if ((support.commentHash && ch == "#")
|| (ch == "-" && stream.eat("-")
&& (!support.commentSpaceRequired || stream.eat(" ")))) {
// 1-line comments
// ref: https://kb.askmonty.org/en/comment-syntax/
stream.skipToEnd();
return "comment";
} else if (ch == "/" && stream.eat("*")) {
// multi-line comments
// ref: https://kb.askmonty.org/en/comment-syntax/
state.tokenize = tokenComment(1);
return state.tokenize(stream, state);
} else if (ch == ".") {
// .1 for 0.1
if (support.zerolessFloat &&
stream.match(/^(?:\d+(?:e[+-]?\d+)?)/i))
return "number";
if (stream.match(/^\.+/))
return null
// .table_name (ODBC)
// // ref:
http://dev.mysql.com/doc/refman/5.6/en/identifier-qualifiers.html
if (support.ODBCdotTable && stream.match(/^[\w\d_$#]+/))
return "variable-2";
} else if (operatorChars.test(ch)) {
// operators
stream.eatWhile(operatorChars);
return "operator";
} else if (brackets.test(ch)) {
// brackets
return "bracket";
} else if (punctuation.test(ch)) {
// punctuation
stream.eatWhile(punctuation);
return "punctuation";
} else if (ch == '{' &&
(stream.match(/^( )*(d|D|t|T|ts|TS)( )*'[^']*'(
)*}/) || stream.match(/^( )*(d|D|t|T|ts|TS)( )*"[^"]*"(
)*}/))) {
// dates (weird ODBC syntax)
// ref:
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-literals.html
return "number";
} else {
stream.eatWhile(/^[_\w\d]/);
var word = stream.current().toLowerCase();
// dates (standard SQL syntax)
// ref:
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-literals.html
if (dateSQL.hasOwnProperty(word) && (stream.match(/^(
)+'[^']*'/) || stream.match(/^( )+"[^"]*"/)))
return "number";
if (atoms.hasOwnProperty(word)) return "atom";
if (builtin.hasOwnProperty(word)) return "builtin";
if (keywords.hasOwnProperty(word)) return "keyword";
if (client.hasOwnProperty(word)) return "string-2";
return null;
}
}
// 'string', with char specified in quote escaped by
'\'
function tokenLiteral(quote, backslashEscapes) {
return function(stream, state) {
var escaped = false, ch;
while ((ch = stream.next()) != null) {
if (ch == quote && !escaped) {
state.tokenize = tokenBase;
break;
}
escaped = (backslashStringEscapes || backslashEscapes) &&
!escaped && ch == "\\";
}
return "string";
};
}
function tokenComment(depth) {
return function(stream, state) {
var m = stream.match(/^.*?(\/\*|\*\/)/)
if (!m) stream.skipToEnd()
else if (m[1] == "/*") state.tokenize = tokenComment(depth
+ 1)
else if (depth > 1) state.tokenize = tokenComment(depth - 1)
else state.tokenize = tokenBase
return "comment"
}
}
function pushContext(stream, state, type) {
state.context = {
prev: state.context,
indent: stream.indentation(),
col: stream.column(),
type: type
};
}
function popContext(state) {
state.indent = state.context.indent;
state.context = state.context.prev;
}
return {
startState: function() {
return {tokenize: tokenBase, context: null};
},
token: function(stream, state) {
if (stream.sol()) {
if (state.context && state.context.align == null)
state.context.align = false;
}
if (state.tokenize == tokenBase && stream.eatSpace()) return
null;
var style = state.tokenize(stream, state);
if (style == "comment") return style;
if (state.context && state.context.align == null)
state.context.align = true;
var tok = stream.current();
if (tok == "(")
pushContext(stream, state, ")");
else if (tok == "[")
pushContext(stream, state, "]");
else if (state.context && state.context.type == tok)
popContext(state);
return style;
},
indent: function(state, textAfter) {
var cx = state.context;
if (!cx) return CodeMirror.Pass;
var closing = textAfter.charAt(0) == cx.type;
if (cx.align) return cx.col + (closing ? 0 : 1);
else return cx.indent + (closing ? 0 : config.indentUnit);
},
blockCommentStart: "/*",
blockCommentEnd: "*/",
lineComment: support.commentSlashSlash ? "//" :
support.commentHash ? "#" : "--",
closeBrackets: "()[]{}''\"\"``"
};
});
// `identifier`
function hookIdentifier(stream) {
// MySQL/MariaDB identifiers
// ref:
http://dev.mysql.com/doc/refman/5.6/en/identifier-qualifiers.html
var ch;
while ((ch = stream.next()) != null) {
if (ch == "`" && !stream.eat("`")) return
"variable-2";
}
stream.backUp(stream.current().length - 1);
return stream.eatWhile(/\w/) ? "variable-2" : null;
}
// "identifier"
function hookIdentifierDoublequote(stream) {
// Standard SQL /SQLite identifiers
// ref:
http://web.archive.org/web/20160813185132/http://savage.net.au/SQL/sql-99.bnf.html#delimited%20identifier
// ref: http://sqlite.org/lang_keywords.html
var ch;
while ((ch = stream.next()) != null) {
if (ch == "\"" &&
!stream.eat("\"")) return "variable-2";
}
stream.backUp(stream.current().length - 1);
return stream.eatWhile(/\w/) ? "variable-2" : null;
}
// variable token
function hookVar(stream) {
// variables
// @@prefix.varName @varName
// varName can be quoted with ` or ' or "
// ref: http://dev.mysql.com/doc/refman/5.5/en/user-variables.html
if (stream.eat("@")) {
stream.match(/^session\./);
stream.match(/^local\./);
stream.match(/^global\./);
}
if (stream.eat("'")) {
stream.match(/^.*'/);
return "variable-2";
} else if (stream.eat('"')) {
stream.match(/^.*"/);
return "variable-2";
} else if (stream.eat("`")) {
stream.match(/^.*`/);
return "variable-2";
} else if (stream.match(/^[0-9a-zA-Z$\.\_]+/)) {
return "variable-2";
}
return null;
};
// short client keyword token
function hookClient(stream) {
// \N means NULL
// ref: http://dev.mysql.com/doc/refman/5.5/en/null-values.html
if (stream.eat("N")) {
return "atom";
}
// \g, etc
// ref: http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html
return stream.match(/^[a-zA-Z.#!?]/) ? "variable-2" : null;
}
// these keywords are used by all SQL dialects (however, a mode can still
overwrite it)
var sqlKeywords = "alter and as asc between by count create delete
desc distinct drop from group having in insert into is join like not on or
order select set table union update values where limit ";
// turn a space-separated list into an array
function set(str) {
var obj = {}, words = str.split(" ");
for (var i = 0; i < words.length; ++i) obj[words[i]] = true;
return obj;
}
var defaultBuiltin = "bool boolean bit blob enum long longblob
longtext medium mediumblob mediumint mediumtext time timestamp tinyblob
tinyint tinytext text bigint int int1 int2 int3 int4 int8 integer float
float4 float8 double char varbinary varchar varcharacter precision real
date datetime year unsigned signed decimal numeric"
// A generic SQL Mode. It's not a standard, it just try to support
what is generally supported
CodeMirror.defineMIME("text/x-sql", {
name: "sql",
keywords: set(sqlKeywords + "begin"),
builtin: set(defaultBuiltin),
atoms: set("false true null unknown"),
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable doubleQuote binaryNumber
hexNumber")
});
CodeMirror.defineMIME("text/x-mssql", {
name: "sql",
client: set("$partition binary_checksum checksum
connectionproperty context_info current_request_id error_line error_message
error_number error_procedure error_severity error_state formatmessage
get_filestream_transaction_context getansinull host_id host_name isnull
isnumeric min_active_rowversion newid newsequentialid rowcount_big
xact_state object_id"),
keywords: set(sqlKeywords + "begin trigger proc view index for add
constraint key primary foreign collate clustered nonclustered declare exec
go if use index holdlock nolock nowait paglock readcommitted
readcommittedlock readpast readuncommitted repeatableread rowlock
serializable snapshot tablock tablockx updlock with"),
builtin: set("bigint numeric bit smallint decimal smallmoney int
tinyint money float real char varchar text nchar nvarchar ntext binary
varbinary image cursor timestamp hierarchyid uniqueidentifier sql_variant
xml table "),
atoms: set("is not null like and or in left right between inner
outer join all any some cross unpivot pivot exists"),
operatorChars: /^[*+\-%<>!=^\&|\/]/,
brackets: /^[\{}\(\)]/,
punctuation: /^[;.,:/]/,
backslashStringEscapes: false,
dateSQL: set("date datetimeoffset datetime2 smalldatetime datetime
time"),
hooks: {
"@": hookVar
}
});
CodeMirror.defineMIME("text/x-mysql", {
name: "sql",
client: set("charset clear connect edit ego exit go help nopager
notee nowarning pager print prompt quit rehash source status system
tee"),
keywords: set(sqlKeywords + "accessible action add after algorithm
all analyze asensitive at authors auto_increment autocommit avg
avg_row_length before binary binlog both btree cache call cascade cascaded
case catalog_name chain change changed character check checkpoint checksum
class_origin client_statistics close coalesce code collate collation
collations column columns comment commit committed completion concurrent
condition connection consistent constraint contains continue contributors
convert cross current current_date current_time current_timestamp
current_user cursor data database databases day_hour day_microsecond
day_minute day_second deallocate dec declare default delay_key_write
delayed delimiter des_key_file describe deterministic dev_pop dev_samp
deviance diagnostics directory disable discard distinctrow div dual
dumpfile each elseif enable enclosed end ends engine engines enum errors
escape escaped even event events every execute exists exit explain extended
fast fetch field fields first flush for force foreign found_rows full
fulltext function general get global grant grants group group_concat
handler hash help high_priority hosts hour_microsecond hour_minute
hour_second if ignore ignore_server_ids import index index_statistics
infile inner innodb inout insensitive insert_method install interval
invoker isolation iterate key keys kill language last leading leave left
level limit linear lines list load local localtime localtimestamp lock logs
low_priority master master_heartbeat_period master_ssl_verify_server_cert
masters match max max_rows maxvalue message_text middleint migrate min
min_rows minute_microsecond minute_second mod mode modifies modify mutex
mysql_errno natural next no no_write_to_binlog offline offset one online
open optimize option optionally out outer outfile pack_keys parser
partition partitions password phase plugin plugins prepare preserve prev
primary privileges procedure processlist profile profiles purge query quick
range read read_write reads real rebuild recover references regexp relaylog
release remove rename reorganize repair repeatable replace require resignal
restrict resume return returns revoke right rlike rollback rollup row
row_format rtree savepoint schedule schema schema_name schemas
second_microsecond security sensitive separator serializable server session
share show signal slave slow smallint snapshot soname spatial specific sql
sql_big_result sql_buffer_result sql_cache sql_calc_found_rows sql_no_cache
sql_small_result sqlexception sqlstate sqlwarning ssl start starting starts
status std stddev stddev_pop stddev_samp storage straight_join
subclass_origin sum suspend table_name table_statistics tables tablespace
temporary terminated to trailing transaction trigger triggers truncate
uncommitted undo uninstall unique unlock upgrade usage use use_frm user
user_resources user_statistics using utc_date utc_time utc_timestamp value
variables varying view views warnings when while with work write xa xor
year_month zerofill begin do then else loop repeat"),
builtin: set("bool boolean bit blob decimal double float long
longblob longtext medium mediumblob mediumint mediumtext time timestamp
tinyblob tinyint tinytext text bigint int int1 int2 int3 int4 int8 integer
float float4 float8 double char varbinary varchar varcharacter precision
date datetime year unsigned signed numeric"),
atoms: set("false true null unknown"),
operatorChars: /^[*+\-%<>!=&|^]/,
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable decimallessFloat zerolessFloat
binaryNumber hexNumber doubleQuote nCharCast charsetCast commentHash
commentSpaceRequired"),
hooks: {
"@": hookVar,
"`": hookIdentifier,
"\\": hookClient
}
});
CodeMirror.defineMIME("text/x-mariadb", {
name: "sql",
client: set("charset clear connect edit ego exit go help nopager
notee nowarning pager print prompt quit rehash source status system
tee"),
keywords: set(sqlKeywords + "accessible action add after algorithm
all always analyze asensitive at authors auto_increment autocommit avg
avg_row_length before binary binlog both btree cache call cascade cascaded
case catalog_name chain change changed character check checkpoint checksum
class_origin client_statistics close coalesce code collate collation
collations column columns comment commit committed completion concurrent
condition connection consistent constraint contains continue contributors
convert cross current current_date current_time current_timestamp
current_user cursor data database databases day_hour day_microsecond
day_minute day_second deallocate dec declare default delay_key_write
delayed delimiter des_key_file describe deterministic dev_pop dev_samp
deviance diagnostics directory disable discard distinctrow div dual
dumpfile each elseif enable enclosed end ends engine engines enum errors
escape escaped even event events every execute exists exit explain extended
fast fetch field fields first flush for force foreign found_rows full
fulltext function general generated get global grant grants group
groupby_concat handler hard hash help high_priority hosts hour_microsecond
hour_minute hour_second if ignore ignore_server_ids import index
index_statistics infile inner innodb inout insensitive insert_method
install interval invoker isolation iterate key keys kill language last
leading leave left level limit linear lines list load local localtime
localtimestamp lock logs low_priority master master_heartbeat_period
master_ssl_verify_server_cert masters match max max_rows maxvalue
message_text middleint migrate min min_rows minute_microsecond
minute_second mod mode modifies modify mutex mysql_errno natural next no
no_write_to_binlog offline offset one online open optimize option
optionally out outer outfile pack_keys parser partition partitions password
persistent phase plugin plugins prepare preserve prev primary privileges
procedure processlist profile profiles purge query quick range read
read_write reads real rebuild recover references regexp relaylog release
remove rename reorganize repair repeatable replace require resignal
restrict resume return returns revoke right rlike rollback rollup row
row_format rtree savepoint schedule schema schema_name schemas
second_microsecond security sensitive separator serializable server session
share show shutdown signal slave slow smallint snapshot soft soname spatial
specific sql sql_big_result sql_buffer_result sql_cache sql_calc_found_rows
sql_no_cache sql_small_result sqlexception sqlstate sqlwarning ssl start
starting starts status std stddev stddev_pop stddev_samp storage
straight_join subclass_origin sum suspend table_name table_statistics
tables tablespace temporary terminated to trailing transaction trigger
triggers truncate uncommitted undo uninstall unique unlock upgrade usage
use use_frm user user_resources user_statistics using utc_date utc_time
utc_timestamp value variables varying view views virtual warnings when
while with work write xa xor year_month zerofill begin do then else loop
repeat"),
builtin: set("bool boolean bit blob decimal double float long
longblob longtext medium mediumblob mediumint mediumtext time timestamp
tinyblob tinyint tinytext text bigint int int1 int2 int3 int4 int8 integer
float float4 float8 double char varbinary varchar varcharacter precision
date datetime year unsigned signed numeric"),
atoms: set("false true null unknown"),
operatorChars: /^[*+\-%<>!=&|^]/,
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable decimallessFloat zerolessFloat
binaryNumber hexNumber doubleQuote nCharCast charsetCast commentHash
commentSpaceRequired"),
hooks: {
"@": hookVar,
"`": hookIdentifier,
"\\": hookClient
}
});
// provided by the phpLiteAdmin project - phpliteadmin.org
CodeMirror.defineMIME("text/x-sqlite", {
name: "sql",
// commands of the official SQLite client, ref:
https://www.sqlite.org/cli.html#dotcmd
client: set("auth backup bail binary changes check clone databases
dbinfo dump echo eqp exit explain fullschema headers help import imposter
indexes iotrace limit lint load log mode nullvalue once open output print
prompt quit read restore save scanstats schema separator session shell show
stats system tables testcase timeout timer trace vfsinfo vfslist vfsname
width"),
// ref: http://sqlite.org/lang_keywords.html
keywords: set(sqlKeywords + "abort action add after all analyze
attach autoincrement before begin cascade case cast check collate column
commit conflict constraint cross current_date current_time
current_timestamp database default deferrable deferred detach each else end
escape except exclusive exists explain fail for foreign full glob if ignore
immediate index indexed initially inner instead intersect isnull key left
limit match natural no notnull null of offset outer plan pragma primary
query raise recursive references regexp reindex release rename replace
restrict right rollback row savepoint temp temporary then to transaction
trigger unique using vacuum view virtual when with without"),
// SQLite is weakly typed, ref: http://sqlite.org/datatype3.html. This
is just a list of some common types.
builtin: set("bool boolean bit blob decimal double float long
longblob longtext medium mediumblob mediumint mediumtext time timestamp
tinyblob tinyint tinytext text clob bigint int int2 int8 integer float
double char varchar date datetime year unsigned signed numeric real"),
// ref: http://sqlite.org/syntax/literal-value.html
atoms: set("null current_date current_time
current_timestamp"),
// ref: http://sqlite.org/lang_expr.html#binaryops
operatorChars: /^[*+\-%<>!=&|/~]/,
// SQLite is weakly typed, ref: http://sqlite.org/datatype3.html. This
is just a list of some common types.
dateSQL: set("date time timestamp datetime"),
support: set("decimallessFloat zerolessFloat"),
identifierQuote: "\"", //ref:
http://sqlite.org/lang_keywords.html
hooks: {
// bind-parameters ref:http://sqlite.org/lang_expr.html#varparam
"@": hookVar,
":": hookVar,
"?": hookVar,
"$": hookVar,
// The preferred way to escape Identifiers is using double quotes,
ref: http://sqlite.org/lang_keywords.html
"\"": hookIdentifierDoublequote,
// there is also support for backtics, ref:
http://sqlite.org/lang_keywords.html
"`": hookIdentifier
}
});
// the query language used by Apache Cassandra is called CQL, but this
mime type
// is called Cassandra to avoid confusion with Contextual Query Language
CodeMirror.defineMIME("text/x-cassandra", {
name: "sql",
client: { },
keywords: set("add all allow alter and any apply as asc authorize
batch begin by clustering columnfamily compact consistency count create
custom delete desc distinct drop each_quorum exists filtering from grant if
in index insert into key keyspace keyspaces level limit local_one
local_quorum modify nan norecursive nosuperuser not of on one order
password permission permissions primary quorum rename revoke schema select
set storage superuser table three to token truncate ttl two type unlogged
update use user users using values where with writetime"),
builtin: set("ascii bigint blob boolean counter decimal double
float frozen inet int list map static text timestamp timeuuid tuple uuid
varchar varint"),
atoms: set("false true infinity NaN"),
operatorChars: /^[<>=]/,
dateSQL: { },
support: set("commentSlashSlash decimallessFloat"),
hooks: { }
});
// this is based on Peter Raganitsch's 'plsql' mode
CodeMirror.defineMIME("text/x-plsql", {
name: "sql",
client: set("appinfo arraysize autocommit autoprint
autorecovery autotrace blockterminator break btitle cmdsep colsep
compatibility compute concat copycommit copytypecheck define describe echo
editfile embedded escape exec execute feedback flagger flush heading
headsep instance linesize lno loboffset logsource long longchunksize markup
native newpage numformat numwidth pagesize pause pno recsep recsepchar
release repfooter repheader serveroutput shiftinout show showmode size
spool sqlblanklines sqlcase sqlcode sqlcontinue sqlnumber
sqlpluscompatibility sqlprefix sqlprompt sqlterminator suffix tab term
termout time timing trimout trimspool ttitle underline verify version
wrap"),
keywords: set("abort accept access add all alter and any array
arraylen as asc assert assign at attributes audit authorization avg
base_table begin between binary_integer body boolean by case cast char
char_base check close cluster clusters colauth column comment commit
compress connect connected constant constraint crash create current currval
cursor data_base database date dba deallocate debugoff debugon decimal
declare default definition delay delete desc digits dispose distinct do
drop else elseif elsif enable end entry escape exception exception_init
exchange exclusive exists exit external fast fetch file for force form from
function generic goto grant group having identified if immediate in
increment index indexes indicator initial initrans insert interface
intersect into is key level library like limited local lock log logging
long loop master maxextents maxtrans member minextents minus mislabel mode
modify multiset new next no noaudit nocompress nologging noparallel not
nowait number_base object of off offline on online only open option or
order out package parallel partition pctfree pctincrease pctused
pls_integer positive positiven pragma primary prior private privileges
procedure public raise range raw read rebuild record ref references refresh
release rename replace resource restrict return returning returns reverse
revoke rollback row rowid rowlabel rownum rows run savepoint schema segment
select separate session set share snapshot some space split sql start
statement storage subtype successful synonym tabauth table tables
tablespace task terminate then to trigger truncate type union unique
unlimited unrecoverable unusable update use using validate value values
variable view views when whenever where while with work"),
builtin: set("abs acos add_months ascii asin atan atan2 average
bfile bfilename bigserial bit blob ceil character chartorowid chr clob
concat convert cos cosh count dec decode deref dual dump dup_val_on_index
empty error exp false float floor found glb greatest hextoraw initcap instr
instrb int integer isopen last_day least length lengthb ln lower lpad ltrim
lub make_ref max min mlslabel mod months_between natural naturaln nchar
nclob new_time next_day nextval nls_charset_decl_len nls_charset_id
nls_charset_name nls_initcap nls_lower nls_sort nls_upper nlssort
no_data_found notfound null number numeric nvarchar2 nvl others power
rawtohex real reftohex round rowcount rowidtochar rowtype rpad rtrim serial
sign signtype sin sinh smallint soundex sqlcode sqlerrm sqrt stddev string
substr substrb sum sysdate tan tanh to_char text to_date to_label
to_multi_byte to_number to_single_byte translate true trunc uid unlogged
upper user userenv varchar varchar2 variance varying vsize xml"),
operatorChars: /^[*\/+\-%<>!=~]/,
dateSQL: set("date time timestamp"),
support: set("doubleQuote nCharCast zerolessFloat binaryNumber
hexNumber")
});
// Created to support specific hive keywords
CodeMirror.defineMIME("text/x-hive", {
name: "sql",
keywords: set("select alter $elem$ $key$ $value$ add after all
analyze and archive as asc before between binary both bucket buckets by
cascade case cast change cluster clustered clusterstatus collection column
columns comment compute concatenate continue create cross cursor data
database databases dbproperties deferred delete delimited desc describe
directory disable distinct distribute drop else enable end escaped
exclusive exists explain export extended external fetch fields fileformat
first format formatted from full function functions grant group having
hold_ddltime idxproperties if import in index indexes inpath inputdriver
inputformat insert intersect into is items join keys lateral left like
limit lines load local location lock locks mapjoin materialized minus msck
no_drop nocompress not of offline on option or order out outer outputdriver
outputformat overwrite partition partitioned partitions percent plus
preserve procedure purge range rcfile read readonly reads rebuild
recordreader recordwriter recover reduce regexp rename repair replace
restrict revoke right rlike row schema schemas semi sequencefile serde
serdeproperties set shared show show_database sort sorted ssl statistics
stored streamtable table tables tablesample tblproperties temporary
terminated textfile then tmp to touch transform trigger unarchive undo
union uniquejoin unlock update use using utc utc_tmestamp view when where
while with admin authorization char compact compactions conf cube current
current_date current_timestamp day decimal defined dependency directories
elem_type exchange file following for grouping hour ignore inner interval
jar less logical macro minute month more none noscan over owner partialscan
preceding pretty principals protection reload rewrite role roles rollup
rows second server sets skewed transactions truncate unbounded unset uri
user values window year"),
builtin: set("bool boolean long timestamp tinyint smallint bigint
int float double date datetime unsigned string array struct map uniontype
key_type utctimestamp value_type varchar"),
atoms: set("false true null unknown"),
operatorChars: /^[*+\-%<>!=]/,
dateSQL: set("date timestamp"),
support: set("ODBCdotTable doubleQuote binaryNumber
hexNumber")
});
CodeMirror.defineMIME("text/x-pgsql", {
name: "sql",
client: set("source"),
// For PostgreSQL -
https://www.postgresql.org/docs/11/sql-keywords-appendix.html
// For pl/pgsql lang -
https://github.com/postgres/postgres/blob/REL_11_2/src/pl/plpgsql/src/pl_scanner.c
keywords: set(sqlKeywords + "a abort abs absent absolute access
according action ada add admin after aggregate alias all allocate also
alter always analyse analyze and any are array array_agg
array_max_cardinality as asc asensitive assert assertion assignment
asymmetric at atomic attach attribute attributes authorization avg backward
base64 before begin begin_frame begin_partition bernoulli between bigint
binary bit bit_length blob blocked bom boolean both breadth by c cache call
called cardinality cascade cascaded case cast catalog catalog_name ceil
ceiling chain char char_length character character_length
character_set_catalog character_set_name character_set_schema
characteristics characters check checkpoint class class_origin clob close
cluster coalesce cobol collate collation collation_catalog collation_name
collation_schema collect column column_name columns command_function
command_function_code comment comments commit committed concurrently
condition condition_number configuration conflict connect connection
connection_name constant constraint constraint_catalog constraint_name
constraint_schema constraints constructor contains content continue control
conversion convert copy corr corresponding cost count covar_pop covar_samp
create cross csv cube cume_dist current current_catalog current_date
current_default_transform_group current_path current_role current_row
current_schema current_time current_timestamp
current_transform_group_for_type current_user cursor cursor_name cycle data
database datalink datatype date datetime_interval_code
datetime_interval_precision day db deallocate debug dec decimal declare
default defaults deferrable deferred defined definer degree delete
delimiter delimiters dense_rank depends depth deref derived desc describe
descriptor detach detail deterministic diagnostics dictionary disable
discard disconnect dispatch distinct dlnewcopy dlpreviouscopy dlurlcomplete
dlurlcompleteonly dlurlcompletewrite dlurlpath dlurlpathonly dlurlpathwrite
dlurlscheme dlurlserver dlvalue do document domain double drop dump dynamic
dynamic_function dynamic_function_code each element else elseif elsif empty
enable encoding encrypted end end_frame end_partition endexec enforced enum
equals errcode error escape event every except exception exclude excluding
exclusive exec execute exists exit exp explain expression extension
external extract false family fetch file filter final first first_value
flag float floor following for force foreach foreign fortran forward found
frame_row free freeze from fs full function functions fusion g general
generated get global go goto grant granted greatest group grouping groups
handler having header hex hierarchy hint hold hour id identity if ignore
ilike immediate immediately immutable implementation implicit import in
include including increment indent index indexes indicator info inherit
inherits initially inline inner inout input insensitive insert instance
instantiable instead int integer integrity intersect intersection interval
into invoker is isnull isolation join k key key_member key_type label lag
language large last last_value lateral lead leading leakproof least left
length level library like like_regex limit link listen ln load local
localtime localtimestamp location locator lock locked log logged loop lower
m map mapping match matched materialized max max_cardinality maxvalue
member merge message message_length message_octet_length message_text
method min minute minvalue mod mode modifies module month more move
multiset mumps name names namespace national natural nchar nclob nesting
new next nfc nfd nfkc nfkd nil no none normalize normalized not nothing
notice notify notnull nowait nth_value ntile null nullable nullif nulls
number numeric object occurrences_regex octet_length octets of off offset
oids old on only open operator option options or order ordering ordinality
others out outer output over overlaps overlay overriding owned owner p pad
parallel parameter parameter_mode parameter_name parameter_ordinal_position
parameter_specific_catalog parameter_specific_name
parameter_specific_schema parser partial partition pascal passing
passthrough password path percent percent_rank percentile_cont
percentile_disc perform period permission pg_context pg_datatype_name
pg_exception_context pg_exception_detail pg_exception_hint placing plans
pli policy portion position position_regex power precedes preceding
precision prepare prepared preserve primary print_strict_params prior
privileges procedural procedure procedures program public publication query
quote raise range rank read reads real reassign recheck recovery recursive
ref references referencing refresh regr_avgx regr_avgy regr_count
regr_intercept regr_r2 regr_slope regr_sxx regr_sxy regr_syy reindex
relative release rename repeatable replace replica requiring reset respect
restart restore restrict result result_oid return returned_cardinality
returned_length returned_octet_length returned_sqlstate returning returns
reverse revoke right role rollback rollup routine routine_catalog
routine_name routine_schema routines row row_count row_number rows rowtype
rule savepoint scale schema schema_name schemas scope scope_catalog
scope_name scope_schema scroll search second section security select
selective self sensitive sequence sequences serializable server server_name
session session_user set setof sets share show similar simple size skip
slice smallint snapshot some source space specific specific_name
specifictype sql sqlcode sqlerror sqlexception sqlstate sqlwarning sqrt
stable stacked standalone start state statement static statistics
stddev_pop stddev_samp stdin stdout storage strict strip structure style
subclass_origin submultiset subscription substring substring_regex succeeds
sum symmetric sysid system system_time system_user t table table_name
tables tablesample tablespace temp template temporary text then ties time
timestamp timezone_hour timezone_minute to token top_level_count trailing
transaction transaction_active transactions_committed
transactions_rolled_back transform transforms translate translate_regex
translation treat trigger trigger_catalog trigger_name trigger_schema trim
trim_array true truncate trusted type types uescape unbounded uncommitted
under unencrypted union unique unknown unlink unlisten unlogged unnamed
unnest until untyped update upper uri usage use_column use_variable user
user_defined_type_catalog user_defined_type_code user_defined_type_name
user_defined_type_schema using vacuum valid validate validator value
value_of values var_pop var_samp varbinary varchar variable_conflict
variadic varying verbose version versioning view views volatile warning
when whenever where while whitespace width_bucket window with within
without work wrapper write xml xmlagg xmlattributes xmlbinary xmlcast
xmlcomment xmlconcat xmldeclaration xmldocument xmlelement xmlexists
xmlforest xmliterate xmlnamespaces xmlparse xmlpi xmlquery xmlroot
xmlschema xmlserialize xmltable xmltext xmlvalidate year yes zone"),
// https://www.postgresql.org/docs/11/datatype.html
builtin: set("bigint int8 bigserial serial8 bit varying varbit
boolean bool box bytea character char varchar cidr circle date double
precision float8 inet integer int int4 interval json jsonb line lseg
macaddr macaddr8 money numeric decimal path pg_lsn point polygon real
float4 smallint int2 smallserial serial2 serial serial4 text time without
zone with timetz timestamp timestamptz tsquery tsvector txid_snapshot uuid
xml"),
atoms: set("false true null unknown"),
operatorChars: /^[*\/+\-%<>!=&|^\/#@?~]/,
backslashStringEscapes: false,
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable decimallessFloat zerolessFloat
binaryNumber hexNumber nCharCast charsetCast escapeConstant")
});
// Google's SQL-like query language, GQL
CodeMirror.defineMIME("text/x-gql", {
name: "sql",
keywords: set("ancestor and asc by contains desc descendant
distinct from group has in is limit offset on order select superset
where"),
atoms: set("false true"),
builtin: set("blob datetime first key __key__ string integer
double boolean null"),
operatorChars: /^[*+\-%<>!=]/
});
// Greenplum
CodeMirror.defineMIME("text/x-gpsql", {
name: "sql",
client: set("source"),
//https://github.com/greenplum-db/gpdb/blob/master/src/include/parser/kwlist.h
keywords: set("abort absolute access action active add admin after
aggregate all also alter always analyse analyze and any array as asc
assertion assignment asymmetric at authorization backward before begin
between bigint binary bit boolean both by cache called cascade cascaded
case cast chain char character characteristics check checkpoint class close
cluster coalesce codegen collate column comment commit committed
concurrency concurrently configuration connection constraint constraints
contains content continue conversion copy cost cpu_rate_limit create
createdb createexttable createrole createuser cross csv cube current
current_catalog current_date current_role current_schema current_time
current_timestamp current_user cursor cycle data database day deallocate
dec decimal declare decode default defaults deferrable deferred definer
delete delimiter delimiters deny desc dictionary disable discard distinct
distributed do document domain double drop dxl each else enable encoding
encrypted end enum errors escape every except exchange exclude excluding
exclusive execute exists explain extension external extract false family
fetch fields filespace fill filter first float following for force foreign
format forward freeze from full function global grant granted greatest
group group_id grouping handler hash having header hold host hour identity
if ignore ilike immediate immutable implicit in including inclusive
increment index indexes inherit inherits initially inline inner inout input
insensitive insert instead int integer intersect interval into invoker is
isnull isolation join key language large last leading least left level like
limit list listen load local localtime localtimestamp location lock log
login mapping master match maxvalue median merge minute minvalue missing
mode modifies modify month move name names national natural nchar new
newline next no nocreatedb nocreateexttable nocreaterole nocreateuser
noinherit nologin none noovercommit nosuperuser not nothing notify notnull
nowait null nullif nulls numeric object of off offset oids old on only
operator option options or order ordered others out outer over overcommit
overlaps overlay owned owner parser partial partition partitions passing
password percent percentile_cont percentile_disc placing plans position
preceding precision prepare prepared preserve primary prior privileges
procedural procedure protocol queue quote randomly range read readable
reads real reassign recheck recursive ref references reindex reject
relative release rename repeatable replace replica reset resource restart
restrict returning returns revoke right role rollback rollup rootpartition
row rows rule savepoint scatter schema scroll search second security
segment select sequence serializable session session_user set setof sets
share show similar simple smallint some split sql stable standalone start
statement statistics stdin stdout storage strict strip subpartition
subpartitions substring superuser symmetric sysid system table tablespace
temp template temporary text then threshold ties time timestamp to trailing
transaction treat trigger trim true truncate trusted type unbounded
uncommitted unencrypted union unique unknown unlisten until update user
using vacuum valid validation validator value values varchar variadic
varying verbose version view volatile web when where whitespace window with
within without work writable write xml xmlattributes xmlconcat xmlelement
xmlexists xmlforest xmlparse xmlpi xmlroot xmlserialize year yes
zone"),
builtin: set("bigint int8 bigserial serial8 bit varying varbit
boolean bool box bytea character char varchar cidr circle date double
precision float float8 inet integer int int4 interval json jsonb line lseg
macaddr macaddr8 money numeric decimal path pg_lsn point polygon real
float4 smallint int2 smallserial serial2 serial serial4 text time without
zone with timetz timestamp timestamptz tsquery tsvector txid_snapshot uuid
xml"),
atoms: set("false true null unknown"),
operatorChars: /^[*+\-%<>!=&|^\/#@?~]/,
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable decimallessFloat zerolessFloat
binaryNumber hexNumber nCharCast charsetCast")
});
// Spark SQL
CodeMirror.defineMIME("text/x-sparksql", {
name: "sql",
keywords: set("add after all alter analyze and anti archive array
as asc at between bucket buckets by cache cascade case cast change clear
cluster clustered codegen collection column columns comment commit compact
compactions compute concatenate cost create cross cube current current_date
current_timestamp database databases datata dbproperties defined delete
delimited deny desc describe dfs directories distinct distribute drop else
end escaped except exchange exists explain export extended external false
fields fileformat first following for format formatted from full function
functions global grant group grouping having if ignore import in index
indexes inner inpath inputformat insert intersect interval into is items
join keys last lateral lazy left like limit lines list load local location
lock locks logical macro map minus msck natural no not null nulls of on
optimize option options or order out outer outputformat over overwrite
partition partitioned partitions percent preceding principals purge range
recordreader recordwriter recover reduce refresh regexp rename repair
replace reset restrict revoke right rlike role roles rollback rollup row
rows schema schemas select semi separated serde serdeproperties set sets
show skewed sort sorted start statistics stored stratify struct table
tables tablesample tblproperties temp temporary terminated then to touch
transaction transactions transform true truncate unarchive unbounded
uncache union unlock unset use using values view when where window
with"),
builtin: set("tinyint smallint int bigint boolean float double
string binary timestamp decimal array map struct uniontype delimited serde
sequencefile textfile rcfile inputformat outputformat"),
atoms: set("false true null"),
operatorChars: /^[*\/+\-%<>!=~&|^]/,
dateSQL: set("date time timestamp"),
support: set("ODBCdotTable doubleQuote zerolessFloat")
});
// Esper
CodeMirror.defineMIME("text/x-esper", {
name: "sql",
client: set("source"),
//
http://www.espertech.com/esper/release-5.5.0/esper-reference/html/appendix_keywords.html
keywords: set("alter and as asc between by count create delete
desc distinct drop from group having in insert into is join like not on or
order select set table union update values where limit after all and as at
asc avedev avg between by case cast coalesce count create current_timestamp
day days delete define desc distinct else end escape events every exists
false first from full group having hour hours in inner insert instanceof
into irstream is istream join last lastweekday left limit like max
match_recognize matches median measures metadatasql min minute minutes msec
millisecond milliseconds not null offset on or order outer output partition
pattern prev prior regexp retain-union retain-intersection right rstream
sec second seconds select set some snapshot sql stddev sum then true
unidirectional until update variable weekday when where window"),
builtin: {},
atoms: set("false true null"),
operatorChars: /^[*+\-%<>!=&|^\/#@?~]/,
dateSQL: set("time"),
support: set("decimallessFloat zerolessFloat binaryNumber
hexNumber")
});
});
/*
How Properties of Mime Types are used by SQL Mode
=================================================
keywords:
A list of keywords you want to be highlighted.
builtin:
A list of builtin types you want to be highlighted (if you want types
to be of class "builtin" instead of "keyword").
operatorChars:
All characters that must be handled as operators.
client:
Commands parsed and executed by the client (not the server).
support:
A list of supported syntaxes which are not common, but are supported by
more than 1 DBMS.
* ODBCdotTable: .tableName
* zerolessFloat: .1
* doubleQuote
* nCharCast: N'string'
* charsetCast: _utf8'string'
* commentHash: use # char for comments
* commentSlashSlash: use // for comments
* commentSpaceRequired: require a space after -- for comments
atoms:
Keywords that must be highlighted as atoms,. Some DBMS's support
more atoms than others:
UNKNOWN, INFINITY, UNDERFLOW, NaN...
dateSQL:
Used for date/time SQL standard syntax, because not all DBMS's
support same temporal types.
*/