def test_csv_loader_can_load_a_csv_into_memory(create_test_file):
field_names = ['bullet_1', 'bullet_2']
actual_dict = {'bullet_1': 'hello', 'bullet_2': 'egd'}
file_path = create_test_file(field_names, [actual_dict])
mem = csv_loader(file_path)
assert list(actual_dict.values()) == list(mem[1].values())
def test_mem_table_can_store_new_record(create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'esdsgd'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
new_record = {'bullet_2': 'new_test'}
recipes = MemTable(memory)
recipes.store(new_record)
assert new_record in recipes.memory_list
def test_mem_table_can_retrieve_a_record_by_id(create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'esdsgd'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
recipes = MemTable(memory)
result = recipes.find(1)
assert list(record_1.values()) == list(result.values())
def test_mem_table_can_return_whole_memory_list_if_no_filters_applied(
create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'test_filtered'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
recipes = MemTable(memory)
mem = recipes.filter_by({})
assert mem is recipes
assert all(x in [record_1, record_2, record_3] for x in recipes.query)
def test_mem_table_can_filter_by_attributes_and_sets_it_to_the_query_global_variable(
create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'test_filtered'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
recipes = MemTable(memory)
mem = recipes.filter_by({'bullet_2': 'test_filtered'})
assert mem is recipes
assert record_2 in recipes.query
def test_mem_table_can_retrieve_an_indexed_list_of_records(create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'esdsgd'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
recipes = MemTable(memory)
result = recipes.list()
assert [record_1, record_2, record_3] == result
def test_mem_table_can_update_a_single_record(create_test_file):
field_names = ['id', 'bullet_2']
record_1 = {'id': 1, 'bullet_2': 'egd'}
record_2 = {'id': 2, 'bullet_2': 'test_filtered'}
record_3 = {'id': 3, 'bullet_2': 'versdfgv'}
file_path = create_test_file(field_names, [record_1, record_2, record_3])
memory = csv_loader(file_path)
recipes = MemTable(memory)
new_record = {'id': 2, 'bullet_2': 'new-bullet'}
recipes.update(1, new_record)
assert recipes.memory_list[1] == new_record
def create_app(test_config=None):
# create and configure the app
app = Flask(__name__)
if test_config is None:
# load the instance config, if it exists, when not testing
app.config.from_pyfile('config.py', silent=True)
else:
# load the test config if passed in
app.config.from_mapping(test_config)
file_path = app.config['RECIPE_DATA_FILE_PATH']
default_per_page = int(app.config['PAGINATION_LIMIT'])
allowed_recipe_filters = ['recipe_cuisine']
memory = csv_loader(file_path)
recipe_model = MemTable(memory)
@app.route('/recipes', defaults={'page': 1})
@app.route('/recipes/page/<int:page>')
def index(page):
per_page = request.args.get('per_page')
per_page = per_page if per_page is not None else default_per_page
filters = _recipe_filters(request.args)
filtered_recipes = recipe_model.filter_by(filters).paginate(page, per_page, 'recipes')
if not filtered_recipes and page != 1:
return '', 404
return json.dumps(filtered_recipes)
@app.route('/recipes/<int:id>', methods=['get'])
def show(id):
recipe = recipe_model.find(id)
if not recipe:
return '', 404
return json.dumps({'data': recipe})
@app.route('/recipes/<int:id>', methods=['patch'])
def update(id):
updated_recipe = recipe_model.update(id, request.get_json())
if not updated_recipe:
return '', 404
return json.dumps({'data': updated_recipe})
@app.route('/recipes', methods=['post'])
def create():
params = request.get_json()
return json.dumps({'data': recipe_model.store(params)}), 201
@app.route('/recipes/<int:id>/ratings', methods=['post'])
def update_rating(id):
existing_model = recipe_model.find(id)
try:
request.get_json()['rating']
except TypeError:
return '', 400
if request.get_json()['rating'] > 5 or request.get_json()['rating'] < 0:
return '', 403
rating_count = 0 if 'rating_count' not in existing_model else existing_model['rating_count']
current_avg_rating = 0 if 'average_rating' not in existing_model else existing_model['average_rating']
average_rating = _calculate_average_recipe_rating(current_avg_rating, rating_count,
request.get_json()['rating'])
new_params = {'average_rating': average_rating, 'rating_count': rating_count + 1}
updated_recipe = recipe_model.update(id, new_params)
return json.dumps({'data': updated_recipe})
def _calculate_average_recipe_rating(current_avg_rating, current_rating_count, new_rating):
rating_total = (current_avg_rating * current_rating_count) + new_rating
average_rating = rating_total / (current_rating_count + 1)
return average_rating
def _recipe_filters(queries):
filters = {}
for v in allowed_recipe_filters:
if v in queries:
filters[v] = request.args.get(v)
return filters
return app