Week 11 Crossover- Yajat and Devam

[yajatyadav]

Crossover grading for Yajat and Devam

[yajatyadav]

Individual PBL Final - Yajat Yadav Video displaying functionality/code

Feature: College Database, Spotify API for Calming Music Commits: All by me Wiki ideas/planning: Wiki page on Database+Calming Music Final code in project:

• Music, View

• Database, View

[devamshri]

Team Grading

• [x] PBL GitHub Pages, Jekyll, Wiki

Our PBL theme, idea, and style is consistent on every page including the about page. We use the same bootstrap and SCSS to style the page, so they are all similar looking.

We implemented SCSS and Bootstrap, which can be linked in the stylesheet tag of the HTML head, as seen in most of our HTML pages.

The database is complete and functioning as seen in the food rating system MVC feature.

The deployment is actively working at http://dnhslunchline.tk/. Steps to deployment can be seen on the wiki.

We have many async operations using the axios library of Javascript. Details are outlined on the wiki.

• [x] Runtime features

Our best features include a lunch line wait time tracker, a food rating system, a menu filter tool, etc.

Our scrum board is clean, organized, complete with issues that have assignees and labels, and sectioned based on the status of the ticket.

We implement MVC (model, view, controller) in our wait time feature which uses a model that uses an algorithm to generate the wait time, a view that displays those wait times on the frontend as well as uses async operations to fetch the backend data, and a controller that runs the Java class and integrates the backend with the frontend.

We use SQL database code in our food rating system feature, which stores user-entered data into a database, then fetches that data to the frontend to be displayed in the HTML.

We have a search bar that connects to the Google search engine implemented into our navbar at the top of every page.

• [x] Clarity and quality of finding information

Everything is outlined on this review ticket as well as organized with tables and diverse markdown on our wiki here.

Individual Grading

• [x] One PBL MVC feature (per pair)

My MVC feature was a CRUD Database or food rating as well as a search bar.

• [x] Individual commits in JS and/or Java

My commits: Search Bar, More Search Bar, Database

• [x] Wiki with design and usage

I added information to the wiki here regarding the CRUD Database.

• [x] Final program code

This is the code: Frontend - rating.html, ratingcreate.html, rating_search.html, ratingupdate.html

Backend - Rating.java, RatingController, RatingJpaRepository, RatingSqlRepository

Database + CRUD Operations

Frontend - rating.html, ratingcreate.html, rating_search.html, ratingupdate.html

Backend - Rating.java, RatingController, RatingJpaRepository, RatingSqlRepository

public  List<Rating>listLikeNative(String term) {
String like_term = String.format("%%%s%%",term);  // Like required % rappers
return jpa.findByLikeTermNative(like_term);
}

public void save(Rating rating) {
    jpa.save(rating);
}

public Rating get(long id) {
    return (jpa.findById(id).isPresent())
            ? jpa.findById(id).get()
            : null;
}

public void delete(long id) {
    scrum_team_jpa.member_deleted(id);
    jpa.deleteById(id);
}

[On The Runtime](https://dnhslunchline.tk/database/person)