server.js

const express = require('express')
const server = express()
//const axios = require('axios').default
var exphbs = require('express-handlebars')
var fs = require('fs');
const { insertMany } = require('./models/article');
var port = process.env.PORT||3000;
var bodyParser = require('body-parser')
var jsonParser = bodyParser.json();

const Article = require('./models/article');


// Serve static files
server.engine('hbs', exphbs({defaultLayout: 'main', extname: '.hbs'}))
server.set('view engine', 'hbs')
server.use(express.static('public'))


//---Andrews Playground--------------------------------------------------------
//server request will call this function and execute console.log()

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

function getPostInfo(){
  var postArray = new Array() //blank array to hold all posts
  var iterator = 0;
  db.serialize(() => {
    db.each(`SELECT id as id,
                    title as title,
                    author as author,
                    description as description,
                    content as content,
                    date as date
            FROM blog_post`, (err, row) => {
      if (err) {
        console.error(err.message);
        console.log("Cannot find columns")
      }

      var singleEntry = new Array() //array to represent a single post
      singleEntry.push(row.id)//0
      singleEntry.push(row.title)//1
      singleEntry.push(row.author)//2
      singleEntry.push(row.description)//3
      singleEntry.push(row.content)//4
      singleEntry.push(row.date)//5

      postArray.push(singleEntry)
    });
  });
  return postArray;
}

function getSinglePost(idx){
  var postArray = new Array() //blank array to hold all posts
  var iterator = 0;
  db.serialize(() => {
    let sql = `SELECT id as id, title as title, author as author, description as description, content as content, date as date FROM blog_post`
    db.each(sql, (err, row) => {
      if (err) {
        console.error(err.message);
        console.log("Cannot find columns")
      }

      var singleEntry = new Array() //array to represent a single post

      if(idx == row.id){
        console.log("Entered if idx == row.id")
        singleEntry.push(row.id)//0
        singleEntry.push(row.title)//1
        singleEntry.push(row.author)//2
        singleEntry.push(row.description)//3
        singleEntry.push(row.content)//4
        singleEntry.push(row.date)//5

        postArray.push(singleEntry)
      }
    });
  })
    return postArray
}


function validateIndex(idx){
  var postCounter = 0;
 `SELECT COUNT(*) as num FROM blog_post`
}

server.get("/", function(req, res, next){
    var posts = getPostInfo()
    res.status(200).render("homePage",{articles:posts});
});

server.get("/new", function(req, res, next){
    res.status(200).render("newPost",{})
});

server.get("/posts/:idx", function(req, res, next){
    var article = getSinglePost(req.params.idx)
    if(article === 0){
      console.log("entered if article == null")
      res.status(404).render('404')}

    else{res.status(200).render('singlePost', {articles:article})}
})


server.get("*", function(req, res){
    res.status(404).render("404",{
    //404 Comment not found
    })
    return;
});

server.post('/new', jsonParser, function(req, res){
  console.log("entered server.post")
  insert(req);

  db.each('SELECT * from blog_post', function(err, row){
    if(row){
      console.log('record: ', JSON.stringify(row));
    }
  })
})

var insert = function(req){
  console.log("entered var insert");
  db.run('INSERT INTO blog_post (title, author, description, content, date) VALUES ("'+req.body.title+'","'+req.body.author+'","'+req.body.description+'","'+req.body.content+'", "'+req.body.date+'")');

  window.location.replace("index.html");
}



module.exports = server
server.listen(port, function () {
  console.log("== Server is listening on port", port);
});