aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-37/+58
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* Remove 10.4 related code and associated macros.stuconnolly2010-09-261-3/+1
|
* Change the comment fomat used when displaying and copying the create ↵stuconnolly2010-09-241-8/+5
| | | | syntaxes for multiple tables to '--' from '#'. Implements issue #842.
* • 'doPerformQueryService' set toolbar to Custom QueryBibiko2010-09-211-5/+6
| | | | - minor commenting stuff
* Very minor tidy up.stuconnolly2010-09-201-3/+2
|
* - Implement support for MySQL over SSL for both TCP/IP and Socket ↵rowanbeentje2010-09-131-1/+34
| | | | | | | | | | connection modes. - Upgrade the MySQL binaries to version 5.1.50 (was 5.1.46) - Enable SSL support in the MySQL libraries (this leads to a large increase in library size, unfortunately) - Enable more optimisations in the MySQL libraries (especially --enable-assembler for faster in-library string processing and --with-mysqld-ldflags=-all-static) This completes support for Issue #27.
* • fixed _supportsEncoding setting to dis/enable safely Database > View ↵Bibiko2010-09-101-1/+6
| | | | Using Encoding
* - Add support for SSH identity files (public keys) in custom locationsrowanbeentje2010-09-081-0/+8
| | | | | | - Update localisable strings - Fix initial window position
* • Show/Copy Create Syntax now come up with all create syntaxes of selected ↵Bibiko2010-09-011-106/+103
| | | | | | | items • if Create Syntax is a PROC wrap the output by DELIMITER ;; etc. to simplify a copy&paste • merged code for copyCreateTableSyntax into showCreateTableSyntax distinguished by the sender (if sender == self) then copy otherwise show
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-63/+44
| | | | | | | | | | | 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
* • made usage of SPBeginWaitingAlertSheet while closing a spf file for ↵Bibiko2010-08-191-8/+16
| | | | | | | 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)
* - Apply column autosizing improvements to custom query loadingrowanbeentje2010-08-161-3/+7
| | | | | | | | - Move Table Content progress tracking onto the main thread's load timer - Improve thread safety when autosizing - Improve autosize to not contrain wide columns as much in tables where all columns can be shown, or if the column is double-clicked to size. (This completes work on Issue #271 and Issue #272)
* Improve export menu item validation by disabling export as XML and CSV when ↵Bibiko2010-08-151-6/+16
| | | | only multiple procs and/or functions are selected
* Improve export menu item validation by disabling export as XML and CSV when ↵stuconnolly2010-08-151-1/+12
| | | | either a proc or function is selected.
* Tidy up database renaming and copying by removing the use of alert dialogs ↵stuconnolly2010-08-131-13/+32
| | | | within loops to prevent locking up the main thread. These operations ideally should also be threaded.
* • fixed bug while closing a tab to remove the connection from NavigatorBibiko2010-08-131-2/+2
| | | | • FIRST implementation to allow to drag a table from the Navigator to the connection window's table list to copy this table with content (it works but needs to be improved!)
* • NavigatorBibiko2010-08-131-4/+4
| | | | | | | - make usage of only one tree - fixed "Button"-dummy - fixed refreshing of the tree data for first invocation - fixed tiny bits for possible crashes/exceptions due to threading
* • while closing a doc window or quitting the app wait for removing the ↵Bibiko2010-08-121-1/+1
| | | | connection structure data used by the Navigator/Completion List to avoid exceptions or crashes
* Improve tab dragging:rowanbeentje2010-08-031-0/+1
| | | | | | - Fix toolbar issues when the last tab is dragged "out of" a window (eg a window is moved via the only tab left inside it) - Fix window positioning flicker when dragging a tab out of its window
* - Make a few more strings localizablerowanbeentje2010-08-011-13/+13
|
* - Replace progress indicator CoreAnimation drawing with manual shadow/fade ↵rowanbeentje2010-07-311-3/+24
| | | | | | | code; this addresses hangs (see Issue #6677) and also prevents triggering the discrete graphics chip on newer MacBook Pros. - Update localisable strings
* - Replace core animation fade of task progress window with custom drawing ↵rowanbeentje2010-07-251-22/+29
| | | | code, in an attempt to fix Issue #677. It appears from testing that this is only a partial fix, but does reduce hang frequency.
* Make the export dialog a little smarter with regard to the current context. ↵stuconnolly2010-07-251-24/+6
| | | | | | | | | | | For example: If either the table content or custom query editor views are active and there is data available, these options will be selected as the export source ('Filtered' or 'Query Result'). If either of these views are not active then the default source are the currently selected tables. If no tables are currently selected then all tables are checked. Note that in this instance the default export type is SQL where as in the case of filtered or query result export the default type is CSV. Also remove some old export methods. Related to issue #610.
* - Improve thread safety when altering task cancellation staterowanbeentje2010-07-211-0/+6
|
* Tab tweaks:rowanbeentje2010-07-201-5/+6
| | | | | | | | - Sheets now appear positioned underneath the tab bar if visible - Tweak bottom corner drawing for a clearer outline, without highlight overlay - Frontmost tab no longer displays server name in the tab Also fix exception when right-clicking on an index to reset auto-increment.
* Make the 'Export' menu item in the 'File' menu behave more like the export ↵stuconnolly2010-07-151-13/+11
| | | | context menu by checking only the selecting tables. If no tables are selected all of them are checked by default (the same as before). Fixes issue #755.
* As the initial MySQL connection is now threaded, start the current tab's ↵stuconnolly2010-07-071-5/+16
| | | | progress indicator to indicate that it's connecting in the event that the user switches to a different tab. Also preserve the tab's label as 'Connecting...' when switching tabs.
* • fine-tuned scrollView position of Custom Query Result tableBibiko2010-07-071-1/+1
| | | | | | | • resized GUI elements (Run Current, Last Error Mes.) for localisation • centered label for "Query Favorites" and "Query History" - maybe we should think about the appearance these buttons! • increased the min width of Custom Query view by 15px in order to avoid GUI overlappings
* Rename TableDump to SPDataImport and fix export selected tables functionality.stuconnolly2010-07-061-5/+5
|
* Rename CustomQuery as SPCustomQuery.stuconnolly2010-07-061-2/+2
|
* - Make the query info/error display collapsible.stuconnolly2010-07-061-1/+1
| | | | | | | - Add a 'gear menu' with the option to export the current result set as either CSV or XML. (Note, that the collapsiable view currently suffers from the same BWToolKit issue as the table information pane).
* Improve tab functionality, behaviour and interaction.rowanbeentje2010-06-301-1/+1
| | | | | | | | | | | | | | | | | | | | | PSMTabBar general improvements: - Fix a phantom tab appearing in windows a tab was just dragged out of - Add support for a new control usersSafariStyleDragging property; this causes tabs being dragged inside a tab bar to snap to the tab bar, be drawn at full transparency (also no longer darkening the placeholder position), and alters tab ordering within the tab bar to be based on the tab position rather than the mouse position, for a more Mac-like reordering feel. - Add support for dragging items onto the menubar to cancel the drag - Alter the image of the dragged tab to use a tab drawn onto a transparent background instead of snapshotting a rectangle around the tab, improving drag appearance - Allow tabs to be dragged partially off screen and keep their position instead of snapping back fully onto the screen - Improve behaviour when dragging tabs out of and back into tab bars, or into new windows, resizing the tabs in the target tab bar to improve display and no longer intermittently showing close buttons while dragging - Pull windows to the front as tabs are dragged onto their tab bars - Abstract Custom Query Editor text snippet code, adding a delegate method so code could be moved to the SP window manager. Sequel Pro tab styling improvements: - Improve and clean up tab drawing code - Draw background tabs with shadows as appropriate - Improve logic for how background tab edges are drawn, handling edges cases better (active tab in overflow menu etc) and vastly improving drawing when a tab is being dragged (respect placeholder position when stacking tabs, draw edges on either side) Sequel Pro tab behaviour improvements: - Improve show/hide tab bar interaction - Improve window positioning after creating new windows via a drag - Alter tab dragging out of the tab bar to use an image based on the full window appearance - looks better, and fixes issues like the tab bar background not being drawn while dragging
* • fixed DBViewSplitter's grabber bounds for splitView:splitView ↵Bibiko2010-06-301-1/+2
| | | | additionalEffectiveRectOfDividerAtIndex:
* • fixed tablesList's searchField width after collapsing tablesList's viewBibiko2010-06-301-0/+17
| | | | • set minimum width of right view (Structure, Content, etc.) in order to avoid irreversible GUI overlaps
* • save window's vertical divider position in spf files in order to be able ↵Bibiko2010-06-291-5/+15
| | | | | | | | | to restore it • do not save tabs or a single window if connectionController is shown • added comments • added to SPTableContent method "tablesListWidth" to retrieve tablesList's view width
* • Open Session fileBibiko2010-06-291-1/+0
| | | | | | - set [tabbar setHideForSingleTab:NO] if window has more than one tab in order to avoid issues while animated fading-in of the tabbar - assign initial keyboard short-cut ^⌥⌘S for Save Session (needs to be discussed) - still hidden
* • allow restoring of a spf file if no table was selected while saving the ↵Bibiko2010-06-281-26/+30
| | | | spf file
* • added to SPconnectionDelegate method "keychainPasswordForSSHConnection"Bibiko2010-06-281-30/+18
|
* • added 'spfs' as allowed extension for open panelBibiko2010-06-271-2/+4
| | | | • avoid adding of in bundle saved spf files to recent files
* • further progress for open/save sessionBibiko2010-06-251-34/+56
| | | | | | - improved remembering of save accessory view settings - if spfs file was saved encrypted ask for it while opening only once • fixed typo while remembering the save accessory view setting for "Remember Query Editor content
* • further progress for open/save sessionBibiko2010-06-251-0/+9
| | | | | - remember window position - remember save accessory view settings in spfs file
* Minor interface tweaks.stuconnolly2010-06-251-1/+1
|
* • fixed issue for saving spf files of ssh connectionsBibiko2010-06-241-3/+19
| | | | | - retrieve the ssh password from keychain • allow to save empty passwords in spf files
* • initial support for open a spfs session file (works rudimentary - ↵Bibiko2010-06-241-1/+1
| | | | | | fine-tuning comes soon) • added constant "SPBundleFileExtension"
* • replaced @"sql" and @"spf" by their SPConstant definitionsBibiko2010-06-241-19/+65
| | | | | | | • further Save Session progress - store "saved as session accessory view data" globally to support "Save Session" - delete global "saved as session accessory view data" if last SP window will be closed - added to info.plist which tab is currently selected
* • further progress to support "Save Session" (all opened windows plus ↵Bibiko2010-06-241-28/+103
| | | | | | | including tabs connections) - loop through all windows and for each window through all tabs and save all untitled doc within the bundle named via UUIDs and all opened spf files • added the SPStringAddition method +[NSString stringWithNewUUID] which returns a new UUID string
* • if user opens a spf file which does not contain connection data display ↵Bibiko2010-06-221-1/+8
| | | | the spf file format (like 'query favorites' etc.) in a message window at least.
* • initial preparations to support the storage of the entire SP session ↵Bibiko2010-06-211-5/+71
| | | | | | | | (all windows including tabs) • added file extension 'spfs' as SP bundle Note: The idea is to save inside the given spfs bundle a file 'Info.list' which contains the entire structure (which window, which tabs, selected items, etc.; each single connection is saved as separate spf file - if untitled inside the bundle in the sub-folder 'Contents' or if not the absolute path to a already saved spf file). This should insure that the user can open a single spf file in SP or as part of a spfs bundle session without loosing having two different spf file for the same connection. - Comments are welcome
* • simplified and unified tab tooltipsBibiko2010-06-181-0/+31
| | | | • added tooltips for tab's overflow menu
* Enable the "Sequel Pro" tab style by default, and include the following fixes:rowanbeentje2010-06-181-1/+3
| | | | | | | | - Fix display of the overflow menu - Improve tab spacing and internal layout - Improve tab names for documents to correctly show the database for background documents in additional cases - Update strings files