aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Various export enhancements and fixes, including:stuconnolly2010-08-1229-638/+1183
| | | | | | | | | | | | - 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.
* Column autosizing:rowanbeentje2010-08-121-1/+5
| | | | | | - Handle "(not loaded)" placeholders; this addresses http://spbug.com/l/1420 - Fix row inspection of widely-spaced rows for large, fast-loading tables, ensuring up to maxRows rows are inspected
* • NavigatorBibiko2010-08-121-11/+18
| | | | | | | - searches only for pattern length greater than 1 - improved connection detection for search if connection itself is selected - improved exceptions handling - improved first display refresh
* • while closing a doc window or quitting the app wait for removing the ↵Bibiko2010-08-121-1/+1
| | | | connection structure data used by the Navigator/Completion List to avoid exceptions or crashes
* • some minor work on NavigatorBibiko2010-08-122-18/+31
| | | | | | | - refresh on first init - sped up sorting a bit - code improvements - removed Quick Access since it can be outsourced (in the future)
* Implement column autosizing for the Content View:rowanbeentje2010-08-124-27/+294
| | | | | | | | - Add automatic column sizing (for columns without saved widths) as part of the value loading process - Rework table updates to be timer based, for time-based and more regular updates. This improves speed and allows tables to update more consistently. This results in overall smoother table loads, faster table loads, and autosizing columns. This partially implements Issues #271 and #272. Column autosizing will likely be tweaked, and this will all also be extended to Custom Query views in a future patch.
* • db schema names à la db.table.field or real numbers like 1.234 are ↵Bibiko2010-08-111-0/+31
| | | | | | | | | treated as one 'word' while navigating/selecting by the keyboard - first patch for solving issue 588 - needs to be tested if this behaviour doesn't disturb other issues Note: it's in some sort tricky since the selection direction isn't caught yet
* • added key stroke CTRL+= to increasing the font size to be consistent ↵Bibiko2010-08-101-1/+1
| | | | with the Mac standard
* • while exporting SQL skip safely non-existing tables (due to encoding ↵Bibiko2010-08-101-195/+199
| | | | problems or others) and write an error message to the file regardless the "Add Error" setting
* • remember user's last setting for "Resetting AUTO_INC" while deletion of ↵Bibiko2010-08-103-5/+11
| | | | all rows in a table
* • Quicklook generatorBibiko2010-08-101-4/+13
| | | | | | - increased default preview height for sql files - increased default preview heigth for spfs files if more than one connection - show for spfs files all windows in reversed order to show the active window on top
* • added first implementation for spfs file QuicklookBibiko2010-08-101-0/+141
|
* • Quicklook generatorBibiko2010-08-091-2/+29
| | | | | - improved icon display by choosing an adequate image of of the icns file - set background to white for all different spf files to be consistent
* • SQL file Quicklook generatorBibiko2010-08-091-54/+58
| | | | - sped up HTML rendering for larger files
* • SQL file Quicklook generatorBibiko2010-08-091-62/+86
| | | | | - truncate SQL files larger than 500k - changed encoding detection: try utf-8, if it fails let Cocoa to detect the enc, if it fails fall back to latin1
* • added syntax highlighting for SQL file QuickLook generatorBibiko2010-08-061-5/+70
| | | | - only SQL files with less than 3MB will be syntax highlighted
* • added svn prop Id to GeneratePreview/ThumbnailForURL.mBibiko2010-08-052-264/+146
| | | | | • added SP's SPData/StringAdditions to QuickLook generator to avoid double-coding • cleaned generator code a bit
* - Add an initial Sequel Pro QuickLook plugin, written by bibiko, as a build ↵rowanbeentje2010-08-043-0/+651
| | | | dependency
* - Fix menu item and window close issues after a tab is dragged to a new ↵rowanbeentje2010-08-031-1/+2
| | | | window, including for single tabs in windows moved by their tabs
* Improve tab dragging:rowanbeentje2010-08-032-1/+3
| | | | | | - Fix toolbar issues when the last tab is dragged "out of" a window (eg a window is moved via the only tab left inside it) - Fix window positioning flicker when dragging a tab out of its window
* - Make another couple of strings localisable, and tweak layout of CREATE ↵rowanbeentje2010-08-011-2/+2
| | | | indexes view labels
* - Make a few more strings localizablerowanbeentje2010-08-016-21/+21
|
* - Make SSH titlebar strings and preferences' favourite "Last Used" menu ↵rowanbeentje2010-08-012-3/+3
| | | | item localisable
* - Improve SPDataStorage exceptions by recording the requested location and ↵rowanbeentje2010-08-011-7/+7
| | | | the storage range
* - Replace progress indicator CoreAnimation drawing with manual shadow/fade ↵rowanbeentje2010-07-313-6/+46
| | | | | | | code; this addresses hangs (see Issue #6677) and also prevents triggering the discrete graphics chip on newer MacBook Pros. - Update localisable strings
* Replace redundant code with newly established methods.stuconnolly2010-07-302-51/+11
|
* - Add support for automatically converting \r and \r\n linebreaks in query ↵rowanbeentje2010-07-294-160/+367
| | | | | | | | syntax to \n. This addresses Issue #652. - Clean up SPSQLParser, and use a few more CFString methods to avoid obj-c messaging in loops - When importing SQL using autodetect, perform a manual SET NAMES if possible to cope with poorly-exported files.
* - Replace core animation fade of task progress window with custom drawing ↵rowanbeentje2010-07-252-24/+31
| | | | code, in an attempt to fix Issue #677. It appears from testing that this is only a partial fix, but does reduce hang frequency.
* During a CSV export if the user selects the tab as the separator update the ↵stuconnolly2010-07-252-1/+18
| | | | extension to be .tsv
* Tidy up SPExportController by splitting out all filename related methods to ↵stuconnolly2010-07-2513-195/+244
| | | | a new category SPExportFilenameUtilities.
* Make the export dialog a little smarter with regard to the current context. ↵stuconnolly2010-07-254-26/+50
| | | | | | | | | | | For example: If either the table content or custom query editor views are active and there is data available, these options will be selected as the export source ('Filtered' or 'Query Result'). If either of these views are not active then the default source are the currently selected tables. If no tables are currently selected then all tables are checked. Note that in this instance the default export type is SQL where as in the case of filtered or query result export the default type is CSV. Also remove some old export methods. Related to issue #610.
* - Fix positioning bug when using Import From Clipboardrowanbeentje2010-07-252-25/+80
| | | | | - Add controllable encoding support when importing CSV and SQL files, including a new default "Autodetect" option. Add UniversalDetector framework to support encoding autodetection. This should address Issue #720.
* - Fix a bug in the bz2 changes causing the first three bytes to be skipped ↵rowanbeentje2010-07-241-0/+1
| | | | when reading uncompressed files
* In addition to Gzip compression support when exporting SQL dumps add the ↵stuconnolly2010-07-2413-176/+369
| | | | | | | | | | | | | | | | | | ability to use Bzip2 compression. Other changes include: + Enable the use of export compression (Gzip and Bzip2) for all export formats. + Move the compression options in the export dialog to the 'Advanced' export settings view. + Simplify the setting of common exporter properties (e.g. the connection, use of compression). + Fix a potential memory leak in the dot exporter. + Update the data importer to recognise Bzip2 compressed files. + Fix several display issues on export dialog. + Restore the default .csv file extension of CSV exports. + Correctly update the default export filename when selecting a output compression type. The addition of Bzip2 compression support implements issue #688.
* - Improve thread safety when altering task cancellation staterowanbeentje2010-07-211-0/+6
|
* Tweak table triggers loading to only proceed for MySQL > 5; this finishes ↵rowanbeentje2010-07-201-1/+3
| | | | the work started in r2201 and should address Issue #748.
* Tab tweaks:rowanbeentje2010-07-201-5/+6
| | | | | | | | - Sheets now appear positioned underneath the tab bar if visible - Tweak bottom corner drawing for a clearer outline, without highlight overlay - Frontmost tab no longer displays server name in the tab Also fix exception when right-clicking on an index to reset auto-increment.
* - Clean up SPDataImport, removing unused methods and cleaning up order and ↵rowanbeentje2010-07-192-184/+189
| | | | | | | | | methods - Improve error handling when the connecting dies during import (previous the sheet would stay open) - Fix localised strings for error messages (label and text the wrong way round) - Improve comments
* - Further tweak new table encodings to improve default-utf8 behaviourrowanbeentje2010-07-181-1/+2
|
* - Fix table creation to use the selected encoding instead of always using ↵rowanbeentje2010-07-181-1/+2
| | | | utf8 (broken in r2325)
* - Expose a number of help menu items and help buttons to use localisable ↵rowanbeentje2010-07-1810-29/+23
| | | | | | | | strings - Tweak MySQL help search to include a localisable language code for results in requested languages This addresses Issue #743
* Tweak structure view index collapsing:rowanbeentje2010-07-172-2/+24
| | | | | | | - Make the minimum index view size a little smaller - Add a button to reveal the indexes subview when it is collapsed. This button is hidden when te index view is not collapsed. This addresses Issue #746
* - Tweak custom query autocompletion to no longer show a key-capturing ↵rowanbeentje2010-07-171-2/+6
| | | | invisible empty autocomplete when no autocomplete matches are found
* Export redesign (#610) CSV filename tweaks:rowanbeentje2010-07-171-2/+4
| | | | | | - Don't forcibly include the table name if only exporting a single table, even if the multiple tables checkbox is ticked - Fix additional _null files exported for Filtered Result exports when the multiple tables checkbox is ticked. Also addresses leaking write threads for those files.
* Make the 'Export' menu item in the 'File' menu behave more like the export ↵stuconnolly2010-07-154-23/+12
| | | | context menu by checking only the selecting tables. If no tables are selected all of them are checked by default (the same as before). Fixes issue #755.
* Improve handling of BIT fields, including:stuconnolly2010-07-153-19/+29
| | | | | | | | | - Exporting BIT fields properly in SQL dumps using b'x' notation. - Properly handling editing of BIT fields in both the content and custom query results views. - Correctly display BIT fields in the content view, where binary values are zero-padded to the specified length of the field. (Note, that the new BIT handling logic has only been added to MCPKit's MCPStreamingResult and MCPResult as the latter does not keep a record of the field's length which the new functionality depends on. Needs to be discussed).
* - Don't localize table types when duplicating tables - used as part of ↵rowanbeentje2010-07-151-4/+6
| | | | queries. This addresses Issue #762.
* Improve handling of network drops, including a new automatic reconnection ↵rowanbeentje2010-07-131-8/+7
| | | | | | | | | | | | | attempt, as well as improved handling of networks not present. This addresses Issue #657. In MCPKit: - Disable MySQL automatic reconnection, and add our own reconnection code for greater consistency - If no network is available, delay reconnects by a short period to allow the network to come back up - Improved handling of proxy disconnects In SPSSHTunnel: - Improved handling of SSH tunnel disconnects, improving automatic reconnection via MCPKit and fixing potential memory/logic tramping. Also remove the "Retry" button from the Disconnected dialog, leaving only the choices "Reconnect" or "Disconnect".
* Added support for edit triggers. Doubleclick on a row and the Add trigger ↵bamse162010-07-112-5/+92
| | | | | | | | | | | | | | pops up with all the fields prepopulated. Edit works as 'DROP' old trigger and then 'CREATE' new trigger (since MySQL doesn't have support for 'ALTER' trigger). In case of error while adding the new trigger, when you add a new trigger, all the info from the original trigger is preserved. (Don't know if this is the best solution).
* When searching for the location of the user's Desktop as the default ↵stuconnolly2010-07-091-1/+1
| | | | location of exports, change the search domain to NSAllDomainsMask to accommodate home directories which are not on the startup volume.
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-14 16:52:40 +0000