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

Tips for ensuring a consistent highlight for an active link in Bootstrap

Despite having unique ids, two file input forms are displayed in the same div in the image preview

Utilizing Ajax looping to generate dynamic HTML content with Bootstrap tabs

Guide on redirecting a Next.js app to HTTPS using cPanel

Meteor, enhanced with the dynamic Iron Router module and integrated

Designing access to data in JavaScript

Navigating with Vue Router in a Nuxt JS vuex Store

Dealing with HTML and Escaping Challenges in jQuery Functions

ReactJS: A single digit input may result in the display of numerous '0's

Tips for sorting server components using a URL search parameter [Next.js, Prisma]

It is important to ensure that the user returned by the onAuthStateChanged function in

An unspecified number of Ajax requests being made within a loop

Troubleshooting deployment issues with aws-amplify and Next.js due to conflicts in aws-exports.js

Is the accuracy of the in-situ convolution filter guaranteed?

What is the default method for automatically disabling drop down fields?

Enhancing the Calculator Functionality in a React Program

After my jQuery functions are executed, my CSS rules are loaded

Error encountered with select2 when using a remote JSONP dataset

Preventing clicks within an iframe

What is the best way to obtain a reference to the parent form element within an AngularJS directive?