sqlite_express_example

const express = require('express')
const app = express()
const port = 3001


app.use(express.json())
app.use(function (req, res, next) {
    res.setHeader('Access-Control-Allow-Origin', 'http://localhost:3000');
    res.setHeader('Access-Control-Allow-Methods', 'GET,POST,PUT,DELETE,OPTIONS');
    res.setHeader('Access-Control-Allow-Headers', 'Content-Type, Access-Control-Allow-Headers');
    next();
});

const sqlite3 = require('sqlite3').verbose();
let db = new sqlite3.Database('test.db', (err) => {
    if (err) {
        return console.error(err.message);
    }
    console.log('Connected to the  SQlite database.');
});

const getCities = (query) => {
    return new Promise(
        function(resolve, reject) {
            db.each(query, (error, results) => {
                if (error) {
                    reject(error)
                }
                //console.log(results)
                resolve(results);
            });
        }
    )
}
app.get('/', (req, res) => {
    console.log(req.query)

    getCities(req.query.query_string)
        .then(response => {
                    res.status(200).send(response);
                })
                .catch(error => {
                    res.status(500).send(error);
                })
})

app.listen(port, () => {
    console.log(`App running on port ${port}.`)
})