FilesExpand file tree

 master

/

sql.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

18 lines (15 loc) · 479 Bytes

 master

/

sql.js

Copy path

Top

File metadata and controls

• Code
• Blame

18 lines (15 loc) · 479 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

var sqlite3 = require('sqlite3').verbose();

var db = new sqlite3.Database('abc.db');

var check;

db.serialize(function() {

db.run("CREATE TABLE if not exists 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.close();