UserServiceIntegrationTest

2025-05-07T01:51:31.773Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : select nextval('sleep_session_sequence')
2025-05-07T01:51:31.775Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:31.777Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.779Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.780Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.782Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.784Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.785Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.787Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.789Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.790Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.792Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.793Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL                        : select u1_0.public_id,u1_0.display_name from app_user u1_0 order by u1_0.public_id fetch first ? rows only
2025-05-07T01:51:31.793Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.795Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.796Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL                        : select count(u1_0.id) from app_user u1_0
2025-05-07T01:51:31.797Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.799Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.800Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE


2025-05-07T01:51:31.803Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL                        : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
  SELECT 1
  FROM sleep_session s
  WHERE s.user_id = u.id
  AND s.stop_time > ?
)
FOR NO KEY UPDATE