aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* Complete the implementation of the management of table triggers (accessible ↵stuconnolly2010-02-061-0/+1
| | | | via Cmd+6). Note, that better support for entering the trigger statement in terms of escaping and delimiter support most likely needs to be added.
* First stab at Schema Privileges. A UI redesign is on its way. Please test ↵mltownsend2010-02-021-1/+1
| | | | on non Production servers
* • Added basic print support for each CMTextViewBibiko2010-02-011-1/+6
| | | | • first steps to renew the field mapper sheet for CSV Import
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-311-0/+24
| | | | | | | | | | | | | | | | | | | | menu item View > Table Triggers (apple-6). Heavily copied from Relations tab, lots of functionality missing. Just lists the triggers for the table now. M Source/SPTableData.m M Source/SPConstants.h M Source/SPConstants.m A Source/SPTableTriggers.h A Source/SPTableTriggers.m M Source/TableDocument.h M Source/TableDocument.m M Source/SPTableData.h M Interfaces/English.lproj/MainMenu.xib M Interfaces/English.lproj/DBView.xib M sequel-pro.xcodeproj/project.pbxproj
* • CMTextView's colours are set via observer, live changed in editable ↵Bibiko2010-01-301-3/+5
| | | | | | | | textviews • added Preference setting "Table font" in "Table" pane to set the table font/size for all result tables (Content, Custom Query) • added to SPTableView the method setFont: • fixed the initialisation of vars in CMTextView (fixes the displaying of create syntax)
* - Ensure the main toolbar items aren't selectable during a task to prevent ↵rowanbeentje2010-01-261-0/+1
| | | | odd update issues
* Improve Disconnection on connection loss:rowanbeentje2010-01-241-14/+19
| | | | | | | | | - Set error strings on MCPConnection on user disconnect to allow existing error chcking to catch the state - Improve close behaviour from threads - Improve window close behaviour and appearance - Add new checks for disconnection in one or two crash-prone locations This addresses Issue #531, one of Issue #532, one of Issue #539, and probable reported crashes on Issue #541.
* • added call to update the completion list to neuralgic placesBibiko2010-01-211-0/+8
| | | | - next steps to minimize the traffic - ie manipulating the dict directly without querying - follows
* Address Issue #546 (format string bugs):rowanbeentje2010-01-201-8/+8
| | | | | | - Fix incorrect uses of [NSString stringWithFormat:] with preconstructed strings and no arguments in SPUserManager - To fix display issues, replace NSBeginAlertSheet (which includes automatic sprintf expansion of the message) with a safely-escaped SPBeginAlertSheet in many files
* • fixed several sheetDidEnd selectors to close a NSAlert or NSWindow ↵Bibiko2010-01-131-1/+8
| | | | | | | properly to avoid overlapping sheets • F5 completion - if a table is selected and no further parsing info is given show that table and its fields at the top of the suggestions
* - Move the query for the database structure to a background processing ↵rowanbeentje2010-01-121-1/+1
| | | | thread, as well as the existing background database connection, for a smoother experience
* - Testing found that r1653 fixed the warnings but for some reason disabled ↵rowanbeentje2010-01-111-0/+1
| | | | the "Stop" button; switch to orderFront: to re-enable without the warnings (thanks to Hans for assistance!)
* • further developments for the F5 completionBibiko2010-01-111-1/+1
| | | | Note: not yet finished!
* • further preparations to F5 completionBibiko2010-01-111-5/+15
| | | | Note: not yet active - only querying the data in background will be performed for testing
* • first preparations to improve the Custom Query database names/table ↵Bibiko2010-01-101-0/+2
| | | | | | | | | names/field names + type and encoding completion - after connecting and updating the table list a background task executed on a different connection will be performed to query the information_schema db (MySQL >= 5 only so far) - the MCPConnection object holds a NSDictionary with all structural data Note: not yet active
* removed:Bibiko2010-01-091-1/+0
| | | | | | | | | [taskProgressWindow orderWindow:NSWindowAbove relativeTo:[tableWindow windowNumber]]; since it causes Console <error> messages mentioning "kCGErrorIllegalArgument" and it is not necessary anymore [thanks to Rowan for the hint]
* - Upgrade Sequel Pro to be compiled as a 3-way PPC/i386/x86_64 binary for ↵rowanbeentje2010-01-091-30/+30
| | | | | | | release builds, including a large number of 64bit compatibility upgrades and tweaks - Upgrade RegexKitLite to 3.3
* • fixed: do not disable User Account if no table is selectedBibiko2010-01-061-2/+9
| | | | • fixed: if user cancelled "Add Database" reselect 'Choose Database Button' instead of displaying "Add Database"
* - Remove two unused variablesrowanbeentje2010-01-031-3/+0
|
* - Ensure all results for server variable requests are returned as strings, ↵rowanbeentje2010-01-031-23/+16
| | | | | | | to avoid binary-mode result issues with certain versions of MySQL (including 4.1.14). This should address Issue #509. - TableDocument now requests the server version string from MCPConnection, aiding caching
* In the database drop down, visually separate 'system' databases (i.e. mysql ↵stuconnolly2009-12-231-13/+32
| | | | and information_schema) from 'user' databases by placing them at the top.
* Remove old redundant code that was left over form when the server variables ↵stuconnolly2009-12-141-40/+1
| | | | sheet was moved to its own controller.
* - Work through static analysis of the source, fixing a number of small ↵rowanbeentje2009-12-141-3/+5
| | | | memory leaks and fixing a couple of over-releases
* Replace the main toolbar's #define'd identifier constants with extern's. ↵stuconnolly2009-12-121-51/+50
| | | | This completes the conversion of all constants in SPConstants to extern's.
* - Fix saving of custom SSH ports when the MySQL server is on a standard ↵rowanbeentje2009-12-101-1/+1
| | | | port - this addresses Issue #495
* - Add document images for .spf and .sql filesrowanbeentje2009-12-091-1/+1
| | | | | | - Rename "SequelPro connections" to "Sequel Pro connections" for consistency - Update version numbers to 0.9.7
* - To improve the favourites/SPF split, hide the document icon and name for ↵rowanbeentje2009-12-051-5/+14
| | | | untitled documents
* • fixed issue for "Update Help while typing" to suppress opening the MySQL ↵Bibiko2009-12-031-1/+1
| | | | documentation periodically if no internal help can be found
* - Ensure the task cancellation button is hidden by default, until tasks ↵rowanbeentje2009-11-291-0/+1
| | | | which support it enable it
* • fixed bug while reading "ssh_port" and "port" from SPF fileBibiko2009-11-261-2/+2
| | | | - now the SPF's integer value will be converted to a string correctly
* - Replace the LIMIT interface on the content view with a pagination control ↵rowanbeentje2009-11-231-3/+3
| | | | | | | | at the bottom. This addresses the last of Issue #49 and implements Issue #133; jump-to and two prefs affecting loading are available in a popup when clicking the pagination interface. - Format row counts at the bottom of the content pane - Increase the MCPStreamingResult buffer for a stronger workaround for #463
* During a session restore, before bailing because there is no matching table ↵stuconnolly2009-11-221-0/+1
| | | | between those in the current database and that stored in the session data, remember to end the current task, otherwise the progress bezel will be displayed indefinitely while locking up the interface.
* - Relocate the table changed notification, allowing table info pane to ↵rowanbeentje2009-11-211-4/+14
| | | | | | | update early in the change process, but ensure the change notification occurs on the main thread for stability. Added NSNotificationAdditions from the Colloquy project for this. - Change the design of the progress indicator layer, and tweak task progress for improved feedback and less flickering by correctly updating interface as appropriate, and delaying status changes for a short time. This partially addresses Issue #455.
* • remember the spell checker status in the blob field editorBibiko2009-11-191-0/+1
| | | | | | - status can be toggled by right-click in the text view and go to submenu "Spelling and Grammar" > "Check Spelling while Typing" Note: up to now "Check Spelling while Typing" wont' be checked in the GUI if it's enabled → TODO (maybe related to the "sheet issue")
* Implement query cancellation support within MCPKit, and add it to the task ↵rowanbeentje2009-11-151-6/+64
| | | | | | | | | | functionality: - MCPKit now supports cancelling the active query; for MySQL servers >= 5.0.0 a query kill is attempted from a new connection, and if that fails or for MySQL < 5 a reconnect is triggered. - TableDocument now supports enabling a cancel task button on the task interface, including an optional callback - Implement query cancellation for custom queries. This addresses Issue #86. - Implement query cancellation for table content loads, filters, and sorts.
* Move connection type constants to SPConstants.stuconnolly2009-11-151-19/+19
|
* Updates to the 'use monospaced font' preference, making it a lot more ↵stuconnolly2009-11-141-18/+6
| | | | consistent across all table views. Also includes live updating when the preference is changed as well as its implementation in the query console, process list and variables table views.
* Bunch of improvements to the query console, including:stuconnolly2009-11-141-1/+2
| | | | | | | | | | | | | - New connection column (been meaning to add this for a while) - Display table view column headers - Enable table view text cell line truncating - Allow table view columns to be re-ordered - The table view now respects the display table view vertical grid lines preference - Support for including the connection when saving messages to a file - Support for showing/hiding the connection column - Increase table view row height to match that of all others - Display message time stamps using the user's system wide medium time format
* Add SPConnectionDelegate as a category of TableDocument to split out all ↵stuconnolly2009-11-131-93/+3
| | | | connection delegate methods into a single file.
* Move query mode constants to SPConstants.h.stuconnolly2009-11-131-4/+4
|
* In an aid to split up the functionality of the TableDocument class as well ↵stuconnolly2009-11-131-233/+32
| | | | as reducing the overall size of DBView, split out the server variables sheet into it's own controller and XIB in the same way as the new server processes sheet is implemented.
* - New server processes panel, accessible via the 'Database' menu and ↵stuconnolly2009-11-121-4/+32
| | | | | | | | alt+cmd+P. Includes the ability to kill queries and connections as well as live filtering support and the ability to save all processes or the current filtered set to a file. Implements issue #458. - Reorganise 'Database' menu. - Give 'Flush Privileges' key equivalent of shift+cmd+F.
* Change the main window's non-connected/connecting state title to 'Sequel ↵stuconnolly2009-11-111-3/+29
| | | | Pro' and only change it to 'Connecting...' when we are actually trying to establish a connection. Fixes issue #456.
* The framework shouldn't be displaying dialogs, get the delegate to do it.stuconnolly2009-11-111-0/+9
|
* During an import, before entering the loop to execute the current batch of ↵stuconnolly2009-11-111-4/+3
| | | | queries, check that the current connection is active and if not bail from the method.
* Validate the the 'Clear Console' menu item in TableDocument in addition to ↵stuconnolly2009-11-101-1/+5
| | | | SPQueryController as it will never be called in SPQueryController if the console isn't visible.
* Implement a more reliable way of updating the show/hide console menu item.stuconnolly2009-11-101-7/+5
|
* - Fix an issue when switching databases - allow the table selection to be ↵rowanbeentje2009-11-101-13/+70
| | | | | | | cleared/reset as necessary - Move the task progress layer to a child window, which can then be faded in - smooths the visual appearance and fixes drawing artifacts
* Set keyboard shortcut for Delete button in alert dialogs to command D.avenjamin2009-11-091-1/+2
| | | | Set keyboard shortcut for Truncate button in alert dialog to command T
* - Wrap SPF restoreSession: call in a task, using the new nested task ↵rowanbeentje2009-11-091-2/+16
| | | | support to fix issue #452