This lesson's interactive features are locked, please to keep using them

Follow

Feeds currently have a creator (the user_id on the feed record) but there's no way for other users to follow feeds created by other users. And because we're making feeds unique by URL, they can't even add a feed that another user has already added.

We need to introduce a many-to-many relationship between users and feeds. Many users can follow the same feed, and a user can follow many feeds.

We'll use a joining table called feed_follows to accomplish this. Creating a feed_follow record indicates that a user is now following a feed. Deleting it is the same as "unfollowing" a feed.

Assignment

Create a feed_follows table with a new migration. It should:
- Have an id column that is a primary key.
- Have created_at and updated_at columns.
- Have user_id and feed_id foreign key columns. Feed follows should auto delete when a user or feed is deleted.
- Add a unique constraint on user/feed pairs - we don't want duplicate follow records.
Add a createFeedFollow function. It should insert a feed follow record, but then return all the fields from the feed follow as well as the names of the linked user and feed. I'll add a tip at the bottom of this lesson if you need it.
Add a follow command. It takes a single url argument and creates a new feed follow record for the current user. It should print the name of the feed and the current user once the record is created (which the query we just made should support). You'll need a query to look up feeds by URL.
Add a getFeedFollowsForUser function. It should return all the feed follows for a given user, and include the names of the feeds and user in the result.
Add a following command. It should print all the names of the feeds the current user is following.
Enhance the addfeed command. It should now automatically create a feed follow record for the current user when they add a feed. This should also print the name of the feed and the current user.

Run and submit the CLI tests.

Tips

My createFeedFollow function started with inserting the new record:

const [newFeedFollow] = await db.insert(feedFollows)...

Now that I have the record in newFeedFollow I can write a SELECT query to INNER JOIN it to the additional info I want.

Select fields from:
- feedFollows: Include metadata like id, createdAt, and updatedAt.
- feeds: Add related fields such as the feed name.
- users: Add related fields such as the user name.
Join the tables:
- Use .innerJoin() to connect the feedFollows table to feeds and users:
- Join feeds where feedFollows.feedId = feeds.id.
- Join users where feedFollows.userId = users.id.