0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0080crudfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Person(age, firstName, lastName, address) values (?, ?, ?, ?) | {1={Person.address=nowhere, Person.lastName=Do, Person.firstName=John, Person.age=35}} 2024-10-31 20:34:11 TRACE ...[truncated 650 chars]... ={Person.address (W)=nowhere, Person.lastName (W)=Do, Person.firstName (W)=John, Person.age (U)=36}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where address = ? and lastName = ? and firstName = ? | {1={Person.address=nowhere, Person.lastName=Do, Person.firstName=John}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0060crud_columnNameOverridden_columnNameIsUsedfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, familyName varchar(255) not null, address varchar(255) not null, unique (firstName, familyName, address)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Person(age, firstName, familyName, address) values (?, ?, ?, ?) | {1={Person.familyName=Do, Person.firstName=John, Person.address=nowhere, Person.age=35}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age as Person_age, Person.firstName as Person_firstName, Person.familyName as Person_familyName, Person.address as Person_address from Person where (Person.firstName, Person.familyName, Person.address) in ((?, ?, ?)) | {Person.familyName=Do, Person.firstName=John, Person.address=nowhere} 2024-10-31 20:34:11 DEBUG EntityTreeInflater Creating instance with org.codefilarete.stalactite.engine.runtime.load.JoinRoot$JoinRootRowConsumer@68d9b2b8 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0150crud_fieldNameOverriddenAndColumnNameOverridden_columnNameIsUsedfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, familyName varchar(255) not null, address varchar(255) not null, unique (firstName, familyName, address)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Person(age, firstName, familyName, address) values (?, ?, ?, ?) | {1={Person.familyName=Do, Person.firstName=John, Person.age=35, Person.address=nowhere}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age as Person_age, Person.firstName as Person_firstName, Person.familyName as Person_familyName, Person.address as Person_address from Person where (Person.firstName, Person.familyName, Person.address) in ((?, ?, ?)) | {Person.familyName=Do, Person.firstName=John, Person.address=nowhere} 2024-10-31 20:34:11 DEBUG EntityTreeInflater Creating instance with org.codefilarete.stalactite.engine.runtime.load.JoinRoot$JoinRootRowConsumer@2b8618f3 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0210crud_fieldNameOverridden_fieldNameIsUsedfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Person(age, firstName, lastName, address) values (?, ?, ?, ?) | {1={Person.address=nowhere, Person.age=35, Person.lastName=Do, Person.firstName=John}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age as Person_age, Person.firstName as Person_firstName, Person.lastName as Person_lastName, Person.address as Person_address from Person where (Person.firstName, Person.lastName, Person.address) in ((?, ?, ?)) | {Person.address=nowhere, Person.lastName=Do, Person.firstName=John} 2024-10-31 20:34:11 DEBUG EntityTreeInflater Creating instance with org.codefilarete.stalactite.engine.runtime.load.JoinRoot$JoinRootRowConsumer@4de042ec 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130crud_inheritance_joinedTablesfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Dog(dogBreed integer, name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Cat(catBreed integer, name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, ...[truncated 4502 chars]... t name from Pet | {} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Cat | {} 2024-10-31 20:34:11 TRACE SQLOperation delete from Cat where (name, race, age) in ((?, ?, ?)) | {Cat.age=4, Cat.name=Pluto, Cat.race=Dog} 2024-10-31 20:34:11 TRACE SQLOperation delete from Pet where (name, race, age) in ((?, ?, ?)) | {Pet.race=Dog, Pet.name=Pluto, Pet.age=4} 2024-10-31 20:34:11 TRACE SQLOperation select name from Pet | {} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Cat | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.010crud_inheritance_singleTablefalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, catBreed integer, dogBreed integer, DTYPE varchar(255) not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Pet(catBreed, name, race, age, DTYPE) values (?, ?, ?, ?, ?) | {1={Pet.race=Dog, Pet.age=4, Pet.name=Pluto, Pet.DTYPE=Pet, Pet.catBreed=Persian}} 2024-10-31 20 ...[truncated 1330 chars]... m Pet where race = ? and age = ? and name = ? | {1={Pet.race=Dog, Pet.age=4, Pet.name=Pluto}} 2024-10-31 20:34:11 TRACE SQLOperation select name from Pet | {} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Pet | {} 2024-10-31 20:34:11 TRACE SQLOperation delete from Pet where (name, race, age) in ((?, ?, ?)) | {Pet.race=Dog, Pet.age=4, Pet.name=Pluto} 2024-10-31 20:34:11 TRACE SQLOperation select name from Pet | {} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Pet | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0170crud_inheritance_tablePerClassfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Dog(dogBreed integer, name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Cat(catBreed integer, name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation insert into Cat(catBreed, name, race, age ...[truncated 1587 chars]... sumer@645e1f92 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Cat where race = ? and name = ? and age = ? | {1={Cat.race=Dog, Cat.age=4, Cat.name=Pluto}} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Cat | {} 2024-10-31 20:34:11 TRACE SQLOperation delete from Cat where (name, race, age) in ((?, ?, ?)) | {Cat.race=Dog, Cat.age=4, Cat.name=Pluto} 2024-10-31 20:34:11 TRACE SQLOperation select catBreed from Cat | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0110crud_manyToManyfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person_pets(person_firstName varchar(255), person_lastName varchar(255), person_address varchar(255), pets_name varchar(255), pets_race varchar(255), pets_age integer not null, unique (person_firstName, person_lastName, person_address, pets_na ...[truncated 5117 chars]... on_firstName=John, Person_pets.pets_race=Dog, Person_pets.pets_age=4, Person_pets.person_address=nowhere, Person_pets.pets_name=Pluto}} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where lastName = ? and firstName = ? and address = ? | {1={Person.firstName=John, Person.address=nowhere, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130crud_oneToMany_ownedByTargetfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, ownerFirstName varchar(255), ownerLastName varchar(255), ownerAddress varchar(255), unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer alter table P ...[truncated 3785 chars]... t.ownerAddress (U)=null, Pet.name (W)=Pluto, Pet.ownerFirstName (U)=null, Pet.race (W)=Dog, Pet.age (W)=4, Pet.ownerLastName (U)=null}} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.firstName=John, Person.address=nowhere, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0140crud_oneToMany_withAssociationTablefalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person_pets(person_firstName varchar(255), person_lastName varchar(255), person_addr ...[truncated 5117 chars]... on_firstName=John, Person_pets.pets_race=Dog, Person_pets.pets_age=4, Person_pets.pets_name=Pluto, Person_pets.person_address=nowhere}} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where address = ? and firstName = ? and lastName = ? | {1={Person.address=nowhere, Person.firstName=John, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0120crud_oneToOne_compositeToCompositeKey_ownedBySourcefalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table House(number integer not null, street varchar(255) not null, zipCode varchar(255) not null, city varchar(255) not null, unique (number, street, zipCode, city)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, houseNumber integer, houseStreet varchar(255), houseZipCode varchar(255), houseCity varchar(255), unique (firstName, lastN ...[truncated 2747 chars]... t (U)=Stalactite street, Person.firstName (W)=John, Person.houseZipCode (U)=888, Person.age (U)=36}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.lastName=Do, Person.address=nowhere, Person.firstName=John}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0120crud_oneToOne_compositeToCompositeKey_ownedByTargetfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table House(number integer not null, street varchar(255) not null, zipCode varchar(255) not null, city varchar(255) not null, ownerFirstName varchar(255), ownerLastName varchar(255), ownerAddress varchar(255), unique (number, street, zipCode, city)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) ...[truncated 3346 chars]... House.zipCode (W)=888, House.ownerFirstName (U)=null, House.city (W)=CodeFilarete City, House.number (W)=42, House.ownerAddress (U)=null, House.street (W)=Stalactite street}} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where address = ? and firstName = ? and lastName = ? | {1={Person.address=nowhere, Person.firstName=John, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.010crud_oneToOne_compositeToSingleKey_ownedBySourcefalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, houseId bigint, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table House(id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) 2024-10-31 20:34:11 DEBUG DDLDeployer alter table Person add constraint FK_Person_houseId_House_id foreign key(houseId) referenc ...[truncated 1526 chars]... , Person.address (W)=nowhere, Person.age (U)=36, Person.firstName (W)=John, Person.lastName (W)=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where firstName = ? and address = ? and lastName = ? | {1={Person.address=nowhere, Person.firstName=John, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0110crud_oneToOne_compositeToSingleKey_ownedByTargetfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table House(id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, ownerFirstName varchar(255), ownerLastName varchar(255), ownerAddress varchar(255), unique (id)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer alter table House add ...[truncated 2414 chars]... stName = ?, ownerAddress = ?, ownerFirstName = ? where id = ? | {1={House.ownerLastName (U)=null, House.ownerAddress (U)=null, House.id (W)=1, House.ownerFirstName (U)=null}} 2024-10-31 20:34:11 DEBUG SQLOperation Batching statement 1 times 2024-10-31 20:34:11 TRACE SQLOperation delete from Person where firstName = ? and lastName = ? and address = ? | {1={Person.firstName=John, Person.address=nowhere, Person.lastName=Do}} 2024-10-31 20:34:11 TRACE SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0380persist_manyToManyfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Person_pets(person_firstName varchar(255), person_lastName varchar(255), person_address varchar(255), pets_name varchar(255), pets_race varchar(255), pets_age integer not null, unique (person_firstName, person_lastName, person_address, pets_na ...[truncated 10827 chars]... eJoinRowConsumer@65567d3c on object Person{id=PersonId{firstName='John', lastName='Do', address='nowhere'}, age=36, house=null, pets=[Pet{id=PetId{name='Pluto', race='Dog', age=4}}]} 2024-10-31 20:34:11 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@2132d921 on object Person{id=PersonId{firstName='John', lastName='Do', address='nowhere'}, age=36, house=null, pets=[Pet{id=PetId{name='Pluto', race='Dog', age=4}}]} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130persist_oneToMany_ownedByTargetfalsePASSED2024-10-31 20:34:11 DEBUG DDLDeployer create table Person(age integer, firstName varchar(255) not null, lastName varchar(255) not null, address varchar(255) not null, unique (firstName, lastName, address)) 2024-10-31 20:34:11 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, ownerFirstName varchar(255), ownerLastName varchar(255), ownerAddress varchar(255), unique (name, race, age)) 2024-10-31 20:34:11 DEBUG DDLDeployer alter table P ...[truncated 7044 chars]... age=36, house=null, pets=[]} 2024-10-31 20:34:11 DEBUG EntityTreeInflater Creating instance with org.codefilarete.stalactite.engine.runtime.load.JoinRoot$JoinRootRowConsumer@46109086 2024-10-31 20:34:11 DEBUG EntityTreeInflater Consuming org.codefilarete.stalactite.engine.runtime.load.RelationJoinNode$DefaultRelationJoinRowConsumer@5cfb3dc2 on object Person{id=PersonId{firstName='John', lastName='Do', address='nowhere'}, age=36, house=null, pets=[Pet{id=PetId{name='Pluto', race='Dog', age=4}}]} 0FluentEntityMappingConfigurationSupportCompositeKeyTest160