verify.js

const { MongoClient } = require('mongodb');
const fs = require('fs');

const url = 'mongodb://localhost:27017';
const client = new MongoClient(url);

async function main() {
  try {
    await client.connect();
    const db = client.db('assignment4_db');
    const collection = db.collection('restaurants');

    // Read and parse the local restaurants.json file
    const rawData = fs.readFileSync('restaurants.json', 'utf8');
    const restaurantData = JSON.parse(rawData);

    // Clear old data and insert the fresh sample data
    await collection.deleteMany({});
    await collection.insertMany(restaurantData);
    console.log('Successfully loaded restaurant data into MongoDB!');

    // --- Practice Queries Area ---
    // Example Query: Find all restaurants in Brooklyn
    const brooklynRestos = await collection.find({ borough: 'Brooklyn' }).toArray();
    console.log('\nPractice Query Result (Restaurants in Brooklyn):');
    console.log(brooklynRestos.map(r => r.name));

  } catch (error) {
    console.error('Error:', error);
  } finally {
    await client.close();
  }
}

main();