aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* • work on Bundle Editor GUIBibiko2010-11-161-83/+1933
| | | | - note: it makes usage of the new ShortcutRecorder.ibplugin
* - Add the NewBSD-licensed ShortcutRecorder.framework to the project, for ↵rowanbeentje2010-11-1625-1/+550
| | | | | | | initial use in the bundle editor (not implemented yet). Includes the .ibplugin within the framework. - Update localisable strings
* • Bundle SupportBibiko2010-11-163-30/+165
| | | | | | - improved Data Table input commands SelectedTableRowsAsTab/Csv/SqlInsert, TableRowsAsTab/Csv/SqlInsert • fixed issue for Copy with Column Names: removed ?\020last appended tab in header line
* • Bundle supportBibiko2010-11-163-37/+61
| | | | | - further minor improvements - make usage of more constants
* • added SPConstants.m source file to QLgenerator target in order to be ↵Bibiko2010-11-161-0/+2
| | | | able to make usage of constants in categorial addition files
* • Bundle supportBibiko2010-11-167-102/+123
| | | | | | - further simplifications and centralizations - runBashCommandWithEnvironment: now it can execute each script command whose first line begins with #!/... natively - added some more shell variables
* • sql QL Bibiko2010-11-161-2/+0
| | | | | - fixed appending of the entire sqlText after parsing - removed replacing of / for better wrapping since it'll break the syntax highlighting
* - Attempt to improve QuickLook crashes by using a pool around the area ↵rowanbeentje2010-11-161-2/+20
| | | | | | | causing crashes on certain files (lines 420,422) - Improve SQL wrapping
* • Bundle supportBibiko2010-11-165-117/+256
| | | | | - added skeleton for scope datatable support - removed unnecessary code
* • Bundle supportBibiko2010-11-155-85/+138
| | | | | | - started to populate the main menu item Bundles [still hidden] - enabled key equivalents for NSTextViews - distinguishes between Query Editor scope and text input scope via menu item validation inside main menu Bundles
* • Bundle supportBibiko2010-11-1510-164/+561
| | | | | | | - 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
* • Quicklook - some minor correctionsBibiko2010-11-151-15/+15
| | | | - note : still some sql files can be opened only sometimes - reason can't pin down so far
* • Quicklook supportBibiko2010-11-1512-81/+89
| | | | | | | | | - used embedded icon image via cid and mime type image/tiff - sql view now wraps long lines - improved general stability - QL now runs on main thread note: there're still some issues for which QL crashed mostly due NSAutoReleasePool releases - more investigations are needed; most of this issues are releted to long lines, icon caching, releasing ...
* - Tweak "Save history..." help text in the Query History popup on the ↵rowanbeentje2010-11-151-12/+128
| | | | Custom Query view. This addresses Issue #897
* - Switch to explicit memory management of strings in the QuickLook plugin ↵rowanbeentje2010-11-153-10/+17
| | | | | | | when viewing SQL files - this fixes certain crashers, addressing Issue 896. - Tweak a misspelling in the templates
* The favorites controller needs to load favorites into a mutable dictionary.stuconnolly2010-11-122-3/+3
|
* • tried to improve the release behaviour of the QuickLook Preview GeneratorBibiko2010-11-121-16/+31
| | | | - addresses issue 896
* • added constants for Bundle Files and EditorBibiko2010-11-122-0/+72
| | | | • added URL scheme constants
* • added skeleton for Bundle EditorBibiko2010-11-127-9/+1275
| | | | - not yet visible
* • improved export of a query result via sequelpro:// scheme commandBibiko2010-11-121-10/+61
|
* - Tweak master view loading on table change, avoiding clearing active views ↵rowanbeentje2010-11-121-5/+9
| | | | unnecessarily. This improves speed slightly by reducing interface interaction, and preserves state better during actions, fixing bugs like Issue #574.
* - Tweak connection/reconnection to use locking, to prevent race condition ↵rowanbeentje2010-11-121-1/+7
| | | | issues when reconnecting after a network loss causing a drop in connection and proxy at the same time.
* • some sequelpro://...@passToDoc/ExecuteQuery/csv improvementsBibiko2010-11-114-24/+58
|
* Remove debug from previous commit.stuconnolly2010-11-111-3/+0
|
* Make sure the root favorite has a name key and value. Also, update string files.stuconnolly2010-11-117-6/+13
|
* More constant use.stuconnolly2010-11-111-7/+7
|
* Add SSL favorite constants and use them in the connection controller.stuconnolly2010-11-113-70/+104
|
* Refactor the favorite node class and fix auto-selection of the default or ↵stuconnolly2010-11-115-51/+59
| | | | last used favorite.
* Commenting and move SPFavoriteNode within Xcode's logical structure.stuconnolly2010-11-112-2/+7
|
* • some tiny progress for sequelpro://$SP_PROCESS_ID/ExecuteQueryBibiko2010-11-111-2/+57
|
* More work on the new favorites controller, including loading and saving as ↵stuconnolly2010-11-117-16/+271
| | | | well as the method to migrate existing favorites data. Currently not yet active.
* • added to Bundle shell command these variables:Bibiko2010-11-117-24/+118
| | | | | | | | | | 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-114-2/+61
| | | | | | 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.
* Add a new outline view to be used by the connection view so hitting enter ↵stuconnolly2010-11-105-44/+120
| | | | doesn't start editing the selected favorite. This will also allow behaviour to be further customised. Fixes issue #892.
* Add a new class template for the favorites controller.stuconnolly2010-11-1011-28/+205
|
* • improved Bundle support; now it the passed input string will be saved as ↵Bibiko2010-11-104-54/+90
| | | | | | | temp file SP_BUNDLE_INPUT_FILE since stdin and shell vars are difficult to handle for a large amount of data • fixed AppleScript class definition since it was renamed • added support for the URL scheme 'sequel' to allow to interact with Sequel Pro eg via bash: open 'sequelpro://executequery=select%205' [not yet implemented ;)]
* • first implementation to allow the user to write and use self-definable ↵Bibiko2010-11-102-7/+151
| | | | | | | | | | | | | | | | | | 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
* • further preparations for user-definable bundle supportBibiko2010-11-102-20/+104
|
* - Alter connection details to be sent over UTF8 instead of Latin1 - this ↵rowanbeentje2010-11-102-19/+36
| | | | | | | | improves handling of special characters in passwords, improving Issue #890 - Improve code in (the unused) [MCPConnection connectWithLogin:password:host:socket:] to match latest updates in the rest of the framework - Fix creation of new users
* • further preparations for user-definable bundle supportBibiko2010-11-094-19/+75
|
* Minor dealloc change.stuconnolly2010-11-091-3/+3
|
* Comments.stuconnolly2010-11-092-2/+21
|
* • further preparations for user-definable bundle supportBibiko2010-11-095-3/+91
|
* Fix build errors.stuconnolly2010-11-093-1/+4
|
* First changes towards changing the initial connection view's favorites table ↵stuconnolly2010-11-0912-237/+508
| | | | 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.
* • added spBundle file extensionBibiko2010-11-094-0/+54
|
* • added to SPStringAddition the method ↵Bibiko2010-11-094-91/+118
| | | | | | | runBashCommandWithEnvironment:atCurrentDirectoryPath:error which will run self as bash command and will return its result - if an error occurred it will return a NSError if desired - added the chance to pass shell environment variables and start directory for future usage in user-definable plugins written as scripts
* • removed unnecessary space inside the WHERE clause generation for ↵Bibiko2010-11-071-1/+1
| | | | filtered table content
* When exporting either a filtered or custom query result include the query in ↵stuconnolly2010-11-071-2/+8
| | | | the opening resultset tag that produced the result.
* Minor tweaks to autocompletion:rowanbeentje2010-11-062-15/+22
| | | | | | - Show the text cursor at the location future input will be inserted for clarity - Show autocompleted text faded to indicate it's temporary and may be replaced by other keypresses