def populate_items_sets(list_of_ids): db = model.connect_db() for item_id in list_of_ids: model.enter_new_items_sets(db, item_id) db.close()
def populate_database_item_set_level3(): success_count = 0 error_count = 0 for item_id in list_items_level3: try: model.enter_new_items_sets(db, item_id, 3) print item_id success_count += 1 except KeyError: print "+++++++++++++++++++" print "This item was not included in any sets. Don't enter into database." print item_id print "++++++++++++++++++++" error_count += 1 print "Successfully entered: " + str(success_count) print "Errors: " + str(error_count) print "Error rate: " + str(round(error_count / success_count * 100, 2)) + "%"