| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
| |
table/field names if such a name begins with a SQL keyword followed by a non-ASCII letter like äöüéた etc.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- (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
|
|
|
|
| |
NSTextView in Sequel-Pro
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
| |
- e.g. for a German one ` is a dead key (press space to enter `)
-- further checks needed for other non-US keyboards
|
|
|
|
|
|
|
|
|
|
| |
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].
|
|
|
|
|
|
|
| |
- 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"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
• 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
|
|
|
|
| |
- not yet bound to any user interaction
|
|
|
|
| |
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.
|
|
|
|
| |
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 UI in Query Tab for favourite and history popups as well as Run query buttons
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
status view were broken, so changed it to use the same method used by the table info pane.
|
| |
|
|
|
|
| |
to improve editor behaviour.
|
|
|
|
| |
'clearConsole:' method in TableDocument.m.
|
|
|
|
|
|
|
| |
mode, and alter notes setting, and disable unique checks if appropriate. Dumps generated by Sequel Pro will now be able to be imported even if foreign keys etc are present, without throwing errors and aborting import.
- When exporting to an SQL file, wrap the data import commands with table locking and key disabling commands - improves import speeds.
|
|
|
|
|
|
|
| |
#212)
- SQL dump now correctly exports the CREATE ALGORITHM statement for views, and no longer attempts to output data for views. Databases with views can now be exported/imported without errors.
|
|
|
|
|
|
|
| |
- Improve connection error messages slightly.
- Avoid reading prefs for every keepalive check - now sets connection timeout and keepalive interval on connection setup
- Fix and extend connection checks to avoid showing extra errors when the connection has been closed
|
|
|
|
|
|
|
|
| |
favorite changes:
- Favorites are no longer resaved on document window close - instead they're saved on connect. Prevents the oldest window open from saving its favorites when closed, overwriting any changes since.
- Explicitly synchs changes to disk to ensure prefs window/connection sheets see each other's changes faster.
|
|
|
|
| |
start and end
|
|
|
|
| |
enclosure, escape and line ending characters from the "export multiple tables" dialog instead.
|
|
|
|
| |
tables which have already seen a column resized in the past. Looks like r389 incorrectly used arrays instead of dictionaries when cleaning up a memory leak.
|
|
|
|
|
|
| |
change default toolbar set to have a separator instead of a flexible space between select database and switch pane items
closes issue #159
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
text view. This should significantly improve import speed, but most importantly resolves the crashes caused by the drawing that was being performed by the text view. Fixes issue #87 and implements #167.
New console provides the following:
- Live filtering
- Ability to hide message time stamps
- Ability to hide SELECT/SHOW statement messages
- Ability to copy messages to pasteboard, including multiple messages
- Ability to save the current filtered content to a file, with the option to include the message time stamps
|
| |
|
|
|
|
|
|
| |
loaded)" in a gray color rather than " - text or blob -"
-the remove and duplicate buttons in table and browse view are now disabled when nothing is selected
|
| |
|
|
|
|
| |
compile as well. thanks marius!)
|
| |
|
| |
|
|
|
|
|
|
| |
Enabled auto pagination, so we print everything for now
|
|
|
|
| |
avoid out-of-range assertions when switching from a larger dataset to a smaller dataset; this fixes Issue #189
|
|
|
|
| |
sortField and not referencing possibly deallocated column identifiers directly
|
|
|
|
|
|
| |
To enable this feature write in Terminal:
bash $ defaults write com.google.code.sequel-pro selectLastFavoriteUsed YES
|
|
|
|
|
|
|
|
| |
- added a backtickQuotedString: method to SPStringAdditions
- created the file SPArrayAdditions for a componentsJoinedAndBacktickQuoted: method
In the future, we should use backtickQuotedString: to quote identifiers like this:
[NSString stringWithFormat:@"SELECT * FROM %@", [tableName backtickQuotedString]]
|
|
|
|
|
| |
Changes after code review: renamed variable, replaced @"NULL" with [prefs objectForKey:@"nullValue"]
|
|
|
|
|
|
|
|
|
|
| |
Fixed - If you attempt to duplicate a row in tables where blob/text data is present but hidden and there are no
keys, SP correctly pops up the dialog but then continues execution, and so crashes.
Fixed - If the row being duplicated contains NULL data, exceptions triggered by [NSNull length] are thrown, and SP
stops responding.
Thanks to Rowan for code review
|
| |
|
|
|
|
|
|
|
| |
Now, if a field has NOT NULL, the default value is '' (empty string), unless the field is autoincrement,
when we can keep the NULL value.
|
| |
|
|
|
|
| |
- Removed refresh tables menu item - refresh button right beside it.
|
| |
|
|
|
|
| |
affected" / "6 rows affected" rather than "1 row(s) affected"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- Use method caches for oft-called functions, and support caching of chunks of the underlying string for string walking, resulting in an overall 1.3x-1.4x parsing speedup.
- Improve handling of multi-character comment starts (eg / or -) at the very end of strings
- When running splitString... methods return even empty strings for consistency.
- Update TableDump and TableData to match new usage
SPStringAddition changes:
- Add a formatter for time intervals.
CMMCPConnection changes:
- Add support for timing queries
CustomQuery and nib changes:
- Change the "Run Queries" button to "Run All".
- Add a "Run Current" button, which runs the query the text caret is currently positioned inside; if text is actually selected, this changes to "Run Selection". This addresses Issue #43.
- Amend the "rows affected" string to better reflect the actual number of rows altered by several queries, show the query count if > 1, and display the overall execution time of the queries. This addresses Issue #142.
- No longer execute blank strings as part of the custom query, preventing errors.
|
|
|
|
|
|
| |
#198 Older-Younger swapped meaning
|
| |
|