view release on metacpan or  search on metacpan

cp/codepress/languages/sql.js  view on Meta::CPAN

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
/*
 * CodePress regular expressions for SQL syntax highlighting
 * By Merlin Moncure
 */
  
// SQL
Language.syntax = [
        { input : /\'(.*?)(\')/g, output : '<s>\'$1$2</s>' }, // strings single quote
        { input : /\b(add|after|aggregate|alias|all|and|as|authorization|between|by|cascade|cache|cache|called|case|check|column|comment|constraint|createdb|createuser|cycle|database|default|deferrable|deferred|diagnostics|distinct|domain|each|else|elseif|e...
        { input : /\b(bigint|bigserial|bit|boolean|box|bytea|char|character|cidr|circle|date|decimal|double|float4|float8|inet|int2|int4|int8|integer|interval|line|lseg|macaddr|money|numeric|oid|path|point|polygon|precision|real|refcursor|serial|serial4|ser...
        { input : /\b(abort|alter|analyze|begin|checkpoint|close|cluster|comment|commit|copy|create|deallocate|declare|delete|drop|end|execute|explain|fetch|grant|insert|listen|load|lock|move|notify|prepare|reindex|reset|restart|revoke|rollback|select|set|s...
        { input : /([^:]|^)\-\-(.*?)(<br|<\/P)/g, output: '$1<i>--$2</i>$3' } // comments //  
]
 
Language.snippets = [
        { input : 'select', output : 'select $0 from  where ' }
]
 
Language.complete = [