aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
diff options
context:
space:
mode:
authormtvee <emptyvee@gmail.com>2009-05-13 00:56:36 +0000
committermtvee <emptyvee@gmail.com>2009-05-13 00:56:36 +0000
commit12b84cb69a904fb6ea714ab6d4b0b885f4d54436 (patch)
tree8e0df64c75a9300f375960d1c2dfcfd90e4d9959 /Source/TableDocument.m
parent35e6aaac3997475a04984b09fac24ab02574ab27 (diff)
downloadsequelpro-12b84cb69a904fb6ea714ab6d4b0b885f4d54436.tar.gz
sequelpro-12b84cb69a904fb6ea714ab6d4b0b885f4d54436.tar.bz2
sequelpro-12b84cb69a904fb6ea714ab6d4b0b885f4d54436.zip
- added ability to view function and procedures and preliminary ability to input same via the editor
Diffstat (limited to 'Source/TableDocument.m')
-rw-r--r--Source/TableDocument.m60
1 files changed, 53 insertions, 7 deletions
diff --git a/Source/TableDocument.m b/Source/TableDocument.m
index fcb3340e..6a769996 100644
--- a/Source/TableDocument.m
+++ b/Source/TableDocument.m
@@ -917,7 +917,32 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
- (IBAction)showCreateTableSyntax:(id)sender
{
//Create the query and get results
- NSString *query = [NSString stringWithFormat:@"SHOW CREATE TABLE %@", [[self table] backtickQuotedString]];
+ NSString *query = nil;
+ NSString *createWindowTitle;
+ int colOffs = 1;
+
+ if( [tablesListInstance tableType] == SP_TABLETYPE_TABLE ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE TABLE %@", [[self table] backtickQuotedString]];
+ createWindowTitle = @"Create Table Syntax";
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_VIEW ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE VIEW %@", [[self table] backtickQuotedString]];
+ createWindowTitle = @"Create View Syntax";
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_PROC ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE PROCEDURE %@", [[self table] backtickQuotedString]];
+ createWindowTitle = @"Create Procedure Syntax";
+ colOffs = 2;
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_FUNC ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE FUNCTION %@", [[self table] backtickQuotedString]];
+ createWindowTitle = @"Create Function Syntax";
+ colOffs = 2;
+ }
+
+ if( query == nil )
+ return;
+
CMMCPResult *theResult = [mySQLConnection queryString:query];
// Check for errors, only displaying if the connection hasn't been terminated
@@ -928,7 +953,7 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
return;
}
- id tableSyntax = [[theResult fetchRowAsArray] objectAtIndex:1];
+ id tableSyntax = [[theResult fetchRowAsArray] objectAtIndex:colOffs];
if ([tableSyntax isKindOfClass:[NSData class]])
tableSyntax = [[NSString alloc] initWithData:tableSyntax encoding:[mySQLConnection encoding]];
@@ -938,6 +963,7 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
else
[syntaxViewContent setString:tableSyntax];
+ [createTableSyntaxWindow setTitle:createWindowTitle];
[createTableSyntaxWindow makeKeyAndOrderFront:self];
}
@@ -946,8 +972,28 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
*/
- (IBAction)copyCreateTableSyntax:(id)sender
{
- // Create the query and get results
- NSString *query = [NSString stringWithFormat:@"SHOW CREATE TABLE %@", [[self table] backtickQuotedString]];
+ // Create the query and get results
+ NSString *query = nil;
+ int colOffs = 1;
+
+ if( [tablesListInstance tableType] == SP_TABLETYPE_TABLE ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE TABLE %@", [[self table] backtickQuotedString]];
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_VIEW ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE VIEW %@", [[self table] backtickQuotedString]];
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_PROC ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE PROCEDURE %@", [[self table] backtickQuotedString]];
+ colOffs = 2;
+ }
+ else if( [tablesListInstance tableType] == SP_TABLETYPE_FUNC ) {
+ query = [NSString stringWithFormat:@"SHOW CREATE FUNCTION %@", [[self table] backtickQuotedString]];
+ colOffs = 2;
+ }
+
+ if( query == nil )
+ return;
+
CMMCPResult *theResult = [mySQLConnection queryString:query];
// Check for errors, only displaying if the connection hasn't been terminated
@@ -958,7 +1004,7 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
return;
}
- id tableSyntax = [[theResult fetchRowAsArray] objectAtIndex:1];
+ id tableSyntax = [[theResult fetchRowAsArray] objectAtIndex:colOffs];
if ([tableSyntax isKindOfClass:[NSData class]])
tableSyntax = [[NSString alloc] initWithData:tableSyntax encoding:[mySQLConnection encoding]];
@@ -972,9 +1018,9 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
[pb setString:tableSyntax forType:NSStringPboardType];
// Table syntax copied Growl notification
- [[SPGrowlController sharedGrowlController] notifyWithTitle:@"Table Syntax Copied"
+ [[SPGrowlController sharedGrowlController] notifyWithTitle:@"Syntax Copied"
description:[NSString stringWithFormat:NSLocalizedString(@"Syntax for %@ table copied",@"description for table syntax copied growl notification"), [self table]]
- notificationName:@"Table Syntax Copied"];
+ notificationName:@"Syntax Copied"];
}
- (IBAction)copyColumnNames:(id)sender