I try to Insert query into sqlite database. But the function Does not work correctly.
const sqlite3 = require('sqlite3');
const { open } = require('sqlite');
async function main() {
try {
sqlite3.verbose();
const ordersDb = await createDbConnection('./test.db');
const orderProcessed = await orderAlreadyProcessed(ordersDb, "users");
console.log('four ');
} catch (error) {
console.error(error);
}
}
async function orderAlreadyProcessed(ordersDb, orderNumberStr) {
try {
console.log('two ');
const query = `INSERT INTO users (first_name , last_name , username , password ) VALUES ('fdlfkld' , 'sfhdfjdk' , 'sdfhsdfhsd' , 'sdffs' )`
const row = await ordersDb.run(query);
console.log('three ');
} catch (error) {
console.error(error);
throw error;
}
}
function createDbConnection(filename) {
return open({
filename,
driver: sqlite3.Database
});
}
let one = [ 1 , 2, 3 ]
Promise.all(one.map(async()=>{
await main();
}))
i need output like this
two
three
four
two
three
four
two
three
four
Sqlite does not work correctly , i need some help to rid the problem