aboutsummaryrefslogtreecommitdiffstats
path: root/TableDocument.m
diff options
context:
space:
mode:
Diffstat (limited to 'TableDocument.m')
-rw-r--r--TableDocument.m80
1 files changed, 45 insertions, 35 deletions
diff --git a/TableDocument.m b/TableDocument.m
index 35aa550e..b5cfb59c 100644
--- a/TableDocument.m
+++ b/TableDocument.m
@@ -31,6 +31,7 @@
#import "CustomQuery.h"
#import "TableDump.h"
#import "TableStatus.h"
+#import "ImageAndTextCell.h"
NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocumentFavoritesControllerSelectionIndexDidChange";
@@ -75,6 +76,12 @@ NSString *TableDocumentFavoritesControllerSelectionIndexDidChange = @"TableDocum
}
+- (CMMCPConnection *)sharedConnection
+{
+ return mySQLConnection;
+}
+
+
//start sheet
/**
@@ -761,7 +768,7 @@ reused when user hits the close button of the variablseSheet or of the createTab
NSString *query = [NSString stringWithFormat:@"SHOW CREATE TABLE `%@`", [self table]];
CMMCPResult *theResult = [mySQLConnection queryString:query];
- // Check for no errors
+ // Check for errors
if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while creating table syntax.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
return;
@@ -782,7 +789,7 @@ reused when user hits the close button of the variablseSheet or of the createTab
NSString *query = [NSString stringWithFormat:@"SHOW CREATE TABLE `%@`", [self table]];
CMMCPResult *theResult = [mySQLConnection queryString:query];
- // Check for no errors
+ // Check for errors
if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while creating table syntax.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
return;
@@ -794,9 +801,9 @@ reused when user hits the close button of the variablseSheet or of the createTab
tableSyntax = [[NSString alloc] initWithData:tableSyntax encoding:[mySQLConnection encoding]];
// copy to the clipboard
- NSPasteboard *pb = [NSPasteboard generalPasteboard];
- [pb declareTypes:[NSArray arrayWithObject:NSStringPboardType] owner:self];
- [pb setString:tableSyntax forType:NSStringPboardType];
+ NSPasteboard *pb = [NSPasteboard generalPasteboard];
+ [pb declareTypes:[NSArray arrayWithObject:NSStringPboardType] owner:self];
+ [pb setString:tableSyntax forType:NSStringPboardType];
}
- (IBAction)checkTable:(id)sender
@@ -809,14 +816,15 @@ reused when user hits the close button of the variablseSheet or of the createTab
query = [NSString stringWithFormat:@"CHECK TABLE `%@`", [self table]];
theResult = [mySQLConnection queryString:query];
- // Check for no errors
- if ( [[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
- theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
- NSRunInformationalAlertPanel(@"Check Table", [NSString stringWithFormat:@"Check: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
- } else {
- // If there was an error
+ // Check for errors
+ if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while checking table.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
+ return;
}
+
+ // Process result
+ theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
+ NSRunInformationalAlertPanel(@"Check Table", [NSString stringWithFormat:@"Check: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
}
- (IBAction)analyzeTable:(id)sender
@@ -829,14 +837,15 @@ reused when user hits the close button of the variablseSheet or of the createTab
query = [NSString stringWithFormat:@"ANALYZE TABLE `%@`", [self table]];
theResult = [mySQLConnection queryString:query];
- // Check for no errors
- if ( [[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
- theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
- NSRunInformationalAlertPanel(@"Analyze Table", [NSString stringWithFormat:@"Analyze: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
- } else {
- // If there was an error
+ // Check for errors
+ if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while analyzing table.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
+ return;
}
+
+ // Process result
+ theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
+ NSRunInformationalAlertPanel(@"Analyze Table", [NSString stringWithFormat:@"Analyze: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
}
- (IBAction)optimizeTable:(id)sender
@@ -849,14 +858,14 @@ reused when user hits the close button of the variablseSheet or of the createTab
query = [NSString stringWithFormat:@"OPTIMIZE TABLE `%@`", [self table]];
theResult = [mySQLConnection queryString:query];
- // Check for no errors
- if ( [[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
- theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
- NSRunInformationalAlertPanel(@"Optimize Table", [NSString stringWithFormat:@"Optimize: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
- } else {
- // If there was an error
+ // Check for errors
+ if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while optimizing table.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
}
+
+ // Process result
+ theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
+ NSRunInformationalAlertPanel(@"Optimize Table", [NSString stringWithFormat:@"Optimize: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
}
- (IBAction)repairTable:(id)sender
@@ -869,14 +878,14 @@ reused when user hits the close button of the variablseSheet or of the createTab
query = [NSString stringWithFormat:@"REPAIR TABLE `%@`", [self table]];
theResult = [mySQLConnection queryString:query];
- // Check for no errors
- if ( [[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
- theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
- NSRunInformationalAlertPanel(@"Repair Table", [NSString stringWithFormat:@"Repair: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
- } else {
- // If there was an error
+ // Check for errors
+ if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while repairing table.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
}
+
+ // Process result
+ theRow = [[theResult fetch2DResultAsType:MCPTypeDictionary] lastObject];
+ NSRunInformationalAlertPanel(@"Repair Table", [NSString stringWithFormat:@"Repair: %@", [theRow objectForKey:@"Msg_text"]], @"OK", nil, nil);
}
- (IBAction)flushTable:(id)sender
@@ -888,13 +897,14 @@ reused when user hits the close button of the variablseSheet or of the createTab
query = [NSString stringWithFormat:@"FLUSH TABLE `%@`", [self table]];
theResult = [mySQLConnection queryString:query];
- // Check for no errors
- if ( [[mySQLConnection getLastErrorMessage] isEqualToString:@""] ) {
- NSRunInformationalAlertPanel(@"Flush Table", @"Flushed", @"OK", nil, nil);
- } else {
- // If there was an error
+ // Check for errors
+ if (![[mySQLConnection getLastErrorMessage] isEqualToString:@""]) {
NSRunAlertPanel(@"Error", [NSString stringWithFormat:@"An error occured while flushing table.\n\n: %@",[mySQLConnection getLastErrorMessage]], @"OK", nil, nil);
+ return;
}
+
+ // Process result
+ NSRunInformationalAlertPanel(@"Flush Table", @"Flushed", @"OK", nil, nil);
}
#pragma mark Other Methods
@@ -1102,7 +1112,7 @@ passes the request to the tableDump object
[menuItem action] == @selector(analyzeTable:) ||
[menuItem action] == @selector(optimizeTable:) ||
[menuItem action] == @selector(repairTable:) ||
- [menuItem action] == @selector(flushTable:))
+ [menuItem action] == @selector(flushTable:))
{
return ([self table] != nil);
}