aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* - Re-add the LIMIT FROM NSStepper rowanbeentje2008-12-102-160/+240
| | | | | | | | - Allow Return or Enter pressed in the Limit From textbox to trigger a table filter - Reset the content table view position on filtering or limit - Refresh no longer clears the LIMIT FROM value if it's still valid - Resolves Issue #65 and partially addresses Issue #49.
* Slight tweak to per-table encoding autodetection following testing and quick ↵rowanbeentje2008-12-091-8/+1
| | | | chat with Stuart - now calls [TableDocument setEncoding:] so that all encoding setting is handled in one place. This fixes a bug where table encoding was detected correctly but only partly used, and adds error detection by falling back to connection autodetection if encoding change fails.
* Separate update_date checks from create_date checks, as InnoDB tables have a ↵rowanbeentje2008-12-091-7/+19
| | | | create_date but not an update_date. Fixes the Table Information pane on InnoDB tables and associated draw errors.
* - Reimplement CSV NULL import using the NULL value as specified in ↵rowanbeentje2008-12-092-50/+81
| | | | | | | | | preferences - resolves Issue #67; - Improve field mapping clarity and allow display of duplicate cell values by appending the column number to the current cell value - Trims blank lines from CSV imports to avoid importing rows filled with defaults - Correctly encodes linebreaks in CSVs for reimport
* - Partial fix for issue #109 by making the option to 'Autodetect' character ↵stuconnolly2008-12-095-24/+49
| | | | | | | encoding specific to each table - Added the selected table's character encoding to the table information pane and removed the table's name
* Remove checking for empty string or NULL when importing a CSV file.avenjamin2008-12-081-255/+247
|
* Fix a regression for CSV field mapping caused by r233 - SVN merged TableDump ↵rowanbeentje2008-12-081-2/+2
| | | | and evidently decided my version was newer without declaring it a conflict. Fixed.
* - No longer export trailing commas for CSV linesrowanbeentje2008-12-081-10/+27
| | | | | | - Don't output the CSV "headers" for exports of single tables - Use the correct line ending as specified in the export dialog when exporting CSV headers and spacing for multi-table exports
* Slight tweak to r246; update the filter input field enabled state when ↵rowanbeentje2008-12-071-1/+4
| | | | filter field selection changes
* If the user is filtering for NULLs then disable the filter input field.stuconnolly2008-12-073-15/+52
|
* - Add new favourites as NSMutableDictionaries instead of NSDictionaries - ↵rowanbeentje2008-12-072-10/+5
| | | | | | | | properly fixes Issue #110. - Save favourites on exit - this saves edits such as favourite name changes within the connection sheet which aren't otherwise caught. - Removes an outdated property (selectedFavourite)
* Fix for issue #55. Added 'IS NULL' and 'IS NOT NULL' to table content filter ↵stuconnolly2008-12-071-20/+49
| | | | to allow filtering for NULLs.
* updated version number and copyright stringsabhibeckert2008-12-072-3/+3
|
* updated version number and copyright stringsabhibeckert2008-12-072-13/+13
|
* Since the 'Page Setup' and 'Print' menu items are now hidden also hide the ↵stuconnolly2008-12-061-3/+4
| | | | separator that was appearing at the bottom of the 'File' menu.
* - Identified and corrected a major n^2 bottleneck in working with all query ↵rowanbeentje2008-12-068-617/+998
| | | | | | | | | | | | | | | result sets - when iterating through a mysql result set, all the data up to each row was seeked through again. With this fixed SP can work with very large result sets at much, much higher speeds. - Fixed incorrect query splitting in splitQueries - improves custom queries and imports. - CSV export now exports NULLs as an empty cell (eg "1,,3"). This resolved Issue #67. Correspondingly, CSV import now also accepts this syntax. - CSV and SQL exports no longer quote numeric values for file size and neatness improvements. - Multi-table exports now show progress through the tables in the text description, and use the progress bar for export of each table, for improved feedback. - The old "Export Table Content" menu has been split into two - "Current Browse View" which matches the old behaviour, and a new "Current Table" entry. This addresses Issue #97. - Exports now write data to a file stream as data is processed for export, and also parse data from the database as a stream where possible. This leads to lower memory usage, speed improvements, and much more accurate and constant feedback. - The export processes have been restructured and rewritten for further speed and memory improvements. - SQL exports now correctly export BLOB and TEXT contents ready for re-import into all systems. - SQL exports now group multiple VALUES for each INSERT INTO command for much, much faster imports of exported data.
* Known Issue for field mapping when importing a CSV file now resolved.avenjamin2008-12-065-6/+24
| | | | No longer required to select a table first before selecting the Import... menu item
* Changing table in field mapping sheet when importing CSV file now correctly ↵avenjamin2008-12-051-1/+1
| | | | | | imports the data into selected table. Known Issue: a table must be selected in TABLES list before choosing Import... menu.
* TableDumpavenjamin2008-12-056-424/+487
| | | | | | | | | | | | | | | --- Field mapping when importing CSV file now makes more sense. You can import data into multiple columns in the table. Known Issue: changing table while field mapping doesn't work. Select the table first before importing TableContent --- Partially solves issue where label at bottom "x of y rows selected" wasn't being updated TablesList --- Moved table delegate methods under correct pragma mark
* Hid the Print and Page Preview Menu Items until they have a valid ↵mltownsend2008-12-051-16/+121
| | | | implementation.
* Fix for Issue #71 - correctly adds the hexadecimal specifier before hex ↵rowanbeentje2008-12-051-4/+1
| | | | strings, fixing the data corruption problems in all TEXT/BLOB types
* Fixed a bug allowing us to now enable the TABLE INFORMATION paneavenjamin2008-12-023-23/+20
|
* Added new table content filter button as a fix for issue #105. Filter is now ↵stuconnolly2008-12-021-89/+191
| | | | only applied on enter rather than when the filter string is changed which caused major performance problems on large tables.
* Updated "Current Developers" list in creditsavenjamin2008-12-021-0/+7
|
* Fixed various Keychain issues regarding already existing passwords by ↵stuconnolly2008-12-025-97/+616
| | | | checking if an item of the same name and account already exists. This revision also fixes issue #94 by removing the Keychain password first and then the favourite from the array controller.
* Fix for issue 53.stuconnolly2008-11-301-2/+14
|
* Keep the headers tidy. We don't need to declare table view and toolbar ↵stuconnolly2008-11-291-16/+0
| | | | delegate/data source methods as public API.
* New Growl notification controller.stuconnolly2008-11-289-84/+200
|
* Tiny tidy up. We don't need to declare these methods in the header and hence ↵stuconnolly2008-11-281-6/+0
| | | | make them public as they are called automatically.
* Added shortcut key for "Show Console"mltownsend2008-11-261-3/+4
|
* Tiny clean up.avenjamin2008-11-261-2/+3
|
* Fix for Issue #44.mltownsend2008-11-251-0/+2
|
* General cleanup. Removed 10.3x code and removed commented out code.mltownsend2008-11-251-37/+6
|
* Fix for Issue 88. NSArrayControllor was trying to bind to multiple values ↵mltownsend2008-11-241-23/+24
| | | | when there is only one value being shown.
* Issue 34 Fix. Plus fixes for some warnings.mltownsend2008-11-216-21/+57
|
* Fix a bug in r200 not showing the rows in the table and a longstanding bug ↵rowanbeentje2008-11-201-4/+6
| | | | not showing any applied limit on initial table load
* Functional changes:rowanbeentje2008-11-204-207/+209
| | | | | | | | | | - Refreshing or reloading a table view will now attempt to preserve sorting and filters. Other changes: - Initial cleanup of TableContent loadTable: - Replacing project-distributed column sort arrows with the OS-provided images
* Fix for Issue 64mltownsend2008-11-191-0/+6
|
* Commiting some changes related to field mapping for csv importing.avenjamin2008-11-191-24/+14
|
* Experimental change: store the table content viewport before a refresh, and ↵rowanbeentje2008-11-181-0/+6
| | | | | | | then restore it afterwards - ie suggestion (2) in http://groups.google.com/group/sequel-pro/browse_frm/thread/71541c6267fc08c1/2f4aeeaa7f15b268 . I was initially in two minds as to whether this would be a good thing, but with r195/r196 removing the need to refresh for structural changes, this change does actually feel right to me - in fact, I now wish it didn't clear any filters/limit, and I'd like to preserve them as well. Any objections?
* Slight cleanup of r195 following discussion with avenjaminrowanbeentje2008-11-183-7/+7
|
* Add support for marking the content for a required refresh on structure ↵rowanbeentje2008-11-183-0/+26
| | | | changes. Implemented by adding a method to TablesList (setContentRequiresReload) and using it when modifying the tble structure, thus only refreshing if the content is actually viewed again.
* Fix outdated references to old version name - fixes my Sparkle instance ↵rowanbeentje2008-11-171-0/+0
| | | | | | | always thinking I'm on 0.5 and offering me the update. I removed instanced which were the same as the root Info.plist for inheritance. we should probably consider setting up build variables for the version number and the build number, so localised versions can very easily include those in copyright strings.
* Embedded content of DBView window into a TabView in preparation of moving ↵avenjamin2008-11-171-4775/+6026
| | | | connectSheet contents into the DBView window. TabView is current tabless with 2 tabs. Main content is in 2nd tab with connectionSheet content in 1st tab.
* Changed debug settings for compiled xib files.avenjamin2008-11-171-2/+3
|
* Expanded area of console text view.avenjamin2008-11-171-8/+12
|
* Part 1 of new import system.avenjamin2008-11-154-3069/+3630
|
* Some initial setup for new import systemavenjamin2008-11-153-114/+17
|
* Improvement to new favourite selection over r182 - now selects the new ↵rowanbeentje2008-11-151-1/+1
| | | | favourite whatever the table sort order.
* General clean up.... more to comeavenjamin2008-11-152-464/+462
|