FilesExpand file tree

master

/

sqlite-sqlcipher-test.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

19 lines (15 loc) · 502 Bytes

master

/

sqlite-sqlcipher-test.js

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

19 lines (15 loc) · 502 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

19

var sqlite3 = require('./lib/sqlite3').verbose()

var db = new sqlite3.Database('test.db')

db.serialize(function() {

db.run('PRAGMA key = 32523524525')

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()