index.js

#!/usr/bin/env node

'use strict'

const express = require('express')

const handlebars = require('express-handlebars').create({defaultLayout: 'main'})
const bodyParser = require('body-parser')
const app = express()
/*var multer = require('multer');*/
/*const upload = multer({ dest: './public/upload/' });*/

app.use(express.static('public'))
app.use(bodyParser.urlencoded({ extended: true }))
app.use(bodyParser.json());

app.engine('handlebars', handlebars.engine)
app.set('view engine', 'handlebars')

const port = 8080


const sqlite3 = require('sqlite3').verbose()

const db = new sqlite3.Database('./database.db', (err) => {
	if (err) return console.error(err.message)
	console.log('Connected to the "database.db" SQlite database.')
})

var multer = require('multer')

var storage = multer.diskStorage({
    destination: function (request, file, callback) {
        callback(null, './uploads/');
    },
    filename: function (request, file, callback) {
        console.log(file);
        callback(null, file.originalname)
    }
});

var upload = multer({ storage: storage });








app.get('/', async(req, res) => {
	const sql = 'SELECT ID, TITTLE, SUMMARY, DATE, IMG FROM TOPIC;'
	console.log(sql)
	db.all(sql, (err, data) => {
		if(err) console.error(err.message)
		console.log(data)
		res.render('home', {TOPIC: data})
	})
})

app.get('/logged', async(req, res) => {
	const sql = 'SELECT ID, TITTLE, SUMMARY, DATE, IMG FROM TOPIC;'
	console.log(sql)
	db.all(sql, (err, data) => {
		if(err) console.error(err.message)
		console.log(data)
		res.render('logged', {TOPIC: data})
	})
})

app.get('/register', async(req, res) => res.render('register'))

app.post('/adduser', async(req, res) => {
	console.log(req.body)
	console.log(req.body.pass)
	const sql = `INSERT INTO USER(NAME, PASSWORD)
								VALUES("${req.body.user}", "${req.body.pass}");`
	console.log(sql)
	db.run(sql)
	res.redirect('/login')

})

app.get('/login', async(req, res) => res.render('login'))
app.post('/login', async(req, res) => {
	console.log(req.body)
	res.redirect('/logged')

})

app.get('/details/:id', (req, res) => {
	console.log(req.params.id)
	const sql = `SELECT * FROM TOPIC WHERE ID = ${req.params.id};`
	console.log(sql)
	db.get(sql, (err, data) => {
		if(err) console.error(err.message)
		console.log(data)
		res.render('details', data)
	})
})



app.get('/form', async(req, res) => res.render('form'))



app.post('/add', upload.single('myFile'), async(req, res) => {
	console.log(req.body)
	console.log(req.file)
	




	/*var filename = req.file.filename;*/
	const sql = `INSERT INTO TOPIC(TITTLE, SUMMARY, FULL_TEXT, DATE, IMG)
								VALUES("${req.body.title}", "${req.body.summary}", "${req.body.fullText}", "${Date()}", "${req.body.myFile}");`
	console.log(sql)
	db.run(sql, err => {
		if(err) console.error(err.message)
		res.redirect('/logged')
	})
})

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