diff options
| author | Bibiko <bibiko@eva.mpg.de> | 2010-03-06 14:42:51 +0000 |
|---|---|---|
| committer | Bibiko <bibiko@eva.mpg.de> | 2010-03-06 14:42:51 +0000 |
| commit | ecbc556ad0ed6e6c66c76145085a524bf8d6035d (patch) | |
| tree | 54f4c7513026113ab0baef757e0983325eb66f2e /Source/SPFieldMapperController.h | |
| parent | 54da3a6b973deb893ce9c8d094ce37ef4c66f9d6 (diff) | |
| download | sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.tar.gz sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.tar.bz2 sequelpro-ecbc556ad0ed6e6c66c76145085a524bf8d6035d.zip | |
• CSV Import Field Mapper
- added to INSERT advanced option "Skip existing rows"
This option allows to insert only those source file rows which primary keys do not exist. It executes INSERT INTO … ON DUPLICATE KEY UPDATE `pri_key_name` = `pri_key_name`. This statement suppresses all warnings/errors regarding to duplicates pri keys etc. BUT it gives an error if an INSERT… statement of a remaining row was erroneous.
Diffstat (limited to 'Source/SPFieldMapperController.h')
| -rw-r--r-- | Source/SPFieldMapperController.h | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/Source/SPFieldMapperController.h b/Source/SPFieldMapperController.h index 7db0f5c9..26491bf0 100644 --- a/Source/SPFieldMapperController.h +++ b/Source/SPFieldMapperController.h @@ -62,6 +62,7 @@ IBOutlet id lowPriorityReplaceCheckBox; IBOutlet id lowPriorityUpdateCheckBox; IBOutlet id highPriorityCheckBox; + IBOutlet id skipexistingRowsCheckBox; IBOutlet CMTextView *onupdateTextView; IBOutlet id advancedButton; @@ -96,6 +97,8 @@ BOOL fieldMappingImportArrayIsPreview; BOOL importFieldNamesHeader; BOOL showAdvancedView; + BOOL targetTableHasPrimaryKey; + NSString *primaryKeyField; NSNumber *lastDisabledCSVFieldcolumn; MCPConnection *mySQLConnection; |