server.js

require('dotenv').config();
const express = require('express');
const mongoose = require('mongoose');
const fileUpload = require('express-fileupload');
const cors = require('cors');
const cookieParser = require('cookie-parser');
const xlsx = require('xlsx');
const app = express();
app.use(express.json());
app.use(cors());
app.use(cookieParser());
app.use(
  fileUpload({
    useTempFiles: true,
  })
);

const employeeTable = require('./models/user');

// Routes
app.use('/user', require('./routes/userRouter'));

app.get('/', (req, res) => {
  // let wb = xlsx.readFile('./data/data.json', { cellDates: true });
  // // const ws = wb.Sheets[wb.SheetNames[0]]; // get the first worksheet
  // // const data = xlsx.utils.sheet_to_json(ws);
  // // console.log(data);

  res.send('Welcome to Data Management');
});

// Connect to mongodb
const URI = process.env.MONGODB_URL;
mongoose.connect(
  URI,
  {
    useCreateIndex: true,
    useFindAndModify: false,
    useNewUrlParser: true,
    useUnifiedTopology: true,
  },
  (err) => {
    if (err) throw err;
    console.log('Connected to mongodb');
  }
);

const PORT = process.env.PORT || 5000;
app.listen(PORT, () => {
  console.log('Server is running on port', PORT);
});
//