dyedgreen / deno-sqlite

Deno SQLite module
https://deno.land/x/sqlite
MIT License
409 stars 36 forks source link

Insert Query doesnt run #190

Closed NewtTheWolf closed 2 years ago

NewtTheWolf commented 2 years ago

Well, all I know is that it runs through queries that select something quickly, but insert queries (I suspect they are not the only ones) just don't run through, the log just stops and nothing happens.

deno 1.20.6 (release, x86_64-pc-windows-msvc)
v8 10.0.139.6
typescript 4.6.2

Code:

const db = new DB("database.db", { mode: "write" });

console.log("[DATABASE]", "Inserting users...");

console.log(db.query("SELECT username FROM user"));

db.query("INSERT INTO `user` (`username`) VALUES ('Peter Parker')");

console.log("[DATABASE]", "Finished users...");

Screenshots: image

dyedgreen commented 2 years ago

Closing this in favor of #191