table_insp_idx.append((s.schemaName, s.owner.name))
else:
log_error("Unsupported inspector type: %s\n" % s.type)
if len(schema_insp):
show_schema_manager(editor, schema_insp, False)
if len(table_insp):
show_table_inspector(editor, table_insp)
if len(table_insp_idx):
show_table_inspector(editor, table_insp_idx, "indexes")
return 0
#@ModuleInfo.plugin("wb.sqlide.refactor.renameSchema", caption = "Rename References to Schema Name", input=[wbinputs.currentQueryBuffer()]) # pluginMenu="SQL/Utilities"
#@ModuleInfo.export(grt.INT, grt.classes.db_query_QueryBuffer)
#def refactorRenameSchema(editor):
# pass
@ModuleInfo.plugin("wb.sqlide.runScript", caption = "Run SQL Script", input=[wbinputs.currentSQLEditor()])
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor)
def runSQLScript(editor):
form = RunScriptForm(editor)
return form.run()
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def runSQLScriptFile(editor, path):
form = RunScriptForm(editor)
return form.run_file(path)
node_symbol,
node_children,
find_child_node,
find_child_nodes,
trim_ast,
ASTHelper,
)
# define this Python module as a GRT module
ModuleInfo = DefineModule(name="CodeUtils", author="Oracle Corp.", version="1.0")
@ModuleInfo.plugin(
"wb.sqlide.copyAsPHPConnect",
caption="Copy as PHP Code (Connect to Server)",
input=[wbinputs.currentSQLEditor()],
pluginMenu="SQL/Utilities",
)
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor)
def copyAsPHPConnect(editor):
"""Copies PHP code to connect to the active MySQL connection to the clipboard.
"""
if editor.connection:
conn = editor.connection
if conn.driver.name == "MysqlNativeSocket":
params = {
"host": "p:localhost",
"port": 3306,
"user": conn.parameterValues["userName"],
"socket": conn.parameterValues["socket"],
@ModuleInfo.export(grt.STRING, grt.classes.db_mgmt_ServerInstance)
def testInstanceSettings(server_instance):
error = testInstanceSettingByName("connect_to_host",
server_instance.connection,
server_instance)
testInstanceSettingByName("disconnect", server_instance.connection,
server_instance)
return error
##------------------------------------------------------------------------------------------------------------------------
@ModuleInfo.plugin("wb.admin.open_into",
type="standalone",
input=[wbinputs.currentSQLEditor(),
wbinputs.string()])
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def openAdminSection(editor, section):
context = grt.fromgrt(editor.customData["adminContext"])
if context:
context.open_into_section(section, True)
else:
log_error("No context found for editor in call to openAdminSection\n")
# Hack to make this plugin only appear if SE modules are available
try:
import wba_meb # noqa
@ModuleInfo.plugin("wb.admin.open_into_se",
# import the wb module
from wb import DefineModule, wbinputs
# import the grt module
import grt
# import the mforms module for GUI stuff
import mforms
from sql_reformatter import node_value, node_symbol, node_children, find_child_node, find_child_nodes, trim_ast, ASTHelper, dump_tree, flatten_node
# define this Python module as a GRT module
ModuleInfo = DefineModule(name= "CodeUtils", author= "Oracle Corp.", version="1.0")
@ModuleInfo.plugin("wb.sqlide.copyAsPHPConnect", caption= "Copy as PHP Code (Connect to Server)", input= [wbinputs.currentSQLEditor()], pluginMenu= "SQL/Utilities")
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor)
def copyAsPHPConnect(editor):
"""Copies PHP code to connect to the active MySQL connection to the clipboard.
"""
if editor.connection:
conn = editor.connection
if conn.driver.name == "MysqlNativeSocket":
params = {
"host" : "p:localhost",
"port" : 3306,
"user" : conn.parameterValues["userName"],
"socket" : conn.parameterValues["socket"],
"dbname" : editor.defaultSchema
}
else:
params = {
# import the wb module
from wb import DefineModule, wbinputs
# import the grt module
import grt
# import the mforms module for GUI stuff
import mforms
from sql_reformatter import node_value, node_symbol, node_children, find_child_node, find_child_nodes, trim_ast, ASTHelper
# define this Python module as a GRT module
ModuleInfo = DefineModule(name= "CodeUtils", author= "Oracle Corp.", version="1.0")
@ModuleInfo.plugin("wb.sqlide.copyAsPHPConnect", caption= "Copy as PHP Code (Connect to Server)", input= [wbinputs.currentSQLEditor()], pluginMenu= "SQL/Utilities")
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor)
def copyAsPHPConnect(editor):
"""Copies PHP code to connect to the active MySQL connection to the clipboard.
"""
if editor.connection:
conn = editor.connection
if conn.driver.name == "MysqlNativeSocket":
params = {
"host" : "p:localhost",
"port" : 3306,
"user" : conn.parameterValues["userName"],
"socket" : conn.parameterValues["socket"],
"dbname" : editor.defaultSchema
}
else:
params = {
#form.run(None, None)
return {}
@ModuleInfo.export(grt.STRING, grt.classes.db_mgmt_ServerInstance)
def testInstanceSettings(server_instance):
error = testInstanceSettingByName("connect_to_host", server_instance.connection, server_instance)
testInstanceSettingByName("disconnect", server_instance.connection, server_instance)
return error
##------------------------------------------------------------------------------------------------------------------------
@ModuleInfo.plugin("wb.admin.open_into", type="standalone", input=[wbinputs.currentSQLEditor(), wbinputs.string()], accessibilityName="Open Into")
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def openAdminSection(editor, section):
context = grt.fromgrt(editor.customData["adminContext"])
if context:
context.open_into_section(section, True)
else:
log_error("No context found for editor in call to openAdminSection\n")
# Hack to make this plugin only appear if SE modules are available
try:
import wba_meb # noqa
@ModuleInfo.plugin("wb.admin.open_into_se", type="standalone", input=[wbinputs.currentSQLEditor(), wbinputs.string()], accessibilityName="Open Into")
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def openAdminSectionSE(editor, section):
#form.run(None, None)
return {}
@ModuleInfo.export(grt.STRING, grt.classes.db_mgmt_ServerInstance)
def testInstanceSettings(server_instance):
error = testInstanceSettingByName("connect_to_host", server_instance.connection, server_instance)
testInstanceSettingByName("disconnect", server_instance.connection, server_instance)
return error
##------------------------------------------------------------------------------------------------------------------------
@ModuleInfo.plugin("wb.admin.open_into", type="standalone", input=[wbinputs.currentSQLEditor(), wbinputs.string()])
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def openAdminSection(editor, section):
context = grt.fromgrt(editor.customData["adminContext"])
if context:
context.open_into_section(section, True)
# Hack to make this plugin only appear if SE modules are available
try:
import wba_meb # noqa
@ModuleInfo.plugin("wb.admin.open_into_se", type="standalone", input=[wbinputs.currentSQLEditor(), wbinputs.string()])
@ModuleInfo.export(grt.INT, grt.classes.db_query_Editor, grt.STRING)
def openAdminSectionSE(editor, section):
context = grt.fromgrt(editor.customData["adminContext"])
if context:
