kukicado / building-modern-app-with-nextjs-and-mongodb Goto Github PK

if(date){
    doc = await req.db.collection('daily').findOne({date: new Date(date)})
  } else {
    doc = await req.db.collection('daily').findOne()
  }

if(date){
    doc = await req.db.collection('daily').findOne({date: new Date(date).toJSON()})
  } else {
    doc = await req.db.collection('daily').findOne()
  }

import nextConnect from 'next-connect';

const client = new MongoClient('mongodb+srv://username:[email protected]/?retryWrites=true&w=majority',
{
  useNewUrlParser: true,
  useUnifiedTopology: true,
});

async function database(req, res, next) {
  if (!client.isConnected()) await client.connect();
  req.dbClient = client;
  req.db = client.db('cercleSport');
  return next();
}

const middleware = nextConnect();

middleware.use(database);

export default middleware;```
------------------------------------------------------------+
------------------------------------------------------------+
One of my api endpoints 
pages/api/fetchallgames
//
```import nextConnect from 'next-connect';
import middleware from '@/middleware/database';

const handler = nextConnect();

handler.use(middleware);

handler.post(async (req, res) => {
    // Convert the object back to a JSON string;
    const league = req.body.league;
    const division = req.body.division;
    const fieldString = "${league}.${division}.games";
    let projectionObject = {_id: 0};
    projectionObject[fieldString] = 1;
    let doc = await req.db.collection('24').findOne({}, { projection: projectionObject });
    let games = doc[league][division].games;
    return res.status(200).json(games);
});

export default handler;```