aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* Rework relation addition and name lookups following testing and research:rowanbeentje2011-09-071-2/+0
| | | | | | | | - Remove the background lookup of table constraint names for the current database. This prevented connection use while the query was running, and the query cannot be optimised and severely taxes servers with many databases. Revert to checking names against names in the current database - Repurpose the activity spinner for adding relation query execution - When an error is encountered adding a relation, re-open the sheet with the submitted values after displaying the error - Add use of 'SHOW InnoDB STATUS' command and text extraction to show more explicit errors for the most common constraint errors
* Fix for issue 1168. Whenever the database is changed load all of the ↵stuconnolly2011-09-041-5/+11
| | | | 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.
* Tidy up console/query controller.stuconnolly2011-09-031-0/+1
|
* * Fixes some localization spacing issues reported by Frédéric Latourdmoagx2011-09-021-1/+1
|
* - Clean up undo manager handlingrowanbeentje2011-08-311-0/+12
| | | | | - 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-13/+40
| | | | | | | | | | | 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
* - Review changes made in r3376 and revert a number of regressionsrowanbeentje2011-08-141-6/+4
|
* Fix encoding issues, particularly giving errors when selecting tables and ↵rowanbeentje2011-08-071-1/+5
| | | | | | | | | | | displaying NULLs within tables when the connection encoding is incorrectly detected (Issue #1100): - No longer rely on a combination of mysql_options(..., MYSQL_SET_CHARSET_NAME, ...utf8...) and mysql_character_set_name() to detect the connection encoding; this incorrectly misses init_connect commands; instead use SHOW_VARIABLES a$ - Combine initial version check/timezone check/encoding check on startup, reducing connection queries and thus improving connection speed - Add support for abbreviated MySQL timezone definitions - Combine MCPKit's -connect and -connectWithLogin:password:host:port:socket: methods to reduce code duplication and fix argument handling for the latter method
* merged latest SP_REFACTOR changessqlprodev2011-08-021-13/+83
|
* - Fix saving .spf documents without SSH key locations stored, addressing ↵rowanbeentje2011-06-061-1/+2
| | | | exceptions when re-saving old .spf files
* - Ensure blank passwords for MySQL connections are passed in as NULL ↵rowanbeentje2011-05-291-5/+2
| | | | instead of an empty string; the MySQL manual suggests that maybe we should be doing this, and it may address Issue #1065.
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-16/+24
|
* • added URL scheme command ↵Bibiko2011-05-111-0/+14
| | | | sequelpro://SP_PROCESS_ID@passToDoc/RunQueryInQueryEditor/ which executes a passed SQL query and displays the result if any in the data table of the query editor
* * Fixes most parts of #1006 (Translation of file names)dmoagx2011-05-101-1/+1
| | | | * Update strings files
* Add the ability to double click a tab to duplicate the connection in a new ↵stuconnolly2011-05-091-6/+1
| | | | tab (equivalent to the 'Open Database in New Tab' menu item). Implements issue #1040.
* Minor tidy up.stuconnolly2011-05-081-9/+12
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-2/+2
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-2/+23
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-3/+3
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-15/+200
| | | | UI code from functional code
* - When restoring connections and sessions, correctly clear and restore ↵rowanbeentje2011-04-041-1/+18
| | | | keychain names and accounts. This addresses incorrect password use, fixing Issue #1020
* Fix Issue #1019 (Sidebar width not remembered):rowanbeentje2011-04-011-3/+6
| | | | | | | - 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 .spfs files not being added to the Recent Documents menu, addressing ↵rowanbeentje2011-03-311-3/+1
| | | | Issue #1011
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-081-37/+41
|
* Fix more compiler warnings.stuconnolly2011-03-041-1/+1
|
* - Fix more compiler warningsrowanbeentje2011-03-041-2/+2
|
* Fix compiler warnings.stuconnolly2011-03-011-2/+6
|
* fixed compiler warningssqlprodev2011-03-011-1/+2
|
* fixed compiler warningssqlprodev2011-03-011-1/+1
|
* - Don't bring the task window to the front before re-adding it to the ↵rowanbeentje2011-02-061-1/+0
| | | | parent window on making that tab foremost, which is unneccessary and can cause switching to the previous Space. This addresses Issue #970.
* • changed the behaviour of ⇧⌘K (Show/Hide Console) slightlyBibiko2011-02-011-16/+17
| | | | - the main purpose of that keyboard short-cut is the SHOW the Console window even if it's visible but hidden under other windows; now ⇧⌘K orders out the Console window if it's invisible or visible but mot the front most window; if it's the front most window ⇧⌘K will hide it
* • fixed updateWindowTitle: threading issueBibiko2011-02-011-1/+1
| | | | | | - if (![NSThread isMainThread]) return [self updateWindowTitle:sender]; will run forever if called not from main thread; instead do: if (![NSThread isMainThread]) return [[self onMainThread] updateWindowTitle:sender];
* - Ensure window title updates occur on the main thread, fixing crashes ↵rowanbeentje2011-01-311-6/+10
| | | | under race conditions
* • show activity pane for running Bundle process automatically if the ↵Bibiko2011-01-201-0/+33
| | | | process runs longer than 1 sec and hide it if no process runs anymore to inform the user better
* • while saving connection/session as spf(s) make "Remember Query Editor ↵Bibiko2011-01-171-2/+6
| | | | | | content" checked as default - issue 900
* • added sequelpro URL scheme commands passToDoc/SetText/<text>, ↵Bibiko2011-01-141-0/+40
| | | | passToDoc/InsertText/<text> and passToDoc/SetSelectedTextRange/<range> which work on the first responder of the called SPDatabaseDocument regardless of the NSApp first responder for long running scripts
* • changed sequelpro URL command SyntaxHighlighting to be connection ↵Bibiko2011-01-101-137/+0
| | | | independent - added example BASH script at http://www.sequelpro.com/docs/URL_scheme_sequelpro://_Usage#Use_Sequel_Pro_to_do_a_syntax_highlighting_of_a_given_SQL_query_HTML_formatted
* Address Issue #857:rowanbeentje2010-12-201-13/+2
| | | | | | | | - Replace master connection and database view split views with full BWSplitViews so controls appear in Interface Builder; use those settings to apply which panes resize, and any max/min constraints - Remove split view delegate code which is no longer necessary after these changes - Fix a bug marking the master database view split view thumb as applying to all DatabaseDocument splits views, fixing cursor issues - Update Connection Controller/BWToolkit split view delegate setup to fix resizing issues
* * Recognize "performance_schema" as system DB (added in 5.5)dmoagx2010-12-181-1/+2
|
* • minor improvements, commenting, cleaning for URL scheme commandsBibiko2010-12-171-1/+16
|
* • improved timing behaviour for a SPDatabaseDocument if it receives a ↵Bibiko2010-12-171-5/+18
| | | | sequence of URL scheme commands
* • allow to some sequelpro URL scheme commands like select a table/db the ↵Bibiko2010-12-171-42/+50
| | | | usage without a specific SP_PROCESS_ID
* • sequelpro URL scheme supportBibiko2010-12-151-5/+281
| | | | | - 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)
* • URL scheme commands:Bibiko2010-12-141-3/+35
| | | | - display some error tooltips and improved the cancellation via ⌘. of the sequelpro://SP_PROCESS_ID@passToDoc/ExecuteQuery command
* • HTML output windowBibiko2010-12-131-0/+3
| | | | | - a BASH script called via window.system.run() inherits the current shell vars and the associated SP_PROCESS_ID if set to make it easier to run sequelpro URL scheme commands from JavaScript via BASH - improved error handling
* • made usage of more constants to avoid double-storing stringsBibiko2010-12-121-13/+13
| | | | • fixed JavaScript alert and confirm window in HTML output window
* - Fix an issue where after failing to select a database the database ↵rowanbeentje2010-12-111-2/+6
| | | | dropdown stayed disabled
* • avoided to execute SHOW VARIABLES LIKE 'character_set_database' twice ↵Bibiko2010-12-101-2/+1
| | | | for setting shell variables for Bundle commands
* • Bundle CommandsBibiko2010-12-091-1/+1
| | | | | | - added shell vars SP_CURRENT_EDITED_COLUMN_NAME, SP_CURRENT_EDITED_TABLE for Input Field scoped commands if invoked from a table cell field editor - added shell var SP_TABLE_DATA_SOURCE (content or query) - fixed table row change trigger for custom query tableView
* • Bundle command supportBibiko2010-12-071-0/+22
| | | | | - fixed issue for commands without assigning a key equivalent - output table meta data about type, type grouping, length, auto_inc, PRI key etc. for Data Table scope commands and sequelpro url scheme command ExecuteQuery