aboutsummaryrefslogtreecommitdiffstats
path: root/Source/CustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
* Improve custom query timing and display:rowanbeentje2009-06-271-5/+5
| | | | | | | - Amend timing using clock() to timing based on mach_absolute_time() (see revision comment on Google code) - Ensure the time returned is for the requested query and not subsequent helper queries - Use NSNumberFormatter to return a localised "< 0.1 ms" rather than the hardcoded Euro-style "< 0,1 ms"
* • fixed issue for sorting the Custom Query table via clicking at the ↵Bibiko2009-06-261-2/+4
| | | | header if no ORDER BY statement was found in the original statement
* • initial trial to make Custom Query's result table sortable by clicking ↵Bibiko2009-06-241-11/+56
| | | | at a column header
* • Custom Query fixes:Bibiko2009-06-241-60/+68
| | | | | - preserve table width/order after editing - updated data source code to avoid having the data twice in the memory
* • added to SPDataAdditions:Bibiko2009-06-231-41/+11
| | | | | | - (NSString *) shortStringRepresentationUsingEncoding: --mainly used for displaying large blob data in a tableView • tiny speed improvements for tableView:objectValueForTableColumn and tableView:setObjectValueForTableColumn in Content Browser and Custom Query
* • added SPDataCellFormatter to data cells of the Custom Query tableBibiko2009-06-231-0/+2
| | | | | | | | • in Content Browser send only the first 255 bytes to the cell formatter (makes it a tick faster) • fixed for editing in Content Browser if row contains binary blob data: - use = instead of LIKE operator in UPDATE statement - binary data will converted into X'...' representation
* • fixed: make usage of backtickQuotedString to allow table names ↵Bibiko2009-06-231-52/+72
| | | | | | containing a ` • some minor code cleaning and commenting
* - Improve r911 (initial Custom Query editability) to allow editing of rows ↵rowanbeentje2009-06-221-13/+13
| | | | containing NULL values and editing data in tables with names containing backticks
* • first trial to make the result table in the Custom Query editable for ↵Bibiko2009-06-221-44/+221
| | | | such fields which can be identified bijectively by the given table data
* • improved: "Copy as SQL INSERT" in Custom Query passes the original table ↵Bibiko2009-06-221-6/+23
| | | | name (not that one defined via "AS") if the result columns' table source is the same, otherwise <table>.
* • first steps to synchronize CustomQuery table and ContentTableBibiko2009-06-221-4/+73
| | | | | | - CustomQuery table now allows to copy selected rows as SQL INSERT (table name is set to "<table>" - if a field is a blob display only the first 255 bytes/chars in the CQ table for speed reasons - blob fields in CQ does not listen to the pref setting for "LoadBlobsAsNeeded" because it could happen that no one-to-one relation to their original data will be found
* • some code cleaning and tiny performance enhancements for various ↵Bibiko2009-06-211-23/+30
| | | | for/while loops
* • added to SPArrayAdditions.h: NSArrayObjectAtIndex() inline functionBibiko2009-06-181-9/+12
| | | | | | | | | - id o = NSArrayObjectAtIndex(anArray, index) :== id o = [anArray objectAtIndex:index] - this speed up it ~3µs per call - replaced that inline function for such calls within loops to speed up them • used IMP function pointers for keepAlive calls within queryString: • set -O3 (Fastest) compiler option • allow in preference pane "Tables" to set the Limit up to 50000
* • some tiny improvements to speed up queryString:Bibiko2009-06-181-4/+4
| | | | | | | | | - cache the function pointer for delegate willPerformQuery: - if Console Log window is NOT visible suppress reloadData and scrolling to last line (this speeds it up remarkably); if user opens the Console log window it will be synchronized - timeIntervall for execution time will be divide by CLOCKS_PER_SEC in [NSString stringForTimeInterval] - removed for utf8 enc in cString the return UTF8String (no significant difference) • now execution time shows only the time for mysql_real_query
* • changed regex of trigger a reload of table/db according to executed queriesBibiko2009-06-171-3/+4
| | | | | - now it also recognizes such keywords with leading comments - still further improvements are needed
* • improved: sped up removing the background color for query highlightingBibiko2009-06-061-2/+8
| | | | • added: DELIMITER to the completion suggestions
* • added to Editor Preferences:Bibiko2009-06-051-4/+19
| | | | | - "Query Background" color - checkbox "Highlight Current Query"
* • reload table list, database pull-down menu according to user's ↵Bibiko2009-06-051-13/+37
| | | | | | | | | statements in the Custom Query editor if necessary - if statement begins with: use, create, alter, rename, drop • reload table list, database pull-down menu according to imported statements • sped up "Import MySQL Dump" • fixed some tiny issues of the last commit
* Fixed some memory leaks found using llvm/clang. There are still some to fixbamse162009-06-051-1/+3
|
* • fixed: suppress highlighting of the current query if something is selectedBibiko2009-06-041-1/+7
| | | | • added: "Select Active Query ^Y" context menu item to the Custom Query Editor
* • simplified quertAtPosition:Bibiko2009-06-041-213/+99
| | | | | | • added queryRangeAtPosition: method because this is needed also for other purposes • moved the commands for highlighting the current query from queryAtPosition: to textViewDidChangedSelection: (where it belongs to) • some minor changes in error highlighting code
* • updated queryTextRangeForQuery: method to make usage of the new SQLParserBibiko2009-06-041-15/+11
|
* • added support for the “delimiter” commandBibiko2009-06-041-87/+119
| | | | | | | | | | | | | | - added (NSArray *) splitSqlStringByCharacter:(unichar)character; (NSArray *) splitSqlStringIntoRangesByCharacter:(unichar)character; (long) firstOccurrenceInSqlOfCharacter: to the SQLParser which recognize a “delimiter” command • queryAtPosition now works with ranges to speed it up - the current query ranges resp. the just activated query range are cached in order to avoid parsing if the user only navigates through the textView buffer, or if the user calls Run Prev/Current Query only • the "import dump" function makes usage of that new “delimiter” support - i.e. dumps with procs/funcs declaration could be imported IMPORTANT: Please check the new SQLParser exhaustively in order to prove that new approach
* • ADDED: highlight the current active query by setting its background ↵Bibiko2009-05-281-1/+19
| | | | color in the Custom Query Editor
* • fixed dependence in showHelpForCurrentWord: to allow to invoke the help ↵Bibiko2009-05-281-1/+1
| | | | (Context Menu or ^H) from any CMTextView (e.g. from create syntax view in Table Info as well)
* Fix for query editor font being lost. Initialize the prefs reference in ↵stuconnolly2009-05-271-2/+2
| | | | setConnection as opposed to init, so we definitely know the font has already been set. Turns out it was me that moved it to init, my bad.
* • activate Preference setting for caret colorBibiko2009-05-241-1/+2
| | | | | | | | • added prototype for new completion (ESC -> Cocoa, F5 -> new completion) - not yet finished - TODO: -- support for NSSpellChecker items -- images for different types of suggestions like proc/func/tabkle/view/sql statement, db name, etc.
* - Forgot to save this file before last commitavenjamin2009-05-221-3/+3
|
* - Few Changes to Query Editor Preferenceavenjamin2009-05-221-119/+119
| | | | | - Cleaned up a few preference keys - Added Caret Color to Query Editor Prefs - disabled for now.
* - Fixed NSFontPanel issue. Now showing font collections in Font Panelavenjamin2009-05-211-0/+7
| | | | | | - Replaced some toolbar icons with new ones - Edited some toolbar icons. - Added keyboard shortcut section to preferences (Disabled for now)
* • made mySQLConnection reachable for CMTextViewBibiko2009-05-201-0/+2
| | | | | | | • for MySQL version > 4 added proc/func names to the completion suggestion list • changed the way of adding the table names to the completion suggestion list - now it uses [mySQLConnection listTables] instead of taking the names from the table view list due to the header items • added some pragma marks to CMTextView
* New preference to allow the displaying of vertical grid lines in table views.stuconnolly2009-05-191-26/+42
|
* • implemented a new approach to split a string into single SQL statements ↵Bibiko2009-05-191-0/+10
| | | | | | | | by using the lexer SPTokenizer - the new method is called splitStringIntoRangesOfSQLQueries: in SPSQLParser - in CustomQuery's method queryAtPosition: can be found a test case which is as default not activated - must be improved further
* More header updates for source files, including Subversion Id property.stuconnolly2009-05-191-1/+2
|
* - added ability to view function and procedures and preliminary ability to ↵mtvee2009-05-131-2/+2
| | | | input same via the editor
* More dialog updates. Issue #192.stuconnolly2009-05-121-5/+6
|
* • added "Query Editor" preference pane for setting colors, font, and modes ↵Bibiko2009-05-071-20/+28
| | | | | | | | | | | | | | | | | (from the CQ's action gear which are still customizable there) - in addition to the syntax colors it's now possible to change the fore/background color as well • added "Update Help while typing" feature in the Custom Query editor • first trial to improve syntax highlighting for large text in the Custom Query editor - if the text is larger than 10k the highlighting is performed only for the visible text area ±bias (3.5k) - if the user changes the visible area the highlighting follows time-delayed 500ms) to assure user interaction - a test with a 45MB SQL dump worked (of course a tick slowier) -- todo: improve prev/current query detection (mainly the SQLParser) - if the text size is > 6MB the completion list won't show words from the text due to parsing time - if the text size is > 6MB the line numbering will be disabled due to performance issue (improvements should follow) • some tiny clarification changes in the syntax highlighting code • some minor code cosmetics
* • MySQL Help - simplified code for goBack/Forward buttons because it is ↵Bibiko2009-05-011-8/+2
| | | | supported in the helpWebView policy delegate method
* • added "MySQL Help" to the MainMenu > Help submenuBibiko2009-04-301-9/+22
| | | | | | - it shows the MySQL Help TOC of the front most tableDocument mysql connection, i.e. each tableDocument has its own Help window (due to the fact that the Help is version specific), and makes it the keyWindow - changed the way for getting the mySQLversion into the CustomQuery; now a new tableDocument set it via [customQueryInstance setMySQLversion:foo]; the other way was to unsafe regarding to get the version if MySQL Help was invoked via MainMenu • Help window and Create Table Syntax window will be released while closing the tableDocument
* • changed context menu item in CQ's textview to support "MySQL Help"Bibiko2009-04-301-0/+11
| | | | | • prepared code to work with autoHelp • improved getRangeForCurrentWord (fix for " |a")
* • MySQL HelpBibiko2009-04-301-1/+1
| | | | | | - updated autoHelp, now it recognizes cursor movement via mouse • if the chunk in CQ's textview is too large remove all attributes • some minor code cosmetics
* • MySQL HelpBibiko2009-04-301-40/+69
| | | | | - refactored and cleaned contextMenuItems for the webview - help-html-template will be loaded only once
* • MySQL HelpBibiko2009-04-291-2/+3
| | | | - fixed: escaped single quotes ' in the search string for HELP 'foo' (search selection)
* Add a menu item separator between the default menu items and MySQL search items.stuconnolly2009-04-291-0/+1
|
* • MySQL Help refactoringBibiko2009-04-291-152/+161
|
* • MySQL HelpBibiko2009-04-291-18/+26
| | | | | - change help target buttons into a NSSegmentedControl - fixed minor typo
* • MySQL HelpBibiko2009-04-291-15/+76
| | | | | | | - managed contextual menus in webview -- added for selection menu "Search in MySQL Help" and "Search in MySQL Documentation" - fixed keyboard short-cuts in webview - corrected tooltip for "Web" button in GUI
* • MySQL Help:Bibiko2009-04-281-1/+1
| | | | - fix for link detection of [HELP foo] if foo contains a \n
* • MySQL HelpBibiko2009-04-281-2/+8
| | | | | - fixed logic to detect whether db connection supports HELP statement - improved the while typing search, e.g. type in the Help search field "sel"
* • MySQL HelpBibiko2009-04-281-7/+17
| | | | | - if the connected database doesn't support the HELP statement or the admin deleted the help tables in mysql the search falls back to the online search according to the connected mysql version - changed slightly the example css output style