1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
# 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+"'"
|
