Make a route to GET/FETCH a product BY NAME

[KhangMBui]

In the folder 'routes' of the backend directory (flask-server), implement a function that makes a route to get a product with a specific name.

Some documents to look for reference:

https://www.geeksforgeeks.org/flask-app-routing/ https://www.geeksforgeeks.org/flask-http-method/

Hints:

• The HTTP method of this route is 'GET'
• Name the route 'get_product'
• The function goes like this: @product_bp.route('/get_product/', methods = ['GET']): def get_products(): [Your code goes here.]

Step-by-step instructions in case you need it:

In the function:

Step 1: Define the Route (Already shown above)

• Use the @route decorator to define the URL path for the route.
• Use /get_products/ where is a placeholder for the product's name that will be passed through the URL.
• Set the route to accept GET requests since it will retrieve data from the server.

Step 2: Retrieve the Product from the Database

• Use Product.query.filter_by(name=name).first() to search the database for the first product that matches the given name.
• Store the result in a variable such as 'product'.
• This will return None if no product with the given name is found.

Step 3: Check if the Product Exists

• Use an if statement to check whether the product exists (i.e., not None).
• If the product exists, move to step 4. If not, move to step 5.

Step 4: Return the Product Data as JSON

• If the product is found, create a dictionary with its id, name, and expiration_date.
• Format the expiration_date using strftime('%Y-%m-%d') to ensure it is returned in a readable format.
• Use jsonify() to return the data as JSON. Include a 200 code for success.

Step 5: Handle the Case When the Product is Not Found

• If the product is None (i.e., not found), return a JSON response with a message indicating that the product was not found.
• Include a 404 Not Found status code to indicate the failure.

[mingo0805]

Hey, @mrthomaslibrary are you working on this task now?