{"id":4200,"date":"2017-05-21T23:37:15","date_gmt":"2017-05-21T14:37:15","guid":{"rendered":"https:\/\/kumapress.com\/wp\/?p=4200"},"modified":"2017-06-15T19:17:14","modified_gmt":"2017-06-15T10:17:14","slug":"node-js%e3%81%a7expresspostgresqlsession-express%e3%82%92%e5%88%a9%e7%94%a8%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/kumapress.com\/?p=4200","title":{"rendered":"node.js\u3067express+PostgreSQL+session-express\u3092\u5229\u7528\u3059\u308b"},"content":{"rendered":"

\u73fe\u5728\u306e\u74b0\u5883<\/span><\/h2>\n

\u30fbCentOS6.8
\n\u30fbPostgreSQL9.6
\n\u30fbnode.js7.10.0<\/p>\n

\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n

$ npm install –save express-session<\/span>
\n<\/span>$ npm install –save connect-pg-simple<\/span><\/p>\n

\u30bb\u30c3\u30b7\u30e7\u30f3\u4f59\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u5c55\u958b\u3059\u308b<\/h3>\n

$ psql -U datauser z_event_db < node_modules\/connect-pg-simple\/table.sql<\/p>\n

app.js<\/h3>\n

var session = require(‘express-session’);
\nvar pgSession = require(‘connect-pg-simple’)(session);<\/p>\n

app.use(session({<\/code>
\n\u00a0 \u00a0 store: new pgSession({<\/code>
\n\u00a0 \u00a0 \u00a0 \u00a0 pg : pg,<\/code>
\n\u00a0 \u00a0 \u00a0 \u00a0conString : 'postgres:\/\/hogeuser:hogepass@localhost:5432\/xxx_db',<\/code>
\n\u00a0 \u00a0 \u00a0 \u00a0crear_interval : 60 * 60 \/\/ \u4fdd\u5b58\u671f\u9593(sec)<\/code>
\n\u00a0 \u00a0 }),<\/code>
\n\u00a0 \u00a0 secret : 'secret', \/\/ Cookie\u306e\u6697\u53f7\u5316\u306b\u5229\u7528\u3059\u308b\u30ad\u30fc<\/code>
\n\u00a0 \u00a0 resave : false, \/\/ true\uff1a\u30bb\u30c3\u30b7\u30e7\u30f3\u5185\u5bb9\u306b\u5909\u66f4\u304c\u306a\u3044\u5834\u5408\u306b\u3082\u4fdd\u5b58\u3059\u308b<\/code>
\n \u00a0 \u00a0 saveUninitialized : false, \/\/ true\uff1a\u65b0\u898f\u306b\u30bb\u30c3\u30b7\u30e7\u30f3\u3092\u751f\u6210\u3057\u3066\u4f55\u3082\u4ee3\u5165\u3055\u308c\u3066\u3044\u306a\u304f\u3066\u3082\u5024\u3092\u5165\u308c\u308b<\/code>
\n \u00a0 \u00a0 rolling : true, \/\/ true\uff1a\u30a2\u30af\u30bb\u30b9\u306e\u5ea6\u306b\u3001\u6709\u52b9\u671f\u9650\u3092\u4f38\u3070\u3059<\/code>
\n \u00a0 \u00a0 cookie : {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 httpOnly : false, \/\/ cookie\u3078\u306e\u30a2\u30af\u30bb\u30b9\u3092HTTP\u306e\u307f\u306b\u5236\u9650\u3057\u306a\u3044<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 maxAge : 60 * 60 * 1000 \/\/ \u30af\u30c3\u30ad\u30fc\u306e\u6709\u52b9\u671f\u9650(msec)<\/code>
\n \u00a0 \u00a0 }<\/code>
\n }));<\/code><\/p>\n

index.js<\/h3>\n

Binging\u304c\u4f55\u6545\u304b\u3046\u307e\u304f\u3044\u304b\u306a\u304f\u3066\u3001SQL\u4f5c\u3063\u3066\u307e\u3059(^^;<\/p>\n

var express = require('express');<\/code>
\nvar router = express.Router();<\/code><\/p>\n

\/* Session *\/<\/code>
\nvar loginCheck = function( req, res, next ){<\/code>
\n\u00a0 \u00a0 if( req.session.user ) {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 next();<\/code>
\n \u00a0 \u00a0 } else {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 res.redirect('login');<\/code>
\n \u00a0 \u00a0 }<\/code>
\n};<\/code><\/p>\n

\/* GET home page. *\/<\/code>
\nrouter.get('\/', loginCheck, function(req, res, next) {<\/code>
\n \u00a0 \u00a0 res.redirect('login');<\/code>
\n\u00a0 \u00a0 \/\/ res.render('index', { title: 'Express' });<\/code>
\n});<\/code>
\nmodule.exports = router;<\/code><\/p>\n

loginchk.js<\/h3>\n

var express = require('express');<\/code>
\nvar router = express.Router();<\/code>
\nvar pg = require('pg');<\/code><\/p>\n

\/* GET home page. *\/<\/code>
\nrouter.post('\/', function(req, res, next) {<\/code>
\n \u00a0 \u00a0 var strUser = req.body[\"user\"];<\/code>
\n \u00a0 \u00a0 var strPass = req.body[\"passwd\"];<\/code><\/p>\n

\u00a0 \u00a0 console.log( \"user:\" + strUser + \" pass:\" + strPass );<\/code><\/p>\n

\u00a0 \u00a0 var con = \"tcp:\/\/datauser@localhost:5432\/z_event_db\";<\/code>
\n \u00a0 \u00a0 pg.connect( con, function( erro, client ) {<\/code><\/p>\n

\u00a0 \u00a0\u00a0 \u00a0 var qStrSel = 'SELECT login_name, login_passwd FROM d_eventor WHERE';<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 qStrSel += \" login_name='\" + strUser + \"'\";<\/code>
\n\u00a0 \u00a0\u00a0 \u00a0 qStrSel += ' AND';<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 qStrSel += \" login_passwd='\" + strPass + \"'\";<\/code>
\n\u00a0 \u00a0\u00a0 \u00a0 qStrSel += ';';<\/code>
\n\u00a0 \u00a0\u00a0 \u00a0 var query = client.query( qStrSel );<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 console.log( \"sql:\" + qStrSel );<\/code><\/p>\n

\u00a0 \u00a0\u00a0 \u00a0 var query = client.query( qStrSel );<\/code><\/p>\n

\u00a0 \u00a0\u00a0 \u00a0 query.on( 'end', function( row, err ) {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 req.session.user = strUser; \/\/ \u30bb\u30c3\u30b7\u30e7\u30f3\u306b\u4fdd\u5b58<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 res.render('loginchk', {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 title : '\u30ed\u30b0\u30a4\u30f3\u6210\u529f\u753b\u9762',<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 content: 'login',<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 user : strUser,<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 pass : strPass<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 });<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 });<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 query.on( 'error', function( error ){<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 res.render('loginchk', {<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 title : '\u30ed\u30b0\u30a4\u30f3\u4e0d\u6210\u529f\u753b\u9762',<\/code>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0content: 'login',<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 user : strUser,<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 pass : strPass<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0\u00a0 \u00a0 });<\/code>
\n \u00a0 \u00a0\u00a0 \u00a0 });<\/code>
\n \u00a0 \u00a0 });<\/code>
\n});<\/code><\/p>\n

module.exports = router;<\/code><\/p>\n