Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
2025-10-15T16:35:27.376Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to query shopping cart with id = 0 of product with id = 15
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
2025-10-15T16:35:27.393Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to remove shopping cart with id = 0 from product with id = 16
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
2025-10-15T16:35:27.409Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to remove shopping cart with id = 49 from product with id = 17
2025-10-15T16:35:27.410Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Finishing process to remove shopping cart with id = 49 from product with id = 17
2025-10-15T16:35:27.410Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to remove shopping cart with id = 50 from product with id = 17
2025-10-15T16:35:27.410Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Finishing process to remove shopping cart with id = 50 from product with id = 17
2025-10-15T16:35:27.410Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to remove shopping cart with id = 51 from product with id = 17
2025-10-15T16:35:27.411Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Finishing process to remove shopping cart with id = 51 from product with id = 17
2025-10-15T16:35:27.411Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to query all shopping carts of product with id = 17
2025-10-15T16:35:27.411Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Finishing process to query all shopping carts of product with id = 17
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
Hibernate: insert into product_entity_shopping_carts (products_id,shopping_carts_id) values (?,?)
2025-10-15T16:35:27.426Z INFO 76 --- [ main] c.e.u.m.b.s.ProductShoppingCartService : Starting process to replace shopping carts associated with product with id = 18
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.84 s - in co.edu.udistrital.mdp.back.services.ProductShoppingCartServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.UserNotificationServiceTest
2025-10-15T16:35:27.432Z INFO 76 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.UserNotificationServiceTest]: UserNotificationServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-10-15T16:35:27.459Z INFO 76 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.UserNotificationServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:27.474Z INFO 76 --- [ main] c.e.u.m.b.s.UserNotificationServiceTest : Starting UserNotificationServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:27.474Z INFO 76 --- [ main] c.e.u.m.b.s.UserNotificationServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:27.535Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-10-15T16:35:27.550Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 14 JPA repository interfaces.
2025-10-15T16:35:27.564Z INFO 76 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-10-15T16:35:27.575Z INFO 76 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:0238c376-1485-43c3-9d86-8c5f38327ea7;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-10-15T16:35:27.592Z INFO 76 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-10-15T16:35:27.594Z INFO 76 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-10-15T16:35:27.597Z INFO 76 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-10-15T16:35:27.599Z WARN 76 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-10-15T16:35:27.788Z INFO 76 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id))
Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id))
Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id))
Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id))
Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id))
Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id))
Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id))
Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null)
Hibernate: create table product_entity (price float(53), stock integer, id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id))
Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null)
Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, service_id bigint, user_id bigint, reservation_status varchar(255), primary key (id))
Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id))
Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null)
Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id))
Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity
Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity
Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity
Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity
Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity
Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity
Hibernate: alter table if exists reservation_entity add constraint FK6hmidbe8cvu5iuma26lbk8awk foreign key (service_id) references service_entity
Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity
Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity
Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity
Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity
Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity
2025-10-15T16:35:27.814Z INFO 76 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-10-15T16:35:27.951Z INFO 76 --- [ main] c.e.u.m.b.s.UserNotificationServiceTest : Started UserNotificationServiceTest in 0.49 seconds (process running for 21.841)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into notification_entity (date,message,read,id) values (?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into notification_entity (date,message,read,id) values (?,?,?,default)
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.527 s - in co.edu.udistrital.mdp.back.services.UserNotificationServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.OrderServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:27.987Z INFO 76 --- [ main] c.e.u.m.back.services.OrderServiceTest : Starting OrderServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:27.987Z INFO 76 --- [ main] c.e.u.m.back.services.OrderServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:28.089Z INFO 76 --- [ main] c.e.u.m.back.services.OrderServiceTest : Started OrderServiceTest in 0.114 seconds (process running for 21.979)
[INFO] Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.147 s - in co.edu.udistrital.mdp.back.services.OrderServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.MultimediaServiceTest
2025-10-15T16:35:28.129Z INFO 76 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.MultimediaServiceTest]: MultimediaServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-10-15T16:35:28.135Z INFO 76 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.MultimediaServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:28.170Z INFO 76 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : Starting MultimediaServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:28.170Z INFO 76 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:28.229Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-10-15T16:35:28.243Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 13 ms. Found 14 JPA repository interfaces.
2025-10-15T16:35:28.257Z INFO 76 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-10-15T16:35:28.268Z INFO 76 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:eeace8a2-b10b-42f2-a582-91599c532583;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-10-15T16:35:28.284Z INFO 76 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-10-15T16:35:28.285Z INFO 76 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-10-15T16:35:28.289Z INFO 76 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-10-15T16:35:28.290Z WARN 76 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-10-15T16:35:28.472Z INFO 76 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id))
Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id))
Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id))
Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id))
Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id))
Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id))
Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id))
Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null)
Hibernate: create table product_entity (price float(53), stock integer, id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id))
Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null)
Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, service_id bigint, user_id bigint, reservation_status varchar(255), primary key (id))
Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id))
Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null)
Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id))
Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity
Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity
Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity
Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity
Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity
Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity
Hibernate: alter table if exists reservation_entity add constraint FK6hmidbe8cvu5iuma26lbk8awk foreign key (service_id) references service_entity
Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity
Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity
Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity
Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity
Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity
2025-10-15T16:35:28.498Z INFO 76 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-10-15T16:35:28.644Z INFO 76 --- [ main] c.e.u.m.b.s.MultimediaServiceTest : Started MultimediaServiceTest in 0.506 seconds (process running for 22.534)
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.662Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query multimedia with id = {0}
2025-10-15T16:35:28.664Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to query multimedia with id = {0}
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.676Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query all multimedia elements
Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.692Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to query multimedia with id = {0}
Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.price,p1_0.stock,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=?
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.731Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0}
Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0
2025-10-15T16:35:28.739Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to delete multimedia with id = {0}
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.755Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia
Hibernate: select be1_0.id,be1_0.address,be1_0.name,be1_0.phone,be1_0.zone from branch_entity be1_0 where be1_0.id=?
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.768Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to update multimedia with id = {0}
2025-10-15T16:35:28.769Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to update multimedia with id = {0}
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.781Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.793Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to update multimedia with id = {0}
Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.price,p1_0.stock,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=?
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.807Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.825Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.838Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0}
Hibernate: select me1_0.id,b1_0.id,b1_0.address,b1_0.name,b1_0.phone,b1_0.zone,p1_0.id,p1_0.category,p1_0.description,p1_0.name,p1_0.price,p1_0.stock,s1_0.id,s1_0.description,s1_0.duration,s1_0.name,s1_0.price,me1_0.type,me1_0.url from multimedia_entity me1_0 left join branch_entity b1_0 on b1_0.id=me1_0.branch_id left join product_entity p1_0 on p1_0.id=me1_0.product_id left join service_entity s1_0 on s1_0.id=me1_0.service_id where me1_0.id=?
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.851Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to create multimedia
2025-10-15T16:35:28.852Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Finishing process to create multimedia
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: delete from multimedia_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from branch_entity
Hibernate: delete from service_entity_branches
Hibernate: delete from service_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: insert into branch_entity (address,name,phone,zone,id) values (?,?,?,?,default)
Hibernate: insert into service_entity (description,duration,name,price,id) values (?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
Hibernate: insert into multimedia_entity (branch_id,product_id,service_id,type,url,id) values (?,?,?,?,?,default)
2025-10-15T16:35:28.865Z INFO 76 --- [ main] c.e.u.m.back.services.MultimediaService : Starting process to delete multimedia with id = {0}
Hibernate: select me1_0.id,me1_0.branch_id,me1_0.product_id,me1_0.service_id,me1_0.type,me1_0.url from multimedia_entity me1_0
[INFO] Tests run: 13, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.735 s - in co.edu.udistrital.mdp.back.services.MultimediaServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.UserServiceTest
2025-10-15T16:35:28.872Z INFO 76 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.UserServiceTest]: UserServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-10-15T16:35:28.881Z INFO 76 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.UserServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:28.903Z INFO 76 --- [ main] c.e.u.mdp.back.services.UserServiceTest : Starting UserServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:28.903Z INFO 76 --- [ main] c.e.u.mdp.back.services.UserServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:28.967Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-10-15T16:35:28.983Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 15 ms. Found 14 JPA repository interfaces.
2025-10-15T16:35:29.000Z INFO 76 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-10-15T16:35:29.036Z INFO 76 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:db69db7d-f96e-44a5-815e-95ef61e7bc15;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-10-15T16:35:29.061Z INFO 76 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-10-15T16:35:29.063Z INFO 76 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-10-15T16:35:29.071Z INFO 76 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-10-15T16:35:29.075Z WARN 76 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-10-15T16:35:29.282Z INFO 76 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id))
Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id))
Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id))
Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id))
Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id))
Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id))
Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id))
Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null)
Hibernate: create table product_entity (price float(53), stock integer, id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id))
Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null)
Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, service_id bigint, user_id bigint, reservation_status varchar(255), primary key (id))
Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id))
Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null)
Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id))
Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity
Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity
Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity
Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity
Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity
Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity
Hibernate: alter table if exists reservation_entity add constraint FK6hmidbe8cvu5iuma26lbk8awk foreign key (service_id) references service_entity
Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity
Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity
Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity
Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity
Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity
2025-10-15T16:35:29.315Z INFO 76 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-10-15T16:35:29.473Z INFO 76 --- [ main] c.e.u.mdp.back.services.UserServiceTest : Started UserServiceTest in 0.585 seconds (process running for 23.363)
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity'
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity'
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints,sc1_0.id,sc1_0.total from person_entity ue1_0 left join shopping_cart_entity sc1_0 on ue1_0.id=sc1_0.user_id where ue1_0.dtype='UserEntity' and ue1_0.id=?
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity'
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity'
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints from person_entity ue1_0 where ue1_0.dtype='UserEntity'
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.613 s - in co.edu.udistrital.mdp.back.services.UserServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest
2025-10-15T16:35:29.518Z INFO 76 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest]: ShoppingCartServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-10-15T16:35:29.524Z INFO 76 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:29.539Z INFO 76 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : Starting ShoppingCartServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:29.539Z INFO 76 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:29.597Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-10-15T16:35:29.611Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14 ms. Found 14 JPA repository interfaces.
2025-10-15T16:35:29.624Z INFO 76 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-10-15T16:35:29.634Z INFO 76 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:f71bd94e-e4a1-468c-beba-fda39b7765bd;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-10-15T16:35:29.649Z INFO 76 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-10-15T16:35:29.650Z INFO 76 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-10-15T16:35:29.654Z INFO 76 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-10-15T16:35:29.655Z WARN 76 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-10-15T16:35:29.829Z INFO 76 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id))
Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id))
Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id))
Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id))
Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id))
Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id))
Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id))
Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null)
Hibernate: create table product_entity (price float(53), stock integer, id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id))
Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null)
Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, service_id bigint, user_id bigint, reservation_status varchar(255), primary key (id))
Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id))
Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null)
Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id))
Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity
Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity
Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity
Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity
Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity
Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity
Hibernate: alter table if exists reservation_entity add constraint FK6hmidbe8cvu5iuma26lbk8awk foreign key (service_id) references service_entity
Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity
Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity
Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity
Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity
Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity
2025-10-15T16:35:29.854Z INFO 76 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-10-15T16:35:30.017Z INFO 76 --- [ main] c.e.u.m.b.s.ShoppingCartServiceTest : Started ShoppingCartServiceTest in 0.491 seconds (process running for 23.907)
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.036Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1}
2025-10-15T16:35:30.037Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to remove product from cart
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.054Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart
Hibernate: select ue1_0.id,ue1_0.address,ue1_0.email,ue1_0.lastname,ue1_0.name,ue1_0.password,ue1_0.telephone,ue1_0.loyaltypoints,sc1_0.id,sc1_0.total from person_entity ue1_0 left join shopping_cart_entity sc1_0 on ue1_0.id=sc1_0.user_id where ue1_0.dtype='UserEntity' and ue1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.070Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0}
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
2025-10-15T16:35:30.086Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart
2025-10-15T16:35:30.086Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to create shopping cart
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.100Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0}
Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.price,pe1_0.stock from product_entity pe1_0 where pe1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.116Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1}
Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.price,pe1_0.stock from product_entity pe1_0 where pe1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.131Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to delete shopping cart with id = {0}
2025-10-15T16:35:30.132Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to delete shopping cart with id = {0}
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.147Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1}
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.163Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query shopping cart with id = {0}
2025-10-15T16:35:30.164Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to query shopping cart with id = {0}
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.178Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1}
2025-10-15T16:35:30.179Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to add product to cart
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.196Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to update shopping cart with id = {0}
2025-10-15T16:35:30.196Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Finishing process to update shopping cart with id = {0}
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.212Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query all shopping carts
Hibernate: select sce1_0.id,sce1_0.total,sce1_0.user_id from shopping_cart_entity sce1_0
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.229Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to query shopping cart with id = {0}
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.246Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to add product with id = {0} to cart with id = {1}
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.261Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to remove product with id = {0} from cart with id = {1}
Hibernate: select pe1_0.id,pe1_0.category,pe1_0.description,pe1_0.name,pe1_0.price,pe1_0.stock from product_entity pe1_0 where pe1_0.id=?
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.276Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.291Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to create shopping cart
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from shopping_cart_entity
Hibernate: delete from product_entity_shopping_carts
Hibernate: delete from product_entity
Hibernate: delete from person_entity_notifications where users_id in (select ue1_0.id from person_entity ue1_0 where ue1_0.dtype='UserEntity')
Hibernate: delete from person_entity where dtype='UserEntity'
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into product_entity (category,description,name,price,stock,id) values (?,?,?,?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,loyaltypoints,dtype,id) values (?,?,?,?,?,?,?,'UserEntity',default)
Hibernate: insert into shopping_cart_entity (total,user_id,id) values (?,?,default)
2025-10-15T16:35:30.305Z INFO 76 --- [ main] c.e.u.m.b.services.ShoppingCartService : Starting process to delete shopping cart with id = {0}
Hibernate: select sce1_0.id,sce1_0.total,u1_0.id,u1_0.address,u1_0.email,u1_0.lastname,u1_0.name,u1_0.password,u1_0.telephone,u1_0.loyaltypoints from shopping_cart_entity sce1_0 left join (select * from person_entity t where t.dtype='UserEntity') u1_0 on u1_0.id=sce1_0.user_id where sce1_0.id=?
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.79 s - in co.edu.udistrital.mdp.back.services.ShoppingCartServiceTest
[INFO] Running co.edu.udistrital.mdp.back.services.PersonServiceTest
2025-10-15T16:35:30.310Z INFO 76 --- [ main] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [co.edu.udistrital.mdp.back.services.PersonServiceTest]: PersonServiceTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2025-10-15T16:35:30.314Z INFO 76 --- [ main] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration co.edu.udistrital.mdp.back.MainApplication for test class co.edu.udistrital.mdp.back.services.PersonServiceTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.2.3)
2025-10-15T16:35:30.328Z INFO 76 --- [ main] c.e.u.m.back.services.PersonServiceTest : Starting PersonServiceTest using Java 21.0.4 with PID 76 (started by root in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back)
2025-10-15T16:35:30.328Z INFO 76 --- [ main] c.e.u.m.back.services.PersonServiceTest : No active profile set, falling back to 1 default profile: "default"
2025-10-15T16:35:30.380Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2025-10-15T16:35:30.394Z INFO 76 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 13 ms. Found 14 JPA repository interfaces.
2025-10-15T16:35:30.405Z INFO 76 --- [ main] beddedDataSourceBeanFactoryPostProcessor : Replacing 'dataSource' DataSource bean with embedded version
2025-10-15T16:35:30.415Z INFO 76 --- [ main] o.s.j.d.e.EmbeddedDatabaseFactory : Starting embedded database: url='jdbc:h2:mem:6d250346-0556-4c61-b38f-e8342626b4b3;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'
2025-10-15T16:35:30.430Z INFO 76 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2025-10-15T16:35:30.432Z INFO 76 --- [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2025-10-15T16:35:30.435Z INFO 76 --- [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2025-10-15T16:35:30.436Z WARN 76 --- [ main] org.hibernate.orm.deprecation : HHH90000025: H2Dialect does not need to be specified explicitly using 'hibernate.dialect' (remove the property setting and it will be selected by default)
2025-10-15T16:35:30.637Z INFO 76 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
Hibernate: create table branch_entity (id bigint generated by default as identity, address varchar(255), name varchar(255), phone varchar(255), zone varchar(255), primary key (id))
Hibernate: create table multimedia_entity (branch_id bigint, id bigint generated by default as identity, product_id bigint, service_id bigint, type varchar(255), url varchar(255), primary key (id))
Hibernate: create table notification_entity (date date, read boolean, id bigint generated by default as identity, message varchar(255), primary key (id))
Hibernate: create table order_detail_entity (quantity integer, subtotal float(53), id bigint generated by default as identity, order_id bigint, product_id bigint, primary key (id))
Hibernate: create table order_entity (discount float(53) not null, order_date date, total_amount float(53), id bigint generated by default as identity, user_id bigint, status varchar(255), primary key (id))
Hibernate: create table payment (amount float(53) not null, date timestamp(6), id bigint generated by default as identity, shopping_cart_id bigint, method varchar(255), status varchar(255), primary key (id))
Hibernate: create table person_entity (loyaltypoints integer, id bigint generated by default as identity, dtype varchar(31) not null, address varchar(255), email varchar(255), lastname varchar(255), name varchar(255), password varchar(255), telephone varchar(255), primary key (id))
Hibernate: create table person_entity_notifications (notifications_id bigint not null, users_id bigint not null)
Hibernate: create table product_entity (price float(53), stock integer, id bigint generated by default as identity, category varchar(255), description varchar(255), name varchar(255), primary key (id))
Hibernate: create table product_entity_shopping_carts (products_id bigint not null, shopping_carts_id bigint not null)
Hibernate: create table reservation_entity (end_time time(6), reservation_date date, start_time time(6), branch_id bigint, id bigint generated by default as identity, service_id bigint, user_id bigint, reservation_status varchar(255), primary key (id))
Hibernate: create table review_entity (rating integer, review_date date, id bigint generated by default as identity, service_id bigint, comments varchar(255), primary key (id))
Hibernate: create table service_entity (duration integer, price float(53), id bigint generated by default as identity, description varchar(255), name varchar(255), primary key (id))
Hibernate: create table service_entity_branches (branches_id bigint not null, services_id bigint not null)
Hibernate: create table shopping_cart_entity (total float(53) not null, id bigint generated by default as identity, user_id bigint unique, primary key (id))
Hibernate: alter table if exists multimedia_entity add constraint FK7ajjjqrdk0gnlrd411q076tlf foreign key (branch_id) references branch_entity
Hibernate: alter table if exists multimedia_entity add constraint FKdjmnd5gcrjru3glt9oj523qis foreign key (product_id) references product_entity
Hibernate: alter table if exists multimedia_entity add constraint FKs4m09gexde2gt7xs29hfv1wl7 foreign key (service_id) references service_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg2q4hs7aq9plvbq0hqba0b1xg foreign key (order_id) references order_entity
Hibernate: alter table if exists order_detail_entity add constraint FKg8u6g80ebrefep6so6f9br7uv foreign key (product_id) references product_entity
Hibernate: alter table if exists order_entity add constraint FKp3exf04p4mi6l9jlj26gcovn0 foreign key (user_id) references person_entity
Hibernate: alter table if exists payment add constraint FKrtdu5kvmrbq6tmxxlgrh6xvuj foreign key (shopping_cart_id) references shopping_cart_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6qplyewbbuj4w0qwoes6xt2i0 foreign key (notifications_id) references notification_entity
Hibernate: alter table if exists person_entity_notifications add constraint FK6eu007syf8l6a1tsjog50rfki foreign key (users_id) references person_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKj8n5f0r91uuvyhdl48ebuac2u foreign key (shopping_carts_id) references shopping_cart_entity
Hibernate: alter table if exists product_entity_shopping_carts add constraint FKjughq4da4ac04ooafvmbfhh0v foreign key (products_id) references product_entity
Hibernate: alter table if exists reservation_entity add constraint FKjcm9qy7yvd8c3h1oyxrn73s73 foreign key (branch_id) references branch_entity
Hibernate: alter table if exists reservation_entity add constraint FK6hmidbe8cvu5iuma26lbk8awk foreign key (service_id) references service_entity
Hibernate: alter table if exists reservation_entity add constraint FK4dgqn2ddwohfuq9inltk5rj2u foreign key (user_id) references person_entity
Hibernate: alter table if exists review_entity add constraint FKh4bih63s2ylplbvgh9yopckld foreign key (service_id) references service_entity
Hibernate: alter table if exists service_entity_branches add constraint FK25p5c40endmpb10m66jvbxi20 foreign key (branches_id) references branch_entity
Hibernate: alter table if exists service_entity_branches add constraint FKhtcplpjkqoam2dbgq3kjyli27 foreign key (services_id) references service_entity
Hibernate: alter table if exists shopping_cart_entity add constraint FKjkio6l0f5mf8rec6gqk1jsyra foreign key (user_id) references person_entity
2025-10-15T16:35:30.666Z INFO 76 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2025-10-15T16:35:30.860Z INFO 76 --- [ main] c.e.u.m.back.services.PersonServiceTest : Started PersonServiceTest in 0.543 seconds (process running for 24.75)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints,sc1_0.id,sc1_0.total,sc1_0.user_id from person_entity pe1_0 left join shopping_cart_entity sc1_0 on pe1_0.id=sc1_0.user_id where pe1_0.id=?
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints from person_entity pe1_0
Hibernate: insert into person_entity (address,email,lastname,name,password,telephone,dtype,id) values (?,?,?,?,?,?,'PersonEntity',default)
Hibernate: select pe1_0.id,pe1_0.dtype,pe1_0.address,pe1_0.email,pe1_0.lastname,pe1_0.name,pe1_0.password,pe1_0.telephone,pe1_0.loyaltypoints,sc1_0.id,sc1_0.total,sc1_0.user_id from person_entity pe1_0 left join shopping_cart_entity sc1_0 on pe1_0.id=sc1_0.user_id where pe1_0.id=?
[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.613 s - in co.edu.udistrital.mdp.back.services.PersonServiceTest
2025-10-15T16:35:31.076Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.090Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.098Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.105Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.114Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.121Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.127Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.133Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.139Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.145Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.150Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.156Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.162Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.167Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
2025-10-15T16:35:31.172Z INFO 76 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Hibernate: drop table if exists branch_entity cascade
Hibernate: drop table if exists multimedia_entity cascade
Hibernate: drop table if exists notification_entity cascade
Hibernate: drop table if exists order_detail_entity cascade
Hibernate: drop table if exists order_entity cascade
Hibernate: drop table if exists payment cascade
Hibernate: drop table if exists person_entity cascade
Hibernate: drop table if exists person_entity_notifications cascade
Hibernate: drop table if exists product_entity cascade
Hibernate: drop table if exists product_entity_shopping_carts cascade
Hibernate: drop table if exists reservation_entity cascade
Hibernate: drop table if exists review_entity cascade
Hibernate: drop table if exists service_entity cascade
Hibernate: drop table if exists service_entity_branches cascade
Hibernate: drop table if exists shopping_cart_entity cascade
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 210, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 26.931 s
[INFO] Finished at: 2025-10-15T16:35:31Z
[INFO] ------------------------------------------------------------------------
[Pipeline] }
$ docker stop --time=1 ecb7e196b14afaa88f91d27ab9859bde04247f2fbcae428aabc87b4dbd2bc371
$ docker rm -f --volumes ecb7e196b14afaa88f91d27ab9859bde04247f2fbcae428aabc87b4dbd2bc371
[Pipeline] // withDockerContainer
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Static Analysis)
[Pipeline] script
[Pipeline] {
[Pipeline] isUnix
[Pipeline] withEnv
[Pipeline] {
[Pipeline] sh
+ docker inspect -f . citools-isis2603:latest
.
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] withDockerContainer
Slave1 does not seem to be running inside a container
$ docker run -t -d -u 1000:1000 -v $HOME/.m2:/root/.m2:z -u root -w /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back -v /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back:/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back:rw,z -v /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back@tmp:/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back@tmp:rw,z -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** -e ******** citools-isis2603:latest cat
$ docker top 5c05702d9aa67b6042e31f89e7e48f14594a7d366f97ebc990ed302f3e137e99 -eo pid,comm
[Pipeline] {
[Pipeline] sh
+ mvn sonar:sonar -Dsonar.token=**** -Dsonar.host.url=http://10.20.84.26:8082/sonar
[INFO] Scanning for projects...
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml
Progress (1): 4.6 kB
Progress (2): 4.6 kB | 3.1 kB
Progress (2): 9.9 kB | 3.1 kB
Progress (2): 9.9 kB | 8.0 kB
Progress (2): 9.9 kB | 11 kB
Progress (2): 9.9 kB | 16 kB
Progress (2): 9.9 kB | 20 kB
Progress (2): 9.9 kB | 21 kB
Progress (2): 14 kB | 21 kB
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml (21 kB at 19 kB/s)
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml (14 kB at 13 kB/s)
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/sonar-maven-plugin/maven-metadata.xml
Progress (1): 1.4 kB
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/sonar-maven-plugin/maven-metadata.xml (1.4 kB at 14 kB/s)
[WARNING] The artifact org.codehaus.mojo:sonar-maven-plugin:jar:4.0.0.4121 has been relocated to org.sonarsource.scanner.maven:sonar-maven-plugin:jar:4.0.0.4121: SonarQube plugin was moved to SonarSource organisation
[INFO]
[INFO] ---------< co.edu.udistrital.mdp:MP_202530_G81_E4_DogSpa_Back >---------
[INFO] Building MP_202530_G81_E4_DogSpa_Back 0.0.1-SNAPSHOT
[INFO] from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- sonar:4.0.0.4121:sonar (default-cli) @ MP_202530_G81_E4_DogSpa_Back ---
[WARNING] 16:35:40.065 Using an unspecified version instead of an explicit plugin version may introduce breaking analysis changes at an unwanted time. It is highly recommended to use an explicit version, e.g. 'org.sonarsource.scanner.maven:sonar-maven-plugin:4.0.0.4121'.
[INFO] 16:35:40.074 Java 21.0.4 Eclipse Adoptium (64-bit)
[INFO] 16:35:40.075 Linux 6.14.0-33-generic (amd64)
[INFO] 16:35:40.141 User cache: /root/.sonar/cache
[INFO] 16:35:40.724 Communicating with SonarQube Server 25.3.0.104237
[INFO] 16:35:40.741 Default locale: "en_US", source code encoding: "UTF-8"
[INFO] 16:35:42.874 Load global settings
[INFO] 16:35:42.957 Load global settings (done) | time=85ms
[INFO] 16:35:42.973 Server id: 243B8A4D-AZWSB3madBdjq_cKUIEO
[INFO] 16:35:42.985 Loading required plugins
[INFO] 16:35:42.986 Load plugins index
[INFO] 16:35:43.032 Load plugins index (done) | time=47ms
[INFO] 16:35:43.032 Load/download plugins
[INFO] 16:35:43.298 Load/download plugins (done) | time=265ms
[INFO] 16:35:43.636 Process project properties
[INFO] 16:35:43.650 Process project properties (done) | time=14ms
[INFO] 16:35:43.662 Project key: co.edu.udistrital.mdp:MP_202530_G81_E4_DogSpa_Back
[INFO] 16:35:43.662 Base dir: /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back
[INFO] 16:35:43.662 Working dir: /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/target/sonar
[INFO] 16:35:43.669 Load project settings for component key: 'co.edu.udistrital.mdp:MP_202530_G81_E4_DogSpa_Back'
[INFO] 16:35:43.698 Load project settings for component key: 'co.edu.udistrital.mdp:MP_202530_G81_E4_DogSpa_Back' (done) | time=29ms
[INFO] 16:35:43.728 Load quality profiles
[INFO] 16:35:43.813 Load quality profiles (done) | time=85ms
[INFO] 16:35:43.826 Auto-configuring with CI 'Jenkins'
[INFO] 16:35:43.861 Load active rules
[INFO] 16:35:44.164 Load active rules (done) | time=303ms
[INFO] 16:35:44.171 Load analysis cache
[INFO] 16:35:44.184 Load analysis cache (404) | time=13ms
[INFO] 16:35:44.253 Preprocessing files...
[INFO] 16:35:44.686 2 languages detected in 79 preprocessed files
[INFO] 16:35:44.687 0 files ignored because of scm ignore settings
[INFO] 16:35:44.689 Loading plugins for detected languages
[INFO] 16:35:44.689 Load/download plugins
[INFO] 16:35:44.993 Load/download plugins (done) | time=304ms
[INFO] 16:35:45.116 Load project repositories
[INFO] 16:35:45.247 Load project repositories (done) | time=131ms
[INFO] 16:35:45.268 Indexing files...
[INFO] 16:35:45.268 Project configuration:
[INFO] 16:35:45.269 Excluded sources for coverage: **/controllers/**, **/exceptions/**, **/podam/**, **/dto/**
[INFO] 16:35:45.287 79 files indexed
[INFO] 16:35:45.288 Quality profile for java: Sonar way
[INFO] 16:35:45.288 Quality profile for xml: Sonar way
[INFO] 16:35:45.288 ------------- Run sensors on module MP_202530_G81_E4_DogSpa_Back
[INFO] 16:35:45.347 Load metrics repository
[INFO] 16:35:45.367 Load metrics repository (done) | time=20ms
[INFO] 16:35:46.309 Sensor JavaSensor [java]
[INFO] 16:35:46.316 Configured Java source version (sonar.java.source): 21, preview features enabled (sonar.java.enablePreview): false
[INFO] 16:35:46.349 Server-side caching is enabled. The Java analyzer will not try to leverage data from a previous analysis.
[INFO] 16:35:46.350 Using ECJ batch to parse 58 Main java source files with batch size 104 KB.
[INFO] 16:35:46.801 Starting batch processing.
[INFO] 16:35:47.358 The Java analyzer cannot skip unchanged files in this context. A full analysis is performed for all files.
[INFO] 16:35:49.958 100% analyzed
[INFO] 16:35:49.958 Batch processing: Done.
[INFO] 16:35:49.959 Did not optimize analysis for any files, performed a full analysis for all 58 files.
[WARNING] 16:35:49.961 Use of preview features have been detected during analysis. Enable DEBUG mode to see them.
[INFO] 16:35:49.962 Using ECJ batch to parse 20 Test java source files with batch size 104 KB.
[INFO] 16:35:49.976 Starting batch processing.
[INFO] 16:35:51.026 100% analyzed
[INFO] 16:35:51.026 Batch processing: Done.
[INFO] 16:35:51.027 Did not optimize analysis for any files, performed a full analysis for all 20 files.
[INFO] 16:35:51.028 No "Generated" source files to scan.
[INFO] 16:35:51.028 Sensor JavaSensor [java] (done) | time=4719ms
[INFO] 16:35:51.028 Sensor SurefireSensor [java]
[INFO] 16:35:51.029 parsing [/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/target/surefire-reports]
[INFO] 16:35:51.131 Sensor SurefireSensor [java] (done) | time=103ms
[INFO] 16:35:51.132 Sensor XML Sensor [xml]
[INFO] 16:35:51.137 1 source file to be analyzed
[INFO] 16:35:51.404 1/1 source file has been analyzed
[INFO] 16:35:51.404 Sensor XML Sensor [xml] (done) | time=272ms
[INFO] 16:35:51.405 Sensor JaCoCo XML Report Importer [jacoco]
[WARNING] 16:35:51.407 No coverage report can be found with sonar.coverage.jacoco.xmlReportPaths='/home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/../target/jacoco-report/jacoco.xml'. Using default locations: target/site/jacoco/jacoco.xml,target/site/jacoco-it/jacoco.xml,build/reports/jacoco/test/jacocoTestReport.xml
[INFO] 16:35:51.409 Importing 1 report(s). Turn your logs in debug mode in order to see the exhaustive list.
[INFO] 16:35:51.509 Sensor JaCoCo XML Report Importer [jacoco] (done) | time=104ms
[INFO] 16:35:51.509 Sensor Java Config Sensor [iac]
[INFO] 16:35:51.529 0 source files to be analyzed
[INFO] 16:35:51.529 0/0 source files have been analyzed
[INFO] 16:35:51.530 Sensor Java Config Sensor [iac] (done) | time=21ms
[INFO] 16:35:51.530 Sensor IaC Docker Sensor [iac]
[INFO] 16:35:51.607 0 source files to be analyzed
[INFO] 16:35:51.607 0/0 source files have been analyzed
[INFO] 16:35:51.607 Sensor IaC Docker Sensor [iac] (done) | time=77ms
[INFO] 16:35:51.607 Sensor TextAndSecretsSensor [text]
[INFO] 16:35:51.607 Available processors: 4
[INFO] 16:35:51.607 Using 4 threads for analysis.
[INFO] 16:35:51.982 Using git CLI to retrieve untracked files
[WARNING] 16:35:51.986 Analyzing only language associated files, make sure to run the analysis inside a git repository to make use of inclusions specified via "sonar.text.inclusions"
[INFO] 16:35:52.012 79 source files to be analyzed
[INFO] 16:35:52.193 79/79 source files have been analyzed
[INFO] 16:35:52.194 Sensor TextAndSecretsSensor [text] (done) | time=587ms
[INFO] 16:35:52.198 ------------- Run sensors on project
[INFO] 16:35:52.348 Sensor Zero Coverage Sensor
[INFO] 16:35:52.349 Sensor Zero Coverage Sensor (done) | time=1ms
[INFO] 16:35:52.350 Sensor Java CPD Block Indexer
[INFO] 16:35:52.444 Sensor Java CPD Block Indexer (done) | time=94ms
[INFO] 16:35:52.444 ------------- Gather SCA dependencies on project
[INFO] 16:35:52.456 SCM Publisher SCM provider for this project is: git
[INFO] 16:35:52.457 SCM Publisher 58 source files to be analyzed
[INFO] 16:35:52.860 SCM Publisher 58/58 source files have been analyzed (done) | time=403ms
[INFO] 16:35:52.868 CPD Executor 22 files had no CPD blocks
[INFO] 16:35:52.868 CPD Executor Calculating CPD for 36 files
[INFO] 16:35:52.884 CPD Executor CPD calculation finished (done) | time=15ms
[INFO] 16:35:52.889 SCM revision ID '1e81944ab79a9bd88e7f0ab9d4a6c0e8f14364e3'
[INFO] 16:35:53.007 Analysis report generated in 106ms, dir size=709.3 kB
[INFO] 16:35:53.215 Analysis report compressed in 207ms, zip size=262.8 kB
[INFO] 16:35:53.251 Analysis report uploaded in 36ms
[INFO] 16:35:53.253 ANALYSIS SUCCESSFUL, you can find the results at: http://10.20.84.26:8082/sonar/dashboard?id=co.edu.udistrital.mdp%3AMP_202530_G81_E4_DogSpa_Back
[INFO] 16:35:53.253 Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report
[INFO] 16:35:53.253 More about the report processing at http://10.20.84.26:8082/sonar/api/ce/task?id=e7d2e344-b9b3-4fdb-b5d2-000c1b1357b5
[INFO] 16:35:53.283 Analysis total time: 9.935 s
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 17.973 s
[INFO] Finished at: 2025-10-15T16:35:53Z
[INFO] ------------------------------------------------------------------------
[Pipeline] }
$ docker stop --time=1 5c05702d9aa67b6042e31f89e7e48f14594a7d366f97ebc990ed302f3e137e99
$ docker rm -f --volumes 5c05702d9aa67b6042e31f89e7e48f14594a7d366f97ebc990ed302f3e137e99
[Pipeline] // withDockerContainer
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] cleanWs
[WS-CLEANUP] Deleting project workspace...
[WS-CLEANUP] Deferred wipeout is used...
[WS-CLEANUP] done
[Pipeline] deleteDir
[Pipeline] dir
Running in /home/cecaduser/workspace/MP_202530_G81_E4_DogSpa_Back/MP_202530_G81_E4_DogSpa_Back@tmp
[Pipeline] {
[Pipeline] deleteDir
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] End of Pipeline
Finished: SUCCESS
![[Jenkins]](/jenkins/static/ed8ccf5c/images/svgs/logo.svg){kind=logo}
