University: San Jose State University
Course: Enterprise Software - Computer Engineering 172 / Spring 2020
Team Members: Sophie Chen, Stefan Do, Janice Lu
Grocery Store Owners often don't realize that the most valuable information they have is right in front of them, their customers and their shopping habits. Grocery stores already keep track of their inventory but often do not utilize this information to make better informed decisions to improve their stores.
Grocery Analytics aims to solve this problem. By utilizing the data that grocery stores collect, like store traffic and inventory sold, Grocery Analytics helps grocery store owners and employees to make decisions for their business that's backed by data.
Store Traffic Screen - Monthly
- Docker Desktop and Docker Account
- MySQL Workbench
- Suggested: GitHub Desktop
- Option 1: Use Command Line or Terminal to clone project into desired folder
git clone https://github.com/JaniceLu/cmpe172_project.git
- Option 2: Go to https://github.com/JaniceLu/cmpe172_project and click on "Clone or download" (requires GitHub Desktop installed or download the zip and place in desired folder)
Create database using this command in MySQL Workbench:
Create database store;
Configure application.properties file to match your database and credentials:
spring.jpa.hibernate.ddl-auto = create
spring.datasource.url = jdbc:mysql://${MYSQL_HOST:localhost}:3306/YOUR_DATABASE_NAME
spring.datasource.username = YOUR_USERNAME
spring.datasource.password = YOUR_PASSWORD
Navigate to the folder that you cloned the project into then run this command:
./gradlew bootRun
- Make sure that this can run successfully and check localhost/8080
- Make sure that the database and its tables have been successfully created
- Stop the localhost (CTRL+C, choose Y to end process)
- Go to MySQL Workbench and import an appropriately formatted CSV file for each table
All queries are handled through Spring Boot JPA (CRUD repositories) and Thymeleaf's templates.
All parts of this project are free to use under the open-source MIT license.