dscnitrourkela / project-avocado-web

The project repository of the admin panel of the mobile app for Institute Counselling Services, NIT Rourkela.
https://project-avocado-8b3e1.uc.r.appspot.com/graphql
MIT License
9 stars 21 forks source link

Create a query to fetch ICS events. #52

Open SriramPatibanda opened 3 years ago

SriramPatibanda commented 3 years ago

Is your feature request related to a problem? Please describe. No

Describe the solution you'd like Create a query that fetches takes any of the following integers as a parameter:

Use google sheets as a database to store the data.

Query Name Query Type
Event Name String
Event Time DateTime
Event Venue String
Event Description String

Additional context For reference of how to use google sheets as a database, you can refer to the following repo: https://github.com/DesignrKnight/sheets-api

DesignrKnight commented 3 years ago
  1. ICS database is already there on MongoDB, use Google Sheets only if the entire DB is getting switched to Sheets
  2. If you finish up Avenue API quick, which would not take much time especially the APIs, directly use that and query by organiser instead of creating something up from scratch

Note: Both comments are my opinions and not an instruction

SriramPatibanda commented 3 years ago
  1. ICS database is already there on MongoDB, use Google Sheets only if the entire DB is getting switched to Sheets
  2. If you finish up Avenue API quick, which would not take much time especially the APIs, directly use that and query by organiser instead of creating something up from scratch

Note: Both comments are my opinions and not an instruction

What I thought is that, if we use sheets as a db for this feature, it would be easier to add an event by just adding an entry in that sheet as we don't have an admin panel as of now.

But yeah, I do understand that it might not be a good practice to maintain data for a single app at many different places.

This is what I thought for short term unti an admin panel is made.

abhibhaw commented 3 years ago
  1. ICS database is already there on MongoDB, use Google Sheets only if the entire DB is getting switched to Sheets
  2. If you finish up Avenue API quick, which would not take much time especially the APIs, directly use that and query by organiser instead of creating something up from scratch

Note: Both comments are my opinions and not an instruction

We will follow the second suggestion as an instruction