Aggregate Total Market Value for MongoDB Trigger [WIP]

[zorazrr]

Summary

WIP Aggregate investment total market value information for faster data fetching on landing page.

• [ ] To-do: Add trigger in MongoDB
• [ ] To-do: Handle case where the data already exists and we are doing an update rather than create

Notes

Open to changes:

• Chose to save the query in this repo rather than having it in the trigger and invoking this as an API endpoint, this way we keep mostly monorepo
• Chose to add a year parameter, just in case we want to have a year toggle in the future
• The MongoDB trigger roughly looks like (need to configure some more details)

exports = function() {
  const axios = require('axios').default;

  axios.get({
      url: "insert_url",
      params: {
        input: {"0": {"json": {"year": 2022}}}
      }
    })
    .then(function (response) {
      console.log(response);
    })
    .catch(function (error) {
      console.log(error);
    });
};

Changes

• Added aggregation query
• Added new fetch data query (should probably delete the old one as well)
• Added new schema

model AggregatedTotalMarketVal {
  id             String @id @default(auto()) @map("_id") @db.ObjectId
  sector         Sector
  totalMarketVal Float
  year           Int?
}

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Updated (UTC)
toriis	✅ Ready (Inspect)	Visit Preview	Jul 13, 2023 5:27am

[kennykos]

Additions

• [ ] Remake the trigger to create a collection based of net asset val per company per year
• [ ] Create prisma enum for year
• [ ] Get rid of null for year