SQLITE mit Node.js

index.js

var sqlite3 = require('sqlite3').verbose();
db = new sqlite3.Database('./users.db');
db.serialize(function () {
    db.run("CREATE TABLE IF NOT EXISTS users (" +
        "id        INTEGER      PRIMARY KEY AUTOINCREMENT," +
        "uuid      VARCHAR (80) NOT NULL," +
        "email     VARCHAR (80) NOT NULL," +
        "generated DATETIME," +
        "accepted  DATETIME" +
        ");");
});

db.run("INSERT INTO users (uuid,email) VALUES ('abcss','[email protected]');", (err) => {
    if (err) {
        return console.error(err.message);
    }
    else {
        console.log('inserted');
    }
});


db.all("SELECT * FROM users;", (err, rows) => {
    if (err) {
        return console.error(err.message);
    }
    else {
        rows.forEach(element => {
            console.log("found:" + element.id+";"+element.uuid);    
        });
        
    }
});

package.json

{
  "name": "sqlitetest",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "",
  "license": "ISC",
  "dependencies": {
    "sqlite3": "^4.0.1"
  }
}