aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - When exporting to an SQL file, disable foreign key checks, change SQL ↵rowanbeentje2009-03-281-11/+41
| | | | | | | 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.
* - The status tab now no longer crashes when viewing Views. (Resolves Issue ↵rowanbeentje2009-03-282-25/+43
| | | | | | | #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.
* - Add a preference (currently with no UI) for connection timeoutrowanbeentje2009-03-285-52/+54
| | | | | | | - 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
* Improve interaction with connection favorites to prevent issues saving ↵rowanbeentje2009-03-282-4/+9
| | | | | | | | 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.
* Fixed bug when using the IN filter. removed inclusion of single quotes at ↵avenjamin2009-03-271-1/+1
| | | | start and end
* Fixed bug where exporting current table would use the field terminator, ↵avenjamin2009-03-272-14/+27
| | | | enclosure, escape and line ending characters from the "export multiple tables" dialog instead.
* - Fix exceptions and so saving table column width changes in databases or ↵rowanbeentje2009-03-271-6/+2
| | | | 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.
* improve labels of toolbar iconsabhibeckert2009-03-261-7/+7
| | | | | | change default toolbar set to have a separator instead of a flexible space between select database and switch pane items closes issue #159
* Completely redesigned query console that now uses a table view instead of a ↵stuconnolly2009-03-2610-157/+556
| | | | | | | | | | | | | 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
* Rename tokens.h to SPEditorTokens.h and tokens.l to SPEditorTokens.l.stuconnolly2009-03-264-6/+6
|
* - when loading texts/blobs is disabled, the table view now shows "(not ↵jakob2009-03-262-19/+114
| | | | | | 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
* Scale print image horizontallybamse162009-03-261-1/+1
|
* - updated the backtickQuotedString method to be 10.4 compatible (and to ↵jakob2009-03-261-1/+1
| | | | compile as well. thanks marius!)
* Reset print settings, so we're not prompted about saving thembamse162009-03-261-0/+3
|
* - updated the backtickQuotedString method to be 10.4 compatiblejakob2009-03-261-1/+16
|
* Enabled Page Setup for printing, so now you can print landscape toobamse162009-03-261-1/+2
| | | | | | Enabled auto pagination, so we print everything for now
* - Refactor custom query results redrawing code and reset view position to ↵rowanbeentje2009-03-251-23/+17
| | | | avoid out-of-range assertions when switching from a larger dataset to a smaller dataset; this fixes Issue #189
* Fix a reproducible sort-sort-refresh-sort crash bug by explicitly managing ↵rowanbeentje2009-03-251-3/+7
| | | | sortField and not referencing possibly deallocated column identifiers directly
* Added hidden preference to automatically select the last favorite you used.bamse162009-03-241-0/+6
| | | | | | To enable this feature write in Terminal: bash $ defaults write com.google.code.sequel-pro selectLastFavoriteUsed YES
* - fixed issue #203 (backticks in identifiers not supported)jakob2009-03-2410-101/+217
| | | | | | | | - 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]]
* Issue 201: Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-231-4/+4
| | | | | Changes after code review: renamed variable, replaced @"NULL" with [prefs objectForKey:@"nullValue"]
* Issue 201: Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-231-4/+14
| | | | | | | | | | 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
* Issue 194: reload table list deselects tablesbamse162009-03-231-1/+13
|
* Issue 202: NULL is prefilled in a non-NULL text fieldbamse162009-03-221-1/+6
| | | | | | | 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.
* Issue #201 Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-223-48/+65
|
* - Added tooltips to action button menu itemsavenjamin2009-03-222-2/+15
| | | | - Removed refresh tables menu item - refresh button right beside it.
* - Removed old no longer used images.avenjamin2009-03-211-1/+6
|
* - changed the status message after executing a custom query to read "1 row ↵jakob2009-03-201-11/+27
| | | | affected" / "6 rows affected" rather than "1 row(s) affected"
* SPSQLParser changes:rowanbeentje2009-03-1910-201/+574
| | | | | | | | | | | | | | | | | | - 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.
* As Rowan's suggestion, I've replaced older/younger with after/beforebamse162009-03-191-1/+1
| | | | | | #198 Older-Younger swapped meaning
* - updated list of keywords used for syntax highlighting (eg. IN was missing)jakob2009-03-181-269/+222
|
* - changed default colors for syntax coloringjakob2009-03-173-65/+109
| | | | | - disabled syntax coloring for texts larger than 20KB (too slow) - added alot of comments to the syntax coloring code
* adding syntax coloring (issue #46 )jakob2009-03-163-0/+420
|
* - Fix an old bug where adding rows when "Reload table after adding a row" ↵rowanbeentje2009-03-111-2/+2
| | | | | | | was switched off inserted the wrong value for autoincrement columns, throwing exceptions and breaking SP - Fix a bug in the autoincrement check which exposed the bug above even when no autoincrement was set.
* More small bugfixesbamse162009-03-111-0/+2
|
* Small fixes clang complained about. Others will followbamse162009-03-112-7/+15
|
* - Increment trunk version number to 0.9.4rowanbeentje2009-03-114-8/+27
| | | | | | | - Improves on r370 and r375 by preventing actions triggered by the save from triggering saves themselves - Improves further on r370 and r375 by committing any current edits before saving - Additional comments
* Additional error checking, centralised connection keep-alive interval ↵rowanbeentje2009-03-092-10/+33
| | | | retrieval, and support for disabling keep-alive by setting the interval to 0.
* Fixes a division by zero error causing crashes on multi-table CSV and XML ↵rowanbeentje2009-03-051-2/+2
| | | | exports (Issue #184)
* - Fix a number of edit sheet crashers regarding opening and saving files, ↵rowanbeentje2009-03-055-36/+156
| | | | | | | | | image deletions, and image drag and dropping (fixes Issue #85 and google groups report) - Improves compatbility of drag-and-drops onto the image well, including support for image drags from other applications - Attempt to automatically select the image or text tab in the edit sheet as appropriate - Fixes build-from-clean warnings caused by an unexposed function added in r375
* Added column names to completion list for for currently selected table.avenjamin2009-03-051-3/+14
|
* Improves the table structure view to only save a row when properly ↵rowanbeentje2009-03-054-43/+95
| | | | deselected, and automatically reselecting the row for re-edit on error - resolves Issue #74.
* Don't allow the table list to be completely out of sight by not allowing the ↵stuconnolly2009-03-041-2/+2
| | | | collapsing of the split view's subview. Minimum subvew view width has also been reduced by 20px. Fixes issue #150.
* Alter the open panel to recognise .csv and .sql extensions on selected files ↵rowanbeentje2009-03-042-0/+27
| | | | and automatically change the format dropdown to match
* Fix a bug related to not saving unchanged-but-edited rows, introduced in r370.rowanbeentje2009-03-041-2/+6
|
* - Renames "Database Encoding" menu item in Database menu to "View Using ↵rowanbeentje2009-03-043-34/+82
| | | | | | | | Encoding" for clarity - Add support for EUC-KR (I think, unable to test), hopefully fixing Issue #149 - Add workaround for UTF8 via Latin 1, supporting viewing and editing of data added using broken clients/upgraded old Wordpress/etc.
* - BLOB and binary fields are now fully visible and editable again (fixes ↵rowanbeentje2009-03-038-52/+140
| | | | | | | | | Issue #155) - Added basic support for viewing, filtering, and editing BIT columns (resolves Issue #127 in basic form) - Rewrites selection/save handling. Rows are now only written to database if their content has changed, resolving a long-standing complaint; row selection and editing has also been improved, improving edit/save interaction (fixes Issue #157) and allowing re-editing of the row on failure (fixes Issue #115). Hopefully also addresses #Issue 131, and improves Issue #172. - Hides the console window when the associated document window closes
* - Re-design the custom query favourties editor and get rid of the nasty ↵stuconnolly2009-03-022-39/+21
| | | | | | | plus/minus buttons. Also add some interface element validation. - Tidy up CustomQuery.h by getting rid of the definition of all datasource and delegate method signatures which don't need to be declared.
* Rollback on newbie mistake...bamse162009-03-021-10/+1
|
* Better error handling of dump reading (checking for NSError object instead ↵bamse162009-03-022-4/+27
| | | | | | | | of content of read string) Raising error when trying to import empty CSV file.