I have been attempting to insert data into a local SQLite database. I am able to achieve this, but unfortunately, I have to create a new table every time. I am hoping to find a way to insert the data without having to create a new table each time.
Even though I am successfully inserting the data into the table, creating a new table for each insertion is proving to be cumbersome.
$("#ecris").click( function()
{
var fs = require("fs");
var sql = require("./js/sql.js");
var db = new sql.Database();
db.run("CREATE TABLE test (col1, col2);");
db.run("INSERT INTO test (col1, col2) VALUES ('8','4564')");
;
var data = db.export();
var buffer = new Buffer(data);
fs.writeFileSync("bd/mybd.sqlite", buffer );
db.close();
});
If there's a way to simply insert into the existing table, I would greatly appreciate your guidance. Thank you!