• added URL scheme command sequelpro://SP_PROCESS_ID@passToDoc/RunQueryInQueryEditor/ which executes a passed SQL query and displays the result if any in the data table of the query editor

1 files changed, 14 insertions, 0 deletions

diff --git a/Source/SPDatabaseDocument.m b/Source/SPDatabaseDocument.m
index d93d5a14..8f63f163 100644
--- a/Source/SPDatabaseDocument.m
+++ b/Source/SPDatabaseDocument.m
@@ -4905,6 +4905,20 @@ static NSString *SPCreateSyntx = @"SPCreateSyntax";
 		return;
 	}
 
+	if([command isEqualToString:@"RunQueryInQueryEditor"]) {
+		NSString *queryFileName = [NSString stringWithFormat:@"%@%@", SPURLSchemeQueryInputPathHeader, docProcessID];
+		NSFileManager *fm = [NSFileManager defaultManager];
+		BOOL isDir;
+		if([fm fileExistsAtPath:queryFileName isDirectory:&isDir] && !isDir) {
+			NSError *inError = nil;
+			NSString *query = [NSString stringWithContentsOfFile:queryFileName encoding:NSUTF8StringEncoding error:&inError];
+			[fm removeItemAtPath:queryFileName error:nil];
+			if(inError == nil && query && [query length]) {
+				[customQueryInstance performQueries:[NSArray arrayWithObject:query] withCallback:NULL];
+			}
+		}
+		return;
+	}
 
 	if([command isEqualToString:@"CreateSyntaxForTables"]) {