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