audiobookshelf/server/models/BookAuthor.js

79 lines
1.7 KiB
JavaScript
Raw Permalink Normal View History

2023-07-05 01:14:44 +02:00
const { DataTypes, Model } = require('sequelize')
2023-08-16 01:03:43 +02:00
class BookAuthor extends Model {
constructor(values, options) {
super(values, options)
/** @type {UUIDV4} */
this.id
/** @type {UUIDV4} */
this.bookId
/** @type {UUIDV4} */
this.authorId
/** @type {Date} */
this.createdAt
2023-07-05 01:14:44 +02:00
}
2023-08-16 01:03:43 +02:00
static removeByIds(authorId = null, bookId = null) {
const where = {}
if (authorId) where.authorId = authorId
if (bookId) where.bookId = bookId
return this.destroy({
where
})
}
2023-07-05 01:14:44 +02:00
/**
* Get number of books for author
*
* @param {string} authorId
* @returns {Promise<number>}
*/
static getCountForAuthor(authorId) {
return this.count({
where: {
authorId
}
})
}
2023-08-16 01:03:43 +02:00
/**
* Initialize model
* @param {import('../Database').sequelize} sequelize
2023-08-16 01:03:43 +02:00
*/
static init(sequelize) {
super.init(
{
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true
}
},
{
sequelize,
modelName: 'bookAuthor',
timestamps: true,
updatedAt: false
2023-08-16 01:03:43 +02:00
}
)
2023-07-05 01:14:44 +02:00
2023-08-16 01:03:43 +02:00
// 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
const { book, author } = sequelize.models
book.belongsToMany(author, { through: BookAuthor })
author.belongsToMany(book, { through: BookAuthor })
2023-07-05 01:14:44 +02:00
book.hasMany(BookAuthor, {
onDelete: 'CASCADE'
})
2023-08-16 01:03:43 +02:00
BookAuthor.belongsTo(book)
2023-07-05 01:14:44 +02:00
author.hasMany(BookAuthor, {
onDelete: 'CASCADE'
})
2023-08-16 01:03:43 +02:00
BookAuthor.belongsTo(author)
}
}
module.exports = BookAuthor