slistrom / me-express-back

var express = require('express');

var router = express.Router();

// const db = new sqlite3.Database('./db/texts.sqlite');

const db = require("../db/database.js");

    const data = {

        data: {

            msg:  "No week given"

        }

    };

    res.json(data);

});

router.get("/:msg", (req, res) => {

    db.each("SELECT week, text FROM reports WHERE week = " + req.params.msg, function(err, row) {

        // console.log(row.week + ": " + row.text);

        const data = {

            data: {

                week: row.week,

                text: row.text

            }

        };

        res.json(data);

    });

});

module.exports = router;