def ProcessExcel(filename): g = FoodGroup(name='Fruits') g.save() book = open_workbook(filename) sheet = book.sheet_by_index(0) cur_group = '' in_group = False total_sum = 0 for row_index in range(sheet.nrows): if (sheet.cell(row_index, 0).value == ''): in_group = False cur_group = '' total_sum = 0 g = '' elif in_group == False: cur_group = sheet.cell(row_index, 0).value opt_value_group = int(sheet.cell(row_index,1).value) in_group = True g = FoodGroup(name=cur_group, optimal_number = opt_value_group, current_number = 0) g.save() else: name = sheet.cell(row_index, 0).value current_value = int(sheet.cell(row_index, 1).value) opt_value = int(sheet.cell(row_index, 2).value) total_sum += current_value i = FoodItem(name=name, foodgroup = g, optimal_number=opt_value, current_number= current_value) i.save() return 'done'
def update_Item(name, food_group, optimal_number, current_number, priority, date): deficit = optimal_number - current_number try: date2 = DateUploaded.objects.all()[DateUploaded.objects.count()-2] recentfood = date2.fooditem_set.all() item = recentfood.get(name=name) change = current_number - item.current_number last_tweet = item.last_tweeted except: change = 0 last_tweet = timezone.now().replace(year=1900) item = FoodItem(name=name, deficit = deficit, food_group = food_group, change = change, optimal_number=optimal_number, current_number= current_number, priority=priority, upload_date=date, last_tweeted=last_tweet) item.save()