Does someone know, why i get this error: TypeError: conn.beginTransaction is not a function? I've been trying to find how to use transaction with mysql2, but haven't found a good solution yet.
dbConfig.js
const mysql = require('mysql2/promise');
const pool = mysql.createPool({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_DATABASE,
connectionLimit: 10,
});
module.exports = pool;
ProductModel.js
const conn = require('../config/dbConfig');
const productModel = {
postOrder: async (order) => {
return await new Promise((resolve, reject) => {
conn.beginTransaction();
console.log('Start Tranaction!');
const insertQuery = conn.query(
'INSERT INTO `beansome`.`order` (`orderCreated`,`orderFirstname`,`orderLastname`,`orderStreet`,`orderHousenumber`,`orderZipcode`,`orderCity`,`orderTelephone`,`orderEmail`,`orderTotalprice`) VALUES (?,?,?,?,?,?,?,?,?,?);',
[
order.orderCreated,
order.orderFirstname,
order.orderLastname,
order.orderStreet,
order.orderHousenumber,
order.orderZipcode,
order.orderCity,
order.orderTelephone,
order.orderEmail,
order.orderTotalprice,
]
);
conn.commit();
console.log('End Tranaction!');
});
},
};
module.exports = productModel;