aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDataImport.m
Commit message (Collapse)AuthorAgeFilesLines
* Add a warning message when trying to import an utf8mb4 SQL file on older ↵Max2016-03-221-1/+30
| | | | MySQL versions (#2452)
* Wrap a repeated call in a simpler methodMax2015-10-251-2/+2
|
* Replace a lot of SPBeginAlertSheet()s with the more concise SPOnewayAlertSheet()Max2015-10-201-38/+40
| | | | This should also eliminate a few use-after-free crashes
* * Change a method name to fit standard naming conventionsMax2015-10-081-2/+2
| | | | | | | | | | | | * Remove a redundant ivar (and while we are at it, restructure some code) * And then there was this gem: (...) if (fileMode == O_RDONLY) { int i, c; char bzbuf[4]; const char *charFileMode = fileMode == O_WRONLY ? "wb" : "rb"; (...)
* * Turn some successive onMainThread ops into a blockMax2015-10-081-26/+27
| | | | * Move a lock() that could become unbalanced and theoretically cause havoc
* Fix two cases of "UI manipulation from background thread" (relates to #2248)Max2015-10-011-24/+27
|
* Add some info which might help a bit with debugging threading issuesMax2015-07-021-5/+5
|
* Addition to commit 2735e15bMax2015-01-041-13/+12
|
* Formalize [x release], x = nil; conventionMax2015-01-041-8/+8
| | | | | 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 broken import on 10.6…Max2015-01-021-1/+6
| | | | | (Import would not work on a new installation where a certain preference key has not yet been set) * Also attached the gear menu in table structure view to the table header view, so the columns to show can now be selected by right-clicking on the table header (like in Activity Monitor)
* Fix two threading issuesMax2014-12-231-25/+29
| | | | | * A call of setString: from background thread which could cause a "deleted thread with uncommitted CATransaction" warning * SPFieldMapperController was allocated from a background thread with an own autoreleasepool, while it contains UI objects. This could cause a crash when the autoreleasepool was drained and the field mapper forcefully released, while other UI objects still had it retained.
* Replace some NSDictionaries with literalsMax2014-12-131-2/+2
| | | | | | * [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).
* Reformatting code for modern ObjCMax2014-12-131-6/+6
| | | | | 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-6/+4
|
* 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
|
* Remove use of deprecated save panel method.Stuart Connolly2013-11-271-37/+32
|
* Allow opened SQL files to be saved back to the original file, addressing ↵rowanbeentje2013-09-081-20/+7
| | | | | | | | | Issue #1805: - Add new menu item for "Save Query", making the existing item "Save Query As" as an alternate - Track the opened SQL file and used encoding to be able to easily save the same file again - Standardise encoding detection to use the UniversalDetector framework and use that for opened SQL files where the encoding menu is not used
* - Address further Release/Distribution build warningsrowanbeentje2013-05-221-1/+1
|
* - Fix all the Xcode 4.6.2 build warnings, and tweak warning settings to ↵rowanbeentje2013-05-211-0/+1
| | | | enable some more
* Remove useless init and dealloc method comments and perform general tidy up.stuconnolly2013-01-221-9/+0
|
* - Add names for most threads created by Sequel Pro for easier debugrowanbeentje2012-10-141-6/+7
|
* * Rename latin1_german_ci to latin1_german1_ci (checking with mysql3.23 ↵dmoagx2012-10-031-0/+1
| | | | sources and mysql doc that seems to have always been it's name?) #1476
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-12/+20
|
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-1/+1
| | | | | | | fix nightly builds - Fix warnings
* - Fix an exception when attempting to preserve the selection in a table ↵rowanbeentje2012-03-241-6/+6
| | | | | | | | 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
* More bugfixes to the SPMySQL integration branch:rowanbeentje2012-03-141-2/+2
| | | | | | - Fix background database structure checks throwing exceptions at the end of certain table operations - Fix incorrect timer access/overrelease when closing a SPNarrowDownCompletion window when database structure fetching is active
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-22/+24
| | | | | | | | | | | | 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
* - Cleanup: improve compatibility with 10.7 SDK to reduce compiler warningsrowanbeentje2012-02-081-1/+1
|
* - Add a new CSV import field escape setting, as a new default, supporting ↵rowanbeentje2012-01-061-1/+6
| | | | both backslash and double-character escaping. This will mean the vast majroty of CSVs selected for import will be read correctly by default, fixing issues such as Issue #1252
* - Speculative fix for Issue #1154 (problems using some field separators ↵rowanbeentje2011-09-121-0/+3
| | | | during CSV import)
* - If the field mapper was cancelled, abort the CSV import at once to avoid ↵rowanbeentje2011-08-251-4/+10
| | | | crashes if a new table name to create was entered
* Minor tidy up.stuconnolly2011-07-111-35/+34
|
* - When importing CSVs, or editing custom query results, set numeric fields ↵rowanbeentje2011-05-091-2/+23
| | | | to NULL instead of 0 if an empty string is entered. This matches TableContent behaviour and addresses Issue #1034.
* - Fix progress bar accuracy when importing gzipped or bzipped CSVsrowanbeentje2011-05-081-11/+35
|
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-081-9/+10
|
* fixed compiler warningssqlprodev2011-03-011-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-1/+0
|
* • fixed bug while CSV Import for method UPDATE and INSERT remaining rows Bibiko2011-02-151-1/+1
| | | | | | - appended a ',' to the wrong NSString - fixes i978
* - Show and hide the custom query info area based on whether custom query ↵rowanbeentje2010-12-041-0/+1
| | | | | | | | | | errors occurred, starting off hidden - Add "errors"/"no errors" prefix to the custom query status area - Add an import cancelled line to the import error list when stopping imports after errors - Fix custom query error highlighting by scrolling to the error - Update localisable strings
* - Change the CSV import accessory view to a general import accessory view, ↵rowanbeentje2010-11-291-4/+40
| | | | | | | | | based on a tab view - When importing SQL, use the accessory view to ask how to handle errors: Ask (the new default), which prompts the user on each error whether to continue, stop, or ignore all errors; and ignoring all errors, which matches the old behaviour. This addresses Issue #901. - When showing the reconnection dialog ensure the window isn't minimised - Update localisable strings
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-5/+1
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* • CSV import now supports to import sequences of 0 and 1 into BIT fieldsBibiko2010-10-311-9/+40
| | | | | | • 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
* - Fix incorrect quoting of BLOB fields on SQL exportsrowanbeentje2010-10-251-3/+14
| | | | | | - Use indeterminate progress bars when importing BZIPped SQL files - Support .tsv as a CSV extension, and automatically choose the field delineator based on .csv/.tsv extension
* CSV Import Field MapperBibiko2010-10-251-25/+16
| | | | | | | | - 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-4/+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-6/+86
| | | | | - 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
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+1
|
* • fixed issue of unnecessary string escaping for importing spatial data ↵Bibiko2010-10-101-1/+1
| | | | | | via GeomFromText() • minor code cosmetics
* • enabled SRID editing of spatial fields via WKT stringBibiko2010-10-091-1/+1
| | | | | - the SRID value will be appended at the WKT string like POINT(1 1),101 which will be transformed to GeomFromText('POINT(1 1)',101) on the fly - otherwise the SRID information will be deleted after editing a geometry field
generated by cgit v1.2.3 (git 2.25.1) at 2024-09-19 14:09:22 +0000