def populateFootwearSelectionDetails():
print(sys._getframe().f_code.co_name + ": ")
dao = FootwearSelectionDAO(gc_connector)
selection = "Selection"
for i in range(1, 12+1):
entry = (i,
selection+str(i),
None)
dao.createAnEntry(entry)
print(dao.selectAllEntries())
print("===================================================")
print("Testing populateFootwearSelectionDetails-------------------complete\n\n\n")
def getSecondPageInfo(self, selection):
dbConnect = DbConnect(FootwearSelectionDAO.getDbDir())
connector = dbConnect.getConnection()
footwearSelectionDAO = FootwearSelectionDAO(connector)
footwearSelectionPriKeys = footwearSelectionDAO.getPriKeys("Selection", selection)
retVal = list()
barcodeDAO = BarcodeDAO(connector)
for footwearSelectionPriKey in footwearSelectionPriKeys:
entries = barcodeDAO.selectEntries("FootwearSelectionDetailsFk", footwearSelectionPriKey)
barcodePriKey = entries[0]
inventoryDAO = InventoryDAO(connector)
inventories = inventoryDAO.getPriKeys("BarcodeDetailsFk", barcodePriKey)
for entry in entries:
retVal.append((entry[1], entry[3], entry[4], entry[5], entry[6], len(inventories) ) )
return retVal
def getFirstPageInfo(self):
dbConnect = DbConnect(FootwearSelectionDAO.getDbDir())
connector = dbConnect.getConnection()
footwearSelectionDAO = FootwearSelectionDAO(connector)
selections = footwearSelectionDAO.selectDistinct("Selection")
queryResult = list()
for selection in selections:
footwearDesigns = list()
for entry in footwearSelectionDAO.selectEntries("Selection", selection):
footwearDesigns.append(entry[1])
for footwearDesign in footwearDesigns:
footwearDesignDAO = FootwearDesignDAO(connector)
entry = footwearDesignDAO.selectAnEntry(footwearDesign)
queryResult.append((selection, entry[1], entry[2], entry[3], entry[4]))
return queryResult
def numItemsAvailable(self, barcode): dbConnect = DbConnect(FootwearSelectionDAO.getDbDir()) connector = dbConnect.getConnection() return self.__numItemsAvailable(connector, barcode)
