0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0080crudfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Person(age, firstName, lastName, address) values (?, ?, ?, ?) | {1={Person.lastName=Do, Person.address=nowhere, Person.age=35, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG ...[truncated 496 chars]... ={Person.lastName (W)=Do, Person.address (W)=nowhere, Person.age (U)=36, Person.firstName (W)=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.lastName=Do, Person.address=nowhere, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0060crud_columnNameOverridden_columnNameIsUsedfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Person(age, firstName, familyName, address) values (?, ?, ?, ?) | {1={Person.age=35, Person.firstName=John, Person.familyName=Do, Person.address=nowhere}} 2024-08-30 07:43:32 DEBUG 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.firstName=John, Person.familyName=Do, Person.address=nowhere} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0150crud_fieldNameOverriddenAndColumnNameOverridden_columnNameIsUsedfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Person(age, firstName, familyName, address) values (?, ?, ?, ?) | {1={Person.familyName=Do, Person.firstName=John, Person.address=nowhere, Person.age=35}} 2024-08-30 07:43:32 DEBUG 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} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0220crud_fieldNameOverridden_fieldNameIsUsedfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Person(age, firstName, lastName, address) values (?, ?, ?, ?) | {1={Person.age=35, Person.firstName=John, Person.address=nowhere, Person.lastName=Do}} 2024-08-30 07:43:32 DEBUG 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.firstName=John, Person.address=nowhere, Person.lastName=Do} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130crud_inheritance_joinedTablesfalsePASSED2024-08-30 07:43:32 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer create table Dog(dogBreed integer, name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, ...[truncated 3790 chars]... t name from Pet | {} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Cat | {} 2024-08-30 07:43:32 DEBUG SQLOperation delete from Cat where (name, race, age) in ((?, ?, ?)) | {Cat.race=Dog, Cat.name=Pluto, Cat.age=4} 2024-08-30 07:43:32 DEBUG SQLOperation delete from Pet where (name, race, age) in ((?, ?, ?)) | {Pet.race=Dog, Pet.age=4, Pet.name=Pluto} 2024-08-30 07:43:32 DEBUG SQLOperation select name from Pet | {} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Cat | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.010crud_inheritance_singleTablefalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Pet(catBreed, name, race, age, DTYPE) values (?, ?, ?, ?, ?) | {1={Pet.name=Pluto, Pet.race=Dog, Pet.age=4, Pet.catBreed=Persian, Pet.DTYPE=Pet}} 2024-08-30 07 ...[truncated 1022 chars]... m Pet where race = ? and name = ? and age = ? | {1={Pet.name=Pluto, Pet.race=Dog, Pet.age=4}} 2024-08-30 07:43:32 DEBUG SQLOperation select name from Pet | {} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Pet | {} 2024-08-30 07:43:32 DEBUG SQLOperation delete from Pet where (name, race, age) in ((?, ?, ?)) | {Pet.name=Pluto, Pet.race=Dog, Pet.age=4} 2024-08-30 07:43:32 DEBUG SQLOperation select name from Pet | {} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Pet | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0180crud_inheritance_tablePerClassfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation insert into Cat(catBreed, name, race, age ...[truncated 1279 chars]... at.name=Pluto} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Cat where age = ? and race = ? and name = ? | {1={Cat.age=4, Cat.race=Dog, Cat.name=Pluto}} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Cat | {} 2024-08-30 07:43:32 DEBUG SQLOperation delete from Cat where (name, race, age) in ((?, ?, ?)) | {Cat.age=4, Cat.race=Dog, Cat.name=Pluto} 2024-08-30 07:43:32 DEBUG SQLOperation select catBreed from Cat | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130crud_manyToManyfalsePASSED2024-08-30 07:43:32 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer create table Person_pets(person_firstName varchar(255), person_lastName varchar(255), person_addr ...[truncated 3651 chars]... rson_pets.person_firstName=John, Person_pets.pets_name=Rantanplan, Person_pets.person_lastName=Do, Person_pets.person_address=nowhere}} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and firstName = ? and address = ? | {1={Person.lastName=Do, Person.firstName=John, Person.address=nowhere}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0140crud_oneToMany_ownedByTargetfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer alter table P ...[truncated 2891 chars]... erLastName (U)=null, Pet.name (W)=Rantanplan, Pet.ownerFirstName (U)=null, Pet.ownerAddress (U)=null, Pet.race (W)=Dog, Pet.age (W)=5}} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and firstName = ? and address = ? | {1={Person.lastName=Do, Person.firstName=John, Person.address=nowhere}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0160crud_oneToMany_withAssociationTablefalsePASSED2024-08-30 07:43:32 DEBUG DDLDeployer create table Pet(name varchar(255) not null, race varchar(255) not null, age integer not null, unique (name, race, age)) 2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer create table Person_pets(person_firstName varchar(255), person_lastName varchar(255), person_addr ...[truncated 3651 chars]... on_firstName=John, Person_pets.pets_race=Dog, Person_pets.pets_name=Pluto, Person_pets.person_address=nowhere, Person_pets.pets_age=4}} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.lastName=Do, Person.address=nowhere, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.firstName, Person.lastName, Person.address from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0130crud_oneToOne_compositeToCompositeKey_ownedBySourcefalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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 2322 chars]... ame (W)=Do, Person.houseCity (U)=CodeFilarete City, Person.houseZipCode (U)=888, Person.age (U)=36}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where firstName = ? and lastName = ? and address = ? | {1={Person.address=nowhere, Person.lastName=Do, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0120crud_oneToOne_compositeToCompositeKey_ownedByTargetfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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)) ...[truncated 2921 chars]... House.city (W)=CodeFilarete City, House.ownerFirstName (U)=null, House.number (W)=42, House.ownerAddress (U)=null, House.street (W)=Stalactite street, House.zipCode (W)=888}} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.lastName=Do, Person.address=nowhere, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.010crud_oneToOne_compositeToSingleKey_ownedBySourcefalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer create table House(id bigint GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) not null, unique (id)) 2024-08-30 07:43:32 DEBUG DDLDeployer alter table Person add constraint FK_Person_houseId_House_id foreign key(houseId) referenc ...[truncated 1103 chars]... owhere, Person.firstName (W)=John, Person.lastName (W)=Do, Person.age (U)=36, Person.houseId (U)=1}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where firstName = ? and address = ? and lastName = ? | {1={Person.address=nowhere, Person.firstName=John, Person.lastName=Do}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0120crud_oneToOne_compositeToSingleKey_ownedByTargetfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer alter table House add ...[truncated 1989 chars]... stName = ?, ownerFirstName = ?, ownerAddress = ? where id = ? | {1={House.ownerLastName (U)=null, House.ownerFirstName (U)=null, House.ownerAddress (U)=null, House.id (W)=1}} 2024-08-30 07:43:32 DEBUG SQLOperation Batching statement 1 times 2024-08-30 07:43:32 DEBUG SQLOperation delete from Person where lastName = ? and address = ? and firstName = ? | {1={Person.lastName=Do, Person.address=nowhere, Person.firstName=John}} 2024-08-30 07:43:32 DEBUG SQLOperation select Person.age from Person | {} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0380persist_manyToManyfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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 6429 chars]... rson_pets as Person_pets on Person.firstName = Person_pets.person_firstName and Person.lastName = Person_pets.person_lastName and Person.address = Person_pets.person_address left outer join Pet as Person_pets_Pet on Person_pets.pets_name = Person_pets_Pet.name and Person_pets.pets_race = Person_pets_Pet.race and Person_pets.pets_age = Person_pets_Pet.age where (Person.firstName, Person.lastName, Person.address) in ((?, ?, ?)) | {Person.firstName=John, Person.address=nowhere, Person.lastName=Do} 0org.codefilarete.stalactite.engine.FluentEntityMappingConfigurationSupportCompositeKeyTest0.0140persist_oneToMany_ownedByTargetfalsePASSED2024-08-30 07:43:32 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-08-30 07:43:32 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-08-30 07:43:32 DEBUG DDLDeployer alter table P ...[truncated 4356 chars]... t Person.age as Person_age, Person.firstName as Person_firstName, Person.lastName as Person_lastName, Person.address as Person_address, Pet.name as Pet_name, Pet.age as Pet_age, Pet.race as Pet_race from Person left outer join Pet as Pet on Person.firstName = Pet.ownerFirstName and Person.lastName = Pet.ownerLastName and Person.address = Pet.ownerAddress where (Person.firstName, Person.lastName, Person.address) in ((?, ?, ?)) | {Person.firstName=John, Person.address=nowhere, Person.lastName=Do} 0FluentEntityMappingConfigurationSupportCompositeKeyTest160