def testOneCategory(self): cats = db_access.get_categories_for_area(3) print(cats) m = filter_first(cats, lambda r: r[0] == 32) print(m) self.assertEqual('East', m[1])
def testOneCategory(self): cats = db_access.get_categories_for_area(3) m = filter_first(cats, lambda r: r["category_id"] == 32) self.assertEqual("East", m["name"])
def testNumberOfCategories(self): cats = db_access.get_categories_for_area(3) self.assertEqual(1, len(cats))
def categories_in_area(area_id): response.content_type = "application/json" data = get_categories_for_area(area_id) return dumps(data)
# Chart formatting space = 18 line_format = ' {:>4} {:<25} {:<10} {:^12} {:' + str(space + 1) + '} ' divider_line1 = '-' * (84) divider_line3 = '-' * 82 line_format2 = ' {:^' + str(60 + space) + '} ' # Print Chart # Print header print("\n" + divider_line1) print(divider_line1) print(line_format.format("ID", "Name", "Num Loc", "Avg Value", "Categories")) print(divider_line3) # Print information for i in db_access.get_all_areas(): avg = db_utility.get_average_measurements_for_area( i[0]) # Calculate average print( line_format.format( str(i[0]), i[1], str(db_utility.number_of_locations_by_area( i[0])), # areaId, name, num of locations "-----" if avg is None else str(round( avg, 2)), # avg measurement, round 2 decimals str(", ".join( str(j[1]) for j in db_access.get_categories_for_area( i[0]))))) # categories
def categories_for_area(area_id): categories_area = get_categories_for_area(area_id) response.content_type = "application/json" return dumps(categories_area)
import db_access import db_utility categories = '' my_tuple_report = [] my_tuple = db_access.get_all_areas() template = "{:>3} {:<25} {:>10} {:>25} {:<30}" line = template.format('ID', 'Name', "Num Loc", "Avg Value", 'Categories') print(line) for area_row in my_tuple: #print(area_row) categories = '' area_id = area_row[0] area_name = area_row[1] loc_num = db_utility.number_of_locations_by_area(area_id) avg_value = db_utility.get_average_measurements_for_area(area_id) if avg_value is None: avg_value = " _________________" my_categories = db_access.get_categories_for_area(area_id) #print(my_categories) for category_row in my_categories: categories = categories + category_row + ', ' if categories is None: pass else: categories = categories.rstrip(', ') template = "{:3} {:25} {:10} {:25.4} {:30}" line2 = template.format(area_id, area_name, loc_num, avg_value, categories) print(line2)
categoryString = '' theCategory = [] try: for i in aList: theCategory.append(i['name']) countString = len(area_category) for i in theCategory: categoryString += i if countString > 1: categoryString += ', ' countString += -1 except TypeError: categoryString = '' return categoryString # ------------------------------------| Pretty Print |---------------------------------------------- for area in areas: area_id = area['area_id'] area_location = db_access.get_locations_for_area(area_id) area_category = db_access.get_categories_for_area(area_id) avgMeasurementString = str( db_utility.get_average_measurements_for_area(area_id)) if not db_utility.get_average_measurements_for_area(area_id): avgMeasurementString = '--------' # Final output row = template.format(area_id, area['name'], len(area_location), avgMeasurementString,getCategoryString(area_category)) print(row)
</div>""") a = get_all_areas() category = "" num = 1 #table space for database entries: print("""<div id="page_body2">Table of Areas</br><table class=\"grid\"><th class=\"grid\">ID</th><th class=\"grid\">Name</th> <th class=\"grid\">Number of Locations</th><th class=\"grid\">Average Value</th> <th class=\"grid\">Categories</th>""") for x in a: b = number_of_locations_by_area(num) c = get_average_measurements_for_area(num) d = get_categories_for_area(num) spec1 = (27-(len(x['name'])+2)) if not d: #if categories returns none category = "" else: #if categories returns a list for C in d: category += C['name']+" " if not c: total = "{0:} {1:} {2:>"+str(spec1)+"} {3:>19} {4:>7}" cc = "----------" # print(total.format(num, x['name'], b, cc, category))r print("<tr><td>" + str(num) + "</td><td>" + x['name'] + "</td><td>" + str(b) + "</td><td>" + str(cc) + "</td><td>" + category + "</td></tr>") else: # nString = str(num) ave_val = str(c)