From 71ece9db51ee88ecdd760079e86e3a5ff6decbba Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Sat, 6 Feb 2010 17:32:46 +0000 Subject: Complete the implementation of the management of table triggers (accessible 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. --- Interfaces/English.lproj/DBView.xib | 1150 ++++++++++++++++++++++++++++++----- 1 file changed, 984 insertions(+), 166 deletions(-) (limited to 'Interfaces/English.lproj') diff --git a/Interfaces/English.lproj/DBView.xib b/Interfaces/English.lproj/DBView.xib index ff9e1fcf..0778dfd4 100644 --- a/Interfaces/English.lproj/DBView.xib +++ b/Interfaces/English.lproj/DBView.xib @@ -18,19 +18,18 @@ YES 740 740 - 1.2.5 + 1.2.2 YES - - + YES com.brandonwalkin.BWToolkit - com.apple.InterfaceBuilder.CocoaPlugin com.apple.WebKitIBPlugin + com.apple.InterfaceBuilder.CocoaPlugin YES @@ -60,7 +59,7 @@ Sequel Pro NSWindow View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {780, 480} @@ -238,7 +237,7 @@ controlColor 3 - MC42NjY2NjY2NjY3AA + MC42NjY2NjY2ODY1AA @@ -283,7 +282,6 @@ {{1, 1}, {218, 38}} - 6 @@ -315,7 +313,6 @@ {{-1, -13}, {220.212, 40}} - 2 @@ -413,7 +410,6 @@ {214, 354} - 4 @@ -441,7 +437,6 @@ {214, 354} - 528 @@ -577,7 +572,6 @@ {214, 145} - 6 @@ -605,7 +599,6 @@ {214, 145} - 512 @@ -1694,7 +1687,6 @@ NO NO NO - NO 0.0 0.0 @@ -2892,7 +2884,7 @@ customQuery - + 256 YES @@ -2919,29 +2911,6 @@ 6418 - - YES - - YES - Apple HTML pasteboard type - Apple PDF pasteboard type - Apple PICT pasteboard type - Apple PNG pasteboard type - Apple URL pasteboard type - CorePasteboardFlavorType 0x6D6F6F76 - NSColor pasteboard type - NSFilenamesPboardType - NSStringPboardType - NeXT Encapsulated PostScript v1.2 pasteboard type - NeXT RTFD pasteboard type - NeXT Rich Text Format v1.0 pasteboard type - NeXT TIFF v4.0 pasteboard type - NeXT font pasteboard type - NeXT ruler pasteboard type - WebURLsWithTitlesPboardType - public.url - - {694, 14} @@ -3003,7 +2972,6 @@ {{1, 1}, {694, 155}} - @@ -3035,7 +3003,6 @@ {696, 157} - 530 @@ -3125,7 +3092,6 @@ {{1, 17}, {694, 228}} - 4 @@ -3159,7 +3125,6 @@ {{1, 0}, {694, 17}} - 4 @@ -3168,7 +3133,6 @@ {696, 246} - 562 @@ -3822,7 +3786,6 @@ {{10, 7}, {706, 544}} - Custom Query @@ -4869,7 +4832,7 @@ triggers - + 256 YES @@ -5302,20 +5265,21 @@ {{10, 7}, {706, 544}} + Triggers - + 134217731 YES YES YES - + @@ -5336,7 +5300,7 @@ {{0, 0}, {1920, 1178}} {780, 502} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} @@ -6411,7 +6375,7 @@ View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {213, 107} @@ -6691,7 +6655,7 @@ {{0, 0}, {1440, 878}} {213, 129} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 1 @@ -6703,7 +6667,7 @@ View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {213, 107} @@ -6859,7 +6823,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1440, 878}} {213, 129} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 1 @@ -6869,7 +6833,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 New Relation NSPanel - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 256 @@ -7470,7 +7434,439 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {302, 307} {{0, 0}, {1440, 878}} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} + + + 1 + 2 + {{196, 162}, {329, 348}} + 1946157056 + New Trigger + NSPanel + + {3.40282e+38, 3.40282e+38} + + + 256 + + YES + + + 12 + + YES + + + 256 + + YES + + + 268 + {{49, 66}, {39, 14}} + + + YES + + 68288064 + 4326400 + Name: + + + + + + + + + 268 + {{94, 64}, {181, 19}} + + + YES + + -1804468671 + 272761856 + + + + YES + + + + + + + 268 + {{91, 35}, {187, 22}} + + + YES + + -2076049856 + 133120 + + + 109199615 + 129 + + + 400 + 75 + + + Before + + 1048576 + 2147483647 + 1 + + + _popUpItemAction: + + + YES + + OtherViews + + YES + + + + After + + 1048576 + 2147483647 + + + _popUpItemAction: + + + + + 1 + YES + YES + 2 + + + + + 268 + {{91, 10}, {187, 22}} + + + YES + + -2076049856 + 133120 + + + 109199615 + 129 + + + 400 + 75 + + + Insert + + 1048576 + 2147483647 + 1 + + + _popUpItemAction: + + + YES + + OtherViews + + YES + + + + Update + + 1048576 + 2147483647 + + + _popUpItemAction: + + + + + Delete + + 1048576 + 2147483647 + + + _popUpItemAction: + + + + + 1 + YES + YES + 2 + + + + + 268 + {{15, 40}, {72, 14}} + + + YES + + 68288064 + 4326400 + Action Time: + + + + + + + + + 268 + {{51, 15}, {36, 14}} + + + YES + + 68288064 + 4326400 + Event: + + + + + + + + {{1, 1}, {293, 93}} + + + + + {{17, 219}, {295, 109}} + + + {0, 0} + + 67239424 + 0 + Trigger: + + + + 3 + MCAwLjgwMDAwMDAxMTkAA + + + + 1 + 0 + 2 + NO + + + + 268 + {{218, 13}, {96, 28}} + + + 1 + YES + + 604110336 + 134348800 + Add + + + -2038284033 + 129 + + DQ + 200 + 25 + + + + + 268 + {{124, 13}, {96, 28}} + + + YES + + 67239424 + 134348800 + Cancel + + + -2038284033 + 268435585 + + . + 200 + 25 + + + + + 274 + + YES + + + 2304 + + YES + + + 2322 + + YES + + YES + Apple HTML pasteboard type + Apple PDF pasteboard type + Apple PICT pasteboard type + Apple PNG pasteboard type + Apple URL pasteboard type + CorePasteboardFlavorType 0x6D6F6F76 + NSColor pasteboard type + NSFilenamesPboardType + NSStringPboardType + NeXT Encapsulated PostScript v1.2 pasteboard type + NeXT RTFD pasteboard type + NeXT Rich Text Format v1.0 pasteboard type + NeXT TIFF v4.0 pasteboard type + NeXT font pasteboard type + NeXT ruler pasteboard type + WebURLsWithTitlesPboardType + public.url + + + {287, 14} + + + + + + + + + + + + YES + + + 6 + + + + 287 + 1 + + + 11811 + 0 + + + + YES + + YES + NSBackgroundColor + NSColor + + + YES + + + + + + + YES + + YES + NSColor + NSUnderline + + + YES + + + + + + + 6 + {592, 1e+07} + {180, 0} + + + + {{1, 1}, {287, 168}} + + + + + + + 4 + + + + -2147483392 + {{-100, -100}, {11, 133}} + + + 256 + + _doScroller: + 0.73888891935348511 + + + + -2147483392 + {{-100, -100}, {87, 18}} + + + 1 + + _doScroller: + 1 + 0.94565218687057495 + + + {{20, 45}, {289, 170}} + + + + 530 + + + + + + {329, 348} + + + + {{0, 0}, {1680, 1028}} + {3.40282e+38, 3.40282e+38} 3 @@ -7482,7 +7878,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {213, 50} @@ -7602,7 +7998,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1920, 1178}} {213, 72} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 9 @@ -7614,7 +8010,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {213, 107} @@ -7749,7 +8145,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1440, 878}} {213, 129} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 15 @@ -7761,7 +8157,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {350, 200} @@ -7963,7 +8359,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1680, 1028}} {350, 222} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 9 @@ -7975,7 +8371,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {213, 107} @@ -8124,7 +8520,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1440, 878}} {213, 129} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 31 @@ -8134,7 +8530,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 MySQL Help NSPanel - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {351, 120} @@ -8528,7 +8924,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1280, 1002}} {351, 136} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} MYSQL_HELP_WINDOW @@ -8541,7 +8937,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 View - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} {350, 250} @@ -8932,7 +9328,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {{0, 0}, {1920, 1178}} {350, 272} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 9 @@ -9065,7 +9461,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 Secure Text Input Sheet NSPanel - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} 256 @@ -9169,7 +9565,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 {338, 138} {{0, 0}, {1280, 778}} - {1.79769e+308, 1.79769e+308} + {3.40282e+38, 3.40282e+38} @@ -11035,7 +11431,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 disabledControlTextColor 3 - MC4zMzMzMzMzMzMzAA + MC4zMzMzMzMzNDMzAA @@ -15074,22 +15470,6 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 6678 - - - menu - - - - 6723 - - - - removeTrigger: - - - - 6738 - dataSource @@ -15116,131 +15496,259 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 - tableDocumentInstance - - + tableDocumentInstance + + + + 6742 + + + + tableDataInstance + + + + 6744 + + + + triggersTableView + + + + 6745 + + + + addTrigger: + + + + 6746 + + + + refreshTriggers: + + + + 6747 + + + + removeTrigger: + + + + 6748 + + + + tableWindow + + + + 6750 + + + + tableList + + + + 6751 + + + + tablesListInstance + + + + 6752 + + + + closeFieldMapperSheet: + + + + 6758 + + + + closeFieldMapperSheet: + + + + 6759 + + + + previousHistoryMenuItem + + + + 6760 + + + + gearMenuItemSelected: + + + + 6761 + + + + nextHistoryMenuItem + + + + 6762 + + + + gearMenuItemSelected: + + + + 6763 + + + + tableRelationsInstance + + + + 6764 + + + + scrollView + + - 6742 + 6795 - tableDataInstance - - + tableTriggersInstance + + - 6744 + 6796 - triggersTableView + addTriggerPanel - + - 6745 + 6797 - - addTrigger: + + triggerNameTextField - + - 6746 + 6798 - - refreshTriggers: + + triggerActionTimePopUpButton - + - 6747 + 6799 - - removeTrigger: + + triggerEventPopUpButton - + - 6748 + 6800 - tableWindow + triggerStatementTextView - + - 6750 + 6801 - tableList - - + delegate + + - 6751 + 6802 - tablesListInstance + confirmAddTriggerButton - + - 6752 + 6803 - closeFieldMapperSheet: - - + confirmAddTrigger: + + - 6758 + 6804 - closeFieldMapperSheet: - - + closeTriggerSheet: + + - 6759 + 6805 - previousHistoryMenuItem - - + labelTextField + + - 6760 + 6806 - - gearMenuItemSelected: - - + + refreshTriggersButton + + - 6761 + 6807 - nextHistoryMenuItem - - + removeTriggerButton + + - 6762 + 6808 - gearMenuItemSelected: - - + removeTrigger: + + - 6763 + 6809 - tableRelationsInstance - - + menu + + - 6764 + 6810 @@ -21512,6 +22020,234 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 + + 6765 + + + YES + + + + New Trigger Sheet + + + 6766 + + + YES + + + + + + + + + 6767 + + + YES + + + + + + 6768 + + + YES + + + + + + 6769 + + + YES + + + + + + + + 6770 + + + YES + + + + + + + + + + + 6771 + + + YES + + + + + + 6772 + + + YES + + + + + + 6773 + + + YES + + + + + + 6774 + + + YES + + + + + + 6775 + + + YES + + + + + + 6776 + + + YES + + + + + + 6777 + + + + + 6778 + + + + + 6779 + + + YES + + + + + + 6780 + + + YES + + + + + + + 6781 + + + + + 6782 + + + + + 6783 + + + YES + + + + + + 6784 + + + YES + + + + + + + + 6785 + + + + + 6786 + + + + + 6787 + + + + + 6788 + + + + + 6789 + + + + + 6790 + + + + + 6791 + + + + + 6792 + + + + + 6793 + + + + + 6794 + + + @@ -22840,9 +23576,46 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 675.ImportedFromIB2 676.IBPluginDependency 676.ImportedFromIB2 + 6765.IBEditorWindowLastContentRect + 6765.IBPluginDependency + 6765.IBWindowTemplateEditedContentRect + 6765.NSWindowTemplate.visibleAtLaunch + 6766.IBPluginDependency + 6766.IBUserGuides + 6767.IBPluginDependency + 6768.IBPluginDependency + 6769.IBPluginDependency 677.CustomClassName 677.IBPluginDependency 677.ImportedFromIB2 + 6770.IBPluginDependency + 6771.IBPluginDependency + 6772.IBPluginDependency + 6773.IBPluginDependency + 6774.IBPluginDependency + 6775.IBPluginDependency + 6776.IBPluginDependency + 6777.IBPluginDependency + 6778.IBPluginDependency + 6779.IBPluginDependency + 6780.IBEditorWindowLastContentRect + 6780.IBPluginDependency + 6781.IBPluginDependency + 6782.IBPluginDependency + 6783.IBPluginDependency + 6784.IBEditorWindowLastContentRect + 6784.IBPluginDependency + 6785.IBPluginDependency + 6786.IBPluginDependency + 6787.IBPluginDependency + 6788.IBPluginDependency + 6789.IBPluginDependency + 6790.IBPluginDependency + 6791.IBPluginDependency + 6792.CustomClassName + 6792.IBPluginDependency + 6793.IBPluginDependency + 6794.IBPluginDependency 68.ImportedFromIB2 69.ImportedFromIB2 711.IBPluginDependency @@ -23706,10 +24479,10 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin - {{59, 289}, {944, 550}} + {{95, 382}, {944, 550}} com.apple.InterfaceBuilder.CocoaPlugin - {{59, 289}, {944, 550}} + {{95, 382}, {944, 550}} {{62, 352}, {845, 504}} @@ -24754,7 +25527,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin - {{539, 190}, {158, 23}} + {{539, 190}, {150, 23}} com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin @@ -24763,9 +25536,58 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 com.apple.InterfaceBuilder.CocoaPlugin + {{888, 156}, {329, 348}} + com.apple.InterfaceBuilder.CocoaPlugin + {{888, 156}, {329, 348}} + + com.apple.InterfaceBuilder.CocoaPlugin + + YES + + + 101 + 0 + + + + 292 + 0 + + + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin BWSplitView com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + {{422, 361}, {187, 37}} + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + {{353, 410}, {187, 54}} + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + CMTextView + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin @@ -24911,7 +25733,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 - 6764 + 6810 @@ -25640,12 +26462,10 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 YES addTrigger: - closeRelationSheet: - confirmAddRelation: + closeTriggerSheet: + confirmAddTrigger: refreshTriggers: removeTrigger: - selectReferenceTable: - selectTableColumn: YES @@ -25654,8 +26474,6 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 id id id - id - id @@ -25665,13 +26483,8 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 addTriggerButton addTriggerPanel addTriggerTableBox - columnPopUpButton confirmAddTriggerButton labelTextField - onDeletePopUpButton - onUpdatePopUpButton - refColumnPopUpButton - refTablePopUpButton refreshTriggersButton removeTriggerButton tableDataInstance @@ -25679,6 +26492,10 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 tableList tableWindow tablesListInstance + triggerActionTimePopUpButton + triggerEventPopUpButton + triggerNameTextField + triggerStatementTextView triggersTableView @@ -25686,13 +26503,8 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 NSButton NSPanel NSBox - NSPopUpButton NSButton NSTextField - NSPopUpButton - NSPopUpButton - NSPopUpButton - NSPopUpButton NSButton NSButton id @@ -25700,6 +26512,10 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 id id id + NSPopUpButton + NSPopUpButton + NSTextField + NSTextView NSTableView @@ -26049,6 +26865,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 tableRelationsInstance tableSourceInstance tableTabView + tableTriggersInstance tableWindow tablesListInstance taskCancelButton @@ -26109,6 +26926,7 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 NSTabView id id + id NSButton id id -- cgit v1.2.3