Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var mysql = require('mysql');
- var session = require('express-session');
- var MySQLStore = require('express-mysql-session')(session);
- var app = express();
- var bodyParser = require('body-parser');
- app.use(bodyParser.json({type: '*/*'}));
- var http = require('http');
- app.use(function (req, res, next) {
- res.setHeader('Access-Control-Allow-Origin', '*');
- res.setHeader('Access-Control-Allow-Methods', 'GET, POST, OPTIONS, PUT, PATCH, DELETE');
- res.setHeader('Access-Control-Allow-Headers', 'X-Requested-With,content-type');
- next();
- });
- var connectionPool = mysql.createPool({
- host: '127.0.0.1',
- user: 'root',
- password: '123456',
- database: 'cs_chat',
- connectionLimit: 2,
- });
- var options = {
- host: '127.0.0.1',
- user: 'root',
- password: '123456',
- database: 'cs_chat',
- schema: {
- tableName: 'my_session',
- columnNames: {
- session_id: 'session_id',
- expires: 'expires_column_name',
- data: 'data_column_name'
- }
- }
- };
- var sessionStore = new MySQLStore(options);
- var server=http.createServer(app);
- app.use(session({
- secret: 'some secret',
- resave: false,
- saveUninitialized: true,
- store: sessionStore,
- cookie: {
- secure: false,
- maxAge: 36000000,
- httpOnly: false,
- },
- }));
- app.get("/test", function(req, res, next){
- console.log(req.session);
- console.log(req.sessionID, req.session.name);
- if(!req.session.name){
- console.log("Not set.");
- req.session.name = "vikas kumar";
- } else {
- console.log("Already set");
- console.log(req.session.name);
- }
- res.end();
- });
- server.listen(3000, '0.0.0.0', function(){
- var host = server.address().address;
- var port = server.address().port;
- console.log("testApp socket server is listening at http://%s:%s", host, port+"nn");
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement