aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPQueryController.m
Commit message (Collapse)AuthorAgeFilesLines
* • added possibility to add a query favorite by user-definable alphanumeric ↵Bibiko2010-01-241-1/+3
| | | | | | | | | tab trigger; eg if tab trigger is set to "sel" sel⇥ will insert the first query which has the defined the tab trigger • preparations to insert programmable query favorites - eg "SELECT ${*} FROM ${Table}" -- after insertion "SELECT * FROM Table" the '*' is highlighted to change, press ⇥ to select the next snippet 'Table'; ⇧⇥ selects the previous snippet; the snippet selection follows the user input - Note: not yet active
* - Upgrade Sequel Pro to be compiled as a 3-way PPC/i386/x86_64 binary for ↵rowanbeentje2010-01-091-6/+6
| | | | | | | release builds, including a large number of 64bit compatibility upgrades and tweaks - Upgrade RegexKitLite to 3.3
* Convert a bunch of #define'd constants to extern's, including preference ↵stuconnolly2009-12-111-1/+1
| | | | toolbar identifiers, pasteboard drag types and file extensions.
* - Fix display of the bottom row in the query console by reloading table ↵rowanbeentje2009-12-021-3/+7
| | | | | | | | data *after* the scroll - Quote timestamp and connection when copying rows from the table console - Reduce queries when fetching database collations or encodings by removing an additional check and adapting logic to match
* When viewing the information_schema database, disable all controls on the ↵stuconnolly2009-11-151-1/+0
| | | | table information view as all table in this database are not modifiable by anyone.
* Updates to the 'use monospaced font' preference, making it a lot more ↵stuconnolly2009-11-141-1/+20
| | | | 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-103/+144
| | | | | | | | | | | | | - 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
* Validate the the 'Clear Console' menu item in TableDocument in addition to ↵stuconnolly2009-11-101-0/+1
| | | | SPQueryController as it will never be called in SPQueryController if the console isn't visible.
* - Fix a crash when opening .spfs caused by an autorelease - revert to ↵rowanbeentje2009-11-011-0/+1
| | | | | | | manual memory management instead of r1455 approach, but fix leaks - Fix an exception caused by closing .spf windows while "Connecting..." windows were open
* Replace the use of hard coded preference keys with constants to prevent ↵stuconnolly2009-10-171-21/+21
| | | | issues such as the one fixed in revision 1419. All future preference usage should be done so using these constants.
* - Improve on r1423 by avoiding stringWithFormat: within the query ↵rowanbeentje2009-10-161-1/+8
| | | | | | | | construction loop, enormously reducing memory usage in big loops - Use 64k chunks instead of 256k chunks - seems to give *much* better performance, possibly due to MySQL parsing/cache sizes (?) - When restoring the query console to allow updates again after a loop, trigger a refresh of the view if the console is visible
* • fixed issue while copying a very large number queries from the Console ↵Bibiko2009-10-151-3/+7
| | | | | | Log window - make usage of a NSMutableString to speed it up and to avoid crashes
* • added the chance to set "allowConsoleUpdate"Bibiko2009-10-151-17/+19
| | | | | | | | - if set to YES the Console Log won't be updated after adding a new message even if the window is visible; this is useful if SP has to execute a large number of queries • first steps to increase the deletion of a large number of rows in the Content pane - removed deprecated 'selectedRowEnumerator' - set Console Log's 'allowConsoleUpdate' to NO if more than 10 rows should be deleted - instead of adding the successful deleted row indexes into a new array delete these indexes from the selectedRows NSIndexSet
* • first implementation of a Content Filter EditorBibiko2009-10-011-0/+40
| | | | | | | | | | | | | | - user-defined content filter can be saved globally (Prefs) or in SPF files - BETA - further tests are needed due to complexity - SPQueryController now handles the local user-defined content filters - tooltips are now generated automatically if not defined explicitly (incl. if $BINARY placeholder was used) • if user added local query favorites or content filters to an Untitled document and s/he wants to close it the standard sheet will be displayed (Don't Save - Cancel - Save) - due to that changed old [TableDocument displayName] to 'displaySPName' to be conform with Cocoa • changed behavior while importing query favorites - now they will append at the list (not inserted after selected row - makes more sense) • introduced to history filter dict the key 'menuLabel' which will be set to [TableContent tableFilterString] for displaying the history menu title and simplified the SPHistoryController logic for that • minor code changes
* • removed leaks in QueryFavoriteManagerBibiko2009-09-071-0/+21
| | | | • prepared QueryController for future steps
* • updated SPQueryFavoriteManager to mange document-based and global query ↵Bibiko2009-09-071-0/+11
| | | | | | | favorites • disabled "Select Active Query" in CMTextView if shown in the favorite manager • code cleaning and simplifications
* • first steps to support global/document-based query favoritesBibiko2009-09-041-5/+6
| | | | - not yet fully implemented but workable
* • implementation of a new history controllerBibiko2009-09-041-77/+166
| | | | | | | | | | | | | - each history is doc-based even if you have opened not only one instance of the same spf file - for each SPF file identified by its file URL SP remembers each history item regardless from which doc instance it comes from internally ( to make sure that after closing the last instance of a doc all executed queries are saved in that file - if the user wants to change that s/he has to save that file under a different name ) - the history list for each Untitled doc will be initialized by the items stored in the global SP's prefs - the history list for each SPF doc will be initialized by the items stored in the SPF file unless an instance of the same file is already open - then the new instance inherits the history list from the opened one(s) - all history items executed in any Untitled docs will be added to SP's prefs - in other words SP's global prefs plist is the historyrepository for each new Untitled doc - if the user saves an untitled doc or rename an opened SPF file the _current_ history list for that doc will be saved to the chosen file unless an other doc instance is still open - all history lists are saved automatically if SP quits or the user closes a doc window Note: This should be tested for any logical pitfalls - each desired logic can be implemented :)
* Table row should be a signed integer not unsigned, fixes duplicate method ↵stuconnolly2009-09-031-1/+1
| | | | definition warning.
* Replace deprecated stringWithCString:length: and update Console.xib after ↵stuconnolly2009-09-031-0/+5
| | | | SPQueryConsole rename.
* • renamed SPQueryConsole to SPQueryController since it controls not only ↵Bibiko2009-09-031-0/+632
the query console but also query favorites and history application-wide - accessible via: [SPQueryController sharedQueryController]