FilesExpand file tree

 master

/

sqlitedbapi.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

35 lines (27 loc) · 890 Bytes

 master

/

sqlitedbapi.js

Copy path

Top

File metadata and controls

• Code
• Blame

35 lines (27 loc) · 890 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

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

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

var db = new sqlite3.Database('data/demodb02');

db.serialize(function() {

db.run("CREATE TABLE IF NOT EXISTS counts (key TEXT, value INTEGER)");

db.run("INSERT INTO counts (key, value) VALUES (?, ?)", "counter", 0);

});

var express = require('express');

var restapi = express();

restapi.get('/data', function(req, res){

db.get("SELECT value FROM counts", function(err, row){

res.json({ "count" : row.value });

});

});

restapi.post('/data', function(req, res){

db.run("UPDATE counts SET value = value + 1 WHERE key = ?", "counter", function(err, row){

if (err){

console.err(err);

res.status(500);

}

else {

res.status(202);

}

res.end();

});

});

restapi.listen(3000);

console.log("Submit GET or POST to http://localhost:3000/data");