var express = require('express');
var app = express();
var bodyParser = require("body-parser");
var mysql      = require('mysql');
var multer = require("multer");
var fs = require("fs");
var namefile;
var connection = mysql.createConnection({
    host     : 'localhost',
      user     : 'root',
    password : 'root',
    database : 'vafood'
});
var storageOfPizza = multer.diskStorage({
    destination: function(req, file, cb) {
        cb(null, './public/img/Pizza/')
    },
    filename: function(req, file, cb) {
        cb(null, file.originalname);
        namefile = "img/pizza/" + file.originalname;
    }
});

var storageOfPaste = multer.diskStorage({
    destination: function(req, file, cb) {
        cb(null, './public/img/paste/')
    },
    filename: function(req, file, cb) {
        cb(null, file.originalname);
        namefile = "img/paste/" + file.originalname;
    }
});

var storageOfRisotto = multer.diskStorage({
    destination: function(req, file, cb) {
        cb(null, './public/img/risotto/')
    },
    filename: function(req, file, cb) {
        cb(null, file.originalname);
        namefile = "img/risotto/" + file.originalname;
    }
});

var storageOfDessert = multer.diskStorage({
    destination: function(req, file, cb) {
        cb(null, './public/img/dessert/')
    },
    filename: function(req, file, cb) {
        cb(null, file.originalname);
        namefile = "img/dessert/" + file.originalname;
    }
});
var uploadPizza = multer({ storage: storageOfPizza });
var uploadPaste = multer({ storage: storageOfPaste });
var uploadRisotto = multer({ storage: storageOfRisotto });
var uploadDessert = multer({ storage: storageOfDessert });
app.use(bodyParser.urlencoded({ extended: false }));
app.use("/", express.static("public"));
app.use(bodyParser.urlencoded({ extended: false }));
app.listen(3000);
console.log('server is start');