Mercurial > kallithea
view rhodecode/public/js/mode/sql/index.html @ 4026:a60a0e9092c6
added codemirror edit mode with autodetection
author | Marcin Kuzminski <marcin@python-works.com> |
---|---|
date | Thu, 20 Jun 2013 23:53:18 +0200 |
parents | |
children | c9bcfe2d2ade |
line wrap: on
line source
<!doctype html> <html> <head> <meta charset="utf-8"> <title>SQL Mode for CodeMirror</title> <link rel="stylesheet" href="../../lib/codemirror.css" /> <script src="../../lib/codemirror.js"></script> <script src="sql.js"></script> <style> .CodeMirror { border-top: 1px solid black; border-bottom: 1px solid black; } </style> <link rel="stylesheet" href="../../doc/docs.css"> <script> var init = function() { var mime = 'text/x-mariadb'; // get mime type if (window.location.href.indexOf('mime=') > -1) { mime = window.location.href.substr(window.location.href.indexOf('mime=') + 5); } window.editor = CodeMirror.fromTextArea(document.getElementById('code'), { mode: mime, indentWithTabs: true, smartIndent: true, lineNumbers: true, matchBrackets : true, autofocus: true }); }; </script> </head> <body onload="init();"> <h1>SQL Mode for CodeMirror</h1> <form> <textarea id="code" name="code">-- SQL Mode for CodeMirror SELECT SQL_NO_CACHE DISTINCT @var1 AS `val1`, @'val2', @global.'sql_mode', 1.1 AS `float_val`, .14 AS `another_float`, 0.09e3 AS `int_with_esp`, 0xFA5 AS `hex`, x'fa5' AS `hex2`, 0b101 AS `bin`, b'101' AS `bin2`, DATE '1994-01-01' AS `sql_date`, { T "1994-01-01" } AS `odbc_date`, 'my string', _utf8'your string', N'her string', TRUE, FALSE, UNKNOWN FROM DUAL -- space needed after '--' # 1 line comment /* multiline comment! */ LIMIT 1 OFFSET 0; </textarea> </form> <p><strong>MIME types defined:</strong> <code><a href="?mime=text/x-sql">text/x-sql</a></code>, <code><a href="?mime=text/x-mysql">text/x-mysql</a></code>, <code><a href="?mime=text/x-mariadb">text/x-mariadb</a></code>, <code><a href="?mime=text/x-cassandra">text/x-cassandra</a></code>, <code><a href="?mime=text/x-plsql">text/x-plsql</a></code>. </p> <p> <strong>Tests:</strong> <a href="../../test/index.html#sql_*">normal</a>, <a href="../../test/index.html#verbose,sql_*">verbose</a>. </p> </body> </html>