aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPFieldMapperController.m
Commit message (Collapse)AuthorAgeFilesLines
* Fix an exception during CSV field mapping that would occur if a header field ↵Max2016-01-141-6/+13
| | | | mapped to NULL (#2375)
* Fix an exception when right-clicking in the CSV field mapping table without ↵Max2015-11-061-3/+9
| | | | active selection (#2219)
* * Lock connection during disconnect to prevent some race conditionsMax2015-10-301-3/+1
| | | | | * Always use the server version name provided by mysql_get_server_info() as that should me more reliable * Use mysql_get_server_version() for version comparisons. Less code, official API and closer to what mysql does
* Formalize [x release], x = nil; conventionMax2015-01-041-16/+16
| | | | | Take this commit as a proposal to formalize our existing "[x release], x = nil;" convention by introducing a macro for it. Feel free to revert this commit if you see issues with the approch or implementation.
* Fix two minor CSV import dialog issuesMax2014-12-261-22/+24
| | | | | * Tooltips were somewhat broken for non-imported fields (issue exists in 1.0.2) * Newly added expressions would cause the field to switch to "do not import" instead of the added expression
* ************** IMPORTANT: SEE BELOW **************Max2014-12-261-108/+126
| | | | | | | | | This change should fix the "slow CSV import dialog" issue on 10.10 (details below). To accomplish that, some major changes had to be made to the CSV import code. PLEASE VERIFY THE CORRECTNESS OF THE NEXT FEW CSV IMPORTS YOU DO! * Renamed some variables for better search visibility * Changed some instances where NSNumbers were being compared using "==" instead of "isEqual…" (does not work with object literals!) * The CSV import dialog would recreate the popup menus on *every* call to "tableView:objectValueFor…". However Instruments suggests that [NSMenu removeAllItems] and [NSMenu addItemsWithTitles:] are **really** expensive, esp. when called multiple times per second (e.g. when scrolling in the table view). This commit moves the popup menu setup into its own method and only calls it when the data actually changes. * The 'destination table column' was for some reason a NSPopupButtonCell which only ever had one item and sometimes got changed to a NSTextFieldCell in code. I didn't see any need to keep the popup cell and replaced it with a simple text cell.
* Replace some NSDictionaries with literalsMax2014-12-131-4/+3
| | | | | | * [NSDictionary dictionary] → @{} * [NSDictionary dictionaryWithObject:forKey:] can safely be replaced. object==nil would have already thrown a NPE in the past. * Also replaced some (hopefully safe) NSArray initializers (ie. their objects should always exist).
* Replace boxed integers in code with @ literalsMax2014-12-131-5/+5
|
* Reformatting code for modern ObjCMax2014-12-131-4/+4
| | | | | Replaced all [NSNumber numberWithBool:YES/NO] with the @YES/@NO literals. Also replaced some TRUE/FALSE with their YES/NO counterparts.
* Add a hidden preference to control the size of the UI's monospaced font.Stuart Connolly2014-05-261-1/+3
|
* Rework CSV field mapping loops for clarity and to theoretically address Log ↵rowanbeentje2014-04-261-74/+56
| | | | #1596; also address two compiler warnings about unused variables
* Fix an issue where CSV imports could not be started if a zero-length field ↵rowanbeentje2014-04-261-6/+6
| | | | was set to not be imported
* Update URL in source file header to point to GitHub.Stuart Connolly2014-01-261-1/+1
|
* Remove SVN property placeholder.Stuart Connolly2014-01-261-2/+0
|
* Cleaned up Format string is not a string literal (potentially insecure) errorsMarius Ursache2013-11-091-2/+2
|
* - Address further Release/Distribution build warningsrowanbeentje2013-05-221-9/+9
|
* - Fix all the Xcode 4.6.2 build warnings, and tweak warning settings to ↵rowanbeentje2013-05-211-20/+9
| | | | enable some more
* - Add a check for SPNotLoaded values when automatically generating new ↵rowanbeentje2013-02-181-1/+1
| | | | tables when importing CSVs, fixing Issue #1621 (SPNotLoaded values are generated when rows shorter than the header row are seen)
* Fix warnings by not using id for IB outlet references.stuconnolly2013-02-171-8/+7
|
* Changing SP_REFACTOR macro to SP_CODAsqlprodev2013-02-141-14/+14
|
* Remove useless init and dealloc method comments and perform general tidy up.stuconnolly2013-01-221-6/+2
|
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-12/+21
|
* - When creating tables as a result of CSV imports into a new table, ↵rowanbeentje2012-05-291-5/+9
| | | | correctly build the column syntax if the last field(s) are set not to import, addressing Issue #1358.
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-4/+0
| | | | | | | fix nightly builds - Fix warnings
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-0/+4
|
* - Fix an exception when attempting to preserve the selection in a table ↵rowanbeentje2012-03-241-3/+3
| | | | | | | | with a primary key with multiple columns of which the first of which is a blob or binary type - Clean up NSNull comparisons and add comments - Clear the selection when filtering a table, allowing reselection to look a little more consistent
* - Alter the import field mapper controller to support multiple primary keys ↵rowanbeentje2012-03-221-5/+9
| | | | in its current syntax builder by using the improved getter.
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-6/+7
| | | | | | | | | | | | exceptions as database structure retrieval is currently missing! Further work on SPMySQLFramework integration: - Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match - Add new convenience querying and result methods to the framework - Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions - Remove MCPKit from the source - Fix a number of warnings on Release-style builds
* - Fix "Multiple selection" still being displayed after multiple tables are ↵rowanbeentje2011-06-141-8/+6
| | | | | | | | | deleted - If multiple tables are selected when opening the SPFieldMapperController select the first to import into - Clean up tableName in tablesList - now returns nil if no tables are selected or multiple tables are selected, instead of returning an empty string for multiple tables
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-5/+5
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-6/+6
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-24/+4
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-6/+6
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-15/+57
| | | | UI code from functional code
* - Fix exceptions importing CSVs, caused by incorrect warnings cleanup in r3240rowanbeentje2011-03-221-3/+3
|
* - Fix more compiler warningsrowanbeentje2011-03-151-1/+1
| | | | | - Tweak README
* - Fix more warningsrowanbeentje2011-03-141-42/+43
|
* fixed compiler warningssqlprodev2011-03-011-10/+9
|
* • CSV field mapperBibiko2011-02-031-11/+22
| | | | | - reset import operators after each change of the chosen alignment - double-click at PathControl performs goBackToFileChooser delayed in order to avoid time racing issues
* • improve CSV field mapping method to align file header names with table ↵Bibiko2011-02-031-16/+72
| | | | | | | column names - first calculate Levenshtein distance; if it is greater than 0 then subtract the length of shared prefix, suffix, and in common character sequence - avoid mapping of already mapped file header names, instead take the next best match not mapped
* - Fix issues right-clicking in the empty table area ( http://spbug.com/l/1726 )rowanbeentje2010-11-271-1/+2
| | | | | | | - Improve 10.5 compatibility when clearing menus ( http://spbug.com/l/1508 , http://spbug.com/l/1829 , http://spbug.com/l/1818 ) - Fix a possible crash when updating database lists - Update localisable strings
* • CSV import now supports to import sequences of 0 and 1 into BIT fieldsBibiko2010-10-311-1/+3
| | | | | | • fixed several issues while importing a CSV file if this file contains empty lines or if a line has less columns as header - fixed issue for matching header names - fixed issue for user-defined SQL functions while importing; in such a case set the value to @"" to get the defaults
* • try to fix crash issue 1748Bibiko2010-10-291-6/+8
| | | | | - it seems that isKindOfClass: method to check length and data type of the csv source while creating a new table failed for empty cells or NULL; I tried to catch these issues - has to be checked further
* • CSV Import Field mapperBibiko2010-10-251-7/+13
| | | | | - fixed issues for tooltips of user-defined values - avoid double-calling the 'add value' sheet since it can be called via popupmenu and keyboard short-cut
* CSV Import Field MapperBibiko2010-10-251-26/+49
| | | | | | | | - 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
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-3/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* • CSV Import Field Mapper SheetBibiko2010-10-231-7/+77
| | | | | - added the possibility to apply any sql function while importing set via "Add value or expression" sheet eg concat('$2', '$1', length('$3')) whereby $1 $2 $3 are the placeholder for the csv file columns 1 2 3 [first column starts with 1] • fixed ' escaping issue in MCPConnection
* • re-enabled three finger trackpad wiping gesture for controlling the ↵Bibiko2010-10-221-15/+23
| | | | | | | | table history • CSV Import Field Mapper Sheet - fixed issue for inserting a global value containing a ' - started preparations of the "Add value or expression" sheet for future enhancements
* Tidy up.stuconnolly2010-10-191-0/+1
|
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|