aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* • REPAIR, OPTIMIZE, ANALYZE, FLUSH, CHECKSUM now can be applied to more ↵Bibiko2010-02-261-88/+281
| | | | | | | | than one selected item in the TablesList; if no error alert OK, if not or for CHECKSUM list the output in a table view - while sheet is open showing the accessory table user can press ⌘C for copying it - added missing NSLocalizeStrings • fixed a tiny issue for $SP_SELECTED_TABLES
* • Query Favorites:Bibiko2010-02-251-17/+91
| | | | | | | | - added snippet variable $SP_SELECTED_TABLES which inserts `table1`,`table2`, etc. (ONLY tables) • improved "Check Table" - now one can select more than one table to execute "CHECK TABLE table1,table2,… ; if all tables passed successfully alert OK, if not show the result as accessory table in the sheet note: OPTIMIZE, REPAIR, FLUSH, CHECKSUM, ANALYZE follow
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-231-0/+7
| | | | | | | | | | value (no sheet) • "Delete all records" confirmation sheet shows a checkbox "Reset AUTO_INCREMENT after deletion" if PRI key is given for that table • minimized table data querying for auto_inc • optimized auto_inc change notification • if user changes tabVIew to Table Info Pane update data in beforehand • TRUNCATE query updates auto_inc value as well in TABLE INFORMATION
* Fix Issue #574 (foreign key links not working after first use):rowanbeentje2010-02-231-3/+3
| | | | | | - Move foreign key reference loading into it's own task and set state modification markers to allow it to override the table state history - Rename modifyingHistoryState to modifyingState now the usge has broadened slightly
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-2/+5
| | | | | | | | Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution) • SPAlertSheets - ensure that this sheet becomes the keyWindow
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-1/+2
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-221-0/+21
| | | | - not yet active
* • fixed keyboard behaviour of "Create Sytax Sheet"Bibiko2010-02-201-0/+3
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* Fix a number of memory leaks, and over-releases, as both a result of manual ↵rowanbeentje2010-02-101-1/+1
| | | | inspection of leaks and Clang static analysis.
* 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.