def databaseCallMethode():
if (tableQuery == None):
return SpoolModel.select().order_by(SpoolModel.created.desc())
offset = int(tableQuery["from"])
limit = int(tableQuery["to"])
sortColumn = tableQuery["sortColumn"]
sortOrder = tableQuery["sortOrder"]
filterName = tableQuery["filterName"]
myQuery = SpoolModel.select().offset(offset).limit(limit)
if (filterName == "hideEmptySpools"):
myQuery = myQuery.where((SpoolModel.remainingWeight > 0)
| (SpoolModel.remainingWeight == None))
if (filterName == "hideInactiveSpools"):
myQuery = myQuery.where((SpoolModel.isActive == True))
if (filterName == "hideEmptySpools,hideInactiveSpools"):
myQuery = myQuery.where(((SpoolModel.remainingWeight > 0) |
(SpoolModel.remainingWeight == None))
& (SpoolModel.isActive == True))
if ("displayName" == sortColumn):
if ("desc" == sortOrder):
myQuery = myQuery.order_by(SpoolModel.displayName.desc())
else:
myQuery = myQuery.order_by(SpoolModel.displayName.asc())
if ("lastUse" == sortColumn):
if ("desc" == sortOrder):
myQuery = myQuery.order_by(SpoolModel.lastUse.desc())
else:
myQuery = myQuery.order_by(SpoolModel.lastUse.asc())
if ("firstUse" == sortColumn):
if ("desc" == sortOrder):
myQuery = myQuery.order_by(SpoolModel.firstUse.desc())
else:
myQuery = myQuery.order_by(SpoolModel.firstUse.asc())
if ("remaining" == sortColumn):
if ("desc" == sortOrder):
myQuery = myQuery.order_by(
SpoolModel.remainingWeight.desc())
else:
myQuery = myQuery.order_by(
SpoolModel.remainingWeight.asc())
if ("material" == sortColumn):
if ("desc" == sortOrder):
myQuery = myQuery.order_by(SpoolModel.material.desc())
else:
myQuery = myQuery.order_by(SpoolModel.material.asc())
return myQuery
def databaseCallMethode():
result = set()
result.add("")
myQuery = SpoolModel.select(SpoolModel.material).distinct()
for spool in myQuery:
value = spool.material
if (value != None):
result.add(value)
return result;
def databaseCallMethode():
result = set()
result.add("")
myQuery = SpoolModel.select(SpoolModel.labels).distinct()
for spool in myQuery:
value = spool.labels
if (value != None):
spoolLabels = json.loads(value)
for singleLabel in spoolLabels:
result.add(singleLabel)
return result
def databaseCallMethode(): myQuery = SpoolModel.select() return myQuery.count()
def databaseCallMethode(): return SpoolModel.select().where(SpoolModel.isTemplate == True)
