Mercurial > kallithea

<!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>
author	Marcin Kuzminski <marcin@python-works.com>
date	Fri, 21 Jun 2013 01:11:16 +0200
parents	a60a0e9092c6
children