Breaking News: Grepper is joining You.com. Read the official announcement!

Excluir dados de duas tabelas que se relacionam, usando sequelize, javascript e mysql

pupygreen answered on May 17, 2023 Popularity 1/10 Helpfulness 1/10

answer Excluir dados de duas tabelas que se relacionam, usando sequelize, javascript e mysql

Excluir dados de duas tabelas que se relacionam, usando sequelize, javascript e mysql

Comment

const deleteUser = async (id) => {
  const userExists = await User.findByPk(id, { raw: true });

  if (!userExists) return { status: 404, message: 'User not found!' };

  // SET FOREIGN_KEY_CHECKS=0; -- to disable them
  // SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

  const setForeignKey = async (value) => {
    await User.sequelize.query(`SET FOREIGN_KEY_CHECKS = ${value};`);
  };

  await setForeignKey(0);
  
  await User.destroy({ where: { id } });

  const saleAll = await Sale.findAll({ where: { userId: id }, raw: true });

  const idSale = saleAll.map(({ id: saleId }) => saleId);

  await Sale.destroy({ where: { userId: id } });

  await SalesProduct.destroy({ where: { saleId: idSale } });

  await setForeignKey(1);
};

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: e javascript mysql que

Link to this answer
Share Copy Link

Contributed on May 17 2023

pupygreen

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Excluir dados de duas tabelas que se relacionam, usando sequelize, javascript e mysql

Contents

More Related Answers

Excluir dados de duas tabelas que se relacionam, usando sequelize, javascript e mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.