Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SequelizeForeignKeyConstraintError: insert or update on table "ads" violates foreign key constraint "ads_id_fkey"
- const users_panel = sequelize.define('users_panel', {
- email: {
- type: Sequelize.STRING,
- allowNull: false,
- unique: true
- }
- })
- const ads = sequelize.define('ads', {
- user_panel_id: {
- type: Sequelize.INTEGER,
- allowNull: false
- },
- name: {
- type: Sequelize.STRING,
- allowNull: false
- },
- })
- usersPanel.hasMany(ads, {foreignKey: 'user_panel_id', as: 'ads'});
- ads.belongsTo(usersPanel, {foreignKey: 'id', as: 'user'});
- sequelize.sync({force: false})
- .then(data => console.log('ok'))
- .catch(error => console.error(error))
- const users_panel = sequelize.define('users_panel', {
- email: {
- type: Sequelize.STRING,
- allowNull: false,
- unique: true
- }
- })
- const ads = sequelize.define('ads', {
- user_panel_id: {
- type: Sequelize.INTEGER,
- allowNull: false
- },
- name: {
- type: Sequelize.STRING,
- allowNull: false
- },
- })
- usersPanel.hasMany(ads, {foreignKey: 'user_panel_id', as: 'ads'});
- ads.belongsTo(usersPanel, {foreignKey: 'id', as: 'user'});
- sequelize.sync({force: false})
- .then(data => console.log('ok'))
- .catch(error => console.error(error))
- ads.create(dataCreate)
- ads.findAndCountAll({
- where: search,
- limit: 100,
- offset: 0,
- include: [{
- as: 'user',
- model: usersPanel
- }]
- })
Add Comment
Please, Sign In to add comment