ManyHasMany table example

[dominikmiskovec]

Hi, I am wondering how ManyHasMany table looks like.

We know that we have to create primary_x_secondary table but we don't know which columns it should have. Does anybody have an example of SQL or something like that?

We are trying to solve it for about 2 hours.

Users class
* @property Eshop[]|null $eshops {m:m Eshop::$users}

Eshop class
* @property User[]|null $users {m:m User::$eshops, isMain=true}

[hrach]

It should have:

• two columns, both creating a composite primary key
• each of them being a foreign key
• the column names do not matter much

Resolution logic may be found here:

orm/src/Mapper/Dbal/Conventions/Conventions.php

Line 315 in 3361400

protected function findManyHasManyPrimaryColumns(string $joinTable, Table $targetTableReflection): array

[dominikmiskovec]

And when we try to add something into $eshops it throws an error.

No primary keys detected for many has many 'product_x_eshop' join table.

But we don't have ManyHasMany anywhere else.

[hrach]

Show me your table definition please.

[dominikmiskovec]

create table touchlogis.user_x_eshop
(
    user  int not null,
    eshop int not null,
    primary key (user, eshop),
    constraint user_x_eshop_eshop
        foreign key (eshop) references touchlogis.eshop (id),
    constraint user_x_eshop_user
        foreign key (user) references touchlogis.user (id)
);

create index user_x_eshop_eshop_idx
    on touchlogis.user_x_eshop (eshop);

[hrach]

Well, the error says you look for 'product_x_eshop' join table. Is it just the same issue with another relationship or is there some other issue?

[dominikmiskovec]

Yes but there is a problem there is no ManyHasMany relationship between Eshop and Product see images
This one is from Eshop

There is Product