restore-db.js

const { exec } = require('child_process');
const path = require('path');
const fs = require('fs');

const possiblePaths = [
  'C:\\Program Files\\MongoDB\\Server\\6.0\\bin',
  'C:\\Program Files\\MongoDB\\Server\\5.0\\bin',
  'C:\\Program Files\\MongoDB\\Server\\4.4\\bin',
  'C:\\Program Files\\MongoDB\\Tools\\100\\bin',
  'C:\\Program Files\\MongoDB\\Tools\\4.4\\bin'
];

let mongoRestorePath = null;
for (const binPath of possiblePaths) {
  if (fs.existsSync(path.join(binPath, 'mongorestore.exe'))) {
    mongoRestorePath = path.join(binPath, 'mongorestore.exe');
    break;
  }
}

if (!mongoRestorePath) {
  console.error('mongorestore.exe not found. Please install MongoDB or provide the correct path.');
  process.exit(1);
}

const backupPath = path.join(__dirname, 'backup');

const command = `"${mongoRestorePath}" "${backupPath}" --drop`;
console.log(`Running command: ${command}`);

exec(command, (error, stdout, stderr) => {
  if (error) {
    console.error(`Error: ${error.message}`);
    return;
  }
  if (stderr) {
    console.error(`Stderr: ${stderr}`);
    return;
  }
  console.log(`Stdout: ${stdout}`);
  console.log('Database restored successfully!');
});