Enrise Tech - Your coding community 😉🚀Youtube Hono Series: Episode 4 Enhance the Tasks API with User Association

Title Image

Episode 4 - Enhancing Our Tasks API with User Association 🚀

In Episode 4 of our API series, we dive deeper into making our application smarter and more functional by associating tasks with users. This episode is perfect for anyone who wants to add relational functionality to their API while keeping it simple and efficient. Here’s the breakdown of what we covered:

Updating the Database Schema

We’ve upgraded our database schema to include a users table and established a foreign key relationship with the tasks table. Here's the updated schema:

typescriptCopy codeimport { sqliteTable, text, integer, foreignKey } from 'drizzle-orm/sqlite-core';

// Define the Users table
export const users = sqliteTable('users', {
id: integer('id').primaryKey({ autoIncrement: true }),
username: text('username').notNull(),
email: text('email').notNull().unique(),
password: text('password').notNull(),
});

// Define the Tasks table with a foreign key to Users
export const tasks = sqliteTable('tasks', {
id: integer('id').primaryKey({ autoIncrement: true }),
title: text('title').notNull(),
description: text('description'),
status: text('status').notNull().default('pending'),
userId: integer('user_id')
.references(() => users.id) // Foreign key references `users.id`
.notNull(),
});

We also enabled foreign key constraints in SQLite by adding:

typescriptCopy codesqlite.exec('PRAGMA foreign_keys = ON;'); // Enable foreign key constraints

Database Commands

After updating the schema, we ran the following commands to apply and interact with the database:

  1. Generate and Migrate Tables:

bashCopy codenpm run db:generate
npm run db:migrate

  1. Explore with Drizzle Studio:
    Launch the studio for direct interaction with your database:

bashCopy codenpm run studio

API Updates for CRUD Operations

To integrate the new users table into our API, we updated our endpoints for both tasks and users. Here’s a quick summary of the key features:

User Management Endpoints

  • Get All Users: /users
  • Get User by ID: /users/:id
  • Create User: /users
  • Update User: /users/:id
  • Delete User: /users/:id

Enhanced Tasks Endpoints

  • Get All Tasks (Optional User Filter): /tasks
  • Get Tasks by User ID: /tasks/:userId
  • Create Task for User: /tasks (Requires userId in query params)
  • Update and Delete Tasks: /tasks/:id

These additions ensure that every task is associated with a user, making the API scalable and ready for multi-user applications.

Watch the Tutorial

I’ve gone through everything in detail in the video, with a step-by-step explanation of the schema updates, database interactions, and API improvements. Watch it here:
👉 Episode 4: Enhance the Tasks API with User Association

Explore the Codebase

Want to get hands-on? Check out the full code on GitHub:
👉 GitHub Repo: Episode4-UserAssociationWithTasks

Join the Discussion

What challenges have you faced while adding user associations in your APIs? How do you structure your database for similar features? Let me know in the comments below or on Reddit. Let’s build and learn together!

🌟 Start Building Your Next App with Confidence! 🌟