def chooseBranch(ordr):
largest = None
b1 = sqlController.databaseGenerator("Branch1", sqlController.columns)
b2 = sqlController.databaseGenerator("Branch2", sqlController.columns)
b3 = sqlController.databaseGenerator("Branch3", sqlController.columns)
a = (b1.getBranchCount("ModelStockInfo", "amt_in_stock", ordr), b1.dbname)
b = (b2.getBranchCount("ModelStockInfo", "amt_in_stock", ordr), b2.dbname)
c = (b3.getBranchCount("ModelStockInfo", "amt_in_stock", ordr), b3.dbname)
if (a[0][0][0] > b[0][0][0]) and (a[0][0][0] > c[0][0][0]):
largest = a
elif (b[0][0][0] > a[0][0][0]) and (b[0][0][0] > c[0][0][0]):
largest = b
else:
largest = c
return (largest[0][0], largest[1])
def insertBranch():
for i in range(3):
now = datetime.datetime.now()
brid = "'{}'".format(str(i) + str(int(now.microsecond)))
p = random.choice(parish)
name = "\"{}Branch\"".format(p)
fake = fake.address()
street = fake.split(',')[0]
phone = "'{}'".format(phoneNumber())
city = "'{}'".format(fake.city())
conn = sqlController.databaseGenerator("CompuStore", sqlController.columns)
conn.addRecord([brid, name, street, city, p, phone], "Branch")
def addPurchasedItem(arg1, arg2, arg3, arg4):
conn = sqlController.databaseGenerator("CompuStore", sqlController.columns)
conn.addPurchasedItem(arg1, arg2, arg3, arg4)
def getByBrand(brand):
conn = sqlController.databaseGenerator("CompuStore", sqlController.columns)
records = conn.getByBrand(brand)
return records
def getByModel(model):
conn = sqlController.databaseGenerator("CompuStore", sqlController.columns)
records = conn.getByModel(model)
return records
def orderByPrice(ordr):
conn = sqlController.databaseGenerator("CompuStore", sqlController.columns)
records = conn.orderByPrice(ordr)
return records