aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* - Add connection checks before uses of mysql_hex_string and ↵rowanbeentje2010-08-311-16/+51
| | | | mysql_real_escape_string (which require an active connection). This addresses http://spbug.com/l/54 .
* - Attempt more status checking before closing the MySQL connection, in an ↵rowanbeentje2010-08-303-3/+3
| | | | | | | attempt to further address http://spbug.com/l/13 - Update localisable strings
* - When a table content page reload loads no data, and so triggers a reload ↵rowanbeentje2010-08-301-0/+1
| | | | of the first page, the previous row count was not correctly reset, thus sometimes triggering an exception. This correctly resets the count, addressing http://spbug.com/l/558
* - Set pagination limit number formatter *off* lenient to allow editing ↵rowanbeentje2010-08-301-114/+494
| | | | formatted numbers (eg editing the default 1,000 to 2,000) without formatting characters such as commas being truncated
* • added some basic VIEW INFORMATION coming from information.schema.VIEWSBibiko2010-08-303-155/+212
|
* - Improve background thread reconnect interaction with the interface; if ↵rowanbeentje2010-08-291-3/+10
| | | | the application is in a modal state, the background thread waits. This improves interface behaviour on multiple SSH disconnections after sleep/wake (finishing Issue #798) and also disconnections while the interface is modally locked (eg editing text/blobs).
* • further improvements for in cell editing of view data in TableContent tablesBibiko2010-08-272-135/+138
| | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-273-110/+108
| | | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well • for TableContent fixed tooltip display - note: improvements as for CustomQuery follow soon
* • fixed issue that data in views weren't editable (copy&paste typo problem)Bibiko2010-08-261-0/+1
|
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-265-64/+111
| | | | | | | | | avoid the trampoline exceptions • unified error message while cell editing • in Custom Query table cell editing errors are displayed as tooltips and added these message if edit event comes from the keyboard • fixed: check edit status in Content Tables only for views to avoid unnecessary queries • used [SPCustomQuery fieldEditStatusForRow:andColumn:] consequently to simplify code
* If the user chooses to overwrite the output file(s) when performing an ↵stuconnolly2010-08-262-2/+11
| | | | export make sure compression and CSV and XML headers and re-enable/rewritten.
* Exporter:rowanbeentje2010-08-265-31/+62
| | | | | | - Enable alternating table lines in the export table view - this addresses Issue #797 - Reconnect GZIp & BZIP2 compression functionality (TODO: not currently working for file overwrites; to be discussed)
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-2521-206/+351
| | | | | | | | | | | with extended characters in MySQL identifiers (names of dbs/tables/cols): - Move encoding queries and control into MCPKit, with newly cleaned-up methods, and switch a number of locations to using the new code. - Use UTF8 connections for many identifier-based queries (selecting and listing databases, tables, stored procs, table information). This fixes selection and creation of table and database names containing extended characters, also fixing exceptions and errors. - Improve UTF8 over Latin1 to correctly set the client character set encoding as well, fixing custom queries and edits; remove custom code in SPTableContent achieving the same thing in a single location. - Fix database encoding detection routines - Update localisable strings
* • added tooltip about non-editable while keyboard navigation and trying to ↵Bibiko2010-08-252-2/+33
| | | | | | modify a cell • in Custom Query table after field editor sheet dismissing preserve the the edited field selection
* • after editing in Custom Query table preserve the selected line even if ↵Bibiko2010-08-252-8/+14
| | | | the actual edited line due to new data will come up in another line
* • fixed several issues for in cell editing of Custom Query tables and view ↵Bibiko2010-08-254-87/+67
| | | | | | | | data in Content tables - now each cell can be selected via keyboard navigation regardless whether it's editable or not; only if the user tries to modify it then it will be checked if it's editable or not - for speed while navigation - fixed issue for view data editing to show blobs in editor sheet if user wants to modify it - Note: still work on progress
* • outsourced control:textView:doCommandBySelector: stuff to SPCopyTable ↵Bibiko2010-08-245-203/+358
| | | | | | | | | | since we need that for Content and Custom Query table; only class specific stuff like ESC trapping will handled in the actual class • enabled in cell editing for Custom Query tables - also added spreadsheet button to Custom Query status bar • fixed ESC trapping: F5 can be used for completion • simplified [SPCopyTable keyDown:] for trapping ENTER/RETURN key • some code cosmetics
* • in [SPCustomQuery tableSortCallback]Bibiko2010-08-241-7/+3
| | | | | - removed unnecessary header indicator image setting - set [[customQueryView onMainThread] setNeedsDisplay:YES] to ensure to display table rendering correctly after changing the sort order
* • added context menu for Copy, Copy with Header, Copy as SQL Insert to ↵Bibiko2010-08-243-4/+149
| | | | Custom Query table
* • introduced tri-state sort order for Content and Custom Query tablesBibiko2010-08-242-188/+242
| | | | | | | - by clicking a the same table header the sort will changed to desc, asc, no sort order, desc, asc, etc. • fixed sorting issue for Custom Query table - reset sort order status before executing a new custom query • code cosmetics: reduced file size for SPCustomQuery.m
* • Content Window cell editingBibiko2010-08-241-0/+6
| | | | - If enum field is edited RETURN selects the new value instead of saving the entire row
* • fixed memory leak in [SPDataAdditions ↵Bibiko2010-08-243-342/+341
| | | | | | | | | | shortStringRepresentationUsingEncoding] after simplifying the code • fixed NSAutoreleaseNoPool(): SPMainThreadTrampoline autoreleased with no pool in place - leak while canceling a print job - call [self endTask] BEFORE [pool drain] • in SPTableContent set the focus to table after editing a cell by the field editor sheet on main thread - this could fix exception 1481 • some code cosmetics: reduced file sizes
* • Table Content editing via keyboardBibiko2010-08-231-0/+12
| | | | | - disable ↑ and ↓ for jumping the next table cell if current cell is a enum field to allow to use the arrow keys for selecting an item from the list - Note: ?\018↩ handling has to be improved here! (coming soon)
* • changed TAB and SHIFT-TAB behaviour of Content Window tableBibiko2010-08-231-29/+98
| | | | | | | - now it selects any field (if it's editable for views) regardless whether the field is a blob - if user tries to edit a blob field the field editor sheet will occur for editing • after cancellation of cell editing in the Content Window table preserve the focus on the table • minor code cosmetics for editing of data coming from a view in Content Window
* • first preparations to allow in cell editing in Custom Query (not yet ↵Bibiko2010-08-224-172/+929
| | | | | | | | | | active) • view data editing - disable add/duplicate/remove row for views - first improvements for editing navigation via keyboard - after editing avoid relaodTable instead use loadTableValues - outsourced: (NSInteger)fieldEditStatusForRow:andColumn: since it will be used for keyboard editing navigation
* • moved changes done in r 2566 to tableViewSelectionDidChange: if no item ↵Bibiko2010-08-221-4/+12
| | | | in tablesList is selected to reset SP
* • after deleting of items in tablesList set selectedTableType to ↵Bibiko2010-08-221-2/+7
| | | | | | SPTableTypeNone and selectedTableName since the table will be deselectAll - fixes various updates like title bar etc. and avoid crashes/exceptions
* • view editingBibiko2010-08-221-11/+19
| | | | - if multipleLineEditingButton is set to on or field is a blob field allow to show the field data as non-editable fieldEditorSheet if field is not editable
* • view editingBibiko2010-08-221-3/+16
| | | | | - fixed: call endTask for the current progress spinner if while editing a field the data were changed meanwhile - fixed line breaking of some long tooltips
* • implemented the editing of views in Content WindowBibiko2010-08-212-2/+277
| | | | | | - the editing is field based as for Custom Query editing - shouldEditRow checks if the clicked field can be identified unambiguously - CAUTION: This must be tested heavily before releasing!! Esp. any kind of threading issues and progress spinner stuff for slower connections
* • overall replacement of:Bibiko2010-08-2014-191/+162
| | | | | | | | | [aString appendString:[NSString stringWithFormat:]] by [aString appendFormat:] since it's much more faster • first look at loop where several [aStr appendString:] occur to try to combine them into one appendString or appendFormat since the allocation of memory takes really time Note: I tested all my changes but we should test it further to be sure that I didn't a mistake!
* Fix various potential memory leaks and general warnings as a result of ↵stuconnolly2010-08-197-11/+17
| | | | static analysis.
* • made usage of SPBeginWaitingAlertSheet while closing a spf file for ↵Bibiko2010-08-194-16/+29
| | | | | | | readability of that spf file • suppress if a window with one tab will be closed that [... parentTabShouldClose] method will be called twice via closeTab: - this issue could be the reason for recent crashes/exception esp. of the NSNavigator (should be investigated further)
* • added SPBeginWaitingAlertSheet() routine which offers the chance to ↵Bibiko2010-08-195-51/+140
| | | | | | display an alert sheet which waits for the change in the didEndSelector method of a passed class NSInteger variable • applied the SPBeginWaitingAlertSheet routine to Pref > Editor's check for unsaved color themes and in SPCustomQuery's sheet about Stop/Continue/Run All if a query failed after executing "Run All"
* • added SPFileManagerAdditionsBibiko2010-08-198-6/+203
| | | | | | | | - [(NSString*)applicationSupportDirectoryForSubDirectory:error:] Return the application support folder of the current application for 'subDirectory'. If this folder doesn't exist it will be created. If 'subDirectory' == nil it only returns the application support folder of the current application. • added SPThemesSupportFolder constant
* Move SPCopyTable in Xcode's logical file structure.stuconnolly2010-08-191-2/+2
|
* Missing changes from r2554.stuconnolly2010-08-194-272/+254
|
* • fixed xcode project for commit 2554 to apply the renaming of ↵Bibiko2010-08-191-6/+6
| | | | CMCopyTable.* to the project
* Rename CMCopyTable to SPCopyTable.stuconnolly2010-08-198-16/+16
|
* • fixed issue if SP's theme support folder or saved theme file resp. was ↵Bibiko2010-08-191-0/+28
| | | | removed while SP's Editor Preferences window is open
* • double-click in Finder on a 'spTheme' file installs this theme in SP's ↵Bibiko2010-08-191-4/+31
| | | | | | support folder • fixed opening of other file types by checking lower cased strings
* • fixed: reset new name to @"" for saving a themeBibiko2010-08-191-0/+1
|
* • added Edit Theme List to Editor Prefs for renaming/deleting/duplicating ↵Bibiko2010-08-193-69/+848
| | | | | | | | themes • fixed some issues for saving a theme note: since it isn't a frequently used feature this should be enough
* • convert alert about unsaved color theme to a waiting sheetBibiko2010-08-182-5/+47
|
* • added Query Editor color theme manager to the Editor PrefBibiko2010-08-185-261/+1046
| | | | | | - themes can be saved/loaded in/from ~/Library/Application Support/Sequel Pro/Themes by using the gear menu items in the Editor Pref - rearrange the GUI - Edit Theme List follows soon
* • Editor color setting in Pref pane displays the color names using the ↵Bibiko2010-08-173-23/+39
| | | | | | | Editor's font - added some logic for closing the NSColorPanel - some GUI tweaks
* Revert the change made in r2536 which prevented the use of exporting the ↵stuconnolly2010-08-172-109/+107
| | | | selected tables. We'll need to find another way to fix the original issue of not showing procs and functions in CSV and XML exports as well as preserving the user's selection when switching between export types.
* • improved SPColorWellCellBibiko2010-08-171-13/+27
| | | | | | - supports the displaying of colors with alpha values (as triangles) - size is set via parent frame with inset 0.5 - modified the border to match the NSColorWell look (not yet finished)
* • initial commit to set the Editor's colors by using a table approach ↵Bibiko2010-08-176-940/+500
| | | | | | containing SPColorWellCells - further improvements will follow soon
* • fixed logic for auto-completion inside quotesBibiko2010-08-161-10/+9
| | | | | • re-enabled autoHelp