From ddf7d62d20614111acdd420075ef762d6deaa8d7 Mon Sep 17 00:00:00 2001 From: rowanbeentje Date: Thu, 19 Mar 2009 23:44:06 +0000 Subject: SPSQLParser changes: - 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. --- Interfaces/English.lproj/DBView.xib | 212 +++++++++++++++++++++++++++++------- 1 file changed, 174 insertions(+), 38 deletions(-) (limited to 'Interfaces/English.lproj') diff --git a/Interfaces/English.lproj/DBView.xib b/Interfaces/English.lproj/DBView.xib index 74755ef7..f30440be 100644 --- a/Interfaces/English.lproj/DBView.xib +++ b/Interfaces/English.lproj/DBView.xib @@ -44,7 +44,7 @@ {3.40282e+38, 3.40282e+38} {780, 480} - + 256 YES @@ -78,6 +78,7 @@ 4352 {194, 393} + YES @@ -174,6 +175,8 @@ {{1, 1}, {194, 393}} + + 6 @@ -188,6 +191,7 @@ -2147483392 {{175, 1}, {15, 481}} + _doScroller: 9.979253e-01 @@ -197,6 +201,7 @@ 256 {{-100, -100}, {141, 11}} + 257 _doScroller: @@ -205,6 +210,8 @@ {196, 395} + + 530 @@ -226,6 +233,7 @@ 4352 {194, 123} + YES @@ -289,6 +297,8 @@ {{1, 1}, {194, 123}} + + 4 @@ -298,6 +308,7 @@ -2147483392 {{175, 1}, {15, 481}} + _doScroller: 9.979253e-01 @@ -307,6 +318,7 @@ 256 {{-100, -100}, {141, 11}} + 257 _doScroller: @@ -315,6 +327,8 @@ {{0, 404}, {196, 125}} + + 530 @@ -324,12 +338,14 @@ {{0, 22}, {196, 529}} + 292 {{0, -1}, {32, 25}} + YES -2080244224 @@ -358,6 +374,7 @@ 292 {{20, 0}, {46, 25}} + YES -2076049856 @@ -366,7 +383,7 @@ -2042609409 35 - + NSImage button_action @@ -382,7 +399,10 @@ 1048576 2147483647 1 - + + NSImage + button_action + _popUpItemAction: @@ -468,6 +488,7 @@ {{179, 0}, {15, 23}} + YES 130560 @@ -500,6 +521,7 @@ {{60, 0}, {119, 23}} + YES 130560 @@ -518,6 +540,7 @@ {194, 550} + NSView @@ -530,6 +553,7 @@ 274 {{-7, -10}, {672, 564}} + YES @@ -566,6 +590,7 @@ {{608, 6}, {10, 13}} + YES 130560 @@ -586,6 +611,7 @@ 257 {{400, 8}, {55, 11}} + YES 67239424 @@ -606,6 +632,7 @@ 257 {{456, 6}, {135, 15}} + YES -1539178944 @@ -714,12 +741,14 @@ 4352 {625, 282} + YES 256 {625, 17} + @@ -727,6 +756,7 @@ -2147483392 {{-26, 0}, {16, 17}} + YES @@ -1259,6 +1289,8 @@ {{1, 17}, {625, 282}} + + 4 @@ -1268,6 +1300,7 @@ -2147483392 {{636, 17}, {15, 265}} + _doScroller: 8.170732e-01 @@ -1277,6 +1310,7 @@ -2147483392 {{1, 282}, {635, 15}} + 1 _doScroller: @@ -1291,6 +1325,8 @@ {{1, 0}, {625, 17}} + + 4 @@ -1299,6 +1335,8 @@ {{-1, 24}, {627, 300}} + + 562 @@ -1312,6 +1350,7 @@ 290 {{107, 0}, {519, 26}} + YES -2080244224 @@ -1332,6 +1371,7 @@ 260 {{-1, 0}, {28, 26}} + YES 604110336 @@ -1356,6 +1396,7 @@ 260 {{26, 0}, {28, 26}} + YES 604110336 @@ -1380,6 +1421,7 @@ 260 {{53, 0}, {28, 26}} + YES 604110336 @@ -1404,6 +1446,7 @@ 260 {{80, 0}, {28, 26}} + YES 67239424 @@ -1426,6 +1469,7 @@ {626, 324} + NSView @@ -1438,6 +1482,7 @@ 264 {{7, 184}, {46, 14}} + YES 67239424 @@ -1464,12 +1509,14 @@ 4352 {625, 138} + YES 256 {625, 17} + @@ -1477,6 +1524,7 @@ -2147483392 {{-26, 0}, {16, 17}} + YES @@ -1729,6 +1777,8 @@ {{1, 17}, {625, 138}} + + 4 @@ -1738,6 +1788,7 @@ -2147483392 {{84, 17}, {15, 67}} + _doScroller: 8.170732e-01 @@ -1747,6 +1798,7 @@ -2147483392 {{1, 123}, {612, 15}} + 1 _doScroller: @@ -1761,6 +1813,8 @@ {{1, 0}, {625, 17}} + + 4 @@ -1769,6 +1823,8 @@ {{-1, 22}, {627, 156}} + + 562 @@ -1782,6 +1838,7 @@ 258 {{80, -2}, {546, 26}} + YES -2080244224 @@ -1802,6 +1859,7 @@ 260 {{-1, -2}, {28, 26}} + YES 604110336 @@ -1826,6 +1884,7 @@ 260 {{26, -2}, {28, 26}} + YES 604110336 @@ -1850,6 +1909,7 @@ 260 {{53, -2}, {28, 26}} + YES 67239424 @@ -1869,15 +1929,18 @@ {{0, 333}, {626, 198}} + NSView {{7, 10}, {626, 531}} + {{10, 7}, {637, 544}} + Structure @@ -2532,7 +2595,7 @@ 6418 - {626, 14} + {625, 14} @@ -2550,7 +2613,7 @@ - 6.260000e+02 + 6.250000e+02 1 @@ -2590,7 +2653,7 @@ - {{1, 1}, {626, 155}} + {{1, 1}, {625, 155}} @@ -2622,7 +2685,7 @@ 9.456522e-01 - {628, 157} + {627, 157} 530 @@ -2631,7 +2694,7 @@ - {628, 156} + {627, 156} NSView @@ -2653,13 +2716,13 @@ 4352 - {626, 226} + {625, 226} YES 256 - {626, 17} + {625, 17} @@ -2672,7 +2735,7 @@ YES - 6.230000e+02 + 6.220000e+02 4.000000e+01 1.000000e+03 @@ -2709,7 +2772,7 @@ YES - {{1, 17}, {626, 226}} + {{1, 17}, {625, 226}} @@ -2742,7 +2805,7 @@ YES - {{1, 0}, {626, 17}} + {{1, 0}, {625, 17}} @@ -2751,7 +2814,7 @@ - {628, 244} + {627, 244} 562 @@ -2765,13 +2828,13 @@ 265 - {{523, 245}, {90, 28}} + {{522, 245}, {90, 28}} YES -2080244224 134348800 - Run Query + Run All -2034876161 @@ -2785,8 +2848,8 @@ - 266 - {{264, 248}, {259, 22}} + 268 + {{214, 248}, {186, 22}} YES @@ -2835,7 +2898,7 @@ 264 - {{17, 248}, {245, 22}} + {{17, 248}, {195, 22}} YES @@ -2916,8 +2979,28 @@ 1 + + + 265 + {{414, 245}, {110, 28}} + + YES + + 604110336 + 134348800 + Run Current + + + -2038284033 + 129 + + + 200 + 25 + + - {{0, 165}, {628, 269}} + {{0, 165}, {627, 269}} NSView @@ -2929,7 +3012,7 @@ 266 - {{242, 67}, {369, 14}} + {{242, 67}, {368, 14}} YES @@ -2965,7 +3048,7 @@ 274 - {{17, 20}, {594, 43}} + {{17, 20}, {593, 43}} YES @@ -2979,16 +3062,16 @@ - {{0, 443}, {628, 87}} + {{0, 443}, {627, 87}} NSView - {{6, 10}, {628, 530}} + {{6, 10}, {627, 530}} - {{10, 7}, {638, 544}} + {{10, 7}, {637, 544}} Custom Query @@ -3374,16 +3457,20 @@ {{203, 0}, {660, 550}} + NSView {863, 550} + YES DBViewSplitter {863, 550} + + {{0, 0}, {1440, 878}} {780, 502} @@ -9613,14 +9700,6 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 214 - - - performQuery: - - - - 215 - textView @@ -11729,6 +11808,38 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 4822 + + + runSelectedQueries: + + + + 5125 + + + + runAllButton + + + + 5126 + + + + runSelectionButton + + + + 5127 + + + + runAllQueries: + + + + 5128 + @@ -16141,8 +16252,9 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 YES - + + @@ -16608,6 +16720,20 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 + + 5123 + + + YES + + + + + + 5124 + + + @@ -17607,6 +17733,8 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 51.ImportedFromIB2 512.IBPluginDependency 512.ImportedFromIB2 + 5123.IBPluginDependency + 5124.IBPluginDependency 513.IBPluginDependency 513.ImportedFromIB2 514.IBPluginDependency @@ -19026,8 +19154,8 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin - {{318, 360}, {863, 550}} - {{318, 360}, {863, 550}} + {{55, 306}, {863, 550}} + {{55, 306}, {863, 550}} {{62, 352}, {845, 504}} @@ -19051,6 +19179,8 @@ IGRvIHlvdSB3YW50IHRvIGFkZCBmb3IgdGhpcyBmaWVsZD8 com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin + com.apple.InterfaceBuilder.CocoaPlugin com.apple.InterfaceBuilder.CocoaPlugin @@ -19401,7 +19531,7 @@ Y2hhbmdlIHRoZSBvcmRlcg - 5122 + 5128 @@ -19475,8 +19605,9 @@ Y2hhbmdlIHRoZSBvcmRlcg closeQueryFavoritesSheet: closeSheet: copyQueryFavorite: - performQuery: removeQueryFavorite: + runAllQueries: + runSelectedQueries: YES @@ -19488,6 +19619,7 @@ Y2hhbmdlIHRoZSBvcmRlcg id id id + id @@ -19503,6 +19635,8 @@ Y2hhbmdlIHRoZSBvcmRlcg queryFavoritesView queryHistoryButton removeQueryFavoriteButton + runAllButton + runSelectionButton tableWindow textView valueSheet @@ -19523,6 +19657,8 @@ Y2hhbmdlIHRoZSBvcmRlcg id id id + id + id -- cgit v1.2.3