34: Data Access Patterns - Repositories

In this example, we already have a table that interacts with our table using the Repository Pattern in Nodejs.

The Repository Pattern

The repository pattern can be applied when running a query.

With the repository pattern, we can create an object that will interact with the database. As an example, here is an example of a User Repository for the users table.

Creating a Repository

In src/repos/user-repo.js:

const pool = require("../pool");

module.exports = {
  find() {
    // implementation details
  },
  findById() {
    // implementation details
  },
  // ... etc
};
copy

This could obviously also be a class or in JS-world just some exported functions.

The course used a class with static methods.