aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPExportFileUtilities.m
Commit message (Collapse)AuthorAgeFilesLines
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-1/+1
| | | | | | | fix nightly builds - Fix warnings
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-0/+1
| | | | | | | | | | | | 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
* Minor tidy up.stuconnolly2011-07-111-11/+22
|
* Add the option to the SQL export view as to whether or not the ↵stuconnolly2011-07-101-6/+5
| | | | AUTO_INCREMENT value on a table's structure is included. Defaults to not included. Implements issue #1064.
* * Fixes most parts of #1006 (Translation of file names)dmoagx2011-05-101-1/+1
| | | | * Update strings files
* Implement a large number of minor fixes and improvements to export ↵rowanbeentje2011-05-071-30/+112
| | | | | | | | | | | | | | | | | | | | | | functionality, including an overhaul of filename NSTokenField functionality: - Improve the NSTokenField used for export filenames: only tokenise reserved tokens, don't tokenise reserved words which are parts of other words, allow the comma to be used, update tokenisation during typing, and prevent whitespace triming. - Save the last selected export path, and make the path selection button open a dialog to the selected directory - Save the export filename and restore on future uses of the export dialog (only if the name contains placeholder tokens, so one-off export names aren't saved) - If the advanced options are collapsed, display a summary of the selected options next to the disclosure triangle - Display a small warning in the corner of the window if the export file cannot be imported into Sequel Pro, to warn those people attempting to back up their databases in XML - Clarify and improve the export warning dialog if files already exist or could not be created; make the simpler file-exists cases reflect OS-style dialogs, alter wording based on the number of files that failed and how they failed, and only show the "replace" or "skip" type buttons if it makes sense to do so. - Fix a mutation-during-enumeration error when skipping files - If "Cancel" is chosen in the export file creation replace/error dialog, redisplay the export sheet with the previous selection still active - Add support for year, month and day tokens in the filename token list - Don't allow blank custom filenames, before or after tokenisation, as this can cause problems - instead fall back to default filenames in those cases - Only append the extension if one hasn't been set - on all export formats, extending r3284 - If exporting to multiple files option is enabled but only one table is selected, supply that table name for filename table tokens - Update the progress bar to reflect update progress when exporting CSV data - Fix a bug causing exports to hang if the low-memory advanced option was set and content was selected to export and any empty tables were encountered - Save memory use and compression advanced export settings across sessions - Update localisable strings
* Fix more warnings.stuconnolly2011-03-131-5/+0
|
* - Fix compiler warnings for MCPKit - largely typecast relatedrowanbeentje2011-03-021-2/+11
| | | | | | | | | - Fix further compiler warnings, including a couple of bugs - Disable the -wselector warnings (Multiple definition types for selector) as they're currently unsupported in LLVM - Disable the -wconversion warnings (Prototype conversion) warnings as we usually can't affect protocol declaration - Disable the -wstrict-selector-match (Strict selector matching) due to too many false positives
* fixed compiler warningssqlprodev2011-03-011-0/+3
|
* When exporting either a filtered or custom query result include the query in ↵stuconnolly2010-11-071-2/+8
| | | | the opening resultset tag that produced the result.
* Complete the implementation of supporting MySQL's XML schema format when ↵stuconnolly2010-11-051-4/+7
| | | | exporting. Also, restore our old format and give the user the choice during export (defaults to MySQL schema). Completes the implementation of issue #840.
* Start moving towards using the same XML format as MySQL uses. The inclusion ↵stuconnolly2010-11-041-1/+5
| | | | of the query executed for filtered and query results as well as the table structure when exporting entire tables still needs to be added. Part of issue #840.
* Localize the header included in SQL and XML exports.stuconnolly2010-10-191-7/+7
|
* If the user chooses to overwrite the output file(s) when performing an ↵stuconnolly2010-08-261-1/+10
| | | | export make sure compression and CSV and XML headers and re-enable/rewritten.
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-1/+1
| | | | | | | | | | | with extended characters in MySQL identifiers (names of dbs/tables/cols): - Move encoding queries and control into MCPKit, with newly cleaned-up methods, and switch a number of locations to using the new code. - Use UTF8 connections for many identifier-based queries (selecting and listing databases, tables, stored procs, table information). This fixes selection and creation of table and database names containing extended characters, also fixing exceptions and errors. - Improve UTF8 over Latin1 to correctly set the client character set encoding as well, fixing custom queries and edits; remove custom code in SPTableContent achieving the same thing in a single location. - Fix database encoding detection routines - Update localisable strings
* • overall replacement of:Bibiko2010-08-201-6/+6
| | | | | | | | | [aString appendString:[NSString stringWithFormat:]] by [aString appendFormat:] since it's much more faster • first look at loop where several [aStr appendString:] occur to try to combine them into one appendString or appendFormat since the allocation of memory takes really time Note: I tested all my changes but we should test it further to be sure that I didn't a mistake!
* Fix release and dist builds.stuconnolly2010-08-161-5/+3
|
* Various export enhancements and fixes, including:stuconnolly2010-08-121-0/+212
- A new SPExportFile class, providing an abstract interface to the handling and creation of export files. - Enables the centralisation of all file/file handle creation logic as well as better support for handling situations where files fail to be created, including files that already exist at the export location. - New SPExportFileHandleStatus constants to support the reporting of file handle creation. - Update SPExporter to use the new file class instead of directly using an instance of SPFileHandle. - Add the necessary logic to deal with files that already exist on disk, by providing the user with 3 options: cancel the export, ignore the files in question or overwrite them. We might want to enhance this to make new files sequential in name to prevent overwriting. Fixes issue #742. - New SPExportFileUtilities category, which centralises all the logic relating to writing export type headers as well as dealing with problems occurred during file/file handle creation. - Improve feedback given on the export progress sheet during export initialisation. - Tidy up and improve comments.