aboutsummaryrefslogtreecommitdiffstats
path: root/Source/CMTextView.m
diff options
context:
space:
mode:
authorBibiko <bibiko@eva.mpg.de>2010-03-08 13:02:05 +0000
committerBibiko <bibiko@eva.mpg.de>2010-03-08 13:02:05 +0000
commit7f8b4675de74f7b43057d21d445f0ddca59f95b8 (patch)
tree69402383bf87177e40d58a0824f6721be226e96b /Source/CMTextView.m
parentc10728213ede7dbdd37493aca9657ab4010edbdc (diff)
downloadsequelpro-7f8b4675de74f7b43057d21d445f0ddca59f95b8.tar.gz
sequelpro-7f8b4675de74f7b43057d21d445f0ddca59f95b8.tar.bz2
sequelpro-7f8b4675de74f7b43057d21d445f0ddca59f95b8.zip
• outsourced keyword completion and function completion lists to CompletionTokens.plist
• SPQueryController manages keyword and function completion lists now; this reduces the memory usage a bit and the list is easier to edit • added pre-defined function argument snippets to CompletionTokens.plist (auto-generated from mysql's HELP) • added Preference option for Editor whether a function completion should insert () and if found the function argument snippets automatically or not - last ) will be linked as autopaired then • changed behaviour for wrapping a selection into `"'() etc. - now it re-selects the original selection after wrapping and in addition last wrap character is now marked as autopair-linked • improved logic for popping up the auto-completion list
Diffstat (limited to 'Source/CMTextView.m')
-rw-r--r--Source/CMTextView.m1062
1 files changed, 56 insertions, 1006 deletions
diff --git a/Source/CMTextView.m b/Source/CMTextView.m
index 30c4d7a5..0c6d2187 100644
--- a/Source/CMTextView.m
+++ b/Source/CMTextView.m
@@ -99,6 +99,7 @@ static inline NSPoint SPPointOnLine(NSPoint a, NSPoint b, CGFloat t) { return NS
@synthesize queryRange;
@synthesize shouldHiliteQuery;
@synthesize completionIsOpen;
+@synthesize completionWasReinvokedAutomatically;
/*
* Sort function (mainly used to sort the words in the textView)
@@ -141,6 +142,8 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
[self setAutopair:[prefs boolForKey:SPCustomQueryAutoPairCharacters]];
[self setAutohelp:[prefs boolForKey:SPCustomQueryUpdateAutoHelp]];
[self setAutouppercaseKeywords:[prefs boolForKey:SPCustomQueryAutoUppercaseKeywords]];
+ [self setCompletionWasReinvokedAutomatically:NO];
+
// Re-define tab stops for a better editing
[self setTabStops];
@@ -278,12 +281,17 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
if(!isDictMode) {
// Add predefined keywords
- for(id s in [self keywords])
+ NSArray *keywordList = [[NSArray arrayWithArray:[[SPQueryController sharedQueryController] keywordList]] retain];
+ for(id s in keywordList)
[possibleCompletions addObject:[NSDictionary dictionaryWithObjectsAndKeys:s, @"display", @"dummy-small", @"image", nil]];
// Add predefined functions
- for(id s in [self functions])
+ NSArray *functionList = [[NSArray arrayWithArray:[[SPQueryController sharedQueryController] functionList]] retain];
+ for(id s in functionList)
[possibleCompletions addObject:[NSDictionary dictionaryWithObjectsAndKeys:s, @"display", @"func-small", @"image", nil]];
+
+ [functionList release];
+ [keywordList release];
}
}
@@ -482,7 +490,9 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
if([[[self textStorage] attribute:kQuote atIndex:r.location-1 effectiveRange:nil] isEqualToString:kQuoteValue])
return;
if(![[NSCharacterSet whitespaceAndNewlineCharacterSet] characterIsMember:[[self string] characterAtIndex:r.location-1]])
- [self doCompletionByUsingSpellChecker:NO fuzzyMode:NO autoCompleteMode:YES];
+ // Suppress auto-completion if window isn't active anymore
+ if([[NSApp keyWindow] firstResponder] == self)
+ [self doCompletionByUsingSpellChecker:NO fuzzyMode:NO autoCompleteMode:YES];
}
}
@@ -520,7 +530,7 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
// Break for long stuff
if(completionRange.length>100000) return;
- NSString* allow; // additional chars which not close the popup
+ NSString* allow; // additional chars which won't close the suggestion list window
if(isDictMode)
allow= @"_";
else
@@ -848,18 +858,25 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
- (BOOL) wrapSelectionWithPrefix:(NSString *)prefix suffix:(NSString *)suffix
{
+ NSRange currentRange = [self selectedRange];
+
// Only proceed if a selection is active
- if ([self selectedRange].length == 0 || ![self isEditable])
+ if (currentRange.length == 0 || ![self isEditable])
return NO;
+ NSString *selString = [[self string] substringWithRange:currentRange];
+
// Replace the current selection with the selected string wrapped in prefix and suffix
- [self insertText:
- [NSString stringWithFormat:@"%@%@%@",
- prefix,
- [[self string] substringWithRange:[self selectedRange]],
- suffix
- ]
- ];
+ [self insertText:[NSString stringWithFormat:@"%@%@%@", prefix, selString, suffix]];
+
+ // Re-select original selection
+ NSRange innerSelectionRange = NSMakeRange(currentRange.location+1, [selString length]);
+ [self setSelectedRange:innerSelectionRange];
+
+ // If autopair is enabled mark last autopair character as autopair-linked
+ if([prefs boolForKey:SPCustomQueryAutoPairCharacters])
+ [[self textStorage] addAttribute:kAPlinked value:kAPval range:NSMakeRange(NSMaxRange(innerSelectionRange), 1)];
+
return YES;
}
@@ -1271,6 +1288,10 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
[self breakUndoCoalescing];
[self insertText:snip];
+ // If autopair is enabled check whether snip begins with ( and ends with ), if so mark ) as pair-linked
+ if([prefs boolForKey:SPCustomQueryAutoPairCharacters] && ([snip hasPrefix:@"("] && [snip hasSuffix:@")"] || ([snip hasPrefix:@"`"] && [snip hasSuffix:@"`"]) || ([snip hasPrefix:@"'"] && [snip hasSuffix:@"'"]) || ([snip hasPrefix:@"\""] && [snip hasSuffix:@"\""])))
+ [[self textStorage] addAttribute:kAPlinked value:kAPval range:NSMakeRange([self selectedRange].location - 1, 1)];
+
// Any snippets defined?
if(snippetControlCounter > -1) {
// Find and select first defined snippet
@@ -1475,6 +1496,12 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
selector:@selector(autoHelp)
object:nil];
+ // Cancel auto-completion timer
+ if([prefs boolForKey:SPCustomQueryAutoComplete])
+ [NSObject cancelPreviousPerformRequestsWithTarget:self
+ selector:@selector(doAutoCompletion)
+ object:nil];
+
[super mouseDown:theEvent];
// Start autoHelp timer
@@ -1497,6 +1524,13 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
afterDelay:[[prefs valueForKey:SPCustomQueryAutoHelpDelay] doubleValue]];
}
+ // Cancel auto-completion timer
+ if([prefs boolForKey:SPCustomQueryAutoComplete])
+ [NSObject cancelPreviousPerformRequestsWithTarget:self
+ selector:@selector(doAutoCompletion)
+ object:nil];
+
+
long allFlags = (NSShiftKeyMask|NSControlKeyMask|NSAlternateKeyMask|NSCommandKeyMask);
// Check if user pressed ⌥ to allow composing of accented characters.
@@ -1516,6 +1550,8 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
if ([theEvent keyCode] == 53 && [self isEditable]){ // ESC key for internal completion
+ [self setCompletionWasReinvokedAutomatically:NO];
+
// Cancel autocompletion trigger
if([prefs boolForKey:SPCustomQueryAutoComplete])
[NSObject cancelPreviousPerformRequestsWithTarget:self
@@ -1529,6 +1565,7 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
return;
}
if (insertedCharacter == NSF5FunctionKey && [self isEditable]){ // F5 for completion based on spell checker
+ [self setCompletionWasReinvokedAutomatically:NO];
[self doCompletionByUsingSpellChecker:YES fuzzyMode:NO autoCompleteMode:NO];
return;
}
@@ -1827,993 +1864,6 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
}
/*
- * List of keywords for autocompletion. If you add a keyword here,
- * it should also be added to the flex file SPEditorTokens.l
- */
--(NSArray *)keywords
-{
- return [NSArray arrayWithObjects:
- @"ACCESSIBLE",
- @"ACTION",
- @"ADD",
- @"AFTER",
- @"AGAINST",
- @"AGGREGATE",
- @"ALGORITHM",
- @"ALL",
- @"ALTER",
- @"ALTER COLUMN",
- @"ALTER DATABASE",
- @"ALTER EVENT",
- @"ALTER FUNCTION",
- @"ALTER LOGFILE GROUP",
- @"ALTER PROCEDURE",
- @"ALTER SCHEMA",
- @"ALTER SERVER",
- @"ALTER TABLE",
- @"ALTER TABLESPACE",
- @"ALTER VIEW",
- @"ANALYZE",
- @"ANALYZE TABLE",
- @"AND",
- @"ANY",
- @"AS",
- @"ASC",
- @"ASCII",
- @"ASENSITIVE",
- @"AT",
- @"AUTHORS",
- @"AUTOEXTEND_SIZE",
- @"AUTO_INCREMENT",
- @"AVG",
- @"AVG_ROW_LENGTH",
- @"BACKUP",
- @"BACKUP TABLE",
- @"BEFORE",
- @"BEGIN",
- @"BETWEEN",
- @"BIGINT",
- @"BINARY",
- @"BINLOG",
- @"BIT",
- @"BLOB",
- @"BOOL",
- @"BOOLEAN",
- @"BOTH",
- @"BTREE",
- @"BY",
- @"BYTE",
- @"CACHE",
- @"CACHE INDEX",
- @"CALL",
- @"CASCADE",
- @"CASCADED",
- @"CASE",
- @"CHAIN",
- @"CHANGE",
- @"CHANGED",
- @"CHAR",
- @"CHARACTER",
- @"CHARACTER SET",
- @"CHARSET",
- @"CHECK",
- @"CHECK TABLE",
- @"CHECKSUM",
- @"CHECKSUM TABLE",
- @"CIPHER",
- @"CLIENT",
- @"CLOSE",
- @"COALESCE",
- @"CODE",
- @"COLLATE",
- @"COLLATION",
- @"COLUMN",
- @"COLUMNS",
- @"COLUMN_FORMAT"
- @"COMMENT",
- @"COMMIT",
- @"COMMITTED",
- @"COMPACT",
- @"COMPLETION",
- @"COMPRESSED",
- @"CONCURRENT",
- @"CONDITION",
- @"CONNECTION",
- @"CONSISTENT",
- @"CONSTRAINT",
- @"CONTAINS",
- @"CONTINUE",
- @"CONTRIBUTORS",
- @"CONVERT",
- @"CREATE",
- @"CREATE DATABASE",
- @"CREATE EVENT",
- @"CREATE FUNCTION",
- @"CREATE INDEX",
- @"CREATE LOGFILE GROUP",
- @"CREATE PROCEDURE",
- @"CREATE SCHEMA",
- @"CREATE TABLE",
- @"CREATE TABLESPACE",
- @"CREATE TRIGGER",
- @"CREATE USER",
- @"CREATE VIEW",
- @"CROSS",
- @"CUBE",
- @"CURRENT_DATE",
- @"CURRENT_TIME",
- @"CURRENT_TIMESTAMP",
- @"CURRENT_USER",
- @"CURSOR",
- @"DATA",
- @"DATABASE",
- @"DATABASES",
- @"DATAFILE",
- @"DATE",
- @"DATETIME",
- @"DAY",
- @"DAY_HOUR",
- @"DAY_MICROSECOND",
- @"DAY_MINUTE",
- @"DAY_SECOND",
- @"DEALLOCATE",
- @"DEALLOCATE PREPARE",
- @"DEC",
- @"DECIMAL",
- @"DECLARE",
- @"DEFAULT",
- @"DEFINER",
- @"DELAYED",
- @"DELAY_KEY_WRITE",
- @"DELETE",
- @"DELIMITER ",
- @"DELIMITER ;\n",
- @"DELIMITER ;;\n",
- @"DESC",
- @"DESCRIBE",
- @"DES_KEY_FILE",
- @"DETERMINISTIC",
- @"DIRECTORY",
- @"DISABLE",
- @"DISCARD",
- @"DISK",
- @"DISTINCT",
- @"DISTINCTROW",
- @"DIV",
- @"DO",
- @"DOUBLE",
- @"DROP",
- @"DROP DATABASE",
- @"DROP EVENT",
- @"DROP FOREIGN KEY",
- @"DROP FUNCTION",
- @"DROP INDEX",
- @"DROP LOGFILE GROUP",
- @"DROP PREPARE",
- @"DROP PRIMARY KEY",
- @"DROP PREPARE",
- @"DROP PROCEDURE",
- @"DROP SCHEMA",
- @"DROP SERVER",
- @"DROP TABLE",
- @"DROP TABLESPACE",
- @"DROP TRIGGER",
- @"DROP USER",
- @"DROP VIEW",
- @"DUAL",
- @"DUMPFILE",
- @"DUPLICATE",
- @"DYNAMIC",
- @"EACH",
- @"ELSE",
- @"ELSEIF",
- @"ENABLE",
- @"ENCLOSED",
- @"END",
- @"ENDS",
- @"ENGINE",
- @"ENGINES",
- @"ENUM",
- @"ERRORS",
- @"ESCAPE",
- @"ESCAPED",
- @"EVENT",
- @"EVENTS",
- @"EVERY",
- @"EXECUTE",
- @"EXISTS",
- @"EXIT",
- @"EXPANSION",
- @"EXPLAIN",
- @"EXTENDED",
- @"EXTENT_SIZE",
- @"FALSE",
- @"FAST",
- @"FETCH",
- @"FIELDS",
- @"FIELDS TERMINATED BY",
- @"FILE",
- @"FIRST",
- @"FIXED",
- @"FLOAT",
- @"FLOAT4",
- @"FLOAT8",
- @"FLUSH",
- @"FOR",
- @"FOR UPDATE",
- @"FORCE",
- @"FOREIGN",
- @"FOREIGN KEY",
- @"FOUND",
- @"FRAC_SECOND",
- @"FROM",
- @"FULL",
- @"FULLTEXT",
- @"FUNCTION",
- @"GEOMETRY",
- @"GEOMETRYCOLLECTION",
- @"GET_FORMAT",
- @"GLOBAL",
- @"GRANT",
- @"GRANTS",
- @"GROUP",
- @"GROUP BY",
- @"HANDLER",
- @"HASH",
- @"HAVING",
- @"HELP",
- @"HIGH_PRIORITY",
- @"HOSTS",
- @"HOUR",
- @"HOUR_MICROSECOND",
- @"HOUR_MINUTE",
- @"HOUR_SECOND",
- @"IDENTIFIED",
- @"IF",
- @"IGNORE",
- @"IMPORT",
- @"IN",
- @"INDEX",
- @"INDEXES",
- @"INFILE",
- @"INITIAL_SIZE",
- @"INNER",
- @"INNOBASE",
- @"INNODB",
- @"INOUT",
- @"INSENSITIVE",
- @"INSERT",
- @"INSERT_METHOD",
- @"INSTALL",
- @"INSTALL PLUGIN",
- @"INT",
- @"INT1",
- @"INT2",
- @"INT3",
- @"INT4",
- @"INT8",
- @"INTEGER",
- @"INTERVAL",
- @"INTO",
- @"INTO DUMPFILE",
- @"INTO OUTFILE",
- @"INTO TABLE",
- @"INVOKER",
- @"IO_THREAD",
- @"IS",
- @"ISOLATION",
- @"ISSUER",
- @"ITERATE",
- @"JOIN",
- @"KEY",
- @"KEYS",
- @"KEY_BLOCK_SIZE",
- @"KILL",
- @"LANGUAGE",
- @"LAST",
- @"LEADING",
- @"LEAVE",
- @"LEAVES",
- @"LEFT",
- @"LESS",
- @"LEVEL",
- @"LIKE",
- @"LIMIT",
- @"LINEAR",
- @"LINES",
- @"LINES TERMINATED BY",
- @"LINESTRING",
- @"LIST",
- @"LOAD DATA",
- @"LOAD INDEX INTO CACHE",
- @"LOAD XML",
- @"LOCAL",
- @"LOCALTIME",
- @"LOCALTIMESTAMP",
- @"LOCK",
- @"LOCK IN SHARE MODE",
- @"LOCK TABLES",
- @"LOCKS",
- @"LOGFILE",
- @"LOGS",
- @"LONG",
- @"LONGBLOB",
- @"LONGTEXT",
- @"LOOP",
- @"LOW_PRIORITY",
- @"MASTER",
- @"MASTER_CONNECT_RETRY",
- @"MASTER_HOST",
- @"MASTER_LOG_FILE",
- @"MASTER_LOG_POS",
- @"MASTER_PASSWORD",
- @"MASTER_PORT",
- @"MASTER_SERVER_ID",
- @"MASTER_SSL",
- @"MASTER_SSL_CA",
- @"MASTER_SSL_CAPATH",
- @"MASTER_SSL_CERT",
- @"MASTER_SSL_CIPHER",
- @"MASTER_SSL_KEY",
- @"MASTER_USER",
- @"MATCH",
- @"MAXVALUE",
- @"MAX_CONNECTIONS_PER_HOUR",
- @"MAX_QUERIES_PER_HOUR",
- @"MAX_ROWS",
- @"MAX_SIZE",
- @"MAX_UPDATES_PER_HOUR",
- @"MAX_USER_CONNECTIONS",
- @"MEDIUM",
- @"MEDIUMBLOB",
- @"MEDIUMINT",
- @"MEDIUMTEXT",
- @"MEMORY",
- @"MERGE",
- @"MICROSECOND",
- @"MIDDLEINT",
- @"MIGRATE",
- @"MINUTE",
- @"MINUTE_MICROSECOND",
- @"MINUTE_SECOND",
- @"MIN_ROWS",
- @"MOD",
- @"MODE",
- @"MODIFIES",
- @"MODIFY",
- @"MONTH",
- @"MULTILINESTRING",
- @"MULTIPOINT",
- @"MULTIPOLYGON",
- @"MUTEX",
- @"NAME",
- @"NAMES",
- @"NATIONAL",
- @"NATURAL",
- @"NCHAR",
- @"NDB",
- @"NDBCLUSTER",
- @"NEW",
- @"NEXT",
- @"NO",
- @"NODEGROUP",
- @"NONE",
- @"NOT",
- @"NO_WAIT",
- @"NO_WRITE_TO_BINLOG",
- @"NULL",
- @"NUMERIC",
- @"NVARCHAR",
- @"OFFSET",
- @"OLD_PASSWORD",
- @"ON",
- @"ONE",
- @"ONE_SHOT",
- @"OPEN",
- @"OPTIMIZE",
- @"OPTIMIZE TABLE",
- @"OPTION",
- @"OPTIONALLY",
- @"OPTIONALLY ENCLOSED BY",
- @"OPTIONS",
- @"OR",
- @"ORDER",
- @"ORDER BY",
- @"OUT",
- @"OUTER",
- @"OUTFILE",
- @"PACK_KEYS",
- @"PARSER",
- @"PARTIAL",
- @"PARTITION",
- @"PARTITIONING",
- @"PARTITIONS",
- @"PASSWORD",
- @"PHASE",
- @"PLUGIN",
- @"PLUGINS",
- @"POINT",
- @"POLYGON",
- @"PRECISION",
- @"PREPARE",
- @"PRESERVE",
- @"PREV",
- @"PRIMARY",
- @"PRIMARY KEY",
- @"PRIVILEGES",
- @"PROCEDURE",
- @"PROCEDURE ANALYSE",
- @"PROCESS",
- @"PROCESSLIST",
- @"PURGE",
- @"QUARTER",
- @"QUERY",
- @"QUICK",
- @"RANGE",
- @"READ",
- @"READS",
- @"READ_ONLY",
- @"READ_WRITE",
- @"REAL",
- @"REBUILD",
- @"RECOVER",
- @"REDOFILE",
- @"REDO_BUFFER_SIZE",
- @"REDUNDANT",
- @"REFERENCES",
- @"REGEXP",
- @"RELAY_LOG_FILE",
- @"RELAY_LOG_POS",
- @"RELAY_THREAD",
- @"RELEASE",
- @"RELOAD",
- @"REMOVE",
- @"RENAME",
- @"RENAME DATABASE",
- @"RENAME TABLE",
- @"REORGANIZE",
- @"REPAIR",
- @"REPAIR TABLE",
- @"REPEAT",
- @"REPEATABLE",
- @"REPLACE",
- @"REPLICATION",
- @"REQUIRE",
- @"RESET",
- @"RESET MASTER",
- @"RESTORE",
- @"RESTORE TABLE",
- @"RESTRICT",
- @"RESUME",
- @"RETURN",
- @"RETURNS",
- @"REVOKE",
- @"RIGHT",
- @"RLIKE",
- @"ROLLBACK",
- @"ROLLUP",
- @"ROUTINE",
- @"ROW",
- @"ROWS",
- @"ROWS IDENTIFIED BY"
- @"ROW_FORMAT",
- @"RTREE",
- @"SAVEPOINT",
- @"SCHEDULE",
- @"SCHEDULER",
- @"SCHEMA",
- @"SCHEMAS",
- @"SECOND",
- @"SECOND_MICROSECOND",
- @"SECURITY",
- @"SELECT",
- @"SELECT DISTINCT",
- @"SENSITIVE",
- @"SEPARATOR",
- @"SERIAL",
- @"SERIALIZABLE",
- @"SESSION",
- @"SET",
- @"SET GLOBAL",
- @"SET NAMES",
- @"SET PASSWORD",
- @"SHARE",
- @"SHOW",
- @"SHOW BINARY LOGS",
- @"SHOW BINLOG EVENTS",
- @"SHOW CHARACTER SET",
- @"SHOW COLLATION",
- @"SHOW COLUMNS",
- @"SHOW CONTRIBUTORS",
- @"SHOW CREATE DATABASE",
- @"SHOW CREATE EVENT",
- @"SHOW CREATE FUNCTION",
- @"SHOW CREATE PROCEDURE",
- @"SHOW CREATE SCHEMA",
- @"SHOW CREATE TABLE",
- @"SHOW CREATE TRIGGERS",
- @"SHOW CREATE VIEW",
- @"SHOW DATABASES",
- @"SHOW ENGINE",
- @"SHOW ENGINES",
- @"SHOW ERRORS",
- @"SHOW EVENTS",
- @"SHOW FIELDS",
- @"SHOW FULL PROCESSLIST",
- @"SHOW FUNCTION CODE",
- @"SHOW FUNCTION STATUS",
- @"SHOW GRANTS",
- @"SHOW INDEX",
- @"SHOW INNODB STATUS",
- @"SHOW KEYS",
- @"SHOW MASTER LOGS",
- @"SHOW MASTER STATUS",
- @"SHOW OPEN TABLES",
- @"SHOW PLUGINS",
- @"SHOW PRIVILEGES",
- @"SHOW PROCEDURE CODE",
- @"SHOW PROCEDURE STATUS",
- @"SHOW PROFILE",
- @"SHOW PROFILES",
- @"SHOW PROCESSLIST",
- @"SHOW SCHEDULER STATUS",
- @"SHOW SCHEMAS",
- @"SHOW SLAVE HOSTS",
- @"SHOW SLAVE STATUS",
- @"SHOW STATUS",
- @"SHOW STORAGE ENGINES",
- @"SHOW TABLE STATUS",
- @"SHOW TABLE TYPES",
- @"SHOW TABLES",
- @"SHOW TRIGGERS",
- @"SHOW VARIABLES",
- @"SHOW WARNINGS",
- @"SHUTDOWN",
- @"SIGNED",
- @"SIMPLE",
- @"SLAVE",
- @"SMALLINT",
- @"SNAPSHOT",
- @"SOME",
- @"SONAME",
- @"SOUNDS",
- @"SPATIAL",
- @"SPECIFIC",
- @"SQL_AUTO_IS_NULL",
- @"SQL_BIG_RESULT",
- @"SQL_BIG_SELECTS",
- @"SQL_BIG_TABLES",
- @"SQL_BUFFER_RESULT",
- @"SQL_CACHE",
- @"SQL_CALC_FOUND_ROWS",
- @"SQL_LOG_BIN",
- @"SQL_LOG_OFF",
- @"SQL_LOG_UPDATE",
- @"SQL_LOW_PRIORITY_UPDATES",
- @"SQL_MAX_JOIN_SIZE",
- @"SQL_NO_CACHE",
- @"SQL_QUOTE_SHOW_CREATE",
- @"SQL_SAFE_UPDATES",
- @"SQL_SELECT_LIMIT",
- @"SQL_SLAVE_SKIP_COUNTER",
- @"SQL_SMALL_RESULT",
- @"SQL_THREAD",
- @"SQL_TSI_DAY",
- @"SQL_TSI_FRAC_SECOND",
- @"SQL_TSI_HOUR",
- @"SQL_TSI_MINUTE",
- @"SQL_TSI_MONTH",
- @"SQL_TSI_QUARTER",
- @"SQL_TSI_SECOND",
- @"SQL_TSI_WEEK",
- @"SQL_TSI_YEAR",
- @"SQL_WARNINGS",
- @"SSL",
- @"START",
- @"START TRANSACTION",
- @"STARTING",
- @"STARTS",
- @"STATUS",
- @"STOP",
- @"STORAGE",
- @"STRAIGHT_JOIN",
- @"STRING",
- @"SUBJECT",
- @"SUBPARTITION",
- @"SUBPARTITIONS",
- @"SUPER",
- @"SUSPEND",
- @"TABLE",
- @"TABLES",
- @"TABLESPACE",
- @"TEMPORARY",
- @"TEMPTABLE",
- @"TERMINATED",
- @"TEXT",
- @"THAN",
- @"THEN",
- @"TIME",
- @"TIMESTAMP",
- @"TIMESTAMPADD",
- @"TIMESTAMPDIFF",
- @"TINYBLOB",
- @"TINYINT",
- @"TINYTEXT",
- @"TO",
- @"TRAILING",
- @"TRANSACTION",
- @"TRIGGER",
- @"TRIGGERS",
- @"TRUE",
- @"TRUNCATE",
- @"TYPE",
- @"TYPES",
- @"UNCOMMITTED",
- @"UNDEFINED",
- @"UNDO",
- @"UNDOFILE",
- @"UNDO_BUFFER_SIZE",
- @"UNICODE",
- @"UNINSTALL",
- @"UNINSTALL PLUGIN",
- @"UNION",
- @"UNIQUE",
- @"UNKNOWN",
- @"UNLOCK",
- @"UNLOCK TABLES",
- @"UNSIGNED",
- @"UNTIL",
- @"UPDATE",
- @"UPGRADE",
- @"USAGE",
- @"USE",
- @"USER",
- @"USER_RESOURCES",
- @"USE_FRM",
- @"USING",
- @"UTC_DATE",
- @"UTC_TIME",
- @"UTC_TIMESTAMP",
- @"VALUE",
- @"VALUES",
- @"VARBINARY",
- @"VARCHAR",
- @"VARCHARACTER",
- @"VARIABLES",
- @"VARYING",
- @"VIEW",
- @"WAIT",
- @"WARNINGS",
- @"WEEK",
- @"WHEN",
- @"WHERE",
- @"WHILE",
- @"WITH",
- @"WITH CONSISTENT SNAPSHOT",
- @"WORK",
- @"WRITE",
- @"X509",
- @"XA",
- @"XOR",
- @"YEAR",
- @"YEAR_MONTH",
- @"ZEROFILL",
-
- nil];
-}
-
-/*
- * List of fucntions for autocompletion. If you add a keyword here,
- * it should also be added to the flex file SPEditorTokens.l
- */
--(NSArray *)functions
-{
- return [NSArray arrayWithObjects:
- @"ABS",
- @"ACOS",
- @"ADDDATE",
- @"ADDTIME",
- @"AES_DECRYPT",
- @"AES_ENCRYPT",
- @"AREA",
- @"ASBINARY",
- @"ASCII",
- @"ASIN",
- @"ASTEXT",
- @"ATAN",
- @"ATAN2",
- @"AVG",
- @"BDMPOLYFROMTEXT",
- @"BDMPOLYFROMWKB",
- @"BDPOLYFROMTEXT",
- @"BDPOLYFROMWKB",
- @"BENCHMARK",
- @"BIN",
- @"BIT_AND",
- @"BIT_COUNT",
- @"BIT_LENGTH",
- @"BIT_OR",
- @"BIT_XOR",
- @"BOUNDARY",
- @"BUFFER",
- @"CAST",
- @"CEIL",
- @"CEILING",
- @"CENTROID",
- @"CHAR",
- @"CHARACTER_LENGTH",
- @"CHARSET",
- @"CHAR_LENGTH",
- @"COALESCE",
- @"COERCIBILITY",
- @"COLLATION",
- @"COMPRESS",
- @"CONCAT",
- @"CONCAT_WS",
- @"CONNECTION_ID",
- @"CONTAINS",
- @"CONV",
- @"CONVERT",
- @"CONVERT_TZ",
- @"CONVEXHULL",
- @"COS",
- @"COT",
- @"COUNT",
- @"COUNT(*)",
- @"CRC32",
- @"CROSSES",
- @"CURDATE",
- @"CURRENT_DATE",
- @"CURRENT_TIME",
- @"CURRENT_TIMESTAMP",
- @"CURRENT_USER",
- @"CURTIME",
- @"DATABASE",
- @"DATE",
- @"DATEDIFF",
- @"DATE_ADD",
- @"DATE_DIFF",
- @"DATE_FORMAT",
- @"DATE_SUB",
- @"DAY",
- @"DAYNAME",
- @"DAYOFMONTH",
- @"DAYOFWEEK",
- @"DAYOFYEAR",
- @"DECODE",
- @"DEFAULT",
- @"DEGREES",
- @"DES_DECRYPT",
- @"DES_ENCRYPT",
- @"DIFFERENCE",
- @"DIMENSION",
- @"DISJOINT",
- @"DISTANCE",
- @"ELT",
- @"ENCODE",
- @"ENCRYPT",
- @"ENDPOINT",
- @"ENVELOPE",
- @"EQUALS",
- @"EXP",
- @"EXPORT_SET",
- @"EXTERIORRING",
- @"EXTRACT",
- @"EXTRACTVALUE",
- @"FIELD",
- @"FIND_IN_SET",
- @"FLOOR",
- @"FORMAT",
- @"FOUND_ROWS",
- @"FROM_DAYS",
- @"FROM_UNIXTIME",
- @"GEOMCOLLFROMTEXT",
- @"GEOMCOLLFROMWKB",
- @"GEOMETRYCOLLECTION",
- @"GEOMETRYCOLLECTIONFROMTEXT",
- @"GEOMETRYCOLLECTIONFROMWKB",
- @"GEOMETRYFROMTEXT",
- @"GEOMETRYFROMWKB",
- @"GEOMETRYN",
- @"GEOMETRYTYPE",
- @"GEOMFROMTEXT",
- @"GEOMFROMWKB",
- @"GET_FORMAT",
- @"GET_LOCK",
- @"GLENGTH",
- @"GREATEST",
- @"GROUP_CONCAT",
- @"GROUP_UNIQUE_USERS",
- @"HEX",
- @"HOUR",
- @"IF",
- @"IFNULL",
- @"INET_ATON",
- @"INET_NTOA",
- @"INSERT",
- @"INSERT_ID",
- @"INSTR",
- @"INTERIORRINGN",
- @"INTERSECTION",
- @"INTERSECTS",
- @"INTERVAL",
- @"ISCLOSED",
- @"ISEMPTY",
- @"ISNULL",
- @"ISRING",
- @"ISSIMPLE",
- @"IS_FREE_LOCK",
- @"IS_USED_LOCK",
- @"LAST_DAY",
- @"LAST_INSERT_ID",
- @"LCASE",
- @"LEAST",
- @"LEFT",
- @"LENGTH",
- @"LINEFROMTEXT",
- @"LINEFROMWKB",
- @"LINESTRING",
- @"LINESTRINGFROMTEXT",
- @"LINESTRINGFROMWKB",
- @"LN",
- @"LOAD_FILE",
- @"LOCALTIME",
- @"LOCALTIMESTAMP",
- @"LOCATE",
- @"LOG",
- @"LOG10",
- @"LOG2",
- @"LOWER",
- @"LPAD",
- @"LTRIM",
- @"MAKEDATE",
- @"MAKETIME",
- @"MAKE_SET",
- @"MASTER_POS_WAIT",
- @"MAX",
- @"MBRCONTAINS",
- @"MBRDISJOINT",
- @"MBREQUAL",
- @"MBRINTERSECTS",
- @"MBROVERLAPS",
- @"MBRTOUCHES",
- @"MBRWITHIN",
- @"MD5",
- @"MICROSECOND",
- @"MID",
- @"MIN",
- @"MINUTE",
- @"MLINEFROMTEXT",
- @"MLINEFROMWKB",
- @"MOD",
- @"MONTH",
- @"MONTHNAME",
- @"NOW",
- @"MPOINTFROMTEXT",
- @"MPOINTFROMWKB",
- @"MPOLYFROMTEXT",
- @"MPOLYFROMWKB",
- @"MULTILINESTRING",
- @"MULTILINESTRINGFROMTEXT",
- @"MULTILINESTRINGFROMWKB",
- @"MULTIPOINT",
- @"MULTIPOINTFROMTEXT",
- @"MULTIPOINTFROMWKB",
- @"MULTIPOLYGON",
- @"MULTIPOLYGONFROMTEXT",
- @"MULTIPOLYGONFROMWKB",
- @"NAME_CONST",
- @"NOW",
- @"NULLIF",
- @"NUMGEOMETRIES",
- @"NUMINTERIORRINGS",
- @"NUMPOINTS",
- @"OCT",
- @"OCTET_LENGTH",
- @"OLD_PASSWORD",
- @"ORD",
- @"OVERLAPS",
- @"PASSWORD",
- @"PERIOD_ADD",
- @"PERIOD_DIFF",
- @"PI",
- @"POINT",
- @"POINTFROMTEXT",
- @"POINTFROMWKB",
- @"POINTN",
- @"POINTONSURFACE",
- @"POLYFROMTEXT",
- @"POLYFROMWKB",
- @"POLYGON",
- @"POLYGONFROMTEXT",
- @"POLYGONFROMWKB",
- @"POSITION",
- @"POW",
- @"POWER",
- @"QUARTER",
- @"QUOTE",
- @"RADIANS",
- @"RAND",
- @"RELATED",
- @"RELEASE_LOCK",
- @"REPEAT",
- @"REPLACE",
- @"REVERSE",
- @"RIGHT",
- @"ROUND",
- @"ROW_COUNT",
- @"RPAD",
- @"RTRIM",
- @"SCHEMA",
- @"SECOND",
- @"SEC_TO_TIME",
- @"SESSION_USER",
- @"SHA",
- @"SHA1",
- @"SIGN",
- @"SIN",
- @"SLEEP",
- @"SOUNDEX",
- @"SPACE",
- @"SQRT",
- @"SRID",
- @"STARTPOINT",
- @"STD",
- @"STDDEV",
- @"STDDEV_POP",
- @"STDDEV_SAMP",
- @"STRCMP",
- @"STR_TO_DATE",
- @"SUBDATE",
- @"SUBSTR",
- @"SUBSTRING",
- @"SUBSTRING_INDEX",
- @"SUBTIME",
- @"SUM",
- @"SYMDIFFERENCE",
- @"SYSDATE",
- @"SYSTEM_USER",
- @"TAN",
- @"TIME",
- @"TIMEDIFF",
- @"TIMESTAMP",
- @"TIMESTAMPADD",
- @"TIMESTAMPDIFF",
- @"TIME_FORMAT",
- @"TIME_TO_SEC",
- @"TOUCHES",
- @"TO_DAYS",
- @"TRIM",
- @"TRUNCATE",
- @"UCASE",
- @"UNCOMPRESS",
- @"UNCOMPRESSED_LENGTH",
- @"UNHEX",
- @"UNIQUE_USERS",
- @"UNIX_TIMESTAMP",
- @"UPDATEXML",
- @"UPPER",
- @"USER",
- @"UTC_DATE",
- @"UTC_TIME",
- @"UTC_TIMESTAMP",
- @"UUID",
- @"VARIANCE",
- @"VAR_POP",
- @"VAR_SAMP",
- @"VERSION",
- @"WEEK",
- @"WEEKDAY",
- @"WEEKOFYEAR",
- @"WITHIN",
- @"YEAR",
- @"YEARWEEK",
-
- nil];
-}
-
-
-/*
* Set whether this text view should apply the indentation on the current line to new lines.
*/
- (void)setAutoindent:(BOOL)enableAutoindent
@@ -3410,6 +2460,12 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
// Make sure that the notification is from the correct textStorage object
if (textStore!=[self textStorage]) return;
+ // Cancel autocompletion trigger
+ if([prefs boolForKey:SPCustomQueryAutoComplete])
+ [NSObject cancelPreviousPerformRequestsWithTarget:self
+ selector:@selector(doAutoCompletion)
+ object:nil];
+
NSInteger editedMask = [textStore editedMask];
// Start autohelp only if the user really changed the text (not e.g. for setting a background color)
@@ -3417,14 +2473,8 @@ NSInteger alphabeticSort(id string1, id string2, void *reverse)
[self performSelector:@selector(autoHelp) withObject:nil afterDelay:[[[prefs valueForKey:SPCustomQueryAutoHelpDelay] retain] doubleValue]];
}
- // Cancel autocompletion trigger
- if([prefs boolForKey:SPCustomQueryAutoComplete])
- [NSObject cancelPreviousPerformRequestsWithTarget:self
- selector:@selector(doAutoCompletion)
- object:nil];
-
// Start autocompletion if enabled
- if([prefs boolForKey:SPCustomQueryAutoComplete] && !completionIsOpen && editedMask != 1)
+ if([[NSApp keyWindow] firstResponder] == self && [prefs boolForKey:SPCustomQueryAutoComplete] && !completionIsOpen && editedMask != 1)
[self performSelector:@selector(doAutoCompletion) withObject:nil afterDelay:[[[prefs valueForKey:SPCustomQueryAutoCompleteDelay] retain] doubleValue]];
// Cancel calling doSyntaxHighlighting for large text