| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
|
|
|
|
| |
- 'is (not)' and 'contains (not)' are now defined as: take the argument literally, ie % and _ will be escaped automatically
- in string fields one can look for \n , \r , \t
- added LIKE and NOT LIKE operators to strings to be more transparent
- a routine detects automatically whether a placeholder was wrapped into ' or " and if so ' or " will be escaped
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- all default filters come from "ContentFilters.plist" which can be localized
main structure:
<plist>
<dict>
<key>number</key>
<array/>
<key>string</key>
<array/>
<key>date</key>
<array/>
</dict>
</plist>
filter item structure: [ ${} is a place holder for an argument ]
<dict>
<key>MenuLabel</key>
<string>BETWEEN</string>
<key>Tooltip>
<string>a tooltip</string>
<key>NumberOfArguments</key>
<integer>2</integer>
<key>ConjunctionLabels</key>
<array>
<string>AND</string>
</array>
<key>Clause</key>
<string>BETWEEN '${}' AND '${}'</string>
</dict>
- if NumberOfArguments == 0 then start filtering automatically
- now one can save his/her own filters in SP's preferences.plist (GUI follows soon)
- fixed issue for filters requiring two arguments that pressing RETURN if one is in the second argument input field invokes "Filter"
- added string operators: "IS EMPTY" and "IS NOT EMPTY"
- fixed issue that now one is able to look for eg \n in string fields
|
| |
|
|
|
|
|
|
|
|
|
|
| |
• outsourced default QuickLook types into a localizable plist
- prepared SP preferences and SP code to allow the user to add own QL types
• prepared a localizable 'ContentFilter.plist' [not yet implemented fully]
- this plist will held the default filter operators
- this approach will give the user the chance to add own filters
• removed three tiny memory leaks
Note: In MCPResult.m variable 'MCPYear0000' was stored retained. Why?
I removed it and couldn't encounter any problems.
|
| |
|
|
|
|
|
|
|
| |
- This is up to now a kind of a 'hack' since SP will be compiled against SDK10.5 but if SP runs on 10.6 it'll use code from a 10.6 framework.
- Under 10.6 full screen mode is available and QL does run in its own run loop ie now it's non-modal
- Changed the way of removing temp files; now all files will be deleted while closing the sheet to fix issues if the user double-click at the QL item and the called app was too slow - this ended up in getting the message 'File not found'
- Changed default container extension for images since 'pict' isn't support under 64bit 10.6; now SP makes usage of 'icns'
• outsourced QuickLook types (show as pull down menu) to SP's preference plist. (up to now only 'power users' can change that type list via a Property List editor)
• enhanced the caching behaviour of the sheet editor in terms of triggering a refresh if the text content was changed (this fixes the issue that it could happen that binary data were interpreted as text data)
|
| |
|
|
|
|
|
| |
- Add defaults for fine-grained logging preferences
- Add a method to TableDocument to allow setting the query mode, and use the query mode to control logging
- Set import/export and custom query to set the appropriate query modes
|
| |
|
|
|
|
|
| |
- added to History list "Replace Editor Content" (stored in the prefs) and a search field
- "Save ... to Favorites" menu title changes according to selection in the textView
Problem: How can we allow if the user hits RETURN in a search field (fav/history) to select the next menu item if any and to change the first responder to popup button menu list?
|
| |
|
|
|
|
| |
- "Replace Editor Content" check box menu item; if checked the chosen query will replace the editor's content if not it will insert it (setting will be saved in the prefs)
- Search Text Field to filter the list of names (by using a regular expressions)
- added a tooltip to each menu item displaying the query behind the name
|
| | |
|
| |
|
|
|
|
|
|
|
| |
will be saved in the Prefs
• font settings in the Field Editor Sheet will be saved in the Prefs
• improved max text length checking while using other InputManager (eg Japanese etc.) - still a bit under construction
Note: each Beep() wil be replaced by a tooltip soon.
|
| |
|
|
|
| |
- lastSqlFileEncoding will be stored in the Preference.plist
- to open SPF files not yet supported
|
| |
|
|
|
|
|
|
|
| |
- Open/Save menu items are hidden
• initial support for drag&drop files *.spf and *.sql to SP's icon or double-click at *.sql or *.spf files in Finder
- SP starts if not already running
- sql files will be executed in the Custom Query if at least one connection is open
- spf files not yet supported
-
|
| | |
|
| |
|
|
|
|
|
|
| |
position that would hide content
- Store collapse state of table information panel in preferences
- Apply a double fix for BWSplitView/NSSplitView+BWAnchoredButtonBar not informing delegates of resizes - correctly inform original BWSplitView delegates of resizes, and allow BWAnchoredButtonBar registered delegates to recieve the original split view resize notifications. This fixes database menu resizing in synch with splitview resizing for improved/consistent look and feel.
|
| |
|
|
| |
behave like proper buttons, allowing clicking and dragging out to cancel the click, and highlight states
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- Includes all custom code from subclasses CMMCPConnection and CMMCPResult, meaning they have subsequently been removed from the project.
- All previous Sequel Pro specific code in the above subclasses has been removed in favour of the delegate (currently set to TableDocumet) informing the framework of such information.
- All references to CMMCPConnection and CMMCPResult have subsequently been changed to MCPConnection and MCPResult.
- Framework includes MySQL 5.1.36 client libraries and source headers.
- Framework is now built as a 4-way (32/64 bit, i386/PPC arch) binary.
- All import references to <MCPKit_bundled/MCPKit_bundled.h> have been changed to <MCPKit/MCPKit.h>.
- New script 'build-mysql-client.sh' can be used to build the MySQL client libraries from the MySQL source. See the script's header for a list of available options or run it with no arguments to display it's usage.
Note that there are still a few changes to be made to the framework with regard to removing Sequel Pro specific calls to the delegate. These however can be made later on as they have no effect on functionality and are merely design changes.
Also, note that any future development done on the framework should be made to be as 'generic' as possible, with no Sequel Pro specific references. This should allow the framework to be integrated into another project without the need for SP specific code.
|
| |
|
|
|
| |
• added: spinning wheel background image
• removed warning in TableContent (unused 'j')
|
| |
|
|
|
|
|
|
|
| |
addressing the first part of #209:
- For the first column linked by each foreign key, display a link arrow within the table cell
- When clicking on the link arrow, select the reference table and set the table filters to select the clicked value
- Also uses the table cell subclass to allow the entire cell to be editable, not just the contained text (addresses #250)
|
| | |
|
| |
|
|
|
| |
- added view icon for Views
- improved some tiny code snippets
|
| |
|
|
| |
view again. Improve by setting background printing to on by default, read on startup.
|
| |
|
|
|
|
| |
- Fix scroll bar bug in Create Table Syntax HUD window
- Convert button bar on LHS to use BWToolkit button bar
- Add some new smaller images to replace images previously used on LHS button bar
|
| |
|
|
|
|
|
| |
- Add view and code to support drawing a connection status icon at the left of the titlebar
- Use for SSH tunnels; completes Issue #114.
- Remove reference to an image resource "j" in the DBView - fixes console log errors.
|
| |
|
|
| |
expanded upon to disable different types of queries.
|
| |
|
|
|
| |
- "Query Background" color
- checkbox "Highlight Current Query"
|
| |
|
|
| |
- some TableDocument code cleanup
|
| | |
|
| |
|
|
|
| |
- first trial to use images for suggestions (up to now supported: tables/views, funcs, procs, dbs, otherwise show a transparent dummy)
|
| |
|
|
|
|
|
|
| |
• added prototype for new completion (ESC -> Cocoa, F5 -> new completion)
- not yet finished
- TODO:
-- support for NSSpellChecker items
-- images for different types of suggestions like proc/func/tabkle/view/sql statement, db name, etc.
|
| |
|
|
|
| |
- Cleaned up a few preference keys
- Added Caret Color to Query Editor Prefs - disabled for now.
|
| |
|
|
|
|
| |
- Replaced some toolbar icons with new ones
- Edited some toolbar icons.
- Added keyboard shortcut section to preferences (Disabled for now)
|
| | |
|
| |
|
|
| |
tests directory.
|
| |
|
|
| |
input same via the editor
|
| |
|
|
| |
property when adding new table fields.
|
| | |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
(from the CQ's action gear which are still customizable there)
- in addition to the syntax colors it's now possible to change the fore/background color as well
• added "Update Help while typing" feature in the Custom Query editor
• first trial to improve syntax highlighting for large text in the Custom Query editor
- if the text is larger than 10k the highlighting is performed only for the visible text area ±bias (3.5k)
- if the user changes the visible area the highlighting follows time-delayed 500ms) to assure user interaction
- a test with a 45MB SQL dump worked (of course a tick slowier)
-- todo: improve prev/current query detection (mainly the SQLParser)
- if the text size is > 6MB the completion list won't show words from the text due to parsing time
- if the text size is > 6MB the line numbering will be disabled due to performance issue (improvements should follow)
• some tiny clarification changes in the syntax highlighting code
• some minor code cosmetics
|
| |
|
|
|
| |
• prepared code to work with autoHelp
• improved getRangeForCurrentWord (fix for " |a")
|
| | |
|
| | |
|
| | |
|
| | |
|
| |
|
|
| |
options for the console in the user preferences
|
| |
|
|
|
|
| |
- New bottom bar.
- Both checkboxes moved into gear button with menu.
- Clear Console button has new custom image
|
| | |
|
| | |
|
| |
|
|
| |
- Added new button_edit image
|
| |
|
|
|
|
| |
- Add the ability to configure the maximum number of items in the query history
- Added appropriate minumums (0) and maximums in prefs for max history items, LIMIT count, connection timeout value
|
| |
|
|
| |
displays "You cannot use the application "Sequel Pro" with this version of Mac OS X", rather than crashing.
|
| |
|
|
|
|
| |
- Restore pref upgrade methods, make compatibible with both lastUsedVersion and LastUsedVersion keys
- Add upgrade method to map old pref keys to new pref keys, delete old keys
|
| |
|
|
|
|
|
| |
- Update a few pref checks which were using the old pref values still
- Resort preference defaults to match layout in prefs, restore old default values for some keys
- Restore missing defaults for new editor properties
|
