aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* Following a manual code review, fix some local variables overriding global ↵rowanbeentje2010-03-151-2/+10
| | | | variables, a few leaks, and additional nil setting/checking to prevent overreleases or releases of random areas of memory.
* Peform the addition and removal of table indexes on a background thread with ↵stuconnolly2010-03-141-1/+0
| | | | the option to cancel the operation to prevent locking up the main thread. Fixes issue #591.
* • fixed printDocument validation if Custom Query is activeBibiko2010-03-131-5/+5
| | | | - allow to print the Custom Query result table even if no database/table is selected
* Perform HTML generation for printing on a background thread, displaying the ↵stuconnolly2010-03-131-2/+2
| | | | usual progress indicator with the ability to cancel it. Still need to add warnings when attempting to print a table content with a large number of rows or a lot of data.
* - Add toolbar item for Triggers interfaceavenjamin2010-03-131-0/+13
| | | | - Add table triggers toolbar icon
* - Fix some leaks and autoreleases after checking static analysisrowanbeentje2010-03-131-10/+0
|
* tiny improvement for printDocument: menu item validationBibiko2010-03-131-2/+7
|
* Lots more printing support enhancements, including:stuconnolly2010-03-131-3/+1
| | | | | | | | | - The ability to print the extended table information view using a new template. - The inclusion of NULL values diaplyed as the user's NULL value placeholder when printing a table's sturcture and indexes. - If enabled in the user's preferences, the inclusion of vertical gridlines in the table views. - Dynamic calculation of page margins based on the paper size of the selected printer as opposed to using hard coded values. - Lots of other little style enhancements.
* Various printing support enhancements, including:stuconnolly2010-03-121-164/+4
| | | | | | | | | - Splitting out all printing methods to SPPrintController which is category of TableDocument. - The ability to print table relations. - If present the inclusion of table indexes when printing a table's source. - If the user has use monospaced fonts enables, then the print out's tabular data will be in a monospaced font. - Lots of other style enhancements, including page headings and sections headings.
* Include the current table name in printing support. Fixes issue #501.stuconnolly2010-03-101-27/+34
|
* - Ensure endTask is called on the main thread, fixing various thread-safety ↵rowanbeentje2010-03-101-0/+6
| | | | issues including http://log.sequelpro.com/view/40 and http://log.sequelpro.com/view/21
* • improved tooltip behaviour of SPNarrowDownCompletion's tableViewBibiko2010-03-091-0/+13
| | | | • added "Filter Tables…" ^⌥⌘F" to main menu > Table which sets the focus to TablesList's search field if visible
* • Select Content Filter ^⌘FBibiko2010-03-081-1/+1
| | | | | - select first textfield for 1 or 2 argument(s); if no argument field is selectable select compareField - ensure the focus setting by calling "makeContentFilterHaveFocus" via performSelector:afterDelay
* Add a new 'Filter Content...' menu item to the 'Table' menu that switches to ↵stuconnolly2010-03-081-0/+15
| | | | the content view and places the focus on the filter field.
* Add a hidden preference to display or hide the MySQL server version in the ↵stuconnolly2010-03-071-2/+2
| | | | window title.
* • CSV Import Field MapperBibiko2010-03-051-17/+16
| | | | | | | | | | | - removed Advanced sheet, instead resize the main sheet and display these settings in it - added advanced options LOW/HIGH_PRIORITY - improved logic for adv. settings, disabling UPDATE if target table has less than 2 fields, etc. - fixed URL for displaying the source file name - removed Help text since it's too large - should be go to the general help • CMTextView - fixed bug if ESC Completion is invoked if caret position is 0 • fixed document URL handling to come up with the correct icons etc.
* • REPAIR, OPTIMIZE, ANALYZE, FLUSH, CHECKSUM now can be applied to more ↵Bibiko2010-02-261-88/+281
| | | | | | | | than one selected item in the TablesList; if no error alert OK, if not or for CHECKSUM list the output in a table view - while sheet is open showing the accessory table user can press ⌘C for copying it - added missing NSLocalizeStrings • fixed a tiny issue for $SP_SELECTED_TABLES
* • Query Favorites:Bibiko2010-02-251-17/+91
| | | | | | | | - added snippet variable $SP_SELECTED_TABLES which inserts `table1`,`table2`, etc. (ONLY tables) • improved "Check Table" - now one can select more than one table to execute "CHECK TABLE table1,table2,… ; if all tables passed successfully alert OK, if not show the result as accessory table in the sheet note: OPTIMIZE, REPAIR, FLUSH, CHECKSUM, ANALYZE follow
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-231-0/+7
| | | | | | | | | | value (no sheet) • "Delete all records" confirmation sheet shows a checkbox "Reset AUTO_INCREMENT after deletion" if PRI key is given for that table • minimized table data querying for auto_inc • optimized auto_inc change notification • if user changes tabVIew to Table Info Pane update data in beforehand • TRUNCATE query updates auto_inc value as well in TABLE INFORMATION
* Fix Issue #574 (foreign key links not working after first use):rowanbeentje2010-02-231-3/+3
| | | | | | - Move foreign key reference loading into it's own task and set state modification markers to allow it to override the table state history - Rename modifyingHistoryState to modifyingState now the usge has broadened slightly
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-2/+5
| | | | | | | | Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution) • SPAlertSheets - ensure that this sheet becomes the keyWindow
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-1/+2
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-221-0/+21
| | | | - not yet active
* • fixed keyboard behaviour of "Create Sytax Sheet"Bibiko2010-02-201-0/+3
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* Fix a number of memory leaks, and over-releases, as both a result of manual ↵rowanbeentje2010-02-101-1/+1
| | | | inspection of leaks and Clang static analysis.
* Complete the implementation of the management of table triggers (accessible ↵stuconnolly2010-02-061-0/+1
| | | | via Cmd+6). Note, that better support for entering the trigger statement in terms of escaping and delimiter support most likely needs to be added.
* First stab at Schema Privileges. A UI redesign is on its way. Please test ↵mltownsend2010-02-021-1/+1
| | | | on non Production servers
* • Added basic print support for each CMTextViewBibiko2010-02-011-1/+6
| | | | • first steps to renew the field mapper sheet for CSV Import
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-311-0/+24
| | | | | | | | | | | | | | | | | | | | menu item View > Table Triggers (apple-6). Heavily copied from Relations tab, lots of functionality missing. Just lists the triggers for the table now. M Source/SPTableData.m M Source/SPConstants.h M Source/SPConstants.m A Source/SPTableTriggers.h A Source/SPTableTriggers.m M Source/TableDocument.h M Source/TableDocument.m M Source/SPTableData.h M Interfaces/English.lproj/MainMenu.xib M Interfaces/English.lproj/DBView.xib M sequel-pro.xcodeproj/project.pbxproj
* • CMTextView's colours are set via observer, live changed in editable ↵Bibiko2010-01-301-3/+5
| | | | | | | | textviews • added Preference setting "Table font" in "Table" pane to set the table font/size for all result tables (Content, Custom Query) • added to SPTableView the method setFont: • fixed the initialisation of vars in CMTextView (fixes the displaying of create syntax)
* - Ensure the main toolbar items aren't selectable during a task to prevent ↵rowanbeentje2010-01-261-0/+1
| | | | odd update issues
* Improve Disconnection on connection loss:rowanbeentje2010-01-241-14/+19
| | | | | | | | | - Set error strings on MCPConnection on user disconnect to allow existing error chcking to catch the state - Improve close behaviour from threads - Improve window close behaviour and appearance - Add new checks for disconnection in one or two crash-prone locations This addresses Issue #531, one of Issue #532, one of Issue #539, and probable reported crashes on Issue #541.
* • added call to update the completion list to neuralgic placesBibiko2010-01-211-0/+8
| | | | - next steps to minimize the traffic - ie manipulating the dict directly without querying - follows
* Address Issue #546 (format string bugs):rowanbeentje2010-01-201-8/+8
| | | | | | - Fix incorrect uses of [NSString stringWithFormat:] with preconstructed strings and no arguments in SPUserManager - To fix display issues, replace NSBeginAlertSheet (which includes automatic sprintf expansion of the message) with a safely-escaped SPBeginAlertSheet in many files
* • fixed several sheetDidEnd selectors to close a NSAlert or NSWindow ↵Bibiko2010-01-131-1/+8
| | | | | | | properly to avoid overlapping sheets • F5 completion - if a table is selected and no further parsing info is given show that table and its fields at the top of the suggestions
* - Move the query for the database structure to a background processing ↵rowanbeentje2010-01-121-1/+1
| | | | thread, as well as the existing background database connection, for a smoother experience
* - Testing found that r1653 fixed the warnings but for some reason disabled ↵rowanbeentje2010-01-111-0/+1
| | | | the "Stop" button; switch to orderFront: to re-enable without the warnings (thanks to Hans for assistance!)
* • further developments for the F5 completionBibiko2010-01-111-1/+1
| | | | Note: not yet finished!
* • further preparations to F5 completionBibiko2010-01-111-5/+15
| | | | Note: not yet active - only querying the data in background will be performed for testing
* • first preparations to improve the Custom Query database names/table ↵Bibiko2010-01-101-0/+2
| | | | | | | | | names/field names + type and encoding completion - after connecting and updating the table list a background task executed on a different connection will be performed to query the information_schema db (MySQL >= 5 only so far) - the MCPConnection object holds a NSDictionary with all structural data Note: not yet active
* removed:Bibiko2010-01-091-1/+0
| | | | | | | | | [taskProgressWindow orderWindow:NSWindowAbove relativeTo:[tableWindow windowNumber]]; since it causes Console <error> messages mentioning "kCGErrorIllegalArgument" and it is not necessary anymore [thanks to Rowan for the hint]
* - Upgrade Sequel Pro to be compiled as a 3-way PPC/i386/x86_64 binary for ↵rowanbeentje2010-01-091-30/+30
| | | | | | | release builds, including a large number of 64bit compatibility upgrades and tweaks - Upgrade RegexKitLite to 3.3
* • fixed: do not disable User Account if no table is selectedBibiko2010-01-061-2/+9
| | | | • fixed: if user cancelled "Add Database" reselect 'Choose Database Button' instead of displaying "Add Database"
* - Remove two unused variablesrowanbeentje2010-01-031-3/+0
|
* - Ensure all results for server variable requests are returned as strings, ↵rowanbeentje2010-01-031-23/+16
| | | | | | | to avoid binary-mode result issues with certain versions of MySQL (including 4.1.14). This should address Issue #509. - TableDocument now requests the server version string from MCPConnection, aiding caching
* In the database drop down, visually separate 'system' databases (i.e. mysql ↵stuconnolly2009-12-231-13/+32
| | | | and information_schema) from 'user' databases by placing them at the top.
* Remove old redundant code that was left over form when the server variables ↵stuconnolly2009-12-141-40/+1
| | | | sheet was moved to its own controller.
* - Work through static analysis of the source, fixing a number of small ↵rowanbeentje2009-12-141-3/+5
| | | | memory leaks and fixing a couple of over-releases
* Replace the main toolbar's #define'd identifier constants with extern's. ↵stuconnolly2009-12-121-51/+50
| | | | This completes the conversion of all constants in SPConstants to extern's.
* - Fix saving of custom SSH ports when the MySQL server is on a standard ↵rowanbeentje2009-12-101-1/+1
| | | | port - this addresses Issue #495