stevehanstudio/productivity-app-backend

My Producivity App (Backend)

This project is the backend API service for My Productivity App project. This project is built with Maven, Java, Spring Boot and MySQL and documented with OpenAPI v3. Visit the source repository for the frontend for a description, backstory, and user interface on this project.

Feature Specification

Create and manage projects and tasks. Dashboard

• Task Projects have can be viewed in 3 ways
• Table View
• Calendar View
• Board View (i.e. Kabana board)

Project Folder Structure

├── backend
│   ├── .mvn
│   │    └── wrapper
│   │        └──
│   ├── .vscode
│   │    └── settings.json # VS Code settings


│   ├── index.css # Global styles.
│   ├── index.tsx # Used for DOM rendering only.
│   ├── react-app-env.d.ts # .
│   ├── reportWebVitals.ts # .
│   ├── setupTests.ts # .
│   └── types.ts # Typescript types definitions for the project.
├── .gitignore # Files ignored by Git.
├── README.md # This file.
├── package.json # npm package manager file.
├── package-lock.json # Contains the dependencies used in the project.
├── postcss-config.json # .
├── tailwind.config.js # Tailwind CSS configuration file.
└── tsconfig.json # Typescript configuration file.

API Documentation

Link to OpenAPI definition

Known Issues

TBD

Future Todos

Resources

Backend (Spring Boot, Java, PostgreSQL, AWS, ...)

• The Complete Java Development Bootcamp (Udemy). This course was great in helping me learn the basics of Java within a week.

• The Complete Spring Boot Development Bootcamp (Udemy). This course was great in helping me learn the basics of Spring Boot within a week.

• Spring Boot in Practice (Amazon)

• Difference Between java.util.Date and java.sql.Date in Java

• Repository not extending JpaRepository

• VS Code message: org.springframework.stereotype.Repository. Unnecessary @Repositoryvscode-spring-boot(JAVA_REPOSITORY) (Stackoverflow)

• Storing tags in MySQL database (Quora)

• A Simple Tagging Implementation with JPA (Baeldung)

• An Advanced Tagging Implementation with JPA (Baeldung)

• Error calling jakarta.validation.Validation#buildDefaultValidatorFactory (Stackoverflow)

• @RequiredArgsConstructor and @NoArgsConstructor annotation errors - Duplicate method Project() in type Project (Stackoverflow)

• Hibernate: "Field 'id' doesn't have a default value"

• MySQL Disable Foreign Key Checks. I made a schema change and could not drop a table due to a foreign key. After running the SQL command SET foreign_key_checks = 0;, I could drop the table.

• Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver' [duplicate] (Stackoverflow) I was getting the message: Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. I resolved it by changing the application.properties from spring.datasource.driver-class-name=com.mysql.jdbc.Driver to spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver.

• Spring h2 database error when trying to save (Stackoverflow) I was getting the error message: java.lang.NullPointerException: Cannot invoke "com.stevehanstudio.productivity.service.ProjectService.createProject(com.stevehanstudio.productivity.entity.Project)" because "this.projectService" is null. The person that posted Stackoverflow he resolved his issue by adding @autowired to the controller. In my case I resolved it by adding @AllArgsConstructor to the service.

• Open API V2 documentation. Open API documentation for OpenAPI 3, Spring Boot v3 with Java 17 and Jakarta EE 9.