aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableTriggers.m
Commit message (Collapse)AuthorAgeFilesLines
* - Fix trigger deletion to use the correct trigger namerowanbeentje2011-02-131-4/+5
| | | | | | | - Improve trigger deletion error process to show error sheets correctly - Fix spelling of "Statement" in interface - Tweak trigger column widths
* - Revert r3187, which only masked an underlying bug and caused double ↵rowanbeentje2011-02-111-11/+21
| | | | | | | | | columns in views - In SPTableStructureDelete, don't request the encoding if the table is reloading; this prevents multithreaded data fetches and race conditions causing Issue #974. - Alter SPTableData to use thread mutexes instead of a boolean to prevent threading issues, which also fixes Issue #974 in a different way. Alter race condition checks to block their threads instead of returning bogus information to prevent state issues. - Alter table loading to no longer load trigger information until required, speeding up use of other views and cleaning up the console log.
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-1/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* Replace use of hardcoded strings with constants when working with trigger data.stuconnolly2010-10-191-21/+33
|
* Add a 'Edit Trigger' menu item to the trigger's table view context menu.stuconnolly2010-10-191-79/+107
|
* Because the process of editing a trigger involves droping and then ↵stuconnolly2010-10-191-38/+55
| | | | re-creating it, if an error occurs when attempting to re-create it remember to then re-create the original one. Fixes issue #795.
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-8/+3
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* • corrected switch() {} syntaxBibiko2010-09-231-3/+8
| | | | - this fixes issue 841
* • do not use title strings of NSPopupButtons for creating the CREATE ↵Bibiko2010-09-211-105/+110
| | | | | | | TRIGGER query due to possible localizations, instead make usage of selected indices - fixes i829 - some code cleaning and commenting stuff
* Tweak table triggers loading to only proceed for MySQL > 5; this finishes ↵rowanbeentje2010-07-201-1/+3
| | | | the work started in r2201 and should address Issue #748.
* Added support for edit triggers. Doubleclick on a row and the Add trigger ↵bamse162010-07-111-5/+88
| | | | | | | | | | | | | | pops up with all the fields prepopulated. Edit works as 'DROP' old trigger and then 'CREATE' new trigger (since MySQL doesn't have support for 'ALTER' trigger). In case of error while adding the new trigger, when you add a new trigger, all the info from the original trigger is preserved. (Don't know if this is the best solution).
* Rename TableDocument to SPDatabaseDocument.stuconnolly2010-05-281-1/+1
|
* Rename TablesList to SPTablesList.stuconnolly2010-05-271-1/+1
|
* Initial implementation of tabs:rowanbeentje2010-05-231-2/+2
| | | | | | | | - Addition of PSMTabBar framework - Rework away from a document-based TableDocument - Support tabs throughout the application - Add menu items for creating tabs, and add support for dragging tabs to different windows
* Rework alert sheets:rowanbeentje2010-05-091-2/+2
| | | | | | | - Change MCPConnection.m to no longer use a reference to tableWindow to attach sheets - instead use a delate error display method if available - Rework TableSource and TableContent sheetDidEnd methods into per-task methods rather than overloading contextInfo - Rework SPAlertSheets to perform actions on the main thread, with the loss of (unused) support for a didDismissSelector. This addresses a number of crashes logged by the crash reporter
* Review trigger fetching and storage:rowanbeentje2010-05-011-50/+45
| | | | | | | - Trigger queries are no longer made for MySQL < 5.0.2 - Trigger loading has been deferred until the trigger tab is active, reducing queries when switching tables and thus increasing overall responsiveness - Export triggers in MySQL dumps even if the Table Content switch is unchecked
* changed many occurrences of "REMOVE" to "DELETE", eg. "DELETE DATABASE"jakob2010-04-221-2/+2
|
* If the user is viewing the triggers table and then switches to either a proc ↵stuconnolly2010-03-311-0/+9
| | | | or function disable all interface controls.
* - Make [MCPConnection getLastErrorMessage] more consistent by always ↵rowanbeentje2010-03-251-5/+2
| | | | | | | returning nil if no error occurred (previously a blank string was returned most of the time) - Add a new (BOOL)[MCPConnection queryErrored] method, changing all error message checks to use it for clarity
* General tidy up, with a focus on consolidating more constants in ↵stuconnolly2010-03-241-1/+1
| | | | SPConstants.h/m.
* - Remove observers for key paths when dealloc'ing objects to fix later ↵rowanbeentje2010-03-231-0/+1
| | | | | | | crashes when changing those keyvalues (eg changing query editor background colour after closing windows - http://log.sequelpro.com/view/44 ) - Fix a memory leak of a prefs reference in CMTextView
* Add support for printing the table triggers view as well some HTML ↵stuconnolly2010-03-131-0/+43
| | | | generation performance improvements.
* Disable the addition of triggers on versions of MySQL less than 5.0.2 when ↵stuconnolly2010-02-071-14/+35
| | | | support for them was initially added.
* Complete the implementation of the management of table triggers (accessible ↵stuconnolly2010-02-061-165/+84
| | | | 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.
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-311-0/+515
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