aboutsummaryrefslogtreecommitdiffstats
path: root/TableStatus.m
diff options
context:
space:
mode:
authorabhibeckert <abhi@abhibeckert.com>2008-04-04 11:37:36 +0000
committerabhibeckert <abhi@abhibeckert.com>2008-04-04 11:37:36 +0000
commit0f586da34dac2c764a12055158e4929cf69340a1 (patch)
treebca3868c9715a10c08017a0a7b6d5148f8bd3556 /TableStatus.m
parent5fb284b7c12887b8eea6c3a02fa83abf50793992 (diff)
downloadsequelpro-0f586da34dac2c764a12055158e4929cf69340a1.tar.gz
sequelpro-0f586da34dac2c764a12055158e4929cf69340a1.tar.bz2
sequelpro-0f586da34dac2c764a12055158e4929cf69340a1.zip
Initial import from (slightly modified) CocoaMySQL v0.7b4
Diffstat (limited to 'TableStatus.m')
-rw-r--r--TableStatus.m113
1 files changed, 113 insertions, 0 deletions
diff --git a/TableStatus.m b/TableStatus.m
new file mode 100644
index 00000000..f2ad1244
--- /dev/null
+++ b/TableStatus.m
@@ -0,0 +1,113 @@
+#import "TableStatus.h"
+
+@implementation TableStatus
+
+- (void)awakeFromNib
+{
+ // TODO: implement awake code.
+}
+
+- (void)setConnection:(CMMCPConnection *)theConnection
+{
+ mySQLConnection = theConnection;
+ [mySQLConnection retain];
+}
+
+- (NSString*)getSQLColumnValue:(NSString *)withName usingFields:(NSDictionary*)fields withLabel:(NSString*)label
+{
+ NSString* value = [fields objectForKey:withName];
+ if([value isKindOfClass:[NSNull class]])
+ {
+ value = @"--";
+ }
+
+ NSString* labelVal = [NSString stringWithFormat:@"%@: %@",label,value];
+
+ return labelVal;
+}
+
+- (void)loadTable:(NSString *)aTable
+{
+ // Store the table name away for future use...
+ selectedTable = aTable;
+
+ // Notify any listeners that a query is about to begin...
+ [[NSNotificationCenter defaultCenter] postNotificationName:@"SMySQLQueryWillBePerformed" object:self];
+
+ // no table selected
+ if([aTable isEqualToString:@""] || !aTable) {
+ [tableName setStringValue:@"Name: --"];
+ [tableType setStringValue:@"Type: --"];
+ [tableCreatedAt setStringValue:@"Created At: --"];
+ [tableUpdatedAt setStringValue:@"Updated At: --"];
+
+ // Assign the row values...
+ [rowsNumber setStringValue:@"Number Of: --"];
+ [rowsFormat setStringValue:@"Format: --"];
+ [rowsAvgLength setStringValue:@"Avg. Length: --"];
+ [rowsAutoIncrement setStringValue:@"Auto Increment: --"];
+
+ // Assign the size values...
+ [sizeData setStringValue:@"Data: --"];
+ [sizeMaxData setStringValue:@"Max Data: --"];
+ [sizeIndex setStringValue:@"Index: --"];
+ [sizeFree setStringValue:@"Free: --"];
+
+ // Finally, set the value of the comments box
+ [commentsBox setStringValue:@"--"];
+
+ // Tell everyone we've finished with our query...
+ [[NSNotificationCenter defaultCenter] postNotificationName:@"SMySQLQueryHasBeenPerformed" object:self];
+ return;
+ }
+
+ // Run the query to retrieve the status of the selected table. We'll then use this information to populate
+ // the associated view's controls.
+ tableStatusResult = [mySQLConnection queryString:[NSString stringWithFormat:@"SHOW TABLE STATUS LIKE '%@'", selectedTable]];
+
+ statusFields = [tableStatusResult fetchRowAsDictionary];
+
+ // Assign the table values...
+ [tableName setStringValue:[NSString stringWithFormat:@"Name: %@",selectedTable]];
+ if ( [statusFields objectForKey:@"Type"] ) {
+ [tableType setStringValue:[self getSQLColumnValue:@"Type" usingFields:statusFields withLabel:@"Type"]];
+ } else {
+ // mysql > 4.1
+ [tableType setStringValue:[self getSQLColumnValue:@"Engine" usingFields:statusFields withLabel:@"Type"]];
+ }
+ [tableCreatedAt setStringValue:[self getSQLColumnValue:@"Create_time" usingFields:statusFields withLabel:@"Created At"]];
+ [tableUpdatedAt setStringValue:[self getSQLColumnValue:@"Update_time" usingFields:statusFields withLabel:@"Updated At"]];
+
+ // Assign the row values...
+ [rowsNumber setStringValue:[self getSQLColumnValue:@"Rows" usingFields:statusFields withLabel:@"Number Of"]];
+ [rowsFormat setStringValue:[self getSQLColumnValue:@"Row_format" usingFields:statusFields withLabel:@"Format"]];
+ [rowsAvgLength setStringValue:[self getSQLColumnValue:@"Avg_row_length" usingFields:statusFields withLabel:@"Avg. Length"]];
+ [rowsAutoIncrement setStringValue:[self getSQLColumnValue:@"Auto_increment" usingFields:statusFields withLabel:@"Auto Increment"]];
+
+ // Assign the size values...
+ [sizeData setStringValue:[self getSQLColumnValue:@"Data_length" usingFields:statusFields withLabel:@"Data"]];
+ [sizeMaxData setStringValue:[self getSQLColumnValue:@"Max_data_length" usingFields:statusFields withLabel:@"Max Data"]];
+ [sizeIndex setStringValue:[self getSQLColumnValue:@"Index_length" usingFields:statusFields withLabel:@"Index"]];
+ [sizeFree setStringValue:[self getSQLColumnValue:@"Data_free" usingFields:statusFields withLabel:@"Free"]];
+
+ // Finally, assign the comments...
+ [commentsBox setStringValue:[statusFields objectForKey:@"Comment"]];
+
+ // Tell everyone we've finished with our query...
+ [[NSNotificationCenter defaultCenter] postNotificationName:@"SMySQLQueryHasBeenPerformed" object:self];
+
+ return;
+}
+
+- (IBAction)reloadTable:(id)sender
+{
+ [self loadTable:selectedTable];
+}
+
+- (id)init
+{
+ self = [super init];
+
+ return self;
+}
+@end