aboutsummaryrefslogtreecommitdiffstats
path: root/Source
diff options
context:
space:
mode:
authorBibiko <bibiko@eva.mpg.de>2009-04-07 22:27:29 +0000
committerBibiko <bibiko@eva.mpg.de>2009-04-07 22:27:29 +0000
commitdaa8f9af6ab131b0e0e3b6cabda1e194841aa78a (patch)
tree5b68a12e8fb31d099210d6f384f4d433c8c19978 /Source
parentf541505474502acb111756c0ab6160d541ac5903 (diff)
downloadsequelpro-daa8f9af6ab131b0e0e3b6cabda1e194841aa78a.tar.gz
sequelpro-daa8f9af6ab131b0e0e3b6cabda1e194841aa78a.tar.bz2
sequelpro-daa8f9af6ab131b0e0e3b6cabda1e194841aa78a.zip
• optimized syntax highlighting a bit
• added syntax highlighting for numeric values • changed syntax highlighting for 'order' and 'group' to 'order by' resp. 'group by' (useful also for visual syntax checking while typing) • fixed the issue to highlight a keyword if that keyword is the name a variable (e.g. @set := 1)
Diffstat (limited to 'Source')
-rw-r--r--Source/CMTextView.m4
-rw-r--r--Source/SPEditorTokens.h3
-rw-r--r--Source/SPEditorTokens.l552
3 files changed, 311 insertions, 248 deletions
diff --git a/Source/CMTextView.m b/Source/CMTextView.m
index e8bb59ba..a1b6c9fe 100644
--- a/Source/CMTextView.m
+++ b/Source/CMTextView.m
@@ -924,6 +924,7 @@ SYNTAX HIGHLIGHTING!
NSColor *quoteColor = [NSColor colorWithDeviceRed:0.769 green:0.102 blue:0.086 alpha:1.000];
NSColor *keywordColor = [NSColor colorWithDeviceRed:0.200 green:0.250 blue:1.000 alpha:1.000];
NSColor *backtickColor = [NSColor colorWithDeviceRed:0.0 green:0.0 blue:0.658 alpha:1.000];
+ NSColor *numericColor = [NSColor colorWithDeviceRed:0.506 green:0.263 blue:0.0 alpha:1.000];
NSColor *tokenColor;
@@ -956,6 +957,9 @@ SYNTAX HIGHLIGHTING!
case SPT_RESERVED_WORD:
tokenColor = keywordColor;
break;
+ case SPT_NUMERIC:
+ tokenColor = numericColor;
+ break;
case SPT_COMMENT:
tokenColor = commentColor;
break;
diff --git a/Source/SPEditorTokens.h b/Source/SPEditorTokens.h
index 1d854e10..e4c8cc6b 100644
--- a/Source/SPEditorTokens.h
+++ b/Source/SPEditorTokens.h
@@ -14,4 +14,5 @@
#define SPT_COMMENT 5
#define SPT_WHITESPACE 6
#define SPT_WORD 7
-#define SPT_OTHER 8 \ No newline at end of file
+#define SPT_OTHER 8
+#define SPT_NUMERIC 9
diff --git a/Source/SPEditorTokens.l b/Source/SPEditorTokens.l
index 89730caf..f9ca6608 100644
--- a/Source/SPEditorTokens.l
+++ b/Source/SPEditorTokens.l
@@ -15,7 +15,7 @@
*/
#import "SPEditorTokens.h"
-int utf8strlen(const char *s);
+int utf8strlen(const char * _s);
int yyuoffset, yyuleng;
#define YY_NO_UNPUT
@@ -25,10 +25,244 @@ int yyuoffset, yyuleng;
%}
%option noyywrap
%option case-insensitive
+
s [ \t\n]+
-word [a-z_0-9À-゚]
-nonword [^a-z_0-9À-゚#\n\t]
+alpha [a-z_\.À-゚]
+numeric ([+-]?(([0-9]+\.[0-9]+)|([0-9]*\.[0-9]+)|([0-9]+))(e[+-]?[0-9]+)?)
+ops "+"|"-"|"*"|"/"
+word [a-z_\.0-9À-゚@]
+nonword [^a-z_0-9À-゚©#\n\t]
+keyword (R(IGHT|E(GEXP|STRICT|NAME|TURN|P(EAT|LACE)|VOKE|QUIRE|FERENCES|LEASE|A(D(S|_WRITE)?|L))|LIKE|ANGE)|GR(OUP{s}BY|ANT)|XOR|M(I(NUTE_(MICROSECOND|SECOND)|DDLEINT)|OD(IFIES)?|EDIUM(BLOB|TEXT|INT)|A(STER_SSL_VERIFY_SERVER_CERT|TCH))|B(Y|I(GINT|NARY)|OTH|E(TWEEN|FORE)|LOB)|S(MALLINT|SL|HOW|CHEMA(S)?|T(RAIGHT_JOIN|ARTING)|P(ECIFIC|ATIAL)|E(NSITIVE|COND_MICROSECOND|T|PARATOR|LECT)|QL(STATE|_(BIG_RESULT|SMALL_RESULT|CALC_FOUND_ROWS)|EXCEPTION|WARNING)?)|H(IGH_PRIORITY|OUR_(MI(NUTE|CROSECOND)|SECOND)|AVING)|YEAR_MONTH|N(O(_WRITE_TO_BINLOG|T)|U(MERIC|LL)|ATURAL)|C(R(OSS|EATE)|H(ECK|A(R(ACTER)?|NGE))|O(N(STRAINT|TINUE|DITION|VERT)|L(UMN|LATE))|UR(RENT_(TIME(STAMP)?|DATE|USER)|SOR)|A(S(CADE|E)|LL))|T(R(IGGER|UE|AILING)|HEN|INY(BLOB|TEXT|INT)|O|ERMINATED|ABLE)|I(GNORE|S|N(SE(RT|NSITIVE)|NER|T(1|2|8|3|O|4|E(RVAL|GER))?|OUT|DEX|FILE)?|TERATE|F)|ZEROFILL|O(R(DER{s}BY)?|N|UT(ER|FILE)?|PTI(MIZE|ON(ALLY)?))|D(ROP|I(STINCT(ROW)?|V)|OUBLE|UAL|E(SC(RIBE)?|C(IMAL|LARE)?|TERMINISTIC|FAULT|L(ETE|AYED))|A(Y_(MI(NUTE|CROSECOND)|SECOND|HOUR)|TABASE(S)?))|U(S(ING|E|AGE)|N(SIGNED|I(ON|QUE)|DO|LOCK)|TC_(TIME(STAMP)?|DATE)|PDATE)|JOIN|P(R(IMARY|OCEDURE|ECISION)|URGE)|E(X(I(STS|T)|PLAIN)|SCAPED|NCLOSED|LSE(IF)?|ACH)|VA(R(BINARY|YING|CHAR(ACTER)?)|LUES)|K(ILL|EY(S)?)|F(ROM|OR(CE|EIGN)?|ULLTEXT|ETCH|LOAT(8|4)?|ALSE)|W(RITE|H(ILE|E(RE|N))|ITH)|L(I(MIT|NE(S|AR)|KE)|O(NG(BLOB|TEXT)?|C(K|ALTIME(STAMP)?)|OP|W_PRIORITY|AD)|E(FT|A(DING|VE)))|A(S(C|ENSITIVE)?|N(D|ALYZE)|CCESSIBLE|DD|L(TER|L)))
+
+/* un-optimized keywords:
+ADD
+ACCESSIBLE
+ADD
+ALL
+ALTER
+ANALYZE
+AND
+AS
+ASC
+ASENSITIVE
+BEFORE
+BETWEEN
+BIGINT
+BINARY
+BLOB
+BOTH
+BY
+CALL
+CASCADE
+CASE
+CHANGE
+CHAR
+CHARACTER
+CHECK
+COLLATE
+COLUMN
+CONDITION
+CONSTRAINT
+CONTINUE
+CONVERT
+CREATE
+CROSS
+CURRENT_DATE
+CURRENT_TIME
+CURRENT_TIMESTAMP
+CURRENT_USER
+CURSOR
+DATABASE
+DATABASES
+DAY_HOUR
+DAY_MICROSECOND
+DAY_MINUTE
+DAY_SECOND
+DEC
+DECIMAL
+DECLARE
+DEFAULT
+DELAYED
+DELETE
+DESC
+DESCRIBE
+DETERMINISTIC
+DISTINCT
+DISTINCTROW
+DIV
+DOUBLE
+DROP
+DUAL
+EACH
+ELSE
+ELSEIF
+ENCLOSED
+ESCAPED
+EXISTS
+EXIT
+EXPLAIN
+FALSE
+FETCH
+FLOAT
+FLOAT4
+FLOAT8
+FOR
+FORCE
+FOREIGN
+FROM
+FULLTEXT
+GRANT
+GROUP{s}BY
+HAVING
+HIGH_PRIORITY
+HOUR_MICROSECOND
+HOUR_MINUTE
+HOUR_SECOND
+IF
+IGNORE
+IN
+INDEX
+INFILE
+INNER
+INOUT
+INSENSITIVE
+INSERT
+INT
+INT1
+INT2
+INT3
+INT4
+INT8
+INTEGER
+INTERVAL
+INTO
+IS
+ITERATE
+JOIN
+KEY
+KEYS
+KILL
+LEADING
+LEAVE
+LEFT
+LIKE
+LIMIT
+LINEAR
+LINES
+LOAD
+LOCALTIME
+LOCALTIMESTAMP
+LOCK
+LONG
+LONGBLOB
+LONGTEXT
+LOOP
+LOW_PRIORITY
+MASTER_SSL_VERIFY_SERVER_CERT
+MATCH
+MEDIUMBLOB
+MEDIUMINT
+MEDIUMTEXT
+MIDDLEINT
+MINUTE_MICROSECOND
+MINUTE_SECOND
+MOD
+MODIFIES
+NATURAL
+NOT
+NO_WRITE_TO_BINLOG
+NULL
+NUMERIC
+ON
+OPTIMIZE
+OPTION
+OPTIONALLY
+OR
+ORDER{s}BY
+OUT
+OUTER
+OUTFILE
+PRECISION
+PRIMARY
+PROCEDURE
+PURGE
+RANGE
+READ
+READS
+READ_WRITE
+REAL
+REFERENCES
+REGEXP
+RELEASE
+RENAME
+REPEAT
+REPLACE
+REQUIRE
+RESTRICT
+RETURN
+REVOKE
+RIGHT
+RLIKE
+SCHEMA
+SCHEMAS
+SECOND_MICROSECOND
+SELECT
+SENSITIVE
+SEPARATOR
+SET
+SHOW
+SMALLINT
+SPATIAL
+SPECIFIC
+SQL
+SQLEXCEPTION
+SQLSTATE
+SQLWARNING
+SQL_BIG_RESULT
+SQL_CALC_FOUND_ROWS
+SQL_SMALL_RESULT
+SSL
+STARTING
+STRAIGHT_JOIN
+TABLE
+TERMINATED
+THEN
+TINYBLOB
+TINYINT
+TINYTEXT
+TO
+TRAILING
+TRIGGER
+TRUE
+UNDO
+UNION
+UNIQUE
+UNLOCK
+UNSIGNED
+UPDATE
+USAGE
+USE
+USING
+UTC_DATE
+UTC_TIME
+UTC_TIMESTAMP
+VALUES
+VARBINARY
+VARCHAR
+VARCHARACTER
+VARYING
+WHEN
+WHERE
+WHILE
+WITH
+WRITE
+XOR
+YEAR_MONTH
+ZEROFILL
+*/
+
%x comment
+%x equation
%%
\"([^"\\]|\\(.|\n))*\"? { return SPT_DOUBLE_QUOTED_TEXT; } /* double quoted strings */
'([^'\\]|\\(.|\n))*'? { return SPT_SINGLE_QUOTED_TEXT; } /* single quoted strings */
@@ -43,236 +277,24 @@ nonword [^a-z_0-9À-゚#\n\t]
http://www.stillhq.com/pdfdb/000561/data.pdf
*/
-#[^\n]*\n? | /* # Comments */
---[ \t][^\n]*\n? { return SPT_COMMENT; } /* -- Comments */
+#[^\n]*\n? | /* # Comments */
+--[ \t][^\n]*\n? { return SPT_COMMENT; } /* -- Comments */
+
+{numeric}/{ops} { BEGIN(equation); return SPT_NUMERIC; } /* numeric before operator */
+<equation>{ops} { BEGIN(INITIAL); return SPT_OTHER; } /* set operator after a numeric */
+{numeric}/{alpha} { return SPT_WORD; } /* catch numeric followed by char */
+
+{s}+ { return SPT_WHITESPACE; } /* ignore spaces */
+
+{keyword} { return SPT_RESERVED_WORD; } /* all the mysql reserved words */
+
+{numeric} { return SPT_NUMERIC; } /* single numeric value */
+
+{word}+ { return SPT_WORD; } /* return any word */
+
+{nonword} { return SPT_OTHER; } /* return anything else */
+
-{s} { return SPT_WHITESPACE; } /* ignore spaces */
-ADD |
-ACCESSIBLE |
-ADD |
-ALL |
-ALTER |
-ANALYZE |
-AND |
-AS |
-ASC |
-ASENSITIVE |
-BEFORE |
-BETWEEN |
-BIGINT |
-BINARY |
-BLOB |
-BOTH |
-BY |
-CALL |
-CASCADE |
-CASE |
-CHANGE |
-CHAR |
-CHARACTER |
-CHECK |
-COLLATE |
-COLUMN |
-CONDITION |
-CONSTRAINT |
-CONTINUE |
-CONVERT |
-CREATE |
-CROSS |
-CURRENT_DATE |
-CURRENT_TIME |
-CURRENT_TIMESTAMP |
-CURRENT_USER |
-CURSOR |
-DATABASE |
-DATABASES |
-DAY_HOUR |
-DAY_MICROSECOND |
-DAY_MINUTE |
-DAY_SECOND |
-DEC |
-DECIMAL |
-DECLARE |
-DEFAULT |
-DELAYED |
-DELETE |
-DESC |
-DESCRIBE |
-DETERMINISTIC |
-DISTINCT |
-DISTINCTROW |
-DIV |
-DOUBLE |
-DROP |
-DUAL |
-EACH |
-ELSE |
-ELSEIF |
-ENCLOSED |
-ESCAPED |
-EXISTS |
-EXIT |
-EXPLAIN |
-FALSE |
-FETCH |
-FLOAT |
-FLOAT4 |
-FLOAT8 |
-FOR |
-FORCE |
-FOREIGN |
-FROM |
-FULLTEXT |
-GRANT |
-GROUP |
-HAVING |
-HIGH_PRIORITY |
-HOUR_MICROSECOND |
-HOUR_MINUTE |
-HOUR_SECOND |
-IF |
-IGNORE |
-IN |
-INDEX |
-INFILE |
-INNER |
-INOUT |
-INSENSITIVE |
-INSERT |
-INT |
-INT1 |
-INT2 |
-INT3 |
-INT4 |
-INT8 |
-INTEGER |
-INTERVAL |
-INTO |
-IS |
-ITERATE |
-JOIN |
-KEY |
-KEYS |
-KILL |
-LEADING |
-LEAVE |
-LEFT |
-LIKE |
-LIMIT |
-LINEAR |
-LINES |
-LOAD |
-LOCALTIME |
-LOCALTIMESTAMP |
-LOCK |
-LONG |
-LONGBLOB |
-LONGTEXT |
-LOOP |
-LOW_PRIORITY |
-MASTER_SSL_VERIFY_SERVER_CERT |
-MATCH |
-MEDIUMBLOB |
-MEDIUMINT |
-MEDIUMTEXT |
-MIDDLEINT |
-MINUTE_MICROSECOND |
-MINUTE_SECOND |
-MOD |
-MODIFIES |
-NATURAL |
-NOT |
-NO_WRITE_TO_BINLOG |
-NULL |
-NUMERIC |
-ON |
-OPTIMIZE |
-OPTION |
-OPTIONALLY |
-OR |
-ORDER |
-OUT |
-OUTER |
-OUTFILE |
-PRECISION |
-PRIMARY |
-PROCEDURE |
-PURGE |
-RANGE |
-READ |
-READS |
-READ_WRITE |
-REAL |
-REFERENCES |
-REGEXP |
-RELEASE |
-RENAME |
-REPEAT |
-REPLACE |
-REQUIRE |
-RESTRICT |
-RETURN |
-REVOKE |
-RIGHT |
-RLIKE |
-SCHEMA |
-SCHEMAS |
-SECOND_MICROSECOND |
-SELECT |
-SENSITIVE |
-SEPARATOR |
-SET |
-SHOW |
-SMALLINT |
-SPATIAL |
-SPECIFIC |
-SQL |
-SQLEXCEPTION |
-SQLSTATE |
-SQLWARNING |
-SQL_BIG_RESULT |
-SQL_CALC_FOUND_ROWS |
-SQL_SMALL_RESULT |
-SSL |
-STARTING |
-STRAIGHT_JOIN |
-TABLE |
-TERMINATED |
-THEN |
-TINYBLOB |
-TINYINT |
-TINYTEXT |
-TO |
-TRAILING |
-TRIGGER |
-TRUE |
-UNDO |
-UNION |
-UNIQUE |
-UNLOCK |
-UNSIGNED |
-UPDATE |
-USAGE |
-USE |
-USING |
-UTC_DATE |
-UTC_TIME |
-UTC_TIMESTAMP |
-VALUES |
-VARBINARY |
-VARCHAR |
-VARCHARACTER |
-VARYING |
-WHEN |
-WHERE |
-WHILE |
-WITH |
-WRITE |
-XOR |
-YEAR_MONTH |
-ZEROFILL { return SPT_RESERVED_WORD; } /* all the mysql reserved words */
-{word}+ { return SPT_WORD; } /* return any word */
-{nonword} { return SPT_OTHER; } /* return anything else */
<<EOF>> {
BEGIN(INITIAL); /* make sure we return to initial state when finished! */
@@ -281,20 +303,56 @@ ZEROFILL { return SPT_RESERVED_WORD; } /* all the mysql r
}
%%
-int utf8strlen(const char *s)
-/*
- This simple function calculates the string length of an UTF-8 string
- It's fast enough and easy to comprehend
-
- Adapted from Kragen Javier Sitaker's my_strlen_utf8_c function as
- found on http://canonical.org/~kragen/strlen-utf8.html
- */
+#define ONEMASK ((size_t)(-1) / 0xFF)
+// adapted from http://www.daemonology.net/blog/2008-06-05-faster-utf8-strlen.html
+int utf8strlen(const char * _s)
{
- int j=0;
- while (*s)
- {
- if ((*s & 0xC0) != 0x80) j++;
- s++;
+ const char * s;
+ size_t count = 0;
+ size_t u;
+ unsigned char b;
+
+ /* Handle any initial misaligned bytes. */
+ for (s = _s; (uintptr_t)(s) & (sizeof(size_t) - 1); s++) {
+ b = *s;
+
+ /* Exit if we hit a zero byte. */
+ if (b == '\0')
+ goto done;
+
+ /* Is this byte NOT the first byte of a character? */
+ count += (b >> 7) & ((~b) >> 6);
}
- return (j);
-} \ No newline at end of file
+
+ /* Handle complete blocks. */
+ for (; ; s += sizeof(size_t)) {
+ /* Prefetch 256 bytes ahead. */
+ __builtin_prefetch(&s[256], 0, 0);
+
+ /* Grab 4 or 8 bytes of UTF-8 data. */
+ u = *(size_t *)(s);
+
+ /* Exit the loop if there are any zero bytes. */
+ if ((u - ONEMASK) & (~u) & (ONEMASK * 0x80))
+ break;
+
+ /* Count bytes which are NOT the first byte of a character. */
+ u = ((u & (ONEMASK * 0x80)) >> 7) & ((~u) >> 6);
+ count += (u * ONEMASK) >> ((sizeof(size_t) - 1) * 8);
+ }
+
+ /* Take care of any left-over bytes. */
+ for (; ; s++) {
+ b = *s;
+
+ /* Exit if we hit a zero byte. */
+ if (b == '\0')
+ break;
+
+ /* Is this byte NOT the first byte of a character? */
+ count += (b >> 7) & ((~b) >> 6);
+ }
+
+done:
+ return ((s - _s) - count);
+}