def get_versions(data_type, module=None):
"""Get a list of all versions available.
Specify a module to see versions associated with that module.
"""
versions = set()
if module is None:
# List all RAT versions
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
reduce=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
versions.add(row["key"][2])
elif type(module) == list and len(module) == 1:
# List only versions for a given module
rows = database.view("_design/proddata/_view/%s_by_mod_pass_sr",
reduce=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
if str(row["key"][1]) == module[0]:
versions.add(row["key"][2])
else:
raise Exception("Must only provide one module name.")
return versions
def get_labels(data_type, module=None):
"""Get a list of all labels available
Specify a module to see versions associated with that module.
"""
labels = set()
if module is None:
# List any labels
rows = database.view("_design/proddata/_view/data_by_label",
reduce=True,
group_level=2,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
lb = row["key"][1]
if type(lb) == list:
lb = lb[0]
labels.add(lb)
elif type(module) == list and len(module) == 1:
# List labels only for a given module
rows = database.view("_design/proddata/_view/data_by_label",
reduce=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
if str(row["key"][2]) == module[0]:
lb = row["key"][1]
if type(lb) == list:
lb = lb[0]
labels.add(lb)
else:
raise Exception("Must only provide one module name.")
return labels
def generate_info_by_version(version, data_type, modules, run_range, fields):
'''Generates file information by production labels
'''
names = []
info = [[] for f in fields]
output_list = []
for i, module in enumerate(modules):
print "Generating lists, %d of %d" % (i, len(modules))
startkey = [data_type, module, version]
endkey = [data_type, module, version]
if run_range:
startkey.append(run_range[0])
endkey.append(run_range[1] + 1)
else:
# No need to change the startkey
endkey.append({})
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
reduce=False,
include_docs=True,
startkey=startkey,
endkey=endkey)
for row in rows:
# We only want the sub run from the key...
sub_run = row['key'][-1]
name = row['value'][0]
values = get_fields_from_doc(row['doc'], sub_run, fields)
output_list.append([name] + values)
return output_list
def get_list_by_module_version(data_type, module, rat_version, run_range):
"""Get a list of files for the settings given.
"""
names = []
sizes = []
guids = []
adlers = []
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
startkey=[data_type, module, rat_version],
endkey=[data_type, module, rat_version, {}],
reduce=False)
for row in rows:
if copy_type == "GUID":
if not row["value"][2] or row["value"][2] == "":
print "Cannot get file %s, no GUID" % (row["value"][0])
continue
else:
if len(row["value"][4]) == 0 or row["value"][4] == "":
print "Cannot get file %s, no SURL" % row["value"][0]
continue
# Run range is after pass in the key, have to filter here rather than on server
if run_range:
if row["key"][4] < run_range[0] or row["key"][4] > run_range[1]:
continue
names.append(row["value"][0])
sizes.append(row["value"][1])
if copy_type == "GUID":
guids.append(row["value"][2])
else:
guids.append(grid.get_closest_copy(server_list, row["value"][4]))
adlers.append(row["value"][5])
return names, sizes, guids, adlers
def getTable(self, textbox):
global table
table = textbox.get('1.0', 'end-1c')
output = postgres.view(table)
self.console.set(output)
def get_modules(data_type, label=None, version=None):
"""Get a list of all modules available
Only one of label or version can be specified (or neither).
"""
if label is not None and version is not None:
raise Exception("May only specify label OR version")
modules = set()
if label is not None:
# Only modules for a given label
rows = database.view("_design/proddata/_view/data_by_label" %
(data_type),
reduce=True,
group_level=3,
startkey=[data_type, label],
endkey=[data_type, label, {}])
for row in rows:
modules.add(row["key"][2])
elif version is not None:
# Only modules for a given RAT version
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
reduce=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
if str(row["key"][2]) == version:
modules.add(row["key"][1])
else:
# Any and all modules
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
reduce=True,
group_level=2,
startkey=[data_type],
endkey=[data_type, {}])
for row in rows:
modules.add(row["key"][1])
return modules
def suggests():
for res in list(database.view()):
word_row = str(res)
new = ""
word_row_indexed = word_row.rindex('\'', 1)
words_list.append(word_row[2:word_row_indexed])
sug = get_close_matches(word.get(), words_list, n=1)
entry2.delete(0, END)
entry2.insert(END, sug)
list1.delete(0, END)
for x in sug:
new += x
for res in database.search(new):
list1.insert(END, res)
def get_module_list_version(data_type, rat_version=None):
"""Get a list of available modules.
"""
rows = database.view("_design/proddata/_view/data_by_mod_pass_sr",
reduce=True,
group=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
module_list = []
for row in rows:
if rat_version and row["key"][2] != unicode(rat_version):
continue
module_list.append(row["key"][1])
return module_list
def get_module_list_label(data_type, label=None):
"""Get a list of available modules.
"""
rows = database.view("_design/proddata/_view/data_by_label",
reduce=True,
group=True,
group_level=3,
startkey=[data_type],
endkey=[data_type, {}])
module_list = []
for row in rows:
if label and row["key"][0] != unicode(label):
continue
module_list.append(row["key"][1])
return module_list
def generate_list_from_exactly(data_type, exactly):
'''Gets a list of data from a list of module,run,pass (exactly).'''
names = []
sizes = []
guids = []
adlers = []
for module, run, passno in exactly:
startkey = [data_type, module, run]
endkey = [data_type, module, run, {}]
rows = database.view("_design/proddata/_view/data_by_mod_run",
startkey=startkey,
endkey=endkey,
reduce=False)
n, s, g, a = rows_to_list(rows, None, passno, None)
names += n
sizes += s
guids += g
adlers += a
return names, sizes, guids, adlers
def get_list_by_module(data_type,
module,
run_range,
run_list=None,
all_passes=True,
ratdb_tag=None):
"""Get a list of files for the settings given.
"""
if run_range:
startkey = [data_type, module, run_range[0]]
endkey = [data_type, module, run_range[1]]
else:
startkey = [data_type, module]
endkey = [data_type, module, {}]
rows = database.view("_design/proddata/_view/data_by_mod_run",
startkey=startkey,
endkey=endkey,
reduce=False)
return rows_to_list(rows, run_list, all_passes, ratdb_tag)
def get_list_by_label_module(data_type, label, module, run_range):
"""Get a list of files for the settings given
If no module give, return all modules.
"""
names = []
sizes = []
guids = []
adlers = []
startkey = [data_type, label, module]
endkey = [data_type, label, module, {}]
if run_range:
startkey = [data_type, label, module, run_range[0]]
endkey = [data_type, label, module,
run_range[1] + 1] # range inclusive
rows = database.view("_design/proddata/_view/data_by_label",
startkey=startkey,
endkey=endkey,
reduce=False)
for row in rows:
if copy_type == "GUID":
if not row["value"][1] or row["value"][1] == "":
print "Cannot get file %s, no GUID" % (row["value"][0])
continue
else:
if len(row["value"][4]) == 0 or row["value"][4] == "":
print "Cannot get file %s, no SURL" % row["value"][0]
continue
names.append(row["value"][0])
if copy_type == "GUID":
guids.append(row["value"][1])
else:
guids.append(grid.get_closest_copy(server_list, row["value"][4]))
adlers.append(row["value"][2])
sizes.append(row["value"][3])
return names, sizes, guids, adlers
def show():
list1.delete(0, END)
for i in database.view():
list1.insert(END, i)
def ViewList():
rowid = 0
tree.delete(*tree.get_children())
for row in database.view():
tree.insert("", rowid, text='', values=row)
rowid += 1
def getTaskList(self):
self.clearTableList()
for row in database.view():
self.addRow(list(map(str, row)))
def view_command():
games_list.delete(0, END)
for row in database.view('games'):
display_info = (row[0], row[1])
games_list.insert(END, display_info)
def vstore_prompt() -> int:
return prompt(vstore_prompt, view("store"))
def view_command():
list_.delete(0, tk.END)
for row in database.view():
list_.insert(tk.END, row)
def view_command():
list.delete(0,END)
for row in database.view():
list.insert(END,row)
def view_history():
list1.delete(0, END)
for row in database.view():
list1.insert(END, row)
import database a = database.view() print(a) #database.delete()
def vpharm_prompt() -> int:
return prompt(vpharm_prompt, view("pharma"))
def view_funct():
self.Scrolledlistbox1.delete(0, END)
for line in database.view():
self.Scrolledlistbox1.insert(END, line)
