aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - 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.
* - In the table status view use the user's long date format and medium time ↵stuconnolly2009-03-012-69/+102
| | | | | | | format when displaying the create and update date/time of the selected table. - In the table info pane set the date formatter's behaviour otherwise setting it's date and time style have no effect. Also consolidate the date formatting code into a single private method to reduce the amount of code duplication.