- const vidQuery =
- "SELECT id " +
- "FROM Variants " +
- "WHERE name = '" + vname + "'";
- db.get(vidQuery, (err,variant) => {
- const insertQuery =
- "INSERT INTO Problems (added, vid, fen, instructions, solution) VALUES " +
- "(" +
- Date.now() + "," +
- variant.id + "," +
- fen + "," +
- instructions + "," +
- solution +
- ")";
- db.run(insertQuery);
+ const insertQuery =
+ "INSERT INTO Problems (added, uid, vid, fen, instructions, solution) " +
+ "VALUES (" + Date.now() + "," + uid + "," + vid + ",'" + fen + "',?,?)";
+ db.run(insertQuery, [instructions, solution], err => {
+ if (!!err)
+ return cb(err);
+ db.get("SELECT last_insert_rowid() AS rowid", cb);