Mercurial
diff .cms/lib/codemirror/mode/sql/index.html @ 0:78edf6b517a0 draft
24.10
author | Coffee CMS <info@coffee-cms.ru> |
---|---|
date | Fri, 11 Oct 2024 22:40:23 +0000 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/.cms/lib/codemirror/mode/sql/index.html Fri Oct 11 22:40:23 2024 +0000 @@ -0,0 +1,92 @@ +<!doctype html> + +<title>CodeMirror: SQL Mode for CodeMirror</title> +<meta charset="utf-8"/> +<link rel=stylesheet href="../../doc/docs.css"> + +<link rel="stylesheet" href="../../lib/codemirror.css" /> +<script src="../../lib/codemirror.js"></script> +<script src="../../addon/edit/matchbrackets.js"></script> +<script src="sql.js"></script> +<link rel="stylesheet" href="../../addon/hint/show-hint.css" /> +<script src="../../addon/hint/show-hint.js"></script> +<script src="../../addon/hint/sql-hint.js"></script> +<style> +.CodeMirror { + border-top: 1px solid black; + border-bottom: 1px solid black; +} + </style> +<div id=nav> + <a href="https://codemirror.net/5"><h1>CodeMirror</h1><img id=logo src="../../doc/logo.png" alt=""></a> + + <ul> + <li><a href="../../index.html">Home</a> + <li><a href="../../doc/manual.html">Manual</a> + <li><a href="https://github.com/codemirror/codemirror5">Code</a> + </ul> + <ul> + <li><a href="../index.html">Language modes</a> + <li><a class=active href="#">SQL Mode for CodeMirror</a> + </ul> +</div> + +<article> +<h2>SQL Mode for CodeMirror</h2> +<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>, + <code><a href="?mime=text/x-mssql">text/x-mssql</a></code>, + <code><a href="?mime=text/x-hive">text/x-hive</a></code>, + <code><a href="?mime=text/x-pgsql">text/x-pgsql</a></code>, + <code><a href="?mime=text/x-gql">text/x-gql</a></code>, + <code><a href="?mime=text/x-gpsql">text/x-gpsql</a></code>. + <code><a href="?mime=text/x-esper">text/x-esper</a></code>. + <code><a href="?mime=text/x-sqlite">text/x-sqlite</a></code>. + <code><a href="?mime=text/x-sparksql">text/x-sparksql</a></code>. + <code><a href="?mime=text/x-trino">text/x-trino</a></code>. + </p> +<script> +window.onload = 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, + extraKeys: {"Ctrl-Space": "autocomplete"}, + hintOptions: {tables: { + users: ["name", "score", "birthDate"], + countries: ["name", "population", "size"] + }} + }); +}; +</script> + +</article>