0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0140bidirectionality_reverseCollectionfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Book(isbn varchar(255), price double, title varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Book_authors(book_id bigint, authors_id bigint, unique (book_id, authors_id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Author(name varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) ...[truncated 3757 chars]... untime.load.JoinRoot$JoinRootRowConsumer@19931489 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.PassiveJoinNode$PassiveJoinRowConsumer@e98520e on object org.codefilarete.stalactite.engine.model.book.Book@70185e95 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@193b9492 on object org.codefilarete.stalactite.engine.model.book.Book@70185e95 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0120bidirectionality_reverseInitializedWithfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Book(isbn varchar(255), price double, title varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Book_authors(book_id bigint, authors_id bigint, unique (book_id, authors_id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Author(name varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) ...[truncated 3755 chars]... runtime.load.JoinRoot$JoinRootRowConsumer@f0c27b8 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.PassiveJoinNode$PassiveJoinRowConsumer@4c954f7d on object org.codefilarete.stalactite.engine.model.book.Book@4984055c 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@8b98dc0 on object org.codefilarete.stalactite.engine.model.book.Book@4984055c 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0130bidirectionality_reverselySetByfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Book(isbn varchar(255), price double, title varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Book_authors(book_id bigint, authors_id bigint, unique (book_id, authors_id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Author(name varchar(255), id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) ...[truncated 3756 chars]... runtime.load.JoinRoot$JoinRootRowConsumer@24585501 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.PassiveJoinNode$PassiveJoinRowConsumer@5e6fd568 on object org.codefilarete.stalactite.engine.model.book.Book@daac320 2024-12-08 23:29:40 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@5663d72d on object org.codefilarete.stalactite.engine.model.book.Book@daac320 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0110crud_relationContainsManyToManyfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:40 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_answer_id_Answer_id foreign key(answer_id) references Answer(id) 2024-12-08 2 ...[truncated 3786 chars]... s 2024-12-08 23:29:40 TRACE SQLOperation delete from Answer_choices where answer_id = ? and choices_id = ? | {1={Answer_choices.answer_id=o.c.s.i.PersistableIdentifier@1, Answer_choices.choices_id=o.c.s.i.PersistableIdentifier@13}} 2024-12-08 23:29:40 DEBUG SQLOperation Batching statement 1 times 2024-12-08 23:29:40 TRACE SQLOperation delete from Answer where id = ? | {1={Answer.id=o.c.s.i.PersistableIdentifier@1}} 2024-12-08 23:29:40 TRACE SQLOperation select answer_id from answer_choices | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.010crud_relationContainsManyToMany_indexedfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, myIdx integer not null, unique (answer_id, choices_id, myIdx)) 2024-12-08 23:29:40 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_answer_id_Answer_id foreign key(answer_id) ref ...[truncated 1076 chars]... rsistableIdentifier@1, Answer_choices.myIdx=2, Answer_choices.choices_id=o.c.s.i.PersistableIdentifier@13}, 3={Answer_choices.answer_id=o.c.s.i.PersistableIdentifier@1, Answer_choices.myIdx=1, Answer_choices.choices_id=o.c.s.i.PersistableIdentifier@17}, 4={Answer_choices.answer_id=o.c.s.i.PersistableIdentifier@2, Answer_choices.myIdx=2, Answer_choices.choices_id=o.c.s.i.PersistableIdentifier@17}} 2024-12-08 23:29:40 TRACE SQLOperation select answer_id, choices_id, myIdx from answer_choices | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0110crud_relationContainsOneToManyfalsePASSED2024-12-08 23:29:39 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:39 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_answer_id_Answer_id foreign key(answer_id) references Answer(id) 2024-12-08 2 ...[truncated 3493 chars]... s 2024-12-08 23:29:39 TRACE SQLOperation delete from Answer_choices where answer_id = ? and choices_id = ? | {1={Answer_choices.answer_id=o.c.s.i.PersistableIdentifier@1, Answer_choices.choices_id=o.c.s.i.PersistableIdentifier@13}} 2024-12-08 23:29:39 DEBUG SQLOperation Batching statement 1 times 2024-12-08 23:29:39 TRACE SQLOperation delete from Answer where id = ? | {1={Answer.id=o.c.s.i.PersistableIdentifier@1}} 2024-12-08 23:29:39 TRACE SQLOperation select answer_id from answer_choices | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0180foreignKeysAreCreatedfalsePASSED2024-12-08 23:29:39 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:39 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_choices_id_Choice_id foreign key(choices_id) references Choice(id) 2024-12-08 23:29:39 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_answer_id_Answer_id foreign key(answer_id) references Answer(id) 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0070foreignKeysAreCreated_targetTableSpecifiedfalsePASSED2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table MyChoice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:40 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:40 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_answer_id_Answer_id foreign key(answer_id) references Answer(id) 2024-12-08 23:29:40 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_choices_id_MyChoice_id foreign key(choices_id) references MyChoice(id) 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0080select_collectionFactoryfalsePASSED2024-12-08 23:29:39 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:39 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_choices_id_Choice_id foreign key(choices_id) references Choice(id) 2024-12-08 ...[truncated 1505 chars]... Consuming org.codefilarete.stalactite.engine.runtime.load.PassiveJoinNode$PassiveJoinRowConsumer@7dec7d41 on object org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest$Answer@8b09aa7 2024-12-08 23:29:39 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@54528790 on object org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest$Answer@8b09aa7 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest0.0080select_noRecordInAssociationTable_mustReturnEmptyCollectionfalsePASSED2024-12-08 23:29:39 DEBUG DDLDeployer create table Choice(label varchar(255), id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer(id int not null, unique (id)) 2024-12-08 23:29:39 DEBUG DDLDeployer create table Answer_choices(answer_id int, choices_id int, unique (answer_id, choices_id)) 2024-12-08 23:29:39 DEBUG DDLDeployer alter table Answer_choices add constraint FK_Answer_choices_choices_id_Choice_id foreign key(choices_id) references Choice(id) 2024-12-08 ...[truncated 808 chars]... Consuming org.codefilarete.stalactite.engine.runtime.load.PassiveJoinNode$PassiveJoinRowConsumer@1c553585 on object org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest$Answer@4e02d65 2024-12-08 23:29:39 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@1421e0d4 on object org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportManyToManySetTest$Answer@4e02d65 0FluentEntityMappingConfigurationSupportManyToManySetTest100