RESTful API using express and sqlite3

index.js

const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('wedding.db');
const express = require('express');
const restapi = express();

restapi.get('/', function(req, res){
    db.all('SELECT * FROM wedding', function(err, rows){
        res.json(rows);
    });
})

restapi.get('/gifts', function(req, res){
    db.all("SELECT * FROM wedding where gift != ''", function(err, rows){
        res.json(rows);
    });
})

restapi.get('/gifts/count', function(req, res){
    db.all("SELECT count(name) FROM wedding where gift != ''", function(err, rows){
        res.json(rows);
    });
})

restapi.get('/gifts/search/:searchterm', function(req, res){
    var query = req.params.searchterm;
    db.all("SELECT * FROM wedding where gift LIKE '%" + query + "%' or name LIKE '%" + query + "%'", function(err, rows){
        res.json(rows);
    });
})

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