如果沒有會無法執行
但當需要以特定的條件執行刪除
但又未包含pk欄位時
可透過設定individualHooks=true
此時sequelize會先執行select 再刪除select取得的rows
這樣就可以達到未帶pk執行刪除的功能
ex
model.destroy({
where: { xxxxx },
individualHooks: true
})
model.destroy({
where: { xxxxx },
individualHooks: true
})
select * from maintable where uid in(select uid from uidTable where flag='Y')
mainTableModel.findAll(
{
where:{
uid: {
[Op.in]: [sequelize.literal(`(select name, uid from maintable where uid in(select uid from uidTable where flag='Y')`)]
}
}
}
)
let havePK = false
fields.forEach(field => {
if (field.primaryKey) havePK = true
})
const model = sequelize.define('tableName', fields, option)
if (!havePK) model.removeAttribute('id')
建立js module
sequelize-auto -o "./models" -d dbName -h localhost -u username -p 3306 -x yourpassword -e mysql
建立json
sequelize-auto -o "./models" -d dbName -h localhost -u username -p 3306 -x yourpassword -e mysql -j
將產生的json轉成js module
const { getModel } = require('sequelize/lib/utils')
const model = await getModel(sequelize, jsonfilePath)