Crews - Spring Server

This Spring server provides basic authentication functionality using Spring Security, but does not include role-based access control.

Tech Stack

Member Functionality

• User CRUD: Users can perform CRUD (Create, Read, Update, Delete) operations based on their email.

• Social Sign In/Sign Up: Users can sign in or sign up using Google or Kakao accounts.

• Favorite Team and Player: Users can set and manage their favorite team and player preferences.

Sports Data Management

This server integrates with the Sofascore API to build and manage sports-related data.

Link for Sofascore API

Sports Data Structure

• Sports: Includes sports categories fetched from Sofascore API.

• Category (Region): Represents different regions or categories of sports.

• Tournaments (League): Contains information about various tournaments fetched from Sofascore API.

• Seasons: Represents different seasons within tournaments.

• Teams: Includes teams participating in tournaments.

• Players: Contains player information, including stats and photos.

• Managers: Stores data and statistics related to team managers.

• Games: Provides schedules and match information for teams.

• Logo and Photo: Stores logos for teams and photos for players.

CRUD Operations

This server supports CRUD operations for managing sports data, including Sports, Category, Tournaments, Seasons, Teams, Players, Managers, Games, Logos, and Photos.

Integration with ML Server

• OpenFeign Client: Integrates with an ML server to fetch news articles related to biased teams.

Biased Team Features

• News Analysis: Retrieves news articles related to biased teams, categorizing them as positive or negative.

• Social Media Data: Fetches social media data related to biased teams.

• Web Community Data: Gathers data from web communities discussing biased teams, categorizing sentiment as positive or negative.

• Keyword Extraction: Extracts keywords associated with biased teams.

• Podcasts: Retrieves podcasts discussing biased teams.

---

ERD

---

API Instructions

https://documenter.getpostman.com/view/27284208/2s9Y5Wy4JW

---

application.properties

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.url=

spring.datasource.username=

spring.datasource.password=

JPA Setting

spring.jpa.hibernate.ddl-auto=update

spring.jpa.properties.hibernate.format_sql=true

jwt.secretKey=

google

spring.security.oauth2.client.registration.google.client-name=google

spring.security.oauth2.client.registration.google.client-id=

spring.security.oauth2.client.registration.google.client-secret =

spring.security.oauth2.client.registration.google.redirect-uri =

token-uri=https://oauth2.googleapis.com/token

resource-uri=https://www.googleapis.com/oauth2/v2/userinfo

kakao

spring.security.oauth2.client.registration.kakao.client-name=kakao

spring.security.oauth2.client.registration.kakao.client-id =

spring.security.oauth2.client.registration.kakao.client-secret =

spring.security.oauth2.client.registration.kakao.redirect-uri=

spring.security.oauth2.client.registration.kakao.authorization-grant-type=authorization_code

spring.security.oauth2.client.registration.kakao.scope=profile,account_email

spring.security.oauth2.client.registration.kakao.client-authentication-method=POST

spring.security.oauth2.client.provider.kakao.authorization-uri=https://kauth.kakao.com/oauth/authorize

spring.security.oauth2.client.provider.kakao.token-uri=https://kauth.kakao.com/oauth/token

spring.security.oauth2.client.provider.kakao.user-info-uri=https://kapi.kakao.com/v2/user/me

spring.security.oauth2.client.provider.kakao.user-name-attribute=id

logging.level.com.team1.finalproject.feign= Debug

feign

feign.test.url=

prometheus

management.endpoints.web.exposure.include=health, info, metrics, prometheus

management.endpoint.metrics.enabled=true

management.endpoint.prometheus.enabled=true

SofaSport API

SofaSport_Host = sofasport.p.rapidapi.com

SofaSport_Key_1 =

SofaSport_Key_2 =

SofaSport_Key_3 =

---

System Architecture