login.js

const sqlite3 = require('sqlite3').verbose();
var express = require('express');
var session = require('express-session');
var bodyParser = require('body-parser');
var path = require('path');
var attempt = 3;


let db = new sqlite3.Database('depression.club.db', sqlite3.OPEN_READONLY, (error) => {
    if (error) {
        console.error(error.message);
    }
    console.log("Connected to depression.club Database.");
});

var app = express();


app.use(session({
    secret: 'secret',
    resave: true,
    saveUninitialized: true
}));

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

app.get('/', function(request, response) {
    response.sendFile(path.join(__dirname + '/index.html'));
});

app.get("/some-endpoint", (req, res) => {
    res.send(true)
});

app.post('/auth', function(request, response) {
    var username = request.body.username;
    var password = request.body.password;
    if (username && password) {
        db.get('SELECT * FROM accounts WHERE username = ? AND password = ?', [username, password], function(error, results, fields) {
            if (results) {
                request.session.loggedin = true;
                request.session.username = username;
                response.redirect('/home');
            }
            else {
                response.redirect('http://localhost:3000');
            }
            response.end();
        });
    }   else {
        response.send('Please enter Username and Password.');
        response.end();
    }
});

module.exports.post = function(results){};

app.get('/home', function(request, response) {
    if (request.session.loggedin) {
        response.send('Welcome back, ' + request.session.username);
    } else {
        response.send('You have to be logged in to view this page.');
    }
    response.end();
});

app.use('/', express.static('./'));
app.listen(3000, ()=>{console.log('Its working')})