app_session_mysql.js

var express = require('express');
var bodyParser = require('body-parser');
var session = require('express-session');
var MySQLStore = require('express-mysql-session')(session);
var app = express();

/* this app is going to use bodyparser for post*/
app.use(bodyParser.urlencoded({
    extended: false
}));

app.use(session({
    secret: '123dfasdf3df3aadfD',
    resave: false,
    saveUninitialized: true,
    store: new MySQLStore({
        host: 'localhost',
        port: 3306,
        user: 'root',
        password: 'visualmedia',
        database: 'o2'
    })
}));

app.get('/count', function(req, res){
    if(req.session.count) {
        req.session.count++;
    } else {
        req.session.count = 1;
    }
    res.send('count :' +req.session.count);
})


app.get('/auth/logout', function(req, res){
    delete req.session.displayName;
    /* req.session.save는 req.session의 값이 save가 되고나서 실행이 되는 콜백함수이다. 데이터베이스에 저장할 시간을 확실히 확보하여 준다 */
    req.session.save(function(){
        res.redirect('/welcome');
    })
})
app.get('/welcome', function(req, res){
    if(req.session.displayName){
        res.send(`
            <h1>Hello, ${req.session.displayName}</h1>
            <a href="/auth/logout">logout</a>
        `);
    } else {
        res.send(`
        <h1>Welcome</h1>
        <a href="/auth/login">Please login</a>
        `)
    }
})
app.post('/auth/login', function(req,res){
    var user = {
        username: 'egoing',
        password:'111',
        displayName: 'Jundong'
    };
    var uname = req.body.username;
    var pwd = req.body.password;
    
    if(uname === user.username && pwd === user.password){
        req.session.displayName = user.displayName;
        res.redirect('/welcome');
    } else {
        res.send(`No user or incorrect password
        <p><a href="/auth/login">login</a></p>`)
    }
});

app.get('/auth/login', function(req,res){
    var output = `
        <h1> Login </h1>
        <form action="/auth/login" method="post">
            <p>
                <input type="text" name="username" placeholder="username">
            </p>
            <p>
                <input type="password" name="password" placeholder="password">
            </p>
            <p>
                <input type="submit">
            </p>
        </form>
    `;
    res.send(output);
});

app.listen(3003, function(){
    
    console.log('Connected 3003 port');
})