Globik · October 21, 2016 16:20 · Oct 21, 2016
diff --git a/server.js b/server.js
@@ -0,0 +1,71 @@
+'use strict';
+const koa=require('koa');
+const render=require('./libs/render.js');
+const path=require('path');
+var debug=module.exports=require('debug')('icon')
+debug('Hali halo debug!');
+var serve=require('koa-static');
+
+var bodyParser=require('koa-body');
+var Router=require('koa-router');
+var pg=require('pg');
+
+var config={
+database:'globi',
+host:'127.0.0.1',
+port:5432,
+max:10,
+idleTimeout:30000,
+user:'User'
+};
+
+var pool=new pg.Pool(config);
+pool.on('error',function(err,client){
+console.log(err.message,err.stack);
+});
+
+pool.on('connect',cl=>{
+	console.log('Connected!!!');
+	});
+pool.on('acquire',cl=>{
+	console.log('Acquired!!!');
+	});
+var app=koa();
+render(app,{});
+app.use(serve(__dirname+'/public'));
+app.use(bodyParser());
+var pub=new Router();
+pub.get('/',function *(){
+	//var client=yield pool.connect();
+	/*
+	// 10 times requests from the browser side and the postgresQL connection is down
+	//(if without client.release()
+try{
+var result=yield client.query('select*from comp');
+console.log('result: ',result.rows[0].age);
+}catch(e){console.log('err: ',e);this.body={'er':e};
+client.release();
+}
+finally{
+	console.log('finally ist da');
+client.release();
+this.body=this.render('main_page',{data:result.rows});
+}
+*/
+try{
+	// and this way is all ok. One connection to DB, and many other aqcuired events
+	//thinking, the Pool instance has got all needed stuff built-in for a node.js request and requests
+	var result=yield pool.query('select*from articles where id=4');
+	console.log('result: ',result.rows[0]);
+}catch(e){
+  console.log('e: ',e);
+//this.status=bla-bla and other stuff
+}
+finally{
+	this.body=this.render('main_page',{data:result.rows[0]});
+}
+});
+app.use(pub.routes());
+
+if(process.env.NODE_ENV === 'test'){module.exports=app.callback();}
+else{console.log('Server started: ',3000);app.listen(process.env.PORT || 3000);}