aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseDocument.h
Commit message (Collapse)AuthorAgeFilesLines
* Refresh the database drop down menu before selecting the new database after ↵stuconnolly2012-03-281-2/+2
| | | | a rename to prevent a secondary thread using the database list while it's being modified on the main thread. Fixes log reports http://spbug.com/l/2294
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-1/+2
|
* Final feature work on the SPMySQL branch before merging:rowanbeentje2012-03-141-1/+3
| | | | | | | | - Add a ping keepalive managing object to prevent retain cycles from the NSTimer - Add -[SPMySQLConnection copy] support - Refactor Hans-Jörg Bibiko's database structure retrieval, moving it out of the MySQL framework and building it around a copy of the connection. This reduces the amount of connections-over-time used by Sequel Pro to two constant connections (addressing Issue #1097) and improves robustness. - Use the database structure retrieval connection for faster query cancellation without an extra connection required, if possible
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-9/+8
| | | | | | | | | | | | exceptions as database structure retrieval is currently missing! Further work on SPMySQLFramework integration: - Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match - Add new convenience querying and result methods to the framework - Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions - Remove MCPKit from the source - Fix a number of warnings on Release-style builds
* - Update database encoding routines to cache the database encoding, ↵rowanbeentje2011-09-291-0/+2
| | | | | | | preventing repeated calls when navigating tables using "default" encoding, or views - Ensure the database encoding is correctly updated when new databases are selected. This addresses Issue #1201
* Fix for issue 1168. Whenever the database is changed load all of the ↵stuconnolly2011-09-041-11/+13
| | | | currently used relation names in a backgroud thread. In the event that the user opens the add new relation sheet during this process, the ability to enter a relation name and confirm the addition is disabled until the retrieval process is complete. There is also a new progress indicator on the add sheet to indicate this.
* - Clean up undo manager handlingrowanbeentje2011-08-311-0/+2
| | | | | - Implement an undo manager per tab (strictly speaking, per connection 'document'), addressing Issue #1109.
* - Lion compatibility improvement: add support for fullscreen windows, on ↵rowanbeentje2011-08-161-0/+2
| | | | | | | | | | | the main window only; hide SSH/SSL status when entering fullscreen mode, to prevent drawing issues - Lion compatibility improvement: update tab colours under 10.7 to match system styles - Lion compatibility improvement: fix issues dragging tabs out of windows and into other tab bars - Lion compatibility improvement: fix QuickLook issues under 10.7, including windows which couldn't be closed, fullscreened, or crashes - Fix exceptions in the bundle controller when using tab switching keys - Lion compatibility improvement: use overlay scrollers where possible
* merged latest SP_REFACTOR changessqlprodev2011-08-021-3/+21
|
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-5/+9
|
* - Fix a number of warnings for DBView.xib by moving some 10.6-only code ↵rowanbeentje2011-05-081-4/+4
| | | | | | | from a #ifndef SP_REFACTOR/#else/#endif to just a #ifdef SP_REFACTOR/<protocol declaration>/#endif, and remarking a few items as IBOutlets - Update localisable strings
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-1/+3
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-12/+66
| | | | UI code from functional code
* Fix Issue #1019 (Sidebar width not remembered):rowanbeentje2011-04-011-1/+1
| | | | | | | - This may be due to an Apple bug. I tracked it down to purely SPDatabaseDocument having a reference outlet to the activity scroll view. - Removing the reference worked as a fix; removing all code that used that reference did not. - Renaming the reference, and removing SPTableInfo's use of a reference, appears to act as a workaround. If the reference is not renamed, the bug still mainfests (!!!)
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-081-8/+9
|
* Fix more compiler warnings.stuconnolly2011-03-041-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-1/+3
|
* • show activity pane for running Bundle process automatically if the ↵Bibiko2011-01-201-0/+4
| | | | process runs longer than 1 sec and hide it if no process runs anymore to inform the user better
* • improved timing behaviour for a SPDatabaseDocument if it receives a ↵Bibiko2010-12-171-0/+2
| | | | sequence of URL scheme commands
* • sequelpro URL scheme supportBibiko2010-12-151-0/+1
| | | | | - added command "SyntaxHighlighting/format" which returns the syntax highlighted string due to the format settings (up to now html and htmlcss) - added command "CreateSyntaxForTables/item1/item2/…/{format}" which returns all CREATE SYNTAX statements of the passed items and if passed syntax highlighted due to format (optional)
* - Add the ability to stop animation of the task indicator, and use it to ↵rowanbeentje2010-12-051-0/+1
| | | | pause the task indicator animation when custom queries are paused and waiting for user interaction after an error
* • added chance to cancel an activity - up to now a running Bundle command ↵Bibiko2010-12-011-4/+4
| | | | | | - from the Activities pane (toggable via double-clicking at Table Information header); it's still tentative and the correct cancel icon will follow asap • added notification system for updating the activities pane (SPActivitiesUpdateNotification)
* • Bundle commandsBibiko2010-11-291-1/+6
| | | | | - register running commands for each SPDatabaseDocument or if the command runs via 'General' for NSApp delegate - kill all running commands before SP will be terminated
* - Abstract SPDatabaseDocument's Connection/.spf saving/loading ↵rowanbeentje2010-11-231-1/+6
| | | | | | | | | | functionality into state setting and getting functions, and refactor old commands to use them - Fix restoring of content sort column order and selected indexes - Add menu items for duplicating current tab (as an alternate), opening selected table in a new tab, or opening selected database in a new tab - Clean up file menu by making Connection/Session "Save as..." menu items alternates - Update localisable strings
* • Bundle supportBibiko2010-11-161-0/+1
| | | | | | - further simplifications and centralizations - runBashCommandWithEnvironment: now it can execute each script command whose first line begins with #!/... natively - added some more shell variables
* • added to Bundle shell command these variables:Bibiko2010-11-111-0/+3
| | | | | | | | | | SP_ALL_DATABASES, SP_ALL_TABLES, SP_ALL_VIEWS, SP_ALL_FUNCTIONS, SP_ALL_PROCEDURES, SP_RDBMS_VERSION, SP_RDBMS_TYPE [hard-coded yet ;)] • some minor improvements to editor Bundle support • fixed issue while running a bash command that the SP GUI doesn't block • added first sequelpro url scheme functionality - sequelpro://$SP_PROCESS_ID/passToDoc/SelectTable/a_name - sequelpro://$SP_PROCESS_ID/passToDoc/SelectDatabase/a_db_name - sequelpro://$SP_PROCESS_ID/passToDoc/SelectDatabase/a_db_name/a_table_name
* • some improvements for sequelpro://process_id/command/param1/param2 url ↵Bibiko2010-11-111-0/+2
| | | | | | scheme support - introduced an unique process ID for each called bash command which will be set for the current SPDatabaseDocument and passed as environment shell variable SP_PROCESS_ID to ensure that such a scheme command will be executed by the correct SPDatabaseDocument, to avoid security issues ie one can authenticate such a sheme command, to enable url scheme process communication based on file shake-hands etc.
* First changes towards changing the initial connection view's favorites table ↵stuconnolly2010-11-091-2/+2
| | | | list to an outline view in order to support grouping favorites. Future changes include creating a favorites data controller, including migrating favorites storage to their own plist in the app support directory as well as support for grouping favorites.
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-8/+10
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* Move SPConnectionController's delegate methods to their own protocol.stuconnolly2010-10-291-1/+3
|
* Split MCPConnection's delegate methods into it's own protocol.stuconnolly2010-10-201-1/+0
|
* Tidy up.stuconnolly2010-10-191-1/+0
|
* Add a 'Refresh Tables' menu item to the 'Database' menu. It currently has ↵stuconnolly2010-10-191-0/+1
| | | | the shortcut Ctrl+Cmd+R, but this can always be remapped in system preferences. Implemented issue #845.
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-2/+10
| | | | | | | | | | | | | - 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.
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-4/+0
| | | | | | | | | | | 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-0/+2
| | | | | | | 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)
* - Replace core animation fade of task progress window with custom drawing ↵rowanbeentje2010-07-251-2/+2
| | | | 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-2/+1
| | | | | | | | | | | 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.
* Make the 'Export' menu item in the 'File' menu behave more like the export ↵stuconnolly2010-07-151-1/+1
| | | | 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.
* • replaced @"sql" and @"spf" by their SPConstant definitionsBibiko2010-06-241-0/+3
| | | | | | | • 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-1/+1
| | | | | | | 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
* • simplified and unified tab tooltipsBibiko2010-06-181-0/+1
| | | | • added tooltips for tab's overflow menu
* • if a text string is dragged on tab this tab will be selected and the ↵Bibiko2010-06-171-0/+1
| | | | corresponding db doc switches to Custom Query editor to be able eg to drag a query from one tab to another one
* - Convert connection encoding menus to be menu tag based to fix ↵rowanbeentje2010-06-141-3/+3
| | | | | | | | | | localisation errors - Add database encoding retrieval support for MySQL 4.1 - Convert the add table and add database sheets to use encoding menus derived from server supported encodings - Re-layout preferences with larger labels to aid localisation - Fix preference resizing in non-Favorite tabs
* Changed the SPUserManager instance to an allocated instance when the ↵mltownsend2010-05-281-1/+1
| | | | SPUserManager is selected. SPUserManager is released when the user his cancel or apply. This forces the UI to refresh itself.
* Rename TableDocument to SPDatabaseDocument.stuconnolly2010-05-281-0/+341