app.mysql.js

/**
 * Module dependencies.
 */
var express = require('express');
var path = require('path');
var favicon = require('serve-static');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var compression = require('compression');
var mongoose = require('mongoose');
var csrf = require("csurf");
var administration = require("./administration/app.mysql");
var fs = require('fs');

// Cấu hình MySQL
var mysqlConfig;
try {
    mysqlConfig = require('./admin-mysql-config');
    config = JSON.parse(fs.readFileSync(`${__dirname}/config.json`).toString());
} catch (e) {
    console.log('Error loading config files, using default config');
    mysqlConfig = {
        host: 'localhost',
        user: 'root',
        password: 'root',
        database: 'nat2010_news'
    };
    config = {
        port: 3017
    };
}
// Sử dụng các endpoint MySQL thay vì MongoDB
var newsEndpoint = require('./routes/newsEndpoint.mysql');
var galleryEndpoint = require('./routes/galleryEndpoint.mysql');
var interviewEndpoint = require('./routes/interviewEndpoint.mysql');
var documentEndpoint = require('./routes/documentEndpoint.mysql');

var app = express();

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded());
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use(function(req, res, next) {
  res.header("Access-Control-Allow-Origin", "*");
  res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
  next();
});

// Cấu hình CORS đầy đủ cho API
app.use(function(req, res, next) {
    res.header("Access-Control-Allow-Origin", "*");
    res.header("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS");
    res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept, Authorization");
    
    // Xử lý OPTIONS request
    if (req.method === 'OPTIONS') {
        return res.status(200).end();
    }
    next();
});

// Tạm thời tắt CSRF để giải quyết vấn đề invalid csrf token
// app.use("/administration/rest/*", csrf({
//     cookie: true
// }));

// Set CSRF token cookie cho admin
app.use(function(req, res, next) {
    // if (req.path.startsWith('/administration/') && req.csrfToken) {
    //     res.cookie("csrf-token", req.csrfToken());
    // }
    next();
});

app.use('/rest/news', newsEndpoint);
app.use('/rest/gallery', galleryEndpoint);
app.use('/rest/interview', interviewEndpoint);
app.use('/rest/document', documentEndpoint);
var adminApp = require('./administration/app.mysql');
adminApp.init(app);

app.get("/*", function(req, res, next) {
    res.sendFile(path.join(__dirname, "public", "javascripts", "app", "index", "index.html"));
});

/// catch 404 and forward to error handler
app.use(function(req, res, next) {
    var err = new Error('Not Found');
    err.status = 404;
    next(err);
});

if (app.get('env') === 'development') {
    app.use(function(err, req, res, next) {
        res.status(err.status || 500);
        res.render('error', {
            message: err.message,
            error: err
        });
    });
}

// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
        message: err.message,
        error: {}
    });
});

// Khởi tạo module administration
administration.init(app);

// Xử lý route mặc định
app.get("/*", function(req, res, next){
    res.sendFile(__dirname + "/public/javascripts/app/index/index.html");
});

/// catch 404 and forward to error handler
app.use(function(req, res, next) {
    var err = new Error('Not Found');
    err.status = 404;
    next(err);
});

/// error handlers
// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    console.log(err.stack)
    res.send("");
});

// Khởi động server
app.listen(config.port || 3017);
console.log('Server started on port ' + (config.port || 3017));

module.exports = app;