upstream/kallithea Files · rhodecode/public/js/mode/sql/index.html

Added codemirror syntax mode in gists....

Added codemirror syntax mode in gists. - autopropose file extension when syntax mode is choosen

marcink - - Load All Authors

File last commit:

r4029:c9bcfe2d default


                r4030:647308db

default

Download file

             index.html
        
                    68 lines
            
             | 2.3 KiB
            
                | text/html
            
             |
                HtmlLexer
            
             / rhodecode / public / js / mode / sql / index.html
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
added codemirror edit mode with autodetection

              r4026
            
      <!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

        marcink
    
codecleaner

              r4029
            
              @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',

        marcink
    
added codemirror edit mode with autodetection

              r4026
            
              TRUE, FALSE, UNKNOWN

        marcink
    
codecleaner

              r4029
            
          FROM DUAL

          -- space needed after '--'

          # 1 line comment

          /* multiline

          comment! */

          LIMIT 1 OFFSET 0;

        marcink
    
added codemirror edit mode with autodetection

              r4026
            
      </textarea>

                  </form>

        marcink
    
codecleaner

              r4029
            
                  <p><strong>MIME types defined:</strong>

        marcink
    
added codemirror edit mode with autodetection

              r4026
            
                  <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>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

marcink added codemirror edit mode with autodetection	r4026	<!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
marcink codecleaner	r4029	@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',
marcink added codemirror edit mode with autodetection	r4026	TRUE, FALSE, UNKNOWN
marcink codecleaner	r4029	FROM DUAL
		-- space needed after '--'
		# 1 line comment
		/* multiline
		comment! */
		LIMIT 1 OFFSET 0;
marcink added codemirror edit mode with autodetection	r4026	</textarea>
		</form>
marcink codecleaner	r4029	<p><strong>MIME types defined:</strong>
marcink added codemirror edit mode with autodetection	r4026	<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>