aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* Make table operation messages more user friendly (issue #192) and display ↵stuconnolly2009-04-093-226/+345
| | | | them in sheets instead of modal dialogs. Also performed a general tidy up of TableDocument.[hm].
* • removed debug infoBibiko2009-04-091-1/+0
|
* • syntax highlighting synchronized according to the completion listBibiko2009-04-092-17/+261
| | | | • some minor code cosmetics
* - Second part of r498: ensure that SQL imports are read in as UTF8, and ↵rowanbeentje2009-04-083-8/+62
| | | | queries are sent as UTF8, if possible; this correctly preserves encoding data when working with files export from Sequel Pro or via mysqldump, and attempts to fall back to the current connection encodings for other files. This should resolve Issue #116.
* • keyword update for syntax highlightingBibiko2009-04-082-8/+349
| | | | • keyword update for completion
* • FIXED: unique completion listBibiko2009-04-081-13/+34
| | | | • ADDED: if caret is inside quotes "" or '' show Apple's default completion list due to the spell checker settings
* • simplified paste: (esp. for undo)Bibiko2009-04-082-4/+3
| | | | • syntax highlighting updated
* • ADDED “TRUNCATE” as SQL keyword for syntax highlighting resp. ↵Bibiko2009-04-081-1/+2
| | | | auto-uppercasing
* • FIXED if deleteBackward: avoid auto-uppercasing if resulting word would ↵Bibiko2009-04-082-3/+10
| | | | | | be a SQL keyword - e.g. type inta and then press deleteBackward:
* • FIXED auto-uppercasing bug if SQL keyword is found at the absolute end ↵Bibiko2009-04-081-5/+10
| | | | | | of the textStorage - this fixes also auto-uppercasing for runAll/Current/SelectionQueries
* - changed the structure of the edit menu to more closely resemble other Mac ↵jakob2009-04-081-87/+87
| | | | OS applications (see eg. TextEdit)
* • syntax highlighting updatedBibiko2009-04-083-108/+148
| | | | - added highlighting for @vars
* • optimized syntax highlighting a bitBibiko2009-04-073-248/+311
| | | | | | • added syntax highlighting for numeric values • changed syntax highlighting for 'order' and 'group' to 'order by' resp. 'group by' (useful also for visual syntax checking while typing) • fixed the issue to highlight a keyword if that keyword is the name a variable (e.g. @set := 1)
* • FIXED in runAllQueries: deselect a given selection before calling ↵Bibiko2009-04-071-0/+1
| | | | textStorageDidProcessEditing: to avoid the deletion of a given selection
* Remove the 'Duplicate' menu item from the 'Edit' menu. Resolves issue #221. ↵stuconnolly2009-04-071-249/+570
| | | | The menu item is always disabled because copyTable: of TablesList is not accessiable via the responder chain. The duplicate table action is available from the table's gear menu and context menu and so is not relevant to the selected context in the 'Edit' menu anyway.
* Fix for issue #211: Table content count incorrectly reporting selected row ↵stuconnolly2009-04-071-8/+16
| | | | count.
* - Quote the build-version script to allow it to be run correctly when the ↵rowanbeentje2009-04-071-1/+1
| | | | path contains spaces or special characters
* • improved auto-uppercasing for: pasting queries from favourites & history ↵Bibiko2009-04-072-7/+28
| | | | | | | and before performQueries • improved undo behaviour of auto-uppercasing • added undo behaviour for pasting queries from favourites & history
* • FIXED bug in doTranspose: if [textView string] === "abc|d" Bibiko2009-04-071-1/+1
|
* - Select 'drop tables' option for MySQL export by default, to improve ↵rowanbeentje2009-04-065-32/+113
| | | | | | | backup-type process and more closely match mysqldump, and correctly drop views - Consistently set and restore the encoding appropriately for SQL import/export, and export to UTF8 files to correctly store all characters. Goes a good way towards addressing Issue #116.
* • FIXED: "Limit from" NSStepper retains the old value if the new value ↵Bibiko2009-04-062-2/+28
| | | | | | | would be greater than the total number of rows of the current table • FIXED: if the user enters into "Limit from" a number which is greater than the total number of rows of the current table, show the last pref's "limitRowsValue" number of rows instead • FIXED: if the user has already filtered the current table by specifying "Limit from" > 1 and afterwards the user applied a new filter the filtering will be repeated for LIMIT 0, "limitRowsValue" if nothing was found
* • ADDED - (IBAction)doRemoveDiacritics:(id)senderBibiko2009-04-063-428/+44
| | | | | - this method removes all combining diacritics -- e.g. façäñど ⇢ facanと after Unicode's NFD
* Remove the 'Clear' menu item from the 'Edit' menu because it doesn't ↵stuconnolly2009-04-051-39/+429
| | | | actually do anything. See issue #221.
* • ADDED: - (IBAction)doTranspose:(id)sender;Bibiko2009-04-053-2/+70
| | | | - Note: not yet combining-diacritics-safe!
* Fix an issue where by the show/hide console menu item was not being updated ↵stuconnolly2009-04-053-12/+41
| | | | when the toolbar item was used. Also add more interface validation by only enabling the 'Clear Console' menu and toolbar items when there is at least one message in the console.
* • tentative fix to suppress auto-uppercasing/syntax highlighting of ↵Bibiko2009-04-051-2/+2
| | | | table/field names if such a name begins with a SQL keyword followed by a non-ASCII letter like äöüéた etc.
* • updated xcode projectBibiko2009-04-051-0/+6
|
* • ADDED to SPTextViewAdditions:Bibiko2009-04-054-555/+286
| | | | | | | | | | | | | | - (NSRange)getRangeForCurrentWord - (IBAction)selectCurrentWord:(id)sender; - (IBAction)selectCurrentLine:(id)sender; - (IBAction)doSelectionUpperCase:(id)sender; - (IBAction)doSelectionLowerCase:(id)sender; - (IBAction)doSelectionTitleCase:(id)sender; - (IBAction)doDecomposedStringWithCanonicalMapping:(id)sender; - (IBAction)doDecomposedStringWithCompatibilityMapping:(id)sender; - (IBAction)doPrecomposedStringWithCanonicalMapping:(id)sender; - (IBAction)doPrecomposedStringWithCompatibilityMapping:(id)sender; • BOUNDED these IBAction to mainmenu.xib
* • ADDED: SPTextViewAdditions for adding global functionality to each ↵Bibiko2009-04-052-0/+55
| | | | NSTextView in Sequel-Pro
* • ADDED to menu item “Edit” the submenus:Bibiko2009-04-051-1/+19
| | | | | | | | | | | | | | | | | | Convert > - to Uppercase ^U - to Lowercase ^⇧U - to Titlecase ^⌥U - Transpose ^T - Remove Diacritics - Normalization > -- Canonical Decomposing (NFD) -- Canonical Composing (NFC) -- Compatibility Decomposition (NFKD) -- Compatibility Composition (NFKC) Select > - Word ^W - Line ^L - All ⌘A
* • ADDED to menu item “Edit” the submenus:Bibiko2009-04-051-36/+458
|
* - Fix an invalid reference to a missing pulldown_arrow image causing ↵rowanbeentje2009-04-056-115/+103
| | | | | | | | invalid log entries - Set the focus to the custom query text field when appropriate when switching to the custom query tab - Add the ability to set the custom query editor font, save and load it from preferences, and no longer reset the font on queries
* • FIXED: allow to enter dead keys esp. for non-US keyboardsBibiko2009-04-041-1/+3
| | | | | - e.g. for a German one ` is a dead key (press space to enter `) -- further checks needed for other non-US keyboards
* - Change the method of creating a new table to be the same as that when ↵stuconnolly2009-04-043-262/+1268
| | | | | | | | | | creating a new database by presenting a sheet, allowing the user to specify the table name and encoding. - Allowing the user to specify the table encoding partially addresses issue #161. - Implementing interface validation in the form of not allowing table creation without a name also removes the need for lots of error checking and presenting these errors to the user. - In addition to the above the ability to specify the initial field name, type and length (if applicable) of a new table can now be done on the same sheet, but is yet to be implemented. - Also did a general tidy up of TablesList.[hm].
* • FIXED upper case of e.g. 'order_' issueBibiko2009-04-041-18/+23
| | | | | | | - in addition fixed issue of typing 'order_' and then deleteBackward: event [ticket 281 comment 2] -- solved by looking at the end of SQL keyword token instead at begin of it => further discussion "undo behaviour"
* - removed some ellipsis (...) from the Favorites/History Menu on the Custom ↵jakob2009-04-031-19/+57
| | | | Query Tab (for information on the proper usage of the ellipsis character, see http://developer.apple.com/documentation/userexperience/Conceptual/AppleHIGuidelines/XHIGText/XHIGText.html#//apple_ref/doc/uid/TP30000365-TPXREF126 )
* • REARRANGED keyDown: for further changesBibiko2009-04-031-115/+278
| | | | | | | | | | | | | | | | | • ADDED the following methods and tentative keyboard support: - (NSRange)selectCurrentLine ^L - (NSRange)selectCurrentWord ^W - (void)copyAsRTF ^C - (void)doSelectionUpperCase ^U - (void)doSelectionLowerCase ^⇧U - (void)doSelectionTitleCase ^⌥U - (void)doDecomposedStringWithCanonicalMapping - (void)doDecomposedStringWithCompatibilityMapping - (void)doPrecomposedStringWithCanonicalMapping - (void)doPrecomposedStringWithCompatibilityMapping -- there's no need to add keyboard shortcuts for the last four methods (but these are very useful while dealing with Unicode characters - see “Unicode noramization”) • some minor code cosmetics
* • ADDED copyAsRTF: to preserve syntax highlighting while copyingBibiko2009-04-031-0/+19
| | | | - not yet bound to any user interaction
* - Fixed issue #219: Query tab favorites, history, run buttons missing in ↵avenjamin2009-04-031-76/+37
| | | | nightly build 469
* - Fixed missing image erroravenjamin2009-04-031-49/+82
|
* - Add the ability for CMTextView to automatically capitalise SQL keywords ↵rowanbeentje2009-04-036-45/+131
| | | | in the text view, currently off by default but saved from preferences. Thanks again to Hans-Jörg Bibiko for this patch; see Issue #218.
* - Improves autopairing to no longer autopair different quote characters ↵rowanbeentje2009-04-021-1/+34
| | | | within a quoted string, and also to no longer autoquote escaped characters within a quoted string. Also adds syntax highlighting to `-enclosed strings. Further thanks to Hans-Jörg Bibiko for these further improvements to his original patch (see http://code.google.com/p/sequel-pro/issues/detail?id=208 )
* - Changed to "NULL" column header to "Allow NULL" to make it cleareravenjamin2009-04-021-42/+16
|
* Change the toggle console menu item's title to either 'Show' or 'Hide' console.stuconnolly2009-04-022-16/+50
|
* - Changed Auto Complete keyboard shortcut to just Escape instead of ↵avenjamin2009-04-021-13/+21
| | | | Option-Escape
* - Implemented "Clear History" in new Gear menuavenjamin2009-04-023-354/+390
| | | | - Changed UI in Query Tab for favourite and history popups as well as Run query buttons
* - Add a new "gear" action menu underneath the custom query view, including ↵rowanbeentje2009-04-027-42/+728
| | | | | | | | | | | | a number of items: - Add menu commands for "Run All" and "Run Selected", with additional keyboard shortcuts - cmd-R for Run all, addressing #137 - Add menu commands for indenting text, outdenting text, and to show autocompletion is available - Add menu commands to toggle autopairing and autoindenting - Also hidden menu commands for history navigation and clearing, not hooked in yet (see #207) - Add a new method to our string additions: lineRangesForRange - Add "shift right" (indent) and "shift left" (outdent) support to CMTextView, including for multiple lines
* - Add autopairing support to CMTextView - many thanks to Hans-Jörg Bibiko ↵rowanbeentje2009-04-015-10/+299
| | | | | | | | for the original patch (see http://code.google.com/p/sequel-pro/issues/detail?id=208 for full details). Applied with slight amendments. - Further changes to make CMTextView more standalone and reusable - autopairing and autoindenting can now be enabled/disabled and checked. - Autopairing and autoindenting moved to app preferences.
* Added delete as a hot key to the remove row and column buttons to fix issue #216avenjamin2009-04-011-8/+8
|
* For some reason the display of the table create and update dates in the ↵stuconnolly2009-03-312-22/+7
| | | | status view were broken, so changed it to use the same method used by the table info pane.