aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableInfo.m
diff options
context:
space:
mode:
Diffstat (limited to 'Source/SPTableInfo.m')
-rw-r--r--Source/SPTableInfo.m12
1 files changed, 7 insertions, 5 deletions
diff --git a/Source/SPTableInfo.m b/Source/SPTableInfo.m
index a6576e4c..e9f3e3a1 100644
--- a/Source/SPTableInfo.m
+++ b/Source/SPTableInfo.m
@@ -104,10 +104,8 @@
if ([tableListInstance tableName]) {
if ([[tableListInstance tableName] isEqualToString:@""]) {
[info addObject:@"multiple tables"];
-
}
else {
-
// Retrieve the table status information via the data cache
tableStatus = [tableDataInstance statusValues];
@@ -117,21 +115,25 @@
return;
}
- // Check for "Create_time" == NULL
+ // Check for 'Create_time' == NULL
if (![[tableStatus objectForKey:@"Create_time"] isNSNull]) {
// Add the creation date to the infoTable
[info addObject:[NSString stringWithFormat:@"created: %@", [self _getUserDefinedDateStringFromMySQLDate:[tableStatus objectForKey:@"Create_time"]]]];
}
- // Check for "Update_time" == NULL - InnoDB tables don't have an update time
+ // Check for 'Update_time' == NULL - InnoDB tables don't have an update time
if (![[tableStatus objectForKey:@"Update_time"] isNSNull]) {
// Add the update date to the infoTable
[info addObject:[NSString stringWithFormat:@"updated: %@", [self _getUserDefinedDateStringFromMySQLDate:[tableStatus objectForKey:@"Update_time"]]]];
}
+
+ // Check for 'Rows' == NULL - information_schema database doesn't report row count for it's tables
+ if (![[tableStatus objectForKey:@"Rows"] isNSNull]) {
+ [info addObject:[NSString stringWithFormat:@"rows: ~%@", [tableStatus objectForKey:@"Rows"]]];
+ }
- [info addObject:[NSString stringWithFormat:@"rows: ~%@", [tableStatus objectForKey:@"Rows"]]];
[info addObject:[NSString stringWithFormat:@"size: %@", [NSString stringForByteSize:[[tableStatus objectForKey:@"Data_length"] intValue]]]];
[info addObject:[NSString stringWithFormat:@"encoding: %@", [tableDataInstance tableEncoding]]];