aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* - Rework SPSQLParser, extending DELIMITER support into all the original ↵rowanbeentje2010-02-059-370/+314
| | | | | | | | | | | functions (off by default). Remove the forked "...Sql..." functions, as they're now duplicates, and switch CustomQuery to using the original methods. - TableDump imports can now process DELIMITERs correctly as a result. - Alter the TableDump display of tables etc to use TablesList as the source of information, and used cached lists where appropriate for a small speedup. Also means we gain consistent sorting. - Display procedures and functions in the toggleable list when exporting as SQL - Tweak the procedure and function export to only export selected items, and also to respect the "export drop syntax" and "export create syntax" checkboxes - Fix a crash when removing items from the TablesList resulted in an errorneous selection by deselecting all rows before deleting (and preemptively applying the same fix to TableContent)
* • bound ⌥⌘H to Mac's default "Hide others"; fixes i561Bibiko2010-02-042-47/+38
| | | | •rebound ⌥⌘Y to open the "Query History"
* Fix for issue #560. Still needs validation on hitting Apply, but fixes the ↵mltownsend2010-02-043-77/+136
| | | | initial problem.
* • fixed undo behaviour of insertion of history/query favsBibiko2010-02-042-5/+17
| | | | • improved text macro/query favs insertion logic
* Patch to filter available privs by what the server supportsmltownsend2010-02-031-2/+1
|
* • improved error handling in Structure View for adding/renaming/removing a ↵Bibiko2010-02-033-4/+37
| | | | | | | field if the actual underlying table doesn't exit anymore; now it informs the user, clean the view, and reloads the Table List • improved error handling in Content View for refreshing data for the current table if the table doesn't exist anymore - this fix and the fix in [TableContent setCompareTypes:] to check for valid table data removes some NSPlaceholderString and NSScanner warnings
* • field mapping sheet is now document-modal instead of blocking SP entirelyBibiko2010-02-035-35/+269
| | | | | | | • if an error occurred while retrieving column or index data in Structure pane reset Structure pane to a stable status, display the error message, and reload Tables List table due to the fact the it's very likely that SP tries to retrieve data from a table which doesn't exist anymore • fixed spelling of "occurred" Note: NOT YET DONE: if in Structure view the actual underlying table was deleted or renamed by an other mysql event and the user tries to add/change a field do suppress this attempt safely
* Fixed refresh problem on the schema privsmltownsend2010-02-031-0/+3
|
* - When copying (as TSV) or dragging rows, copy BLOBs and binary TEXTs as ↵rowanbeentje2010-02-031-6/+21
| | | | | | | they are shown - as strings. This addresses Issue #558. - Remove some unused variables
* Moved the schema priv tab over and selected first host if user is selected ↵mltownsend2010-02-022-272/+273
| | | | when tab is selected.
* Fix weird issue with lines not compiling in release mode.mltownsend2010-02-021-4/+4
|
* Refresh function added to user manager.mltownsend2010-02-022-10/+11
|
* • further work on SPFieldMapperControllerBibiko2010-02-023-26/+342
|
* • CMTextViewBibiko2010-02-022-8/+11
| | | | | | - suppress current query/syntax highlighting for text buffer size > 20MB to allow at least editing and performing queries • Main Menu - set hidden new Export menu item to key ⇧⌘E and reset "Use selection for searching" to ⌘E since it's a standard Mac binding
* • fixed partially syntax highlighting for very very long linesBibiko2010-02-021-7/+25
| | | | • fixed some NSUInteger checks à la while(NSUInterger >= 0) since it's always > 0
* • added key-shortcut ⌘= to make the textview size largerBibiko2010-02-023-112/+100
| | | | | | | | • ⌘-, ⌘+, ⌘= changes the font size temporarily (Mac app conform) • added key-shortcut ⌘0 to reset the font to pref default • fixed search field background for Tables List • fixed NSUInteger for completion parsing; interrupt completion if parsed string length is larger than 100000 since it doesn't make sense and leads to warnings
* First stab at Schema Privileges. A UI redesign is on its way. Please test ↵mltownsend2010-02-026-24/+1529
| | | | on non Production servers
* • fixed in CMTextView several NSInteger which has to be NSUInteger; this ↵Bibiko2010-02-021-21/+21
| | | | | | led to an issue that SP crashed for very very long lines/queries - this has to be investigate further!
* • sped up Query Editor for larger textBibiko2010-02-013-109/+123
| | | | - rewrote [NoodleLineNumber requiredThickness] completely to avoid stack overflow for larger text due to [NSMutableString string] plus appendString all the time without releasing it in time
* - Check whether super implement awakeFromNib before calling to fix 10.5 ↵rowanbeentje2010-02-011-1/+3
| | | | compatibility
* • CMTextView: switch off syntax highlighting if text buffer size is larger ↵Bibiko2010-02-015-52/+180
| | | | | | than SP_SYNTAX_HILITE_BIAS (has to be improved) • added SPFieldMapperController
* • re-enabled possibility to change the font size of non-editable ↵Bibiko2010-02-011-2/+2
| | | | CMTextViews via ⌘+, ⌘-, or trackpad pinch in/out gesture
* • Added basic print support for each CMTextViewBibiko2010-02-013-92/+1170
| | | | • first steps to renew the field mapper sheet for CSV Import
* • improved text macro snippet logicBibiko2010-02-011-17/+19
|
* • Content Table and Query Editor table's tooltip are displayed by using ↵Bibiko2010-01-313-98/+26
| | | | | | the same font/size as the table cells • CMTextView: make sure that some methods are never called if the CMTextView is set to 'not ediable'
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-3111-116/+1839
| | | | | | | | | | | | | | | | | | | | 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-3011-120/+448
| | | | | | | | 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)
* Rework CMCopyTable copy functionality and related code:rowanbeentje2010-01-304-200/+211
| | | | | | | | | | - Reverse the effects of the r1664/r1690 combination, restoring the original link from CMCopyTable to the underlying data source - Adapt the code to retrieve information from the new SPDataStorage; update SPDataStorage as necessary if underlying data changes - Refactor and speed up various checks and loops for speed and logic improvements - Ensure the binary-encoded TEXT data is hex encoded rather than retrieved as "<123ABC 123ABC...>" NSData representations - Fix some memory leaks This resolves Issue #533 and the original "Copy as SQL" issue
* • suppress the display of table cell tooltips if TableDocument isWorking ↵Bibiko2010-01-302-2/+2
| | | | to avoid unstable tooltip status
* • added observer for all Query Editor colors to avoid initialising colors ↵Bibiko2010-01-303-96/+139
| | | | | | each time for syntax highlighting which speed it up a bit; now if one changes a color the changes are done in view after a delay of 0.1 s if text buffer < 100k for speed reasons • fixed: before highlighting the current query ensure that the text storage is in a stable and clean status; otherwise SP crashes for ranges which aren't rendered yet
* Fix bugs introduced by last commit.avenjamin2010-01-302-257/+291
| | | | | - SplitView divider now thin - Search Box appears again
* • current query highlighting is done now in drawRect: (much more faster ↵Bibiko2010-01-304-67/+158
| | | | | | | | and thanks to Jakob) • improved snippet background drawings esp. for multiple lines (commit on behalf of Jakob) • simplified code for changing and setting background colors and Pref setting for highlight current query by observers (much more faster)
* Update to BWToolkit 1.2.5avenjamin2010-01-3012-275/+28
| | | | - Fixes issue where Database selector wasn't resizing to match Table list width.
* - Bugfix: when the number of table columns for a content result set no ↵rowanbeentje2010-01-301-3/+18
| | | | longer matched the internal table representation, table storage exceptions would occur. Additional checks are now made against the column count; if a content result set is retrieved with an unexpected number of columns, the result set is discarded and a full table refresh is triggered to restore the state.
* • bound three finger multi-touch right/left swipe event to go back/forward ↵Bibiko2010-01-291-0/+15
| | | | in table history
* • text macro logicBibiko2010-01-292-20/+31
| | | | | | | - improved highlighting of multi-line snippets (many thanks to jabakobob for this patch!) - some tiny cosmetics • error message highlighting in Custom Query Editor - removed near message length checking to be larger than 2, not necessary
* • further tiny improvements to avoid exceptional cases while highlighting ↵Bibiko2010-01-292-4/+20
| | | | | | | | | the erroneous query - added check for near message length - make an intersection with the buffer range before selecting • text macro - each selection of a snippet breaks the undo buffer - note: undo behaviour while text macro session is active needs to be solved ⇢ work in progress
* • fixed some issues and improved the text macro behaviourBibiko2010-01-292-63/+61
|
* • text macro improvementsBibiko2010-01-281-5/+44
| | | | | | | | - added dynamically set SP variables $SP_SELECTED_TABLE and $SP_SELECTED_DATABASE available in each ${x:…} snippet to allow to create a query fav à la: SELECT ${1:$SP_SELECTED_TABLE.} FROM ${1:$SP_SELECTED_TABLE} whereby for the first snippet one can press ESC to insert one or by holding down the CTRL key while inserting more field names from the current table - improved snippet range detection for current caret position - reduced the border width of snippet highlighting and changed slightly the colour for the current selected snippet
* * removed a stray NSLog()jakob2010-01-281-3/+3
| | | | * changed name of closeDocumentWindowAndDisconnect-selector again...
* * fixed typo that prevented the document window from closing when choosing ↵jakob2010-01-282-4/+5
| | | | | | 'disconnect' in the connection error dialog * improved some comments
* - removed two occurances of runModalForWindow: when asking questions for the ↵jakob2010-01-283-94/+193
| | | | SSH-helper (see #357)
* • for [CMTextView selectLineNumber:…] added safety-check for lineNumber < 1Bibiko2010-01-282-8/+14
| | | | | | | | • error message highlighting in CustomQuery - check for error ID 1064 before trying to select the erroneous line given as '… at line x' (this solves the issue that other error messages could end by a number) - improved regexp to get rid of localized error messages for parsing the erroneous line number (thanks to Jakob) - look the last number in a string - improved regexp to parse for the 'near message' for localized error messages
* • ESC completionBibiko2010-01-281-15/+9
| | | | - speed up gathering data by avoiding the check for uniqueness if not necessary, make usage of NSMutableSet to collect unique data automatically, and rely on NSSubTextStorage to get all words from the text buffer (if text buffer size less than 6MB)
* * renaming a table/view/proc/func now doesn't open a sheet anymorejakob2010-01-283-564/+214
| | | | | * table name checks now correctly consider only functions when working with functions * when an empty table name is entered, the change is ignored (like in finder)
* • SPQueryFavoriteManagerBibiko2010-01-281-1/+1
| | | | | - changed regex for validation of the entered tab trigger to "(?i)[^[:L:]0-9]+" since "(?i)[^\\w0-9]+" doesn't work if SP runs in 32bit mode. - It seems that the new RegexKitLite has a problem to expand \w correctly if it is used like [^\w]
* * Fixed #484 (renaming tables where only the case changed)jakob2010-01-281-214/+184
| | | | * refactored the table/proc renaming code a bit
* • Query Favorite text macroBibiko2010-01-271-19/+24
| | | | | | - fixed bug for deletion nested snippet ranges after editing - further improvement of the graphical representation - selected snippet will be drawn differently
* • improved the graphical representation of text macro snippetsBibiko2010-01-274-74/+27
|
* • query favorite snippet session (text macro)Bibiko2010-01-271-1/+49
| | | | | - draw a bezier path around defined snippets to group them graphically (test phase) - allow the user to go into a snippet by using the mouse