eshaanagg / lfxmm-backend

Backend API and scripts to LFX Mentorship Metrics. Built in Go and PostgreSQL.

   

I'm Eshaan Aggarwal, a student, and developer from India. 🚀

• 💻 I am a Computer Science and Engineering undergraduate student at the Indian Institute of Technology BHU (Varanasi) pursuing a Bachelor of Technology in my second year.

• 🐱 I have a keen interest in Open Source.

• 📫 Reach me at [email protected]

• 📄 Take a look at my resume if you want to know what I have been upto lately!

My Skill Set

Frontend

Backend

DevOps

Connect with me

Github Stats

Recent Activity ⚡

1. 🗣 Commented on #1065 in sosy-lab/benchexec
2. 🗣 Commented on #5265 in karmada-io/karmada
3. 💪 Opened PR #5265 in karmada-io/karmada
4. 🗣 Commented on #1065 in sosy-lab/benchexec
5. 🗣 Commented on #1065 in sosy-lab/benchexec

lfxmm-backend's Issues

Searching Different Org/Projects directly

Creating end points /search for searching different orgs/project, adding search folder, accessing through the api for retreiving search results, with org[id], project [id] so that cards for that same search could be displayed, writing sql query for search orgs/projects by name

Create API endpoint for Project Details and modify response

• Currently there is no endpoint to get the details of a particular project under an organisation.
• Project details will include : Project name, description, apprentice needs, mentors and terms etc.
• The project details have already been scraped using this API: https://api.mentorship.lfx.linuxfoundation.org/projects/a8eddf2a-2b97-447a-90cc-7e8db0dab269
• Checkout /scrappers/projects/response.go for the response.
• Current Endpoints:

- instead of "projects", it should be "orgs".

• Create endpoint: router.GET("/api/orgs/:id/:projectId", getProjectDet)
• Add the subsequent handler : getProjectDet
• create a Sql query for projectResponse in response.go in scrappers/projects
• Edit current endpoints.
• Edit response from router.GET("/api/projects/:id", getOrg) to have projects listed year-wise.
  something like this:

Same Orgs Listed, TechStack Missing

ISSUE 1

Name of Orgs Same and Typo Error in One

ISSUE 2

Tech Stack not listed, in future writing scripts to scrap it

ISSUE 3

Removing this Organization, It was there to resolve issuesm, not to apply

@EshaanAgg

Showing detailed data for each project/org

Create routes for organisation

Change the name of the routes which calls the parent org handler function

GET api/orgs ==> hander getAllOrgs();

Graph representing the number of projects for a certain org

To be done:

• Create a graph component representing the number of projects per term/year for the frontend.
• Create a function for api response containing necessary data.
• Create a handler function to get the data from the database.

get the details of a particular organisation and to get the project associated with each term

1. for the home page:-
   Create a function to get the the orgs associated with each term from the database.

base api :- /api/orgs

filter example one :- orgs?year="2019"&term="fall"

for the projects page:-
create a handler function to apply crud operations on the details of a particular project .
for the filter component:-
create a schema of get all organisation api(for the following endpoint:/api/projects?year=2021&tech=html)

Changes for the model/schema of ParentOrg

Changes for the model of Org

properties tobe added -

{
description : "" , // write the each org description here
term : "" , // "fall" , "spring" , "winter"
year : Number , // "2019",
}

Increasing the fields of database on orgs

Managing and displaying project data with sql and query parameters

we can get list of all projects from API endpoint which is like /organization/[orgid]/projects.
Creating handler function to get data of all organizations and apply SQL select queries to retrieve data based on user-provided query parameters (e.g., category or organization). Then execute SQL queries, process the results, and pass them to your website's front end for rendering.
We can also collect info about mentors to create different space for mentors . For e.g https://api.mentorship.lfx.linuxfoundation.org/mentors , here we can collect all data and apply SQL select queries to filter it by user id.

Creating GET routes of orgs and projects

Projects List for individual Orgs

Creating an endpoint to retrieve projects within a specific organization. Structure our API endpoints like /organizations/[orgID]/projects
Executing a SQL query to retrieve projects that belong to that specific organization, in something like getProjectsfromOrg
Adding query parameters to our endpoint and modifying the SQL query

Creating API Endpoint and create a handler getProjectByOrg()

• For the PastProjectCard we need projects for a particular orgid, I think we should get all projects, at once, and then we can select based on year and term in browser. This will prevent multiple GET request and user would want to switch between projects based on year/term more frequently than between orgs. We need to register and end point /api/orgs/[orgID]/projects. And make SQL query