Drugbox - Backend

Our project is a service that assists in the management of various pharmaceuticals within households and helps properly dispose of expired medications.

We provide guidelines for managing the inventory and expiration dates of over-the-counter and prescription medicines, as well as instructions on how to dispose of waste pharmaceuticals according to prescribed methods.

By utilizing this service, we aim to address various issues caused by improper disposal methods and, ultimately, reduce unnecessary consumption of pharmaceuticals to promote the well-being and health of individuals and the environment.

✔️ How to Start

1) Prerequisites

• Java 11
• IntelliJ IDEA or eclipse
• MySQL
• Redis

2) Clone

Clone this repo to your local machine using:

git clone https://github.com/2024-Google-Solution-Challenge-Team5/Backend.git

3) Setup

resources folder structure

• Add application.properties in resources

  • Fill in the blank space after the equal sign with your own words

  • application.properties

    # database
    application.spring.datasource.url=jdbc:mysql://localhost:3306/drugbox?createDatabaseIfNotExist=true&characterEncoding=UTF-8
    application.spring.datasource.username=
    application.spring.datasource.password=
    
    # GCP
    application.spring.cloud.gcp.storage.credentials.location=classpath:google-cloud.json
    application.spring.cloud.gcp.storage.project-id=
    application.spring.cloud.gcp.storage.bucket=
    application.spring.cloud.gcp.geocodingAPI=
    
    # Oauth - 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=http://localhost:8080/auth/redirect/google
    
    # Drug Database
    application.spring.api.url=http://apis.data.go.kr/1471000/DrbEasyDrugInfoService/getDrbEasyDrugList
    application.spring.api.key=rsbkswEZaOZIDED3uNDy6FGvvXfmixuSLvKgzRWPIrzgqRjyHrYOrMnuNdh00HkHnBnqYOwpDjlqiklnucfJog%3D%3D
    
    # jwt 
    application.jwt.secret=
    application.jwt.secret_refresh=
    application.jwt.access_token.duration=
    application.jwt.refresh_token.duration=
    
    # redis
    spring.data.redis.host=localhost
    spring.data.redis.port=6379
    
    

• Add seoul.geojson and drugbin.CSV in resources

  • seoul.geojson (zip file)

  • drugbin.CSV

  • Note: This service currently only provides the locations of pharmaceutical waste collection bins in some regions of South Korea. Since we are retrieving the locations of pharmaceutical waste collection bins using an open API, exceeding the daily quota of requests may result in access restrictions.

• Add google-cloud.json in resources
  • Private key issued by GCP (If you don't want to use image-related APIs, it's okay to just create a file and leave the file content empty)

• Add google-oauth.json in resources
  • private key from GCP for google login

• Create a database called drugbox in MySQL
• Change the value of the ddl-auto variable inside application.yml to create only on the first execution.
• Run DrugboxApplication

🛠 Tech Stacks

• Gradle
• Spring Boot 2.7.5
• Spring Data JPA
• Spring Security
• GCP : Google Compute Engine, Google Cloud Storage, Google Cloud SQL
• JWT
• MySQL
• Redis

📽 Demo Video

Youtube Link

👥 Contributors

• Bomin Kwon
• Miju Kim

📎 Link

• Mobile Repository
• AI Repository