ok.js

var express = require('express'),
    app = express(),
    port = process.env.PORT || 3000
var mongoose = require('mongoose')
var Task = require('./api/models/todoListModel')
var IgAccount = require('./api/models/IgAccountModel')
var bodyParser = require('body-parser')

// mongoose instance connection url connection
mongoose.Promise = global.Promise;
mongoose.connect('mongodb://localhost:27017/Tododb', {
    useNewUrlParser: true
})

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('/Users/converge/Documents/workspace/duffgram-engine/db/duffgram.db');


app.use(bodyParser.urlencoded({
    extended: true
}));
app.use(bodyParser.json());

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);
});
/*
app.get('/get_usernamesqlite', function(req, res){
    db.get("SELECT value FROM counts", function(err, row){
        console.log(row.value)
        res.json({ "count" : row.value });
    });
});*/
app.get('/get_usernamesqlite', function(req, res) {
    db.get("SELECT ig_account_id, followers, followings, total_posts, created FROM ig_account_statistics", function(err, row) {
        res.json({
            'ig_account_id': row.ig_account_id,
            'followers': row.followers,
            'followings': row.followings,
            'total_posts': row.total_posts,
            'created': row.created
        });
    });
});


var routes = require('./api/routes/todoListRoutes'); //importing route
routes(app); //register the route

app.listen(port);

app.use(function(req, res) {
    res.status(404).send({
        url: req.originalUrl + ' not found'
    })
});


console.log('todo list RESTful API server started on: ' + port);