Changeset e9a0543 for backend

Timestamp:

05/05/26 17:55:27 (2 months ago)

Author:

Andrej <asumanovski@…>

Branches:

master

Children:

b3d5fed

Parents:

4f85b41

Message:

Custom tracking category feature complete

Location:

backend/src/main

Files:

• java/com/trekr/backend/controller/CustomTrackingController.java (added)
• java/com/trekr/backend/dto/discipline/CreateCustomTrackingCategoryRequest.java (added)
• java/com/trekr/backend/dto/discipline/CustomTrackingCategoriesResponse.java (added)
• java/com/trekr/backend/dto/discipline/CustomTrackingCategoryDto.java (added)
• java/com/trekr/backend/repository/CustomTrackingCategoryRepository.java (added)
• java/com/trekr/backend/repository/TaskRepository.java (modified) (1 diff)
• java/com/trekr/backend/service/CustomTrackingService.java (added)
• java/com/trekr/backend/service/DisciplineService.java (modified) (1 diff)
• resources/application.properties (modified) (1 diff)

backend/src/main/java/com/trekr/backend/repository/TaskRepository.java

@@ -23 +23 @@
     List<Task> findByDisciplineUser_UserIdAndFinishedTrue(Long userId);
 
+    List<Task> findByCustomTrackingCategory_CustomTrackingIdAndCustomTrackingCategory_User_UserIdOrderByTaskIdDesc(
+            Long customTrackingId, Long userId);
+
+    int deleteByTaskIdAndCustomTrackingCategory_CustomTrackingIdAndCustomTrackingCategory_User_UserId(
+            Long taskId, Long customTrackingId, Long userId);
+
     @Modifying
     @Query("update Task t set t.finished = false where t.disciplineUser.userId = :userId")

backend/src/main/java/com/trekr/backend/service/DisciplineService.java

@@ -52 +52 @@
     }
 
+
     public boolean isTracking(Long userId) {
         return disciplineUserRepository.existsById(userId);

backend/src/main/resources/application.properties

@@ -42 +42 @@
 # ============================
 spring.datasource.hikari.pool-name=trekrHikariPool
-spring.datasource.hikari.maximum-pool-size=20
-spring.datasource.hikari.minimum-idle=5
+# Remote PostgreSQL (especially via SSH tunnel) often has a small max_connections.
+# Use conservative defaults to avoid exhausting connection slots; override via env if needed.
+spring.datasource.hikari.maximum-pool-size=${SPRING_DATASOURCE_HIKARI_MAX_POOL_SIZE:4}
+spring.datasource.hikari.minimum-idle=${SPRING_DATASOURCE_HIKARI_MIN_IDLE:0}
 spring.datasource.hikari.connection-timeout=30000
 spring.datasource.hikari.idle-timeout=600000