javascript - 我的 sqlite 项目在添加到表时不断抛出错误

问题描述

我的服务器上有这段代码，但每当它运行时，它总是给我一个错误。当我在 Chrome 中进入开发者控制台时，它只是说错误，但没有更多信息可以帮助我找出原因。我是从模板中制作的，并且我一遍又一遍地进行了更改，但我无法弄清楚它为什么停止工作。任何帮助表示赞赏。

这是代码：

// endpoint to add a dream to the database
app.post("/addDream", (request, response) => {
  console.log(`add to dreams ${request.body.name} ${request.body.price} ${request.body.email} ${request.body.description} ${request.body.photoID} ${request.body.date}`);

  // DISALLOW_WRITE is an ENV variable that gets reset for new projects
  // so they can write to the database
  if (!process.env.DISALLOW_WRITE) {
    const cleansedName = cleanseString(request.body.name);
    const cleansedPrice = cleanseString(request.body.name);
    const cleansedEmail = cleanseString(request.body.name);
    const cleansedState = cleanseString(request.body.name);
    const cleansedDescription = cleanseString(request.body.name);
    const cleansedphotoID = cleanseString(request.body.name);
    const cleansedDate = cleanseString(request.body.name);

    db.run("INSERT INTO Dreams (name, price, email, description, photoID, date) VALUES (cleansedName, cleansedPrice, cleansedEmail, cleansedState, cleansedDescription, cleansedphotoID, cleansedDate);", error => {
      if (error) {
        response.send({ message: "error!" });
        console.log("error")
      } else {
        response.send({ message: "success" });
        console.log("success")
      }
    });
  }
});

这是在我更改之前有效的模板的原始代码：

// endpoint to add a dream to the database
app.post("/addDream", (request, response) => {
  console.log(`add to dreams ${request.body.dream}`);

  // DISALLOW_WRITE is an ENV variable that gets reset for new projects
  // so they can write to the database
  if (!process.env.DISALLOW_WRITE) {
    const cleansedDream = cleanseString(request.body.dream);
    db.run(`INSERT INTO Dreams (dream) VALUES (?)`, cleansedDream, error => {
      if (error) {
        response.send({ message: "error!" });
      } else {
        response.send({ message: "success" });
      }
    });
  }
});

如果有帮助，这里是完整项目的链接：https ://glitch.com/edit/#!/beta2-droneswap?path=server.js%3A215%3A0

感谢您抽出宝贵时间，再次感谢您的帮助。

编辑：启动时发生了另一个错误，但我修复了它，它仍然无法正常工作。当前错误发生在我尝试添加列表时。我很确定它与第 166 行附近的 sql 代码有关。

这是我认为错误所在的当前代码：

// endpoint to add a dream to the database
app.post("/addDream", (request, response) => {
  console.log(
    `add to dreams ${request.body.name}, ${request.body.price}, ${request.body.email}, ${request.body.state}, ${request.body.description}, ${request.body.photoID}, ${request.body.date}`
  );

  // DISALLOW_WRITE is an ENV variable that gets reset for new projects
  // so they can write to the database
  if (!process.env.DISALLOW_WRITE) {
    const cleansedName = cleanseString(request.body.name);
    const cleansedPrice = cleanseString(request.body.price);
    const cleansedEmail = cleanseString(request.body.email);
    const cleansedState = cleanseString(request.body.state);
    const cleansedDescription = cleanseString(request.body.description);
    const cleansedphotoID = cleanseString(request.body.photoID);
    const cleansedDate = cleanseString(request.body.date);

    db.run(
      `INSERT INTO Listings (name, price, email, state, photoID, date) VALUES (cleansedName, cleansedPrice, cleansedEmail, cleansedState, cleansedDescription, cleansedphotoID, cleansedDate)`,
      error => {
        if (error) {
          response.send({ message: "error!" });
          console.log("error");
        } else {
          response.send({ message: "success" });
          console.log("success");
        }
      }
    );
  }
});

标签： javascriptmysqlsqlsqlite

javascript - 我的 sqlite 项目在添加到表时不断抛出错误

问题描述

解决方案

推荐阅读