aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPDatabaseDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* Bring outline view branch up to date with trunk (r3056:r3162).stuconnolly2011-01-271-134/+74
|\
| * • 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
* | Bring fravorites outline view branch up to date with trunk (r3036:3058).stuconnolly2010-12-281-14/+4
|\|
| * 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
| |
* | Bring outline view branch up to date with trunk (r3030:3035).stuconnolly2010-12-171-26/+338
|\|
| * • 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)
* | Bring outline view branch up to date with trunk (r3018:3028).stuconnolly2010-12-141-3/+35
|\|
| * • 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
* | Bring outline view branch up to date with trunk (r3011:3016).stuconnolly2010-12-131-0/+3
|\|
| * • 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
* | Bring outline view branch up to date with trunk (r3007:3010).stuconnolly2010-12-121-15/+19
|\|
| * • 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
* | Bring outlineview branch up to date with trunk (r2989:3005).stuconnolly2010-12-111-3/+2
|\|
| * • 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
* | Bring outline view branch up to date with trunk (r2976:2988).stuconnolly2010-12-081-0/+22
|\|
| * • 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
* | Bring outlineview branch up to date with trunk (r2967:2974).stuconnolly2010-12-061-0/+15
|\|
| * • finished implementation of SPChooseMenuItemDialogBibiko2010-12-061-0/+2
| | | | | | | | | | • simplified bundle command handling and handling for bundle commands which have the same key equivalent to be able to group similar bundle commands • minor code improvements
| * - Add the ability to stop animation of the task indicator, and use it to ↵rowanbeentje2010-12-051-0/+13
| | | | | | | | pause the task indicator animation when custom queries are paused and waiting for user interaction after an error
* | Apply new favorites outline view patch.stuconnolly2010-12-051-4/+4
|/
* • Bundle CommandsBibiko2010-12-011-9/+27
| | | | | - make sure that each HTML output window will be released - if a triggered command will outputs its result in an HTML window invoke it only if the HTML output window is already open; this enables the user to "switch on/off" such a trigger
* • Bundle Editor / Bundle commandsBibiko2010-12-011-16/+20
| | | | | | | - enabled trigger support to run a command if db, table, or table row was changed - HTML output window will be ordered out without making it the key window to remain the first responder • SPTableTExtFieldCell - forgotten to remove expansionFrameWithFrame: method
* • progress on trigger support for Bundle commandsBibiko2010-12-011-0/+17
|
* • added chance to cancel an activity - up to now a running Bundle command ↵Bibiko2010-12-011-10/+10
| | | | | | - 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)
* • fixed issue for saving spf files if sslCertificateFileLocation is nilBibiko2010-11-301-2/+2
| | | | | | | | | • SPConnectionController - assign favoritesTable to the correct new class SPFavoriteOutlineView (not a NSTableView) - allowed empty selection for SPFavoriteOutlineView [ this fixes mainly the issue to open spfs files ] - moved double-click action to outlineView:shouldEditTableColumn:tableColumn item: to suppress double-click at a group header - re-enabled navigation through the fav outlineView even if the password field is empty - now if the field is empty the user can simply press TAB key move the focus to that field - this fixes issue 799 • minor code cleaning
* • Bundle commandsBibiko2010-11-301-0/+17
| | | | | | - before closing a db doc window kill all commands associated to this doc - suppress an error message if a bash command was killed via code 9 - added a temporary and preliminary table view to display command activities (double-click at TABLE INFO header to toggle and refresh it - only for testing purposes - it shows all commands started from that db doc and a General command names)
* • Bundle commandsBibiko2010-11-291-1/+25
| | | | | - 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
* - Fix issues right-clicking in the empty table area ( http://spbug.com/l/1726 )rowanbeentje2010-11-271-1/+1
| | | | | | | - Improve 10.5 compatibility when clearing menus ( http://spbug.com/l/1508 , http://spbug.com/l/1829 , http://spbug.com/l/1818 ) - Fix a possible crash when updating database lists - Update localisable strings
* - Right-align numeric columns in table content views and custom query resultsrowanbeentje2010-11-271-2/+2
| | | | | - Fix exceptions caused by nil SSL locations when re-saving old session files
* • Bundle EditorBibiko2010-11-231-0/+7
| | | | | | | - fixed gui arragement - suppress error message if no ouptut key found in command.plist • added sequelpro://ID@/passToDoc/SelectTableRows/1/3/4/.. scheme command which selects given rows in current table if a SPCopyTable is the first responder; not valid given rows are ignored • added SP_SELECTED_ROW_INDICES as passed shell variable for Data Table scope
* - Abstract SPDatabaseDocument's Connection/.spf saving/loading ↵rowanbeentje2010-11-231-568/+696
| | | | | | | | | | 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
* • sequelpro url scheme supportBibiko2010-11-221-4/+42
| | | | | | | • added commands: SelectDocumentView, ReloadContentTableWithWHEREClause • fixed typos • tried to queue incoming commands
* • renamed some shell variables for Bundle commandsBibiko2010-11-221-0/+17
| | | | • added sequelpro scheme commands: SelectTables, ReloadTablesList, ReloadContentTable
* • Bundle supportBibiko2010-11-161-0/+52
| | | | | | - further simplifications and centralizations - runBashCommandWithEnvironment: now it can execute each script command whose first line begins with #!/... natively - added some more shell variables
* • Bundle supportBibiko2010-11-151-6/+4
| | | | | | | - outsourced code to SPAppController to centralise Bundle support and make it available for different scopes (query editor, input text fields, data tables etc.) - store bundle info scope-based - added input text field support - made usage of constants
* • improved export of a query result via sequelpro:// scheme commandBibiko2010-11-121-10/+61
|
* • some sequelpro://...@passToDoc/ExecuteQuery/csv improvementsBibiko2010-11-111-4/+24
|
* • some tiny progress for sequelpro://$SP_PROCESS_ID/ExecuteQueryBibiko2010-11-111-2/+57
|
* • added to Bundle shell command these variables:Bibiko2010-11-111-0/+43
| | | | | | | | | | 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 implementation to allow the user to write and use self-definable ↵Bibiko2010-11-101-1/+3
| | | | | | | | | | | | | | | | | | functions inside the Custom Query Editor - such commands will be stored as foo.spBundle in SP's Application Folder/Bundles - up to now they will be displayed inside the context menu as submenu Bundles which can be by itself contain further submenus specified via 'category' key - to each command the user can assign a tooltip and a keyboard short-cut; if user chose a standard SP short-cut it will be ignored - commands will be executed as bash commands ie it can also be written in any script language - the bash process inherits several environment variables like SP_BUNDLE_PATH, SP_SELECTED_TEXT, SP_SELECTED_DATABASE, SP_SELECTED_TABLE, SP_CURRENT_QUERY, SP_CURRENT_LINE, SP_CURRENT_WORD - the bash command's result can be processed as follows: insertAsText, insertAsSnippet, replaceContent, replaceSeletion (with fallbacks to word, line, query, entire content), showAsTextTooltip, showAsHTMLTooltip - up to now all installed bundles are reload for each menuForEvent: [this is tendative!] - each spBundle command has a scope to allow to the user to specify for which SP element a command can be useful; up to now only the scope 'editor' is supported; further scopes could be 'data table' for context menus of mysql table data (Content or Custom Query - including info of selected lines, table data in different formats, etc.) - foo.spBundle files can be installed simply by double-clicking at it (remember up to now Bundles will be reloaded while opening the editor's context menu!) two tiny examples for testing: http://wwwstaff.eva.mpg.de/~bibiko/dt/temp/spBundleExamples.zip