2025-05-18T23:06:38.152Z INFO 4760 --- [psyceful_api] [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [com.psyceful.psyceful_api.integration.PractitionerControllerTests]: PractitionerControllerTests does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-05-18T23:06:38.163Z INFO 4760 --- [psyceful_api] [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration com.psyceful.psyceful_api.PsycefulApiApplication for test class com.psyceful.psyceful_api.integration.PractitionerControllerTests
2025-05-18T23:06:38.197Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:38.197Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:38.200Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 3 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
count(*)
from
practitioners p1_0
Hibernate:
select
count(*)
from
users u1_0
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:39.194Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:39.196Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:39.201Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 4 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
t1_0.id,
t1_0.created_at,
t1_0.expire_at,
t1_0.token,
t1_0.type,
t1_0.user_id,
t1_0.validate_at
from
tokens t1_0
where
t1_0.token=?
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
r1_0.users_id,
r1_1.id,
r1_1.name,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
left join
users_roles r1_0
on u1_0.id=r1_0.users_id
left join
roles r1_1
on r1_1.id=r1_0.roles_id
where
u1_0.id=?
order by
r1_1.name desc
Hibernate:
update
users
set
activated=?,
created_at=?,
email=?,
enabled=?,
firstname=?,
lastname=?,
password=?,
updated_at=?
where
id=?
Hibernate:
update
tokens
set
created_at=?,
expire_at=?,
token=?,
type=?,
user_id=?,
validate_at=?
where
id=?
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:39.802Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:39.803Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:39.806Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 3 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:40.394Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:40.396Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:40.400Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 3 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
update
users
set
activated=?,
created_at=?,
email=?,
enabled=?,
firstname=?,
lastname=?,
password=?,
updated_at=?
where
id=?
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
count(*)
from
practitioners p1_0
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:40.928Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:40.930Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:40.935Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 5 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
2025-05-18T23:06:41.263Z DEBUG 4760 --- [psyceful_api] [ Test worker] horizationManagerBeforeMethodInterceptor : Authorizing method invocation ReflectiveMethodInvocation: public org.springframework.http.ResponseEntity com.psyceful.psyceful_api.www.PractitionerController.getPractitioner(); target is of class [com.psyceful.psyceful_api.www.PractitionerController]
2025-05-18T23:06:41.368Z DEBUG 4760 --- [psyceful_api] [ Test worker] horizationManagerBeforeMethodInterceptor : Authorized method invocation ReflectiveMethodInvocation: public org.springframework.http.ResponseEntity com.psyceful.psyceful_api.www.PractitionerController.getPractitioner(); target is of class [com.psyceful.psyceful_api.www.PractitionerController]
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:41.476Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:41.478Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:41.486Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 8 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:41.845Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:41.847Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:41.850Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 3 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
r1_0.users_id,
r1_1.id,
r1_1.name,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
left join
users_roles r1_0
on p1_1.id=r1_0.users_id
left join
roles r1_1
on r1_1.id=r1_0.roles_id
where
p1_0.id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.practitioners_id,
p1_1.id,
p1_2.activated,
p1_2.created_at,
p1_2.email,
p1_2.enabled,
p1_2.firstname,
p1_2.lastname,
p1_2.password,
r1_0.users_id,
r1_1.id,
r1_1.name,
p1_2.updated_at
from
practitioners_patients p1_0
join
patients p1_1
on p1_1.id=p1_0.patients_id
join
users p1_2
on p1_1.id=p1_2.id
left join
users_roles r1_0
on p1_2.id=r1_0.users_id
left join
roles r1_1
on r1_1.id=r1_0.roles_id
where
p1_0.practitioners_id=?
order by
r1_1.name desc,
p1_2.lastname desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
r1_0.users_id,
r1_1.id,
r1_1.name,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
left join
users_roles r1_0
on p1_1.id=r1_0.users_id
left join
roles r1_1
on r1_1.id=r1_0.roles_id
where
p1_0.id=?
order by
r1_1.name desc
Hibernate:
insert
into
practitioners_patients
(practitioners_id, patients_id)
values
(?, ?)
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p2_1.id,
p2_2.activated,
p2_2.created_at,
p2_2.email,
p2_2.enabled,
p2_2.firstname,
p2_2.lastname,
p2_2.password,
p2_2.updated_at
from
practitioners p1_0
join
practitioners_patients p2_0
on p1_0.id=p2_0.practitioners_id
join
patients p2_1
on p2_1.id=p2_0.patients_id
join
users p2_2
on p2_1.id=p2_2.id
where
p1_0.id=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?
2025-05-18T23:06:42.462Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.b.t.m.w.SpringBootMockServletContext : Initializing Spring TestDispatcherServlet ''
2025-05-18T23:06:42.464Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Initializing Servlet ''
2025-05-18T23:06:42.468Z INFO 4760 --- [psyceful_api] [ Test worker] o.s.t.web.servlet.TestDispatcherServlet : Completed initialization in 2 ms
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
practitioners
(id)
values
(?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
insert
into
tokens
(created_at, expire_at, token, type, user_id, validate_at, id)
values
(?, ?, ?, ?, ?, ?, ?)
Hibernate:
select
u1_0.id,
case
when u1_1.id is not null
then 1
when u1_2.id is not null
then 2
when u1_0.id is not null
then 0
end,
u1_0.activated,
u1_0.created_at,
u1_0.email,
u1_0.enabled,
u1_0.firstname,
u1_0.lastname,
u1_0.password,
u1_0.updated_at
from
users u1_0
left join
patients u1_1
on u1_0.id=u1_1.id
left join
practitioners u1_2
on u1_0.id=u1_2.id
where
u1_0.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.id,
r1_0.name
from
roles r1_0
where
r1_0.name=?
Hibernate:
select
p1_0.practitioners_id,
p1_1.id,
p1_2.activated,
p1_2.created_at,
p1_2.email,
p1_2.enabled,
p1_2.firstname,
p1_2.lastname,
p1_2.password,
r1_0.users_id,
r1_1.id,
r1_1.name,
p1_2.updated_at
from
practitioners_patients p1_0
join
patients p1_1
on p1_1.id=p1_0.patients_id
join
users p1_2
on p1_1.id=p1_2.id
left join
users_roles r1_0
on p1_2.id=r1_0.users_id
left join
roles r1_1
on r1_1.id=r1_0.roles_id
where
p1_0.practitioners_id=?
order by
r1_1.name desc,
p1_2.lastname desc
Hibernate:
insert
into
users
(activated, created_at, email, enabled, firstname, lastname, password, updated_at, id)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
patients
(id)
values
(?)
Hibernate:
insert
into
practitioners_patients
(practitioners_id, patients_id)
values
(?, ?)
Hibernate:
insert
into
users_roles
(users_id, roles_id)
values
(?, ?)
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
patients p1_0
join
users p1_1
on p1_0.id=p1_1.id
where
p1_1.email=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p2_1.id,
p2_2.activated,
p2_2.created_at,
p2_2.email,
p2_2.enabled,
p2_2.firstname,
p2_2.lastname,
p2_2.password,
p2_2.updated_at
from
practitioners p1_0
join
practitioners_patients p2_0
on p1_0.id=p2_0.practitioners_id
join
patients p2_1
on p2_1.id=p2_0.patients_id
join
users p2_2
on p2_1.id=p2_2.id
where
p1_0.id=?
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
select
p1_0.id,
p1_1.activated,
p1_1.created_at,
p1_1.email,
p1_1.enabled,
p1_1.firstname,
p1_1.lastname,
p1_1.password,
p1_1.updated_at
from
practitioners p1_0
join
users p1_1
on p1_0.id=p1_1.id
Hibernate:
select
r1_0.users_id,
r1_1.id,
r1_1.name
from
users_roles r1_0
join
roles r1_1
on r1_1.id=r1_0.roles_id
where
r1_0.users_id=?
order by
r1_1.name desc
Hibernate:
delete
from
users_roles
where
users_id=?
Hibernate:
delete
from
practitioners_patients
where
practitioners_id=?
Hibernate:
delete
from
practitioners
where
id=?
Hibernate:
delete
from
users
where
id=?