|
14 | 14 | */ |
15 | 15 | package org.utplsql.sqldev.editor.menu |
16 | 16 |
|
| 17 | +import java.awt.Dimension |
17 | 18 | import java.util.logging.Logger |
18 | 19 | import javax.swing.JEditorPane |
| 20 | +import javax.swing.JSplitPane |
19 | 21 | import oracle.dbtools.raptor.navigator.impl.DatabaseSourceNode |
20 | 22 | import oracle.dbtools.raptor.utils.Connections |
21 | 23 | import oracle.dbtools.worksheet.editor.OpenWorksheetWizard |
22 | 24 | import oracle.dbtools.worksheet.editor.Worksheet |
| 25 | +import oracle.dbtools.worksheet.editor.WorksheetGUI |
| 26 | +import oracle.dbtools.worksheet.utils.WorksheetUtil |
23 | 27 | import oracle.ide.Context |
24 | 28 | import oracle.ide.Ide |
25 | 29 | import oracle.ide.config.Preferences |
@@ -88,26 +92,31 @@ class UtplsqlEditorController implements Controller { |
88 | 92 | connectionName = Connections.instance.createPrivateConnection(connectionName) |
89 | 93 | } |
90 | 94 | val code = ''' |
91 | | - SET SERVEROUTPUT ON SIZE 1000000 |
92 | 95 | «IF preferences.resetPackage» |
93 | | - BEGIN |
94 | | - dbms_session.reset_package; |
95 | | - END; |
96 | | - / |
| 96 | + EXECUTE dbms_session.reset_package; |
97 | 97 | «ENDIF» |
98 | | - BEGIN |
99 | | - ut.run('«parser.getPathAt(position)»'); |
100 | | - END; |
101 | | - / |
| 98 | + SET SERVEROUTPUT ON SIZE 1000000 |
| 99 | + CLEAR SCREEN |
| 100 | + EXECUTE ut.run('«parser.getPathAt(position)»'); |
102 | 101 | ''' |
103 | 102 | val worksheet = OpenWorksheetWizard.openNewTempWorksheet(connectionName, code) as Worksheet |
104 | 103 | if (connectionName === null) { |
105 | 104 | worksheet.comboConnection = null |
106 | 105 | } |
107 | | - // TODO make update Title work |
108 | | - worksheet.updateTitle(UtplsqlResources.getString("WORKSHEET_TITLE")) |
109 | | - // TODO exeucte code in worksheet when preferences.autoExecute |
110 | | - logger.fine('''Cursor is at «position». Calling «parser.getPathAt(position)»''') |
| 106 | + WorksheetUtil.setWorksheetTabName(worksheet.context.node.URL, UtplsqlResources.getString("WORKSHEET_TITLE")); |
| 107 | + if (preferences.autoExecute) { |
| 108 | + Thread.sleep(100) // give worksheet time to initialize |
| 109 | + val action = Ide.getIdeActionMap.get(Ide.findCmdID("Worksheet.RunScript")) as IdeAction |
| 110 | + action.performAction(worksheet.context) |
| 111 | + Thread.sleep(200) // give script runner time to initiate result panel |
| 112 | + val splitPane = worksheet.selectedResultPanel?.GUI?.parent?.parent?.parent as JSplitPane |
| 113 | + if (splitPane === null) { |
| 114 | + logger.severe("Could not adjust size of worksheet.") |
| 115 | + } else { |
| 116 | + splitPane.dividerLocation = 0.15 // 15% for Worksheet, 85% for Script Output |
| 117 | + } |
| 118 | + } |
| 119 | + logger.fine('''utPLSQL test called for code at cursor position «position».»''') |
111 | 120 | } |
112 | 121 | } |
113 | 122 | } |
|
0 commit comments