'TypeError: models.leaves.getAllEmpoyees is not a function

I am writing a function in Schema Model for getting Data with a query. The query is working fine, but unfortunately i am getting an error regarding Function - getAllEmpoyees() not found. For Reference - my sequelize version is - 6.15.0 . I am new to Node.js. Can anyone help me out yrr, Thanks in Advance!


    const Sequelize = require('sequelize');
    module.exports = function(sequelize, DataTypes) {
      
      return sequelize.define('leaves', {
        id: {
          autoIncrement: true,
          type: DataTypes.BIGINT.UNSIGNED,
          allowNull: false,
          primaryKey: true
        },
        employee_id: {
          type: DataTypes.INTEGER,
          allowNull: false
        },
        leave_type_id: {
          type: DataTypes.INTEGER,
          allowNull: false
        },
        leave_reason: {
          type: DataTypes.STRING(255),
          allowNull: false
        },
        remark: {
          type: DataTypes.STRING(255),
        },
        status: {
          type: DataTypes.STRING(255),
          allowNull: false
        },
        created_by: {
          type: DataTypes.INTEGER
        }
      },
      {
        sequelize,
        tableName: 'leaves',
        timestamps: true,
        indexes: [
          {
            name: "PRIMARY",
            unique: true,
            using: "BTREE",
            fields: [
              { name: "id" },
            ]
          },
        ]
      },
      getAllEmpoyees = function() {
        var query = "select * from leaves as l join leave_types as lt on l.leave_type_id=lt.id";
        return sequelize.query(query, { type: sequelize.QueryTypes.SELECT});
      },
      );
    };

    
    const express = require('express');
    const router = express.Router();
    var path = require('path');
    var root_path = path.dirname(require.main.filename);
    var models = require(root_path + '/models');
    var moment = require("moment");
    
    router.get('/getallemployeeLeaves', (req, res) => {
        console.log("All Fetched");
        models.leaves.getAllEmpoyees().then(function (data) {
            console.log("");
            if (data.length > 0) {
                res.json({
                    status: 200,
                    data: data
                })
            } else {
                res.json({
                    status: 400,
                })
            }
        })
    
    })
    
    


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source