server.js

var http = require('http');
var express = require('express');
var mysql = require('mysql');
var bcrypt = require('bcryptjs');
var fs = require('fs');
//var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var path = require('path');

var app = express();

var connection = mysql.createPool({
    host: 'bgabgb3vi-mysql.services.clever-cloud.com',
    user: 'uawpqbdrl3llqjpt',
    password: 'Dlff4WOTqvDqpTfu3a5',
	database: "bgabgb3vi"
});
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(function (req,res,next) {

    res.header("Access-Control-Allow-Origin","*");
    res.header('Access-Control-Allow-Methods','POST,GET,PUT,DELETE,OPTIONS');
    res.header("Access-Control-Allow-Headers","X-Requested-With,X-HTTP-Methods-Override,Content-Type,Accept,Cache-Control, Pragma, Origin,Authorization, Content-Type");
    res.header("Access-Control-Allow-Credentials","true");
    if ('OPTIONS' == req.method){
        return res.sendStatus(200);
    }
    next();
});

/*function handleDisconnected()
{
	connection.createPool(function(err){
		if(err)
		{
			console.log('error when connecting to db:', err);
			connection.connect();
			setTimeout(handleDisconnected, 2000);
		}
	});
	
	connection.on('error', function(err) {
		console.log('db error', err);
		if(err.code == 'PROTOCOL_CONNECTION_LOST') { 
		  handleDisconnected();                         
		}
		//else if(err.code == 'PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR')
		//{
		//	connection.connect();
		//}
		else{                                      
		  throw err;                                  
		}
	});
}
handleDisconnected();*/

require("./routes/tblUser")(app);
require("./routes/tblAkun")(app);
require("./routes/tblJurnal")(app);
require("./routes/test")(app);

app.get("/",function(req,res){
	res.json("berhasil");
});


var server_port = process.env.OPENSHIFT_NODEJS_PORT || 8080;
var server_ip_address = process.env.OPENSHIFT_NODEJS_IP || '0.0.0.0';

//app.listen(3100);
//console.log("port web service : 3100");

app.listen(server_port, server_ip_address, function () {
  console.log( "Listening on " + server_ip_address + ", port " + server_port )
});
//app.listen(server_port);


app.use(express.static(path.join(__dirname, 'public')));

process.on('uncaughtException', (err) => {
  fs.writeSync(1, 'Caught exception: '+err+'\n');
});


setTimeout(() => {
  console.log('This will still run.');
}, 500);

//nonexistentFunc();


module.exports = app;