From 03783658ec16339b87d9005838d6ac8263871853 Mon Sep 17 00:00:00 2001
From: rowanbeentje <rowan@beent.je>
Date: Tue, 29 Sep 2009 00:12:19 +0000
Subject:  - When editing a row in a table with "on update CURRENT_TIMESTAMP"
 set for a column, if that column value hasn't been changed by the user apply
 the CURRENT_TIMESTAMP appropriately.  This addresses Issue #416

---
 Source/TableContent.m | 26 +++++++++++++++-----------
 1 file changed, 15 insertions(+), 11 deletions(-)

diff --git a/Source/TableContent.m b/Source/TableContent.m
index 9d3110b4..a030ee27 100644
--- a/Source/TableContent.m
+++ b/Source/TableContent.m
@@ -1331,7 +1331,6 @@
  */
 - (BOOL)addRowToDB
 {
-	NSArray *columnNames;
 	NSMutableString *queryString;
 	id rowObject;
 	NSMutableString *rowValue = [NSMutableString string];
@@ -1352,16 +1351,21 @@
 		return YES;
 	}
 
-	// Retrieve the field names and types for this table from the data cache.  This is used when requesting all data as part
-	// of the fieldListForQuery method, and also to decide whether or not to preserve the current filter/sort settings.
-	columnNames = [tableDataInstance columnNames];
-	
 	NSMutableArray *fieldValues = [[NSMutableArray alloc] init];
 	// Get the field values
-	for ( i = 0 ; i < [columnNames count] ; i++ ) {
+	for ( i = 0 ; i < [dataColumns count] ; i++ ) {
 		rowObject = [NSArrayObjectAtIndex(tableValues, currentlyEditingRow) objectAtIndex:i];
+
+		// Catch CURRENT_TIMESTAMP automatic updates - if the row is new and the cell value matches
+		// the default value, or if the cell hasn't changed, update the current timestamp.
+		if ([[NSArrayObjectAtIndex(dataColumns, i) objectForKey:@"onupdatetimestamp"] intValue]
+			&& (   (isEditingNewRow && [rowObject isEqualTo:[NSArrayObjectAtIndex(dataColumns, i) objectForKey:@"default"]])
+				|| (!isEditingNewRow && [rowObject isEqualTo:NSArrayObjectAtIndex(oldRow, i)])))
+		{
+			[rowValue setString:@"CURRENT_TIMESTAMP"];
+
 		// Convert the object to a string (here we can add special treatment for date-, number- and data-fields)
-		if ( [[rowObject description] isEqualToString:[prefs stringForKey:@"NullValue"]]
+		} else if ( [[rowObject description] isEqualToString:[prefs stringForKey:@"NullValue"]]
 				|| ([rowObject isMemberOfClass:[NSString class]] && [[rowObject description] isEqualToString:@""]) ) {
 
 			//NULL when user entered the nullValue string defined in the prefs or when a number field isn't set
@@ -1378,7 +1382,7 @@
 			} else if ( [rowObject isKindOfClass:[NSData class]] ) {
 				[rowValue setString:[NSString stringWithFormat:@"X'%@'", [mySQLConnection prepareBinaryData:rowObject]]];
 			} else {
-				if ( [[rowObject description] isEqualToString:@"CURRENT_TIMESTAMP"] ) {
+				if ([[rowObject description] isEqualToString:@"CURRENT_TIMESTAMP"]) {
 					[rowValue setString:@"CURRENT_TIMESTAMP"];
 				} else if ([[NSArrayObjectAtIndex(dataColumns, i) objectForKey:@"typegrouping"] isEqualToString:@"bit"]) {
 					[rowValue setString:((![[rowObject description] length] || [[rowObject description] isEqualToString:@"0"])?@"0":@"1")];
@@ -1396,17 +1400,17 @@
 	// Use INSERT syntax when creating new rows
 	if ( isEditingNewRow ) {
 		queryString = [NSString stringWithFormat:@"INSERT INTO %@ (%@) VALUES (%@)",
-					   [selectedTable backtickQuotedString], [columnNames componentsJoinedAndBacktickQuoted], [fieldValues componentsJoinedByString:@","]];
+					   [selectedTable backtickQuotedString], [[tableDataInstance columnNames] componentsJoinedAndBacktickQuoted], [fieldValues componentsJoinedByString:@","]];
 
 	// Use UPDATE syntax otherwise
 	} else {
 		queryString = [NSMutableString stringWithFormat:@"UPDATE %@ SET ", [selectedTable backtickQuotedString]];
-		for ( i = 0 ; i < [columnNames count] ; i++ ) {
+		for ( i = 0 ; i < [dataColumns count] ; i++ ) {
 			if ( i > 0 ) {
 				[queryString appendString:@", "];
 			}
 			[queryString appendString:[NSString stringWithFormat:@"%@=%@",
-									   [NSArrayObjectAtIndex(columnNames, i) backtickQuotedString], [fieldValues objectAtIndex:i]]];
+									   [[NSArrayObjectAtIndex(dataColumns, i) objectForKey:@"name"] backtickQuotedString], [fieldValues objectAtIndex:i]]];
 		}
 		[queryString appendString:[NSString stringWithFormat:@" WHERE %@", [self argumentForRow:-2]]];
 	}
-- 
cgit v1.2.3