import express from 'express';
import Promise from 'bluebird';
import db from 'sqlite';

const server = express();
const port = process.env.PORT || 3000;

server.get('/', async (req, res, next) => {
  try {
    const row = await db.get(`SELECT * FROM tableName WHERE id = ?`, 123);
    res.send(`Hello, ${row.columnName}!`);
  } catch (err) {
    next(err);
  }
});

db.open('./db.sqlite', { verbose: true, Promise })
  .catch(err => console.error(err))
  .finally(() => {
    server.listen(port, () => {
      console.log(`Node.js app is running at http://localhost:${port}/`);
    });
  });