2023-03-12 20:51:45 +01:00
|
|
|
const { DataTypes, Model } = require('sequelize')
|
|
|
|
|
|
|
|
module.exports = (sequelize) => {
|
|
|
|
class BookNarrator extends Model { }
|
|
|
|
|
|
|
|
BookNarrator.init({
|
|
|
|
id: {
|
|
|
|
type: DataTypes.UUID,
|
|
|
|
defaultValue: DataTypes.UUIDV4,
|
|
|
|
primaryKey: true
|
|
|
|
}
|
|
|
|
}, {
|
|
|
|
sequelize,
|
2023-03-19 21:19:22 +01:00
|
|
|
modelName: 'bookNarrator',
|
2023-03-12 20:51:45 +01:00
|
|
|
timestamps: false
|
|
|
|
})
|
|
|
|
|
|
|
|
// Super Many-to-Many
|
|
|
|
// ref: https://sequelize.org/docs/v6/advanced-association-concepts/advanced-many-to-many/#the-best-of-both-worlds-the-super-many-to-many-relationship
|
2023-03-19 21:19:22 +01:00
|
|
|
const { book, person } = sequelize.models
|
|
|
|
book.belongsToMany(person, { through: BookNarrator, as: 'narrators', otherKey: 'narratorId' })
|
|
|
|
person.belongsToMany(book, { through: BookNarrator, foreignKey: 'narratorId' })
|
2023-03-12 20:51:45 +01:00
|
|
|
|
2023-03-19 21:19:22 +01:00
|
|
|
book.hasMany(BookNarrator)
|
|
|
|
BookNarrator.belongsTo(book)
|
2023-03-12 20:51:45 +01:00
|
|
|
|
2023-03-19 21:19:22 +01:00
|
|
|
person.hasMany(BookNarrator, { foreignKey: 'narratorId' })
|
|
|
|
BookNarrator.belongsTo(person, { as: 'narrator', foreignKey: 'narratorId' })
|
2023-03-12 20:51:45 +01:00
|
|
|
|
|
|
|
return BookNarrator
|
|
|
|
}
|