This video is available to students only

Public Lunch Week Page

Adding a Public Lunch Week Page

Public Lunch Week Page#

The purpose of our application is to publish a weekly lunch menu for the public to access. To that end, we are going to use what we've learned so far and build a Lunch Menu View page with a public Express endpoint for the data. Here's what the page will look like:


Our front-end route will use the convention /lunch-menu/<school-name>/<yyyy-MM-dd>, e.g., /lunch-menu/pinewood-elementary/2020-11-16 so we can pull the school database name and week of from the front-end route and send it as a GET to the backend API.

Let's get start with the backend API endpoint. Create a new file in the /routes directory called lunch-week-public.js with a simple version of the endpoint:

Then import the route file into app.js and register it with the router. In this case we want the endpoint to be public, so we won't use the JWT or Knex middleware:

Test this in Postman and make sure the endpoint is working. Here is an example API route: localhost:3000/api/lunch-week-public/pinewood-elementary/2020-11-16. You should see a response that looks like this:


Passing Knex to the Public Route#

Now that we have the basic endpoint working, let's actually wire it up to the database. Earlier, we used a dynamic-knex module to cache and return Knex instances based on JWTs for our secured routes. In this case, we have a public route without a JWT and we have the database name as part of the route's URL convention.

Working again with the dynamic-knex module, add a new middleware function called passKnexPublic:

At the same time, change the name of the original passKnex function to passKnexSecured to make it more obvious that one is a unsecured way of passing Knex and the other one is a secured way:

Last, change the module.exports to export both middleware functions:

Since we changed the name of passKnex and the export style, we need to update app.js:

Next, we need to apply the new passKnexPublic middleware. For consistency, it would be nice if we could use it in app.js, but unfortunately since it depends on req.params.schoolName, we cannot - req.params are not parsed by Express until after the router.use calls.

Therefore, in this case we need to use the new middleware in lunch-week-public. Import it and add it to the GET /lunch-week-public endpoint like this. Uncomment the tenantKnex variable and assign it in the route:

Returning the Lunch Week Data#

We have Knex squared away, so in lunch-week-public.js create a helper function to return the data were looking for:


This page is a preview of Fullstack Svelte

Please select a discussion on the left.