node. js Operation SQLite3

NPM Install Sqlite3--save

varFS = require ("FS");varFile = Process.env.CLOUD_DIR + "/" + "test.db";varexists =fs.existssync (file);if(!exists) {Console.log ("Creating DB file."); Fs.opensync (file,"W");}varSqlite3 = require ("Sqlite3"). verbose ();vardb =NewSqlite3. Database (file);d b.serialize (function() {    if(!exists) {Db.run ("CREATE TABLE Stuff (thing TEXT)"); }    varstmt = Db.prepare ("INSERT into Stuff VALUES (?)"); //Insert Random Data    varRnd;  for(vari = 0; I < 10; i++) {rnd= Math.floor (Math.random () * 10000000); Stmt.run ("Thing #" +Rnd);    } stmt.finalize (); Db.each ("Select rowID as ID, thing from Stuff",function(err, row) {Console.log (row.id+ ": " +row.thing); });}); Db.close ();

node. js Operation SQLite3