package org.hibernate.bugreport.jointable.constraintviolation;

import org.hibernate.bugreport.jointable.constraintviolation.entity.Component;
import org.hibernate.bugreport.jointable.constraintviolation.entity.Laptop;
import org.junit.Test;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;

public class JoinTableTests {

    @Test
    public void testSetup() {
        EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("JoinTableConstraintViolation");
        EntityManager entityManager = entityManagerFactory.createEntityManager();
        EntityTransaction transaction = entityManager.getTransaction();
        transaction.begin();

        Laptop laptop = new Laptop();
        laptop.setBrand("Toshiba");
        laptop.setSeries("Protege");

        Component component1 = new Component();
        component1.setName("RAM");

        Component component2 = new Component();
        component2.setName("HDD");

        laptop.addComponent(component1);
        laptop.addComponent(component2);

        entityManager.persist(laptop);
        transaction.commit();
    }
}

Hibernate: drop table Laptop if exists
Hibernate: drop table laptop_components if exists
Hibernate: create table Component (id varchar(255) not null, name varchar(255), laptop_id varchar(255), primary key (id))
Hibernate: create table Laptop (id varchar(255) not null, brand varchar(255), series varchar(255), primary key (id))

Hibernate: create table laptop_components (
    laptop_id varchar(255) not null, 
    component_id varchar(255) not null, 
    primary key (laptop_id, component_id)
)

Hibernate: alter table laptop_components add constraint UK_1n0yp9k01q1uf7nf5kadq4o2s unique (component_id)
Hibernate: alter table Component add constraint FKih2f07tb259k4o5j7oi6x0yy8 foreign key (laptop_id) references Laptop
Hibernate: alter table laptop_components add constraint FKsyr0k6qm7di0dijd7hlvjtcj9 foreign key (component_id) references Component
Hibernate: alter table laptop_components add constraint FKm3j842ax28v8q7l805un43qbj foreign key (laptop_id) references Laptop
Hibernate: insert into Laptop (brand, series, id) values (?, ?, ?)
Hibernate: insert into Component (laptop_id, name, id) values (?, ?, ?)
Hibernate: insert into laptop_components (laptop_id, component_id) values (?, ?)