aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Add a new SPFileHandle class to support gzip compression and writing on a ↵rowanbeentje2010-04-127-46/+452
| | | | | | | | | | | background thread, and integrate for SQL import: - Implement streaming reading of gzip-compressed files for SQL import - Support exporting SQL dumps into a gzip-compressed file - SPFileHandle supports the most-used subset of NSFileHandle commands for easy integration - Integrate zlib 1.2.4 for improved gzip streaming performance (and support for custom buffer sizes and file offset positions) This implements Issue #571 .
* Forgot to update Localizable.strings for previous commit.stuconnolly2010-04-112-4/+4
|
* Add a 'Show Create Syntax...' menu item to the tables list context menu and ↵stuconnolly2010-04-112-22/+57
| | | | 'gear' menu.
* • Import from ClipboardBibiko2010-04-101-0/+2
| | | | - forgotten to remove the temp file after importSQL successfully
* • added "Import from Clipboard" ⌥⇧⌘IBibiko2010-04-107-18/+159
| | | | | | - sheet showing the first 4kB of pasteboard content and the SQL/CSV accessory view - pasteboard content will be saved as temp file and read by using the current table/connection encoding
* When displaying a table/view's create syntax in the extended table ↵stuconnolly2010-04-092-5/+7
| | | | information view or create syntax sheet remember to append a semi-colon. Fixes issue #629.
* • improved querying db structure handlingBibiko2010-04-071-1/+6
| | | | - distinguish between any update tables list invoked by SP which causes a weak and quick refresh if nothing was changed and if the user pressed Table List Refresh button explicitly which will cancel any current db querying and pending ones
* Tried to fine-tune the auto-completion behaviour esp. for automatically ↵Bibiko2010-04-073-3/+57
| | | | | | inserted suggestions and increased the minimum auto-complete delay to 0.5s since below that a fight between computer speed and user typing speed could occur. This addresses i625.
* - Improve .spf handling of blank passwords; allow empty passwords to be ↵rowanbeentje2010-04-061-4/+4
| | | | saved (this addresses http://spbug/l/75), and correctly restore empty passwords
* File header typo.stuconnolly2010-04-061-1/+1
|
* • overlapping of completion windows after refreshing its content if db ↵Bibiko2010-04-063-4/+22
| | | | | | structure fetching was finished - for some reasons it could happen that the timer? fires twice, to avoid this changed the re-invocation strategy
* fix for referential action not showing in relations view in certain ↵mtvee2010-04-061-2/+2
| | | | circumstances
* • CSV ImportBibiko2010-04-061-8/+45
| | | | | - ensure that if the connection is lost while importing all relevant allocated objects are released including the import pool - any error which cancels the import process will also release all retained global variables coming from the field mapper
* in Preferences > Favorite ask for confirmation before removing the selected ↵Bibiko2010-04-061-30/+61
| | | | favorite
* If user selects the Query Editor window set always the focus on the text ↵Bibiko2010-04-061-2/+2
| | | | view regardless if the content is empty or not, since it's very likely that the user wants to change it. This should solve i483.
* • completion listBibiko2010-04-061-43/+54
| | | | | - unified scroll behaviour - fixed some issues if animated "fetching data…" row is displayed incl. a fix to avoid overlapping completion windows
* - Improve on r2050, running reconnections after a proxy disconnect on a new ↵rowanbeentje2010-04-041-0/+2
| | | | thread to allow the UI to update and handle events on 10.6. Also clean up the logic in MCPConnection waiting for a proxy discoonect to handle more cases and simplify code.
* Don't append a semi-colon to console messages that are errors.stuconnolly2010-04-041-1/+8
|
* Default the reseting a table's auto increment value to on when removing all ↵stuconnolly2010-04-031-1/+1
| | | | rows from a table.
* - Initialise prefs controller before setting Sparkle delegaterowanbeentje2010-04-022-6/+8
| | | | | | - Move sparkle prefs reset from 2056 to 2057 - Tweak prefs key binding to the user preference stats enabled key rather than the overall Sparkle stats enabled key
* - Reset automatic software update (Sparkle) prefs so that users will be ↵rowanbeentje2010-04-021-0/+6
| | | | prompted for profile submission preference
* - Fix an intermittent crasher - occurring most often when sorting tables - ↵rowanbeentje2010-04-022-2/+2
| | | | by using copies of data store objects when the data store is being updated. This addresses http://log.sequelpro.com/view/20 and http://log.sequelpro.com/view/88
* Although the table content field drop down should always be populated and ↵stuconnolly2010-04-011-1/+1
| | | | selected, make sure to check that the value returned is not nil/NULL before we perform any regex with it. Fixes exception http://log.sequelpro.com/view/95.
* - Improve SPSSHTunnel question/password dialogs to no longer eat 100% CPU ↵rowanbeentje2010-03-313-29/+35
| | | | | | | | by switching from NSCondition blocking to NSLock blocking - Improve behaviour of SSH tunnels with no password in keychain - prompt appropriately - Set MXPConnection to check the proxy state when attempting to reconnect a dropped connection, extending the timer when an auth UI is up. This prevents a multiple-dialogs misbehaviour (or sometimes deadlock), addressing the last part of http://log.sequelpro.com/view/86 .
* • ensure that the global schema structure data for completion are updated ↵Bibiko2010-03-313-11/+10
| | | | even if SP is not active
* More tidy up. Constants and functions.stuconnolly2010-03-316-29/+31
|
* • fixed issue for refreshing the completion list after finishing the ↵Bibiko2010-03-311-2/+2
| | | | | | structure querying - set variable directly and call [self close] explicitly
* Tidy up imports and fix 'Reverse Sort Order' when sorting connection ↵stuconnolly2010-03-3143-51/+39
| | | | favorites (Thanks Hans).
* • fixed issue for completion window if animated sync icon is shownBibiko2010-03-311-6/+25
| | | | | - init all column' data cells according to their settings to avoid jittering and font size change - this fix also removed one issue for 'overlapping' completion windows
* Manually set the connection favorites button bar delegate to ensure the ↵stuconnolly2010-03-313-2/+7
| | | | split view delegate methods are called.
* check for the attributed string length >= 3 while truncating it to avoid ↵Bibiko2010-03-311-2/+2
| | | | exceptions
* Add a new gear drop down menu to the connection favorites table view ↵stuconnolly2010-03-311-36/+33
| | | | containing the remove, duplicate and sort favorites menu items. Also, fix the selection of newly added and duplicated favorites because of sorting options being applied.
* • if document window will close sent a ↵Bibiko2010-03-313-4/+16
| | | | | | 'cancelPreviousPerformRequestsWithTarget' to the custom query editor to stop auto-completion and auto-help timer to avoid crashes after closing • improved some minor stuff for completion's re-invocation
* If the user is viewing the triggers table and then switches to either a proc ↵stuconnolly2010-03-311-0/+9
| | | | or function disable all interface controls.
* • querying for db structure is queued for the same connection to avoid ↵Bibiko2010-03-316-61/+197
| | | | | | | | | | | 'overlapping' access to global variables • after querying db structure write back data on main thread • completion list displays animated sync images if connection is just querying db structure data • fixed some minor issue for completion list • make sure that if last window of a connection is closed all relevant data will be removed from global variables Note: please test!
* Minor tidy up. Remove uneccessary import and rename pre-compiled header.stuconnolly2010-03-312-3/+1
|
* - Improve error checking for various actions, particularly permissions ↵rowanbeentje2010-03-314-16/+92
| | | | errors (NULL data returned) for views and stored procedures. This should fix http://log.sequelpro.com/view/27 , http://log.sequelpro.com/view/57 , and the last of http://log.sequelpro.com/view/53
* When adding a new table with a CSV storage engine, the initial field cannot ↵stuconnolly2010-03-301-11/+26
| | | | be NULL as nullable fields are not supported. Fixes issue #614. Although resolved, this will ultimately be fixed in a better approach upon the implementation of issue #297 that should allow the user to customize many of the properties of the initial field of a new table.
* • next trial to make getAllKeysOfDbStructure thread safeBibiko2010-03-302-59/+107
| | | | | | | | • some speed improvements for navigator - pre-calculate display string for type info to avoid doing it all the time while refreshing the outline view • suppress double-clicking at a not yet queried db structure if the same connection is querying another structure to avoid accessing the same storage objects from different threads (test) • reload outline view after filtering in navigator runs in its own thread to avoid blocking SP • fixed memory leaks while returning [obj copy]
* • some further code optimizations for navigator Bibiko2010-03-302-23/+53
|
* • some speed improvements and code simplifications for navigatorBibiko2010-03-305-43/+41
| | | | | | • avoid making the completion key list unique since it's possible to insert unique items only • added trigger to query db structure after SQL import • some work to avoid http://log.sequelpro.com/view/90 (not yet ideally - WIP)
* - Ensure Copy [with Column Names]/Copy As SQL are disabled on the trigger ↵rowanbeentje2010-03-292-12/+32
| | | | and relations views. This fixes the copy parts of http://log.sequelpro.com/view/53
* • fixed several threading issues due to threadingBibiko2010-03-291-10/+9
| | | | | - collection classes as NSMutableSet are NOT thread safe! • further tiny speed improvements for navigator
* • added some more sanity checks to avoid exceptions due to threadingBibiko2010-03-291-10/+19
|
* • improved completion suggestion for db schemataBibiko2010-03-293-42/+48
| | | | | | | | - if user typed "foo." and there's an unique schema path regardless cases (like there's an item Foo) show the content of the path Foo - now getUniqueDbIdentifierFor:term returns an array of found type (db or table) and the found string to handle case better for completion • tried to speed up the search in the navigator by using a NSPredicate • [MCPConennection allKeysofDbStructure] - fixed issue while returning if allKeysofDbStructure == nil
* • fixed several issue for completion listsBibiko2010-03-295-27/+97
| | | | | | | • improved gathering and caching of structure data coming from connection windows with the same connection • made the structure querying more stable against threading issues • moved getUniqueDbIdentifierFor from MCPConnection to SPNavigatorController to be up-to-date in all connection windows • improved detection if db structure querying should be performed or not (not yet finished)
* - db structure for tables and views will now be queried by using SHOW… ↵Bibiko2010-03-284-60/+79
| | | | | | | | | | | statements - completion now works for server versions < 5 as well - proc/func info will be queried by using information_schema for mysql >= 5 - changed completion logic to handle new format - completion will get the info from SPNavigator since this controller caches all information about db structure - optimization and fine-tuning will follow very soon
* - Improve MCPConnection behaviour with respect to run loops and proxies, ↵rowanbeentje2010-03-271-4/+2
| | | | | | | improving both proxy disconnection and reconnection after dropped connections - Slightly tweak SPSSHTunnel to improve proxy behaviour
* Add the ability to sort the connection favorites table view in the ↵stuconnolly2010-03-275-8/+126
| | | | preferences. Sort options are by name, host or type as well as the option to be sorted in reverse order. This implements issue #490.
* - When switching tables, correctly catch disconnections and suppress error ↵rowanbeentje2010-03-274-25/+25
| | | | | | | | | dialogs and related crashes - Move connection error sheet close method to the connection delegate - Tweak the information_schema db schema building query to be much faster on busy servers by amending the VIEW part - Set the connection lock to nil after releasing, coping with connection unlocks deferred on the main thread until after dealloc