aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBibiko <bibiko@eva.mpg.de>2010-10-25 07:54:11 +0000
committerBibiko <bibiko@eva.mpg.de>2010-10-25 07:54:11 +0000
commitd8692ec22b231091c9c73eaf68ec81b834a4cdc0 (patch)
tree59c320e23fa3d781d76b65f03f3d005966c5eb1f
parent6d335ffc70ec69d3ebe197ad7d9593592a1261d7 (diff)
downloadsequelpro-d8692ec22b231091c9c73eaf68ec81b834a4cdc0.tar.gz
sequelpro-d8692ec22b231091c9c73eaf68ec81b834a4cdc0.tar.bz2
sequelpro-d8692ec22b231091c9c73eaf68ec81b834a4cdc0.zip
CSV Import Field Mapper
- a column placeholder will be wrapped into '…' if csv cell content is not NULL, in other words there's no need to write eg length('$1') instead simply write length($1) - fixed issue if csv cell content is NULL - fixed issue for deletion of global values if they were already in use - assigned keyboard short-cut ⌥⌘G to "Add value or expression…" menu item
-rw-r--r--Source/SPDataImport.m41
-rw-r--r--Source/SPFieldMapperController.m75
2 files changed, 65 insertions, 51 deletions
diff --git a/Source/SPDataImport.m b/Source/SPDataImport.m
index 5fafe4a4..8a8f9d64 100644
--- a/Source/SPDataImport.m
+++ b/Source/SPDataImport.m
@@ -1285,16 +1285,13 @@
NSRange aRange = [globalVar rangeOfRegex:re capture:0L];
NSInteger colIndex = [[globalVar substringWithRange:[globalVar rangeOfRegex:re capture:1L]] integerValue];
if(colIndex > 0 && colIndex <= [csvRowArray count]) {
- NSString *colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
- // escape column string for ' or " if the char just before $… is a " or '
- if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '\'')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]];
- else if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '"')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"\"" withString:@"\\\""]];
+ id colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
+ if(colStr == [NSNull null])
+ [globalVar replaceCharactersInRange:aRange withString:@"NULL"];
else
- [globalVar replaceCharactersInRange:aRange withString:colStr];
+ [globalVar replaceCharactersInRange:aRange withString:[NSString stringWithFormat:@"'%@'", [(NSString*)colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]]];
} else {
- [globalVar replaceCharactersInRange:aRange withString:@""];
+ [globalVar replaceCharactersInRange:aRange withString:@"GLOBAL_SQL_EXPRESSION_ERROR"];
}
}
}
@@ -1335,16 +1332,13 @@
NSRange aRange = [globalVar rangeOfRegex:re capture:0L];
NSInteger colIndex = [[globalVar substringWithRange:[globalVar rangeOfRegex:re capture:1L]] integerValue];
if(colIndex > 0 && colIndex <= [csvRowArray count]) {
- NSString *colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
- // escape column string for ' or " if the char just before $… is a " or '
- if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '\'')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]];
- else if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '"')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"\"" withString:@"\\\""]];
+ id colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
+ if(colStr == [NSNull null])
+ [globalVar replaceCharactersInRange:aRange withString:@"NULL"];
else
- [globalVar replaceCharactersInRange:aRange withString:colStr];
+ [globalVar replaceCharactersInRange:aRange withString:[NSString stringWithFormat:@"'%@'", [(NSString*)colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]]];
} else {
- [globalVar replaceCharactersInRange:aRange withString:@""];
+ [globalVar replaceCharactersInRange:aRange withString:@"GLOBAL_SQL_EXPRESSION_ERROR"];
}
}
}
@@ -1400,23 +1394,20 @@
} else {
[globalVar setString:NSArrayObjectAtIndex(fieldMappingGlobalValueArray, mapColumn)];
// Global variables are coming wrapped in ' ' if there're not marked as SQL.
- // If global variable contains column placeholders $1 etc. replace them.
+ // If global variable contains column placeholders $1 etc. replace them by escaped 'csv content' or NULL.
if([globalVar rangeOfString:@"$"].length && [globalVar isMatchedByRegex:re]) {
while([globalVar isMatchedByRegex:re]) {
[globalVar flushCachedRegexData];
NSRange aRange = [globalVar rangeOfRegex:re capture:0L];
NSInteger colIndex = [[globalVar substringWithRange:[globalVar rangeOfRegex:re capture:1L]] integerValue];
if(colIndex > 0 && colIndex <= [csvRowArray count]) {
- NSString *colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
- // escape column string for ' or " if the char just before $… is a " or '
- if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '\'')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]];
- else if(aRange.location && [globalVar characterAtIndex:aRange.location-1] == '"')
- [globalVar replaceCharactersInRange:aRange withString:[colStr stringByReplacingOccurrencesOfString:@"\"" withString:@"\\\""]];
+ id colStr = NSArrayObjectAtIndex(csvRowArray, colIndex-1);
+ if(colStr == [NSNull null])
+ [globalVar replaceCharactersInRange:aRange withString:@"NULL"];
else
- [globalVar replaceCharactersInRange:aRange withString:colStr];
+ [globalVar replaceCharactersInRange:aRange withString:[NSString stringWithFormat:@"'%@'", [(NSString*)colStr stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]]];
} else {
- [globalVar replaceCharactersInRange:aRange withString:@""];
+ [globalVar replaceCharactersInRange:aRange withString:@"GLOBAL_SQL_EXPRESSION_ERROR"];
}
}
}
diff --git a/Source/SPFieldMapperController.m b/Source/SPFieldMapperController.m
index ca43d4d0..df944117 100644
--- a/Source/SPFieldMapperController.m
+++ b/Source/SPFieldMapperController.m
@@ -31,6 +31,16 @@
#define SP_NUMBER_OF_RECORDS_STRING NSLocalizedString(@"%ld of %@%lu records", @"Label showing the index of the selected CSV row")
+// Constants
+static const NSString *SPTableViewImportValueColumnID = @"import_value";
+static const NSString *SPTableViewTypeColumnID = @"type";
+static const NSString *SPTableViewTargetFieldColumnID = @"target_field";
+static const NSString *SPTableViewOperatorColumnID = @"operator";
+static const NSString *SPTableViewValueIndexColumnID = @"value_index";
+static const NSString *SPTableViewGlobalValueColumnID = @"global_value";
+static const NSString *SPTableViewSqlColumnID = @"sql";
+
+
@implementation SPFieldMapperController
@synthesize sourcePath;
@@ -276,11 +286,13 @@
- (NSArray*)fieldMappingGlobalValueArray
{
NSMutableArray *globals = [NSMutableArray array];
- for(NSInteger i=0; i < [fieldMappingGlobalValues count]; i++)
- if([[fieldMappingGlobalValuesSQLMarked objectAtIndex:i] boolValue] || [[fieldMappingGlobalValues objectAtIndex:i] isKindOfClass:[NSNull class]])
- [globals addObject:[fieldMappingGlobalValues objectAtIndex:i]];
+ for(NSInteger i=0; i < [fieldMappingGlobalValues count]; i++) {
+ id glob = NSArrayObjectAtIndex(fieldMappingGlobalValues, i);
+ if([NSArrayObjectAtIndex(fieldMappingGlobalValuesSQLMarked, i) boolValue] || glob == [NSNull null])
+ [globals addObject:glob];
else
- [globals addObject:[NSString stringWithFormat:@"'%@'", [[fieldMappingGlobalValues objectAtIndex:i] stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]]];
+ [globals addObject:[NSString stringWithFormat:@"'%@'", [(NSString*)glob stringByReplacingOccurrencesOfString:@"'" withString:@"\\'"]]];
+ }
return globals;
}
@@ -289,7 +301,7 @@
{
NSInteger i = 0;
for(id item in fieldMappingArray) {
- if([item intValue] >= numberOfImportColumns && [fieldMappingOperatorArray objectAtIndex:i] != doNotImport)
+ if([item intValue] >= numberOfImportColumns && NSArrayObjectAtIndex(fieldMappingOperatorArray, i) != doNotImport)
return YES;
i++;
}
@@ -1562,7 +1574,7 @@
if(aTableView == fieldMapperTableView) {
// A click at the operator column's header toggle all operators
- if ([[aTableColumn identifier] isEqualToString:@"operator"]
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewOperatorColumnID]
&& [self numberOfRowsInTableView:aTableView]
&& [fieldMappingOperatorArray count]
&& [fieldMappingTableColumnNames count]) {
@@ -1586,7 +1598,7 @@
if ([fieldMappingOperatorArray objectAtIndex:rowIndex] == doNotImport) return [NSString stringWithFormat:@"DEFAULT: %@", [fieldMappingTableDefaultValues objectAtIndex:rowIndex]];
- if([[aTableColumn identifier] isEqualToString:@"import_value"] && [importFieldNamesHeaderSwitch state] == NSOnState) {
+ if([[aTableColumn identifier] isEqualToString:SPTableViewImportValueColumnID] && [importFieldNamesHeaderSwitch state] == NSOnState) {
if([NSArrayObjectAtIndex(fieldMappingArray, rowIndex) integerValue]>=[NSArrayObjectAtIndex(fieldMappingImportArray, 0) count])
return [NSString stringWithFormat:@"%@: %@", NSLocalizedString(@"Global value", @"global value"), NSArrayObjectAtIndex(fieldMappingGlobalValues, [NSArrayObjectAtIndex(fieldMappingArray, rowIndex) integerValue])];
@@ -1600,10 +1612,15 @@
}
- else if([[aTableColumn identifier] isEqualToString:@"import_value"] && [importFieldNamesHeaderSwitch state] == NSOffState)
- return [NSArrayObjectAtIndex(NSArrayObjectAtIndex(fieldMappingImportArray, fieldMappingCurrentRow), [NSArrayObjectAtIndex(fieldMappingArray, rowIndex) integerValue]) description];
+ else if([[aTableColumn identifier] isEqualToString:SPTableViewImportValueColumnID] && [importFieldNamesHeaderSwitch state] == NSOffState) {
+ id value = NSArrayObjectAtIndex(NSArrayObjectAtIndex(fieldMappingImportArray, fieldMappingCurrentRow), [NSArrayObjectAtIndex(fieldMappingArray, rowIndex) integerValue]);
+ if(value)
+ return [value description];
+ else
+ return @"";
+ }
- else if([[aTableColumn identifier] isEqualToString:@"operator"]) {
+ else if([[aTableColumn identifier] isEqualToString:SPTableViewOperatorColumnID]) {
if([aCell objectValue] == doImport)
return NSLocalizedString(@"Import field", @"import field operator tooltip");
else if([aCell objectValue] == doNotImport)
@@ -1614,11 +1631,11 @@
return @"";
}
- else if([[aTableColumn identifier] isEqualToString:@"target_field"])
+ else if([[aTableColumn identifier] isEqualToString:SPTableViewTargetFieldColumnID])
return [fieldMappingTableColumnNames objectAtIndex:rowIndex];
}
else if(aTableView == globalValuesTableView) {
- if ([[aTableColumn identifier] isEqualToString:@"global_value"])
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewGlobalValueColumnID])
return [fieldMappingGlobalValues objectAtIndex:numberOfImportColumns + rowIndex];
}
return @"";
@@ -1628,7 +1645,7 @@
{
if(aTableView == fieldMapperTableView) {
- if ([[aTableColumn identifier] isEqualToString:@"target_field"]) {
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewTargetFieldColumnID]) {
if([toBeEditedRowIndexes containsIndex:rowIndex]) {
NSTextFieldCell *b = [[[NSTextFieldCell alloc] initTextCell:[fieldMappingTableColumnNames objectAtIndex:rowIndex]] autorelease];
[b setEditable:YES];
@@ -1651,7 +1668,7 @@
}
}
- else if ([[aTableColumn identifier] isEqualToString:@"type"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewTypeColumnID]) {
if([toBeEditedRowIndexes containsIndex:rowIndex]) {
[aTableColumn setDataCell:typeComboxBox];
return [fieldMappingTableTypes objectAtIndex:rowIndex];
@@ -1671,8 +1688,13 @@
}
}
- else if ([[aTableColumn identifier] isEqualToString:@"import_value"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewImportValueColumnID]) {
+ // Check if all global value was deleted, if so set assigned field as doNotImport
+ if([[fieldMappingArray objectAtIndex:rowIndex] intValue] >= [fieldMappingButtonOptions count])
+ [fieldMappingOperatorArray replaceObjectAtIndex:rowIndex withObject:doNotImport];
+
if ([[aTableColumn dataCell] isKindOfClass:[NSPopUpButtonCell class]]) {
+
NSPopUpButtonCell *c = [aTableColumn dataCell];
NSMenu *m = [c menu];
[m setAutoenablesItems:NO];
@@ -1685,7 +1707,8 @@
if([[self selectedImportMethod] isEqualToString:@"UPDATE"])
[c addItemWithTitle:NSLocalizedString(@"Match Field", @"match field menu item")];
[m addItem:[NSMenuItem separatorItem]];
- [c addItemWithTitle:NSLocalizedString(@"Add Value or Expression…", @"add global value or expression menu item")];
+ NSMenuItem *menuItem = [m addItemWithTitle:NSLocalizedString(@"Add Value or Expression…", @"add global value or expression menu item") action:@selector(addGlobalSourceVariable:) keyEquivalent:@"g"];
+ [menuItem setKeyEquivalentModifierMask:(NSAlternateKeyMask|NSCommandKeyMask)];
[c addItemWithTitle:[NSString stringWithFormat:@"DEFAULT: %@", [fieldMappingTableDefaultValues objectAtIndex:rowIndex]]];
[[m itemAtIndex:[c numberOfItems]-1] setEnabled:NO];
@@ -1699,7 +1722,7 @@
}
}
- else if ([[aTableColumn identifier] isEqualToString:@"operator"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewOperatorColumnID]) {
if ([[aTableColumn dataCell] isKindOfClass:[NSPopUpButtonCell class]]) {
[(NSPopUpButtonCell *)[aTableColumn dataCell] removeAllItems];
[(NSPopUpButtonCell *)[aTableColumn dataCell] addItemsWithTitles:fieldMappingOperatorOptions];
@@ -1710,15 +1733,15 @@
else if(aTableView == globalValuesTableView) {
- if ([[aTableColumn identifier] isEqualToString:@"value_index"]) {
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewValueIndexColumnID]) {
return [NSString stringWithFormat:@"%ld.", numberOfImportColumns + rowIndex + 1];
}
- else if ([[aTableColumn identifier] isEqualToString:@"global_value"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewGlobalValueColumnID]) {
return [fieldMappingGlobalValues objectAtIndex:numberOfImportColumns + rowIndex];
}
- else if ([[aTableColumn identifier] isEqualToString:@"sql"])
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewSqlColumnID])
return [fieldMappingGlobalValuesSQLMarked objectAtIndex:numberOfImportColumns + rowIndex];
}
@@ -1743,7 +1766,7 @@
{
if(aTableView == fieldMapperTableView) {
- if ([[aTableColumn identifier] isEqualToString:@"import_value"]) {
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewImportValueColumnID]) {
if([anObject integerValue] > [fieldMappingButtonOptions count]) {
// Ignore field - set operator to doNotImport
if([anObject integerValue] == [fieldMappingButtonOptions count]+1) {
@@ -1797,7 +1820,7 @@
}
- else if ([[aTableColumn identifier] isEqualToString:@"target_field"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewTargetFieldColumnID]) {
if(newTableMode || [toBeEditedRowIndexes containsIndex:rowIndex]) {
if([(NSString*)anObject length]) {
[fieldMappingTableColumnNames replaceObjectAtIndex:rowIndex withObject:anObject];
@@ -1805,7 +1828,7 @@
}
}
- else if ([[aTableColumn identifier] isEqualToString:@"type"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewTypeColumnID]) {
if(newTableMode || [toBeEditedRowIndexes containsIndex:rowIndex]) {
if([(NSString*)anObject length]) {
[fieldMappingTableTypes replaceObjectAtIndex:rowIndex withObject:anObject];
@@ -1817,7 +1840,7 @@
}
}
- else if ([[aTableColumn identifier] isEqualToString:@"operator"]) {
+ else if ([[aTableColumn identifier] isEqualToString:SPTableViewOperatorColumnID]) {
if([fieldMappingOperatorArray objectAtIndex:rowIndex] == doNotImport) {
[fieldMappingOperatorArray replaceObjectAtIndex:rowIndex withObject:anObject];
[fieldMappingArray replaceObjectAtIndex:rowIndex withObject:lastDisabledCSVFieldcolumn];
@@ -1829,7 +1852,7 @@
}
}
else if(aTableView == globalValuesTableView) {
- if ([[aTableColumn identifier] isEqualToString:@"global_value"]) {
+ if ([[aTableColumn identifier] isEqualToString:SPTableViewGlobalValueColumnID]) {
[fieldMappingGlobalValues replaceObjectAtIndex:(numberOfImportColumns + rowIndex) withObject:anObject];
@@ -1854,7 +1877,7 @@
for(id item in recents)
[recentGlobalValueMenu addItemWithTitle:item action:@selector(insertRecentGlobalValue:) keyEquivalent:@""];
- } else if ([[aTableColumn identifier] isEqualToString:@"sql"]) {
+ } else if ([[aTableColumn identifier] isEqualToString:SPTableViewSqlColumnID]) {
[fieldMappingGlobalValuesSQLMarked replaceObjectAtIndex:(numberOfImportColumns + rowIndex) withObject:anObject];
}
}