Association with alias \"reservations\" does not exist on reservations"

Viewed 337

I'm trying to associate my reservation table to my schedule table but I'm not sure what this error means Association with alias "reservations" does not exist on reservations" Thank you very much

Associations

// USER AND ERRANDS Associations
db.schedule.hasMany(db.reservations, { as: "reservations" });
db.reservations.belongsTo(db.schedule, {
 foreignKey: "scheduleID",
 as: "schedule"
});

Reservation Model

module.exports = (sequelize, DataTypes) => {
const Reservation = sequelize.define('reservations', {
    id: {
        type: DataTypes.INTEGER,
        autoIncrement: true,
        primaryKey: true
    },
    userID: {
        type: DataTypes.INTEGER,
        allowNull: false
    },
    scheduleID: {
        type: DataTypes.INTEGER,
        allowNull: false
    },
    date: {
        type: DataTypes.STRING,
        allowNull: false
    }
});

return Reservation;

};

Schedule Model

module.exports = (sequelize, DataTypes) => {
const Schedule = sequelize.define('schedules', {
    id: {
        type: DataTypes.INTEGER,
        autoIncrement: true,
        primaryKey: true
    },
    timein: {
        type: DataTypes.STRING,
        allowNull: false
    },
    timeout: {
        type: DataTypes.STRING,
        allowNull: false
    },
    slot: {
        type: DataTypes.STRING,
        allowNull: false
    },
    statuss: {
        type: DataTypes.STRING,
        allowNull: false
    }
});

return Schedule;

};

My Controller

exports.ScheduleReservation = async function (req, res, next) {

try {
    var reservation = await ReservationService.ScheduleReservation({include: ["reservations"]})
    return res.status(200).json({ status: 200, data: reservation, message: "Succesfully Users Retrieved" });
} catch (e) {
    return res.status(400).json({ status: 400, message: e.message });
}

}

0 Answers
Related