| Server IP : 180.180.241.3 / Your IP : 216.73.216.35 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
# import the wb module
from wb import *
# import the grt module
import grt
# import the mforms module for GUI stuff
import mforms
# define this Python module as a GRT module
ModuleInfo = DefineModule(name= "TextUtils", author= "Oracle Corp.", version="1.0")
#@ModuleInfo.plugin("wb.text.doStuff", caption= "Do Stuff", input= [wbinputs.currentQueryBuffer()], pluginMenu= "Text")
#@ModuleInfo.export(grt.INT, grt.classes.db_query_QueryBuffer)
#def doStuff(qbuffer):
#
# return 0
@ModuleInfo.exportFilter("wb.text.sort", "Sort Selection")
def sortText(text):
lines = text.split("\n")
lines.sort()
return "\n".join(lines)
@ModuleInfo.exportFilter("wb.text.quoteString", "Quote and Escape String")
def quoteString(text):
escaped= ""
for c in text:
escape= None
if ord(c) == 0:
escape= '0'
elif c == '\n':
escape= 'n'
elif c == '\r':
escape= 'r'
elif c == '\\':
escape= '\\'
elif c == "'":
escape= "'"
elif ord(c) == 032:
escape= 'Z'
if escape is not None:
escaped += "\\"+escape
else:
escaped += c
return "'"+escaped+"'"