aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPQueryController.m
Commit message (Collapse)AuthorAgeFilesLines
...
* • outsourced keyword completion and function completion lists to ↵Bibiko2010-03-081-1/+66
| | | | | | | | | | | CompletionTokens.plist • SPQueryController manages keyword and function completion lists now; this reduces the memory usage a bit and the list is easier to edit • added pre-defined function argument snippets to CompletionTokens.plist (auto-generated from mysql's HELP) • added Preference option for Editor whether a function completion should insert () and if found the function argument snippets automatically or not - last ) will be linked as autopaired then • changed behaviour for wrapping a selection into `"'() etc. - now it re-selects the original selection after wrapping and in addition last wrap character is now marked as autopair-linked • improved logic for popping up the auto-completion list
* • CSV Import Field MapperBibiko2010-03-051-1/+1
| | | | | | | | | | | - removed Advanced sheet, instead resize the main sheet and display these settings in it - added advanced options LOW/HIGH_PRIORITY - improved logic for adv. settings, disabling UPDATE if target table has less than 2 fields, etc. - fixed URL for displaying the source file name - removed Help text since it's too large - should be go to the general help • CMTextView - fixed bug if ESC Completion is invoked if caret position is 0 • fixed document URL handling to come up with the correct icons etc.
* • fixed threading issue if user performs query in Custom Query all the ↵Bibiko2010-02-181-1/+1
| | | | | | | time by holding down ⌘R for a long time caused by updating the history - removed unnecessary updating of the historyButton - updating of all docs is now performedOnMainThread:waitUntilDone:NO
* • improved text macro snippet behaviourBibiko2010-02-131-1/+2
| | | | | | • improved the ability to run bash commands inside of snippets • ignore most of the syntax highlighting inside snippet declarations • fixed issue in CMTextView to use obj class variables only to generalise this object
* 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.
* • fixed synchronisation of history lists if more than one instance of the ↵Bibiko2010-02-051-0/+6
| | | | | | same SPF file is open - simplified code a bit
* • refactored the entire history logic in Custom QueryBibiko2010-02-051-0/+26
| | | | | | - queries which are longer than then 64 chars are truncated in title and queries which are longer than then 256 chars are truncated in tooltip to avoid processing time to load very long queries from history; this also decreases the memory usage - added "Insert Next/Previous History Query" logic bound to ^↑ and ^↓ - fixed tiny GUI spacing problem in Custom Query
* • 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]