db.each("SELECT * FROM targets", function (err,row) { console.log("Read target from DB : " + row.id + " : " + row.target + " (" + row.hostname + ")"); results[row.target] = []; losses[row.target] = []; targets.push(row.target); hosts[row.target] = row.hostname; }, startPing);
// Start serialization using db.serialize() db.serialize(() => { // Select records using db.each() for easy access of row entries db.each('SELECT * from USER', (err, row) => { if(err) console.log(err.message); else // Easy access to row-Entries using row.NAME console.log(row.ID + " | " + row.NAME + " | " + row.DESC + " | " + row.ACTIVE); }); })
db.serialize(function() { db.run("CREATE TABLE lorem (info TEXT)"); var stmt = db.prepare("INSERT INTO lorem VALUES (?)"); for (var i = 0; i < 10; i++) { stmt.run("Ipsum " + i); } stmt.finalize(); db.each("SELECT rowid AS id, info FROM lorem", function(err, row) { console.log(row.id + ": " + row.info); }); });
db.each('SELECT * FROM payload', function(err, row) { if(err) { console.log(err); process.exit(-1); } bplist.parseBuffer(row.value, function(err, results) { if(err) { console.log(err); return err; } var archive = new MSUnarchiver(results[0]); // This has the main sketch data structure var top = archive.top(); console.log('The first page name is: ' + top.pages[0].name); }); });
socket.on("LogIn", function(data){ db.each('SELECT * FROM `users` WHERE `username` LIKE "' +data.user.username+'" AND `password` LIKE "' +data.user.password+'"', function(error,result) { if(error) { throw error; } else if(result.length > 0){ socket.emit("LoginClient"); socket.emit("MainShow"); socket.emit("LoginCorrect"); } else{ socket.emit("LoginIncorrect"); } }) })
db.serialize(() => { db.run(`CREATE TABLE IF NOT EXISTS ${table_name} (title TEXT)`); db.run(`INSERT INTO ${table_name} VALUES (?)`, title); db.each(`SELECT rowid AS id, title FROM ${table_name}`, function(err, row) { console.log(row.id + ": " + row.title); }); });
db.each(`SELECT rowid AS id, title FROM ${table_name}`, function(err, row) { console.log(row.id + ": " + row.title); });
socket.on("Register", function(data){ db.each('SELECT * FROM `users` WHERE `username` LIKE "' +data.user.username+'"', function(error,result) { if(result.length > 0){ socket.emit("AlreadyUser"); } else { db.run('INSERT INTO users VALUES ("' + data.user.username + '","' + data.user.password + '","'+ data.user.email +'")', function(error,result) { if(error) { throw error; console.log("Error : "+error); } else{ socket.emit("RegisterCorrect"); console.log("New user" , data.user.name); } }) } }) })
db.each( 'SELECT num_hotel FROM chambre ' + 'WHERE (chambre.prix > 50)' , function(err, row) { db.each( 'SELECT * FROM hotel,chambre ' + 'WHERE (hotel.num_hotel = chambre.num_hotel)' , function(err, row) { db.each( 'SELECT nom_hotel FROM hotel,chambre ' + 'WHERE (hotel.num_hotel = chambre.num_hotel '+ 'AND chambre.prix > 50)' db.each("SELECT num_hotel, nom_hotel FROM hotel", function(err, row) { console.log(JSON.stringify(row)); }); db.each( 'SELECT num_hotel, num_chambre FROM chambre ' + 'WHERE (chambre.prix < 50)' , function(err, row) { db.each( 'SELECT nom_hote, adresse_hote FROM hote', function(err, row) { console.log(JSON.stringify(row)); }); db.each( 'SELECT prix, type ' + 'FROM hotel , chambre ' + 'WHERE ( ' + db.each( 'SELECT num_hote, nom_hote ' +