diff options
| author | Bibiko <bibiko@eva.mpg.de> | 2010-03-04 14:17:35 +0000 |
|---|---|---|
| committer | Bibiko <bibiko@eva.mpg.de> | 2010-03-04 14:17:35 +0000 |
| commit | d63dff9e7b9f88799b5fa753c8a3510404aa17b8 (patch) | |
| tree | da8df9d549147a108f3d2095b0a8b8514f1f0018 /Source/TableDump.h | |
| parent | e9d08a697eaf44b1c620706d55dd619f77d33af1 (diff) | |
| download | sequelpro-d63dff9e7b9f88799b5fa753c8a3510404aa17b8.tar.gz sequelpro-d63dff9e7b9f88799b5fa753c8a3510404aa17b8.tar.bz2 sequelpro-d63dff9e7b9f88799b5fa753c8a3510404aa17b8.zip | |
• CSV Import Field Mapper
- added UPDATE method which allows to configure an import statement à la:
UPDATE t1 SET col1=foo1, col2=foo2 WHERE col3=baz1 AND col4=baz2
- Insert remaining rows (which are not matched) isn't implemented yet
- note: further tests are needed to ensure it works as expected
Diffstat (limited to 'Source/TableDump.h')
| -rw-r--r-- | Source/TableDump.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/Source/TableDump.h b/Source/TableDump.h index 3855fe57..8f785f72 100644 --- a/Source/TableDump.h +++ b/Source/TableDump.h @@ -116,6 +116,7 @@ typedef enum _SPExportModes { BOOL fieldMappingArrayHasGlobalVariables; BOOL csvImportMethodHasTail; BOOL insertRemainingRowsAfterUpdate; + BOOL importMethodIsUpdate; NSUInteger exportMode; NSUserDefaults *prefs; @@ -144,6 +145,7 @@ typedef enum _SPExportModes { - (void)openPanelDidEnd:(NSOpenPanel *)sheet returnCode:(NSInteger)returnCode contextInfo:(NSString *)contextInfo; - (BOOL) buildFieldMappingArrayWithData:(NSArray *)importData isPreview:(BOOL)dataIsPreviewData ofSoureFile:(NSString*)filename; - (NSString *) mappedValueStringForRowArray:(NSArray *)csvRowArray; +- (NSString *) mappedUpdateSetStatementStringForRowArray:(NSArray *)csvRowArray; // Export methods - (BOOL)dumpSelectedTablesAsSqlToFileHandle:(NSFileHandle *)fileHandle; |