def writeTypesToDatabase(dir):
items = xmlParser.parseFromFile(dir)
params = xmlParser.createStringFromKeys(items[0])
itemVal = xmlParser.createValues(items)
sleep(1)
dao.insertItems(params, itemVal)
sleep(1)
matches = xmlParser.gunsAndMatchingItem(items)
dao.createCombos(matches)
"""
def writeTypesToDatabase(dir):
items = xmlParser.parseFromFile(dir)
params = xmlParser.createStringFromKeys(items[0])
itemVal = xmlParser.createValues(items)
sleep(1)
dao.insertItems(params, itemVal)
sleep(1)
matches = xmlParser.gunsAndMatchingItem(items)
try:
dao.createCombos(matches)
except Exception:
print("An exception occured when trying to create item Links")
def appendTypesToDatabase(xml, root, mod, useNew):
count = 0
successes = []
message = " Items where added to database, duplicate items where not added:\n"
items = xmlParser.parseFromString(xml, mod)
params = xmlParser.createStringFromKeys(items[0])
itemVal = xmlParser.createValues(items)
matches = xmlParser.gunsAndMatchingItem(items)
if len(itemVal) > 100:
sleep(1)
i = 0
for item in items:
item = item.parameters
name = item["name"]
err = dao.insertItem(params, list(item.values()))
if err == 1:
message += name + "\n"
if useNew:
item["rarity"] = dao.getRarity(name)
item["mod"] = mod
item["usage"] = itemVal[i][15:28]
item["tier"] = itemVal[i][28:32]
item["subtype"] = dao.getSubtype(name)
dao.update(item)
else:
count += 1
successes.append(item["name"])
i += 1
if len(itemVal) > 100:
sleep(1)
if len(matches) != 0:
dao.createCombos(matches)
showError(root, "Success", str(count) + message)
return successes