Guest User

Untitled

a guest
Jul 19th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. SequelizeForeignKeyConstraintError: insert or update on table "ads" violates foreign key constraint "ads_id_fkey"
  2.  
  3. const users_panel = sequelize.define('users_panel', {
  4. email: {
  5. type: Sequelize.STRING,
  6. allowNull: false,
  7. unique: true
  8. }
  9. })
  10. const ads = sequelize.define('ads', {
  11. user_panel_id: {
  12. type: Sequelize.INTEGER,
  13. allowNull: false
  14. },
  15. name: {
  16. type: Sequelize.STRING,
  17. allowNull: false
  18. },
  19.  
  20. })
  21. usersPanel.hasMany(ads, {foreignKey: 'user_panel_id', as: 'ads'});
  22. ads.belongsTo(usersPanel, {foreignKey: 'id', as: 'user'});
  23.  
  24. sequelize.sync({force: false})
  25. .then(data => console.log('ok'))
  26. .catch(error => console.error(error))
  27.  
  28.  
  29. const users_panel = sequelize.define('users_panel', {
  30. email: {
  31. type: Sequelize.STRING,
  32. allowNull: false,
  33. unique: true
  34. }
  35. })
  36.  
  37. const ads = sequelize.define('ads', {
  38. user_panel_id: {
  39. type: Sequelize.INTEGER,
  40. allowNull: false
  41. },
  42. name: {
  43. type: Sequelize.STRING,
  44. allowNull: false
  45. },
  46.  
  47. })
  48. usersPanel.hasMany(ads, {foreignKey: 'user_panel_id', as: 'ads'});
  49. ads.belongsTo(usersPanel, {foreignKey: 'id', as: 'user'});
  50.  
  51. sequelize.sync({force: false})
  52. .then(data => console.log('ok'))
  53. .catch(error => console.error(error))
  54.  
  55. ads.create(dataCreate)
  56.  
  57.  
  58. ads.findAndCountAll({
  59. where: search,
  60. limit: 100,
  61. offset: 0,
  62. include: [{
  63. as: 'user',
  64. model: usersPanel
  65. }]
  66. })
Add Comment
Please, Sign In to add comment