dscnitrourkela / project-avocado-web Goto Github PK

This will help in the time of the beginning of a new academic year.

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:

• 1 - Fetch previous events
• 2 - Fetch current events
• 3 - Fetch upcoming events

Use google sheets as a database to store the data.

• Schema:

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

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

• Currently, the PrefectType can display the coordinator related with the particular prefect. A similar thing is to be done with CoordinatorType. Add a field to display the corresponding prefect.

Describe the solution you'd like

• Add a field in the Coordinator Schema to store prefect id.
• In the Coordinator field use this prefect id to fetch the prefect details

Describe the bug

• While creating a new user (be that any of the 4 types), the user is directly saved to the database without checking if there exists a previous user with same details.

Expected behavior

• Before saving to the database, checks should be made to see if an existing user with the same Roll Number exists or not. If not, proceed with saving. If yes throw an error.

• Currently all the types, root queries, mutations are placed inside a single schema.js file.
• Separate this file into 3 different files for queries, mutations, types respectively.
• Import all three files inside Schema.js and export the GraphQLSchema from here itself.

Currently, the mentor query just returns the prefect ID. Requires modification to get the prefect details in the mentor query. Use the prefect ID to query the prefects collection and get the prefect details.

APIs for the following functionalities are required for the admin panel:

• Add/Edit/Remove Coordinator
• Add/Edit/Remove Prefect
• Add/Edit/Remove Mentor
• Add/Edit/Remove Mentee