File modules/editor/codemirror/mode/sql/index.html

Last commit: Sun Dec 17 01:14:09 2017 +0100	Jan Dankert	Integration eines weiteren Code-Editors: Codemirror. Demnächst müssen wir hier mal aufräumen und andere Editoren rauswerfen.


     1 <!doctype html>
     2 
     3 <title>CodeMirror: SQL Mode for CodeMirror</title>
     4 <meta charset="utf-8"/>
     5 <link rel=stylesheet href="../../doc/docs.css">
     6 
     7 <link rel="stylesheet" href="../../lib/codemirror.css" />
     8 <script src="../../lib/codemirror.js"></script>
     9 <script src="sql.js"></script>
    10 <link rel="stylesheet" href="../../addon/hint/show-hint.css" />
    11 <script src="../../addon/hint/show-hint.js"></script>
    12 <script src="../../addon/hint/sql-hint.js"></script>
    13 <style>
    14 .CodeMirror {
    15     border-top: 1px solid black;
    16     border-bottom: 1px solid black;
    17 }
    18         </style>
    19 <div id=nav>
    20   <a href="http://codemirror.net"><h1>CodeMirror</h1><img id=logo src="../../doc/logo.png"></a>
    21 
    22   <ul>
    23     <li><a href="../../index.html">Home</a>
    24     <li><a href="../../doc/manual.html">Manual</a>
    25     <li><a href="https://github.com/codemirror/codemirror">Code</a>
    26   </ul>
    27   <ul>
    28     <li><a href="../index.html">Language modes</a>
    29     <li><a class=active href="#">SQL Mode for CodeMirror</a>
    30   </ul>
    31 </div>
    32 
    33 <article>
    34 <h2>SQL Mode for CodeMirror</h2>
    35 <form>
    36             <textarea id="code" name="code">-- SQL Mode for CodeMirror
    37 SELECT SQL_NO_CACHE DISTINCT
    38 		@var1 AS `val1`, @'val2', @global.'sql_mode',
    39 		1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`,
    40 		0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`,
    41 		DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`,
    42 		'my string', _utf8'your string', N'her string',
    43         TRUE, FALSE, UNKNOWN
    44 	FROM DUAL
    45 	-- space needed after '--'
    46 	# 1 line comment
    47 	/* multiline
    48 	comment! */
    49 	LIMIT 1 OFFSET 0;
    50 </textarea>
    51             </form>
    52             <p><strong>MIME types defined:</strong>
    53             <code><a href="?mime=text/x-sql">text/x-sql</a></code>,
    54             <code><a href="?mime=text/x-mysql">text/x-mysql</a></code>,
    55             <code><a href="?mime=text/x-mariadb">text/x-mariadb</a></code>,
    56             <code><a href="?mime=text/x-cassandra">text/x-cassandra</a></code>,
    57             <code><a href="?mime=text/x-plsql">text/x-plsql</a></code>,
    58             <code><a href="?mime=text/x-mssql">text/x-mssql</a></code>,
    59             <code><a href="?mime=text/x-hive">text/x-hive</a></code>,
    60             <code><a href="?mime=text/x-pgsql">text/x-pgsql</a></code>,
    61             <code><a href="?mime=text/x-gql">text/x-gql</a></code>,
    62             <code><a href="?mime=text/x-gpsql">text/x-gpsql</a></code>.
    63             <code><a href="?mime=text/x-esper">text/x-esper</a></code>.
    64         </p>
    65 <script>
    66 window.onload = function() {
    67   var mime = 'text/x-mariadb';
    68   // get mime type
    69   if (window.location.href.indexOf('mime=') > -1) {
    70     mime = window.location.href.substr(window.location.href.indexOf('mime=') + 5);
    71   }
    72   window.editor = CodeMirror.fromTextArea(document.getElementById('code'), {
    73     mode: mime,
    74     indentWithTabs: true,
    75     smartIndent: true,
    76     lineNumbers: true,
    77     matchBrackets : true,
    78     autofocus: true,
    79     extraKeys: {"Ctrl-Space": "autocomplete"},
    80     hintOptions: {tables: {
    81       users: ["name", "score", "birthDate"],
    82       countries: ["name", "population", "size"]
    83     }}
    84   });
    85 };
    86 </script>
    87 
    88 </article>



Download modules/editor/codemirror/mode/sql/index.html


History
Sun, 17 Dec 2017 01:14:09 +0100	Jan Dankert	Integration eines weiteren Code-Editors: Codemirror. Demnächst müssen wir hier mal aufräumen und andere Editoren rauswerfen.