Access model information from a controller with the help of Next.js and Sequelize

Question

Access model information from a controller with the help of Next.js and Sequelize

I'm currently working on a project involving Vue.js as my frontend and Next.js as my backend. While everything seems to be running smoothly, I am facing an issue with retrieving my model data back to my controller...

Additional details:

I have utilized Sequelize for creating my models, migrations, and seeders.
The database is PostgreSQL

Below is my controller (recetteController.js) where I invoke the findAllRecette() method :

// import { Recette } from '../../models/recette'; 
const { Recette } = require('../../models/recette'); 
// const Recette = require('../../models/recette');

console.log(Recette);

export default async function handler(req, res) {
    try {
        const recettes = await Recette.getAllRecette(); 
        res.status(200).json(recettes);
    } catch (error) {
        res.status(500).json({ error: 'An error occurred while fetching the recipes' });
    }
}

Here is my model (recette) where the getAllRecette() function is defined :

'use strict';
const { Model } = require('sequelize');

module.exports = (sequelize, DataTypes) => {
  class Recette extends Model {
    static associate(models) {
      Recette.belongsTo(models.Difficulte, { foreignKey: 'id_difficulte', as: 'difficulty' });
      Recette.belongsTo(models.Categorie, { foreignKey: 'id_categorie', as: 'category' });
    }
  
    // Fetch all recipes
    static async getAllRecette() {
      console.log("SUCCESS");
      const recettes = await this.findAll();
      return recettes;
    }
  }

  Recette.init({
    name: DataTypes.STRING,
    description: DataTypes.STRING,
    serving: DataTypes.INTEGER,
    time: DataTypes.INTEGER,
    id_difficulty: DataTypes.INTEGER,
    id_category: DataTypes.INTEGER,
    image: DataTypes.TEXT
  }, {
    sequelize,
    modelName: 'Recipe',
  });

  return Recipe;
};

I do not have prior experience in this setup apart from Laravel, so there might be mistakes in my approach...(MVC)

The issue arises when the console.log(Recette) output is either 'undefined' or '[Function (anonymous)]' depending on how I import the Recette object

I also attempted calling findAll() directly within my controller but it did not resolve the problem of the controller failing to locate my model.

Please, I have spent considerable time trying to resolve this! Thank you!

javascript next.js sequelize.js

Answer 1

Answer №1

If you want to establish a database connection in your Node.js application, consider using the import {} syntax instead of require() and create a separate JavaScript file for connecting to the database. Here's an example:

//database.js
import { Sequelize } from 'sequelize';

const sequelize = new Sequelize('db_name', 'user', 'password', {
  host: 'host_name',
  dialect: 'dialect', //e.g. postgres
  logging: console.log, 
});

(async () => {
  try {
    await sequelize.authenticate();
    console.log('Database connection successfully established.');
  } catch (error) {
    console.error('Error connecting to the database:', error);
  }
})();

export default sequelize;

You can then use this database connection file in your model files like this: import sequelize from 'database';

//model.js
import { DataTypes, Model } from 'sequelize';
import sequelize from 'database';

class MyClass extends Model {
  static associate(models) {
   
  }

}

export default (sequelize) => {
  Recette.init({
    name: DataTypes.STRING,
    description: DataTypes.STRING,
    //... 
  }, {
    sequelize,
    modelName: 'MyClass',
  });

  return MyClass;
};

export { MyClass };

Finally, for the controller part, you can structure it as follows:

import {MyClass} from '../models/myClass';

export default async function handler(req, res) {
  try {
    const datas = await MyClass.findAll(); 
    res.status(200).json(datas);
  } catch (error) {
    res.status(500).json({ error: 'Error while fetching datas' });
  }
};

Answer 2

If you want to establish a database connection in your Node.js application, consider using the import {} syntax instead of require() and create a separate JavaScript file for connecting to the database. Here's an example:

//database.js
import { Sequelize } from 'sequelize';

const sequelize = new Sequelize('db_name', 'user', 'password', {
  host: 'host_name',
  dialect: 'dialect', //e.g. postgres
  logging: console.log, 
});

(async () => {
  try {
    await sequelize.authenticate();
    console.log('Database connection successfully established.');
  } catch (error) {
    console.error('Error connecting to the database:', error);
  }
})();

export default sequelize;

You can then use this database connection file in your model files like this: import sequelize from 'database';

//model.js
import { DataTypes, Model } from 'sequelize';
import sequelize from 'database';

class MyClass extends Model {
  static associate(models) {
   
  }

}

export default (sequelize) => {
  Recette.init({
    name: DataTypes.STRING,
    description: DataTypes.STRING,
    //... 
  }, {
    sequelize,
    modelName: 'MyClass',
  });

  return MyClass;
};

export { MyClass };

Finally, for the controller part, you can structure it as follows:

import {MyClass} from '../models/myClass';

export default async function handler(req, res) {
  try {
    const datas = await MyClass.findAll(); 
    res.status(200).json(datas);
  } catch (error) {
    res.status(500).json({ error: 'Error while fetching datas' });
  }
};

Access model information from a controller with the help of Next.js and Sequelize

Answer №1

Similar questions

Challenges with the efficiency of the Material UI Datagrid

watchWebpack is compiling all the files

Design your own arrow Slideshow + Next.js + Sass styling

Trigger Object RuntimeError

Encountering the error "Cannot access property 'stroke' of undefined" when utilizing constructors in React and p5

Rotation snapping feature 'control.setRotationSnap' in TransformControls.js (Three.js) is not functioning properly

Issue with TypeORM Many-to-Many relation returning incorrect data when using the "where" clause

Using JavaScript with namespaces in C#

Is it possible to directly add a child in HTML from nodejs?

"Unlocking the Secrets of Extracting Data from Highlighted Cells in Excel with Node.js

I am sending an AJAX request to a remote server in order to retrieve access records

Developing a JavaScript library that utilizes flow type annotations and provides access to various data types

Distributing JWT to the recipient using Express

Tips for clearing all content within a React Material UI table

Reduce the file size of CSS and JS files for Magento

Display function not functioning properly following AJAX request

Sending numerous array values from datatables

file_put_contents - store user-defined variables

Combining intersecting sets within an array of sets

Automatically reduce the size of Java Script files and CSS files with compression