-
Notifications
You must be signed in to change notification settings - Fork 0
/
pdgmDispUI-formsearch.py
343 lines (309 loc) · 12.1 KB
/
pdgmDispUI-formsearch.py
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
'''
Basic framework for formsearch using tkinter.
Comma-separted strings of property values in listbox are keys to full
pdgm-defining prop:val strings (pvstrings/pdgm-dict-LANG.py). SPARQL query
for pdgm derived from that in pdgmDisp.query. Widgets and grid modeled
on Mark Roseman, Modern Tkinter -- cf. esp. pp. 67-70.
NOTE: In this one-frame version of pdgmDispUI, paradigm and res
[=SPARQL query formed in pdgmDisp.query()] are inserted into the Tk text
widgets lpdgm and lquery.
'''
from tkinter import *
from tkinter import ttk
from SPARQLWrapper import SPARQLWrapper, JSON
from tabulate import tabulate
import pandas as pd
from pandas import Series, DataFrame
from io import StringIO
import shelve
from pdgmDispQuery import query, formsquery #import for pdgm-display query code
# import re
f = ('times',16) #'the pleasing font'; used in llabel1, pdglabl
# Called when the selection in the lbox1 changes; figure out
# which language is currently selected, and then lookup its lcode,
# and from that, its lfile. As well, clear the selected pdgmmessage,
# so it doesn't stick around after we start doing
# other things.
def showLangs(*args):
idxs = lbox.curselection()
idxslist = list(idxs)
print('llist: ')
print(idxslist)
lnameslist = []
for i in idxslist:
idx = int(i)
lname = languagenames[idx]
#lmsg1.set("Paradigms for %s" % lname)
lnameslist.append(lname)
languages= (',').join(lnameslist)
print(languages)
llmsg.set(languages)
def choosePdgms(*args):
idxs = lforms.curselection()
idxslist = list(idxs)
#resultstr = lformslist.get()
#resultlist = resultstr.split(',')
#print('resultlist: ')
#print(resultlist)
print('lformslist: ')
print(idxslist)
pnameslist = []
for i in idxslist:
idx = int(i)
print(str('idx = ' + str(idx)))
form = resultlist[idx]
pname = form[-1].strip('()')
print(str('pname: ' + str(pname)))
pnameslist.append(pname)
pnames = (',').join(pnameslist)
print(str('pnames: ' + pnames))
#pdgms= (',').join(pnameslist)
#print(str('pdgms: ' + pdgms))
pdgmmsg.set(pnames)
def pvpairsSearch(*args):
print('===============================\n')
lforms.insert('end', '\n===============================\n')
# From lang select-list
languages = llmsg.get()
# From prop=Val entry form
qstring = pvpairs.get()
#resultlist = []
resultstr = ""
# Make SPARQL query
res = formsquery(languages,qstring)
print(str("QUERY: \n" + res))
# Submit it to paradigm datasrore
sparql = SPARQLWrapper("http://localhost:3030/aama/query")
sparql.setQuery(res)
sparql.setReturnFormat(JSON)
results = sparql.query().convert()
results2 = sparql.query()
#print("results")
#print(results)
#print('results2')
#print(results2)
title = str('FORM SEARCH: ' + qstring)
resultlist.append(title)
select = results["head"]["vars"]
# print()
header = (" ").join(select)
resultlist.append(header)
uline = '-' * len(header)
header3 = (",").join(select)
resultlist.append(uline)
for result in results["results"]["bindings"]:
# print(result)
resultrow = []
for sel in select:
#print(str('sel: ' + sel))
if sel in result:
#if result[sel]:
if sel == 'pdgmLabel':
#NB: If I tray any other symbols but '()' to
# set pdgmLabel graphically apart, program
# inserts a '{}' around the pdgmLabel
selval = str('(' + result[sel]["value"] + ')')
#selval.strip('{}')
#selval = str('[' + selval1 + ']')
else:
selval = result[sel]["value"]
else:
selval = "--"
resultrow.append(selval)
#print('resultrow: ')
#print(resultrow)
resultrowstr = (",").join(resultrow)
resultstr = str(resultstr + resultrowstr + "\n")
resultlist.append(resultrow)
#print(header3)
#print(select)
# kludge to get desired category order in pivot table
#pdgmstr2 = pdgmstr.replace("Singular", " Singular")
#pdgmstr2 = pdgmstr2.replace("Masc", " Masc")
#print(select)
#formslist = []
lformslist.set(resultlist)
#print('result list: ')
#print(resultlist)
lforms.insert('end', '\n\n===============================\n\n')
def displayPdgms(*args):
pdgmids = pdgmmsg.get()
plabellist = pdgmids.split(',')
print('\nFor each of the paradigms:')
for i in plabellist:
#Presumption is that first item in each plabel is '[LANG]:'
print(i)
pname = (i).split('_')
lang = pname[0]
print(str('lang = ' + lang))
pdgmlist = []
pdgmstr = ""
sfile = str('pvlists/' + lang + '-labldb')
# get pvalue from pkey in (unshelved) pdgmdb
labldb = shelve.open(sfile) # open it
pvalue = labldb[i] # get the full prop-val string
labldb.close() # close it right away
if "%" in pvalue:
propsel = pvalue.split("%")
pvalue = propsel[0]
valstring = propsel[1]
valstring = valstring.replace("%","")
else:
valstring = "number,person,gender,token"
vallist = valstring.split(',') # = pandas row
vallist.remove('token') # = pandas value
# The following 6 lines are in order to get 'lang'
# There has to be a more direct way!
pvlist = pvalue.split(',')
pvdict = {}
for pv in pvlist:
pt = pv.split(':')
pvdict[pt[0]] = pt[1]
lang = pvdict['language']
#print(str('valstring: ' + valstring))
# pdgmDisp.query makes SPARQL query out of full prop-val
# pdgm specification in pval
res = query(pvalue,valstring,lang)
# print("\nThe SPARQL query from the prop-val list:\n")
# print(res)
#print('\n')
# pause = input("Press <return> to continue:")
sparql = SPARQLWrapper("http://localhost:3030/aama/query")
sparql.setQuery(res)
sparql.setReturnFormat(JSON)
results = sparql.query().convert()
results2 = sparql.query()
#print("results")
#print(results)
#print('results2')
#print(results2)
select = results["head"]["vars"]
select2 = []
for s in select:
select2.append(s.upper())
# print()
#header = (" ").join(select).upper()
header3 = (",").join(select)
for result in results["results"]["bindings"]:
#print(result)
pdgmrow = []
for sel in select:
#print(sel)
if sel in result:
#if result[sel]:
selval = result[sel]["value"]
else:
selval = "--"
pdgmrow.append(selval)
#print(pdgmrow)
pdgmrowstr = (",").join(pdgmrow)
pdgmstr = str(pdgmstr + pdgmrowstr + "\n")
pdgmlist.append(pdgmrow)
# Make pdgm label:
plabel = str("\nParadigm for " + i + ":\n" + pvalue + "\n")
# Make pdgm table:
pdgmtab = tabulate(pdgmlist, headers = select2)
print("Table:")
print(plabel)
print(pdgmtab)
# Write the pdgm(s) to the pdgms text widget
pdgms.insert('end', plabel)
pdgms.insert('end', pdgmtab)
pdgms.insert('end', "\n")
pdgms.insert('end', "\n")
#languagenames = ('beja-hud', 'afar', 'oromo', 'somali-standard')
languagenames = ['afar', 'alaaba', 'alagwa', 'akkadian-ob', 'arabic', 'arbore', 'awngi', 'bayso', 'beja-alm', 'beja-hud', 'beja-rei', 'beja-rop', 'beja-van', 'beja-wed', 'berber-ghadames', 'bilin', 'boni-jara', 'boni-kijee-bala', 'boni-kilii', 'burji', 'burunge', 'coptic-sahidic', 'dahalo', 'dhaasanac', 'dizi', 'egyptian-middle', 'elmolo', 'gawwada', 'gedeo', 'geez', 'hadiyya', 'hausa', 'hdi', 'hebrew', 'iraqw', 'kambaata', 'kemant', 'khamtanga', 'koorete', 'maale', 'mubi', 'oromo', 'rendille', 'saho', 'shinassha', 'sidaama', 'somali', 'syriac', 'tsamakko', 'wolaytta', 'yaaku', 'yemsa']
formslist = []
resultlist = []
#pcount = "1"
#print(str("pcount1 = " + pcount))
# Root and Frame
# NOTE ON WINDOW HEIGHT/WIDTH;
# Present root.geometry seems to be optimal, as far as it goes.
# Can increase pbox and decrease lquery (and vice-versa).
# Would addition of scrollbar to lquery or lpdgm give more optioms?
root = Tk()
root.geometry('1200x1200')
root.title('Form Search')
# Configure cols and rows
# from UIa
root.grid_columnconfigure(0, weight=1)
root.grid_rowconfigure(0,weight=1)
## Create and grid the outer content frame
cframe = ttk.Frame(root, padding=(10, 10, 22, 20))
cframe.grid(column=0, row=0, sticky=(N,W,E,S))
# from A
cframe.grid_columnconfigure(0, weight=1)
cframe.grid_rowconfigure(5, weight=1)
# State variables
lnames = StringVar(value=languagenames) # lbox1
lformslist = StringVar(value=formslist)
pvar = StringVar()
pmsg = StringVar()
#lmsg1 = StringVar()
llmsg = StringVar()
pdgmmsg = StringVar()
pcount = StringVar()
pdisp = StringVar()
qdisp = StringVar()
# Create widgets
llablgen = ttk.Label(cframe, text="Choose Languages:")
llablgen.grid(column=0, row=0, padx=10, pady=5)
lbox = Listbox(cframe, listvariable=lnames, selectmode='multiple', width=100, height=15)
lbox.grid(column=0, row=1, rowspan=20, sticky=(N,S,E,W), pady=5, padx=5)
#lcbutton = ttk.Button(cframe, text='Clear Languages', command=clearLangs, default='active')
#lcbutton.grid(column=0, row=22, sticky=W)
#pdbutton.grid(column=0, row=25, sticky=E)
ttk.Label(cframe, text="Enter List of prop=Value/prop=?value Queries").grid(column=0, row=22, sticky=W)
pvpairs = StringVar()
pvpairs_entry = ttk.Entry(cframe, width=35, textvariable=pvpairs)
pvpairs_entry.grid(column=0, row=23, sticky=W)
ttk.Button(cframe, text="Find Forms", command=pvpairsSearch).grid(column=0,row=24, sticky=W)
pcbutton = ttk.Button(cframe, text='Choose Paradigm', command=choosePdgms, default='active')
pcbutton.grid(column=0, row=25, sticky=W)
pdbutton = ttk.Button(cframe, text="Display Paradigms", command=displayPdgms)
pdbutton.grid(column=0, row=25, sticky=E)
#ttk.Label(cframe, text="Format: 'person=Person2,gender=Fem,pos=?pos,number=?number'").grid(column=0, row=25, sticky=W)
llabel1 = ttk.Label(cframe, text="Languages:", font=f)
llabel1.grid(column=1, row=0, sticky=(N,E))
llabel2 = ttk.Label(cframe, textvariable=llmsg, anchor=W)
llabel2.grid(column=2, row=0, sticky=W)
# pdgm content displayed here in Listbox widget
lforms = Listbox(cframe, listvariable=lformslist, selectmode='multiple', width=80, height=100)
lforms.grid(column=2, row=2, rowspan=20, sticky=(W, E))
pdgmslb1 = ttk.Label(cframe, text="Paradigms:", font=f)
pdgmslb1.grid(column=1, row=22, sticky=(N,E))
pdgmslb2 = ttk.Label(cframe, textvariable=pdgmmsg, anchor=W)
pdgmslb2.grid(column=2, row=22, sticky=W)
# query content displayed here in text widget
pdgms = Text(cframe, state='normal', width=80, height=15, wrap='none')
pdgms.grid(column=2, row=23, rowspan=3, sticky=(W, E))
#pdbutton = ttk.Button(cframe, text="Display Paradigm", command=guipdgm)
for child in cframe.winfo_children(): child.grid_configure(padx=5, pady=5)
# Set event bindings for when the selection in lbox1 changes,
# when the user double clicks the list, and when they hit the Return key
lbox.bind('<<ListboxSelect>>', showLangs)
lbox.bind('<Double-1>', showLangs)
root.bind('<Return>', showLangs)
#lforms.bind('<<ListboxSelect>>', showForms)
#lforms.bind('<Double-1>', showForms)
#root.bind('<Return>', showForms)
# Colorize alternating lines of the lbox1
for i in range(0,len(languagenames),2):
lbox.itemconfigure(i, background='#f0f0ff')
# Set the starting state of the interface
# including clearing the messages.
# Select the first language in the list; because the
# <<ListboxSelect> event is only
# fired when user makes a change, we explicitly call showLfile.
#pmsg.set('')
llmsg.set('')
pcount.set('0')
pdisp.set('paradigm ....')
#qdisp.set('query ....')
lbox.selection_set(0)
showLangs()
root.mainloop()
'''
person=Person2,gender=Fem,pos=?pos,number=?number
'''