def GetDataframe(self):
run_id = tableRuns.run_id
row_id = 1
rows = []
row = {}
row["id"] = row_id
row["name"] = "Run id:"+ str(run_id)
row["startlist"] = 0 #tableUsers.getCount()
row["dns"] = 0#tableUsers.getCount("dns")
row["finished"] = 0#tableUsers.getCount("finished")
row["dq"] = 0#tableUsers.getCount("dq")
row["dnf"] = 0#tableUsers.getCount("dnf")
row["race"] = 0#tableUsers.getCount("race")
if row["startlist"] == row["dns"] + row["finished"] + row["dq"] + row["dnf"] + row["race"]:
row["check"] = "ok"
else:
row["check"] = "ko"
rows.append(row)
row_id = row_id + 1
#categories
dbCategories = tableCategories.getDbRows()
for dbCategory in dbCategories:
#row = self.db2tableRow(row)
row = {}
row["id"] = row_id
row["name"] = dbCategory["name"]
row["startlist"] = 0# tableUsers.getCount(dbCategory = dbCategory)
row["dns"] = 0# tableUsers.getCount("dns", dbCategory)
row["finished"] = 0# tableUsers.getCount("finish", dbCategory)
row["dq"] = 0# tableUsers.getCount("dq", dbCategory)
row["dnf"] = 0# tableUsers.getCount("dnf", dbCategory)
row["race"] = 0# tableUsers.getCount("race", dbCategory)
if row["startlist"] == row["dns"] + row["finished"] + row["dq"] + row["dnf"] + row["race"]:
row["check"] = "ok"
else:
row["check"] = "ko"
rows.append(row)
row_id = row_id + 1
df = pd.DataFrame(rows)
return df
def Update(self, parameter=None, value=None):
"""
Update model z databaze
Update() => update cele tabulky
Update(parameter, value) => vsechny radky s parametrem = value
Update(conditions, operation) => condition[0][0]=condition[0][1] OPERATION condition[1][0]=condition[1][1]
"""
#disable user actions
dstore.Set("user_actions", dstore.Get("user_actions")+1)
#smazat vsechny radky
self.removeRows(0, self.rowCount())
row_id = 1
#row_table = self.db2tableRow(row)
row_table = {}
row_table["id"] = row_id
row_table["name"] = "Run id:"#+ str(run_id)
row_table["startlist"] = 0 #tableUsers.getCount()
row_table["dns"] = 0#tableUsers.getCount("dns")
row_table["finished"] = 0#tableUsers.getCount("finished")
row_table["dq"] = 0#tableUsers.getCount("dq")
row_table["dnf"] = 0#tableUsers.getCount("dnf")
row_table["race"] = 0#tableUsers.getCount("race")
if row_table["startlist"] == row_table["dns"] + row_table["finished"] + row_table["dq"] + row_table["dnf"] + row_table["race"]:
row_table["check"] = "ok"
else:
row_table["check"] = "ko"
self.addRow(row_table)
row_id = row_id + 1
#categories
dbCategories = tableCategories.getDbRows()
for dbCategory in dbCategories:
#row_table = self.db2tableRow(row)
row_table = {}
row_table["id"] = row_id
row_table["name"] = dbCategory["name"]
row_table["startlist"] = 0# tableUsers.getCount(dbCategory = dbCategory)
row_table["dns"] = 0# tableUsers.getCount("dns", dbCategory)
row_table["finished"] = 0# tableUsers.getCount("finish", dbCategory)
row_table["dq"] = 0# tableUsers.getCount("dq", dbCategory)
row_table["dnf"] = 0# tableUsers.getCount("dnf", dbCategory)
row_table["race"] = 0# tableUsers.getCount("race", dbCategory)
if row_table["startlist"] == row_table["dns"] + row_table["finished"] + row_table["dq"] + row_table["dnf"] + row_table["race"]:
row_table["check"] = "ok"
else:
row_table["check"] = "ko"
self.addRow(row_table)
row_id = row_id + 1
#enable user actions
dstore.Set("user_actions", dstore.Get("user_actions")-1)
