Table can't reference another table twice

[bacebu4]

Given the following schema

CREATE TABLE quotes (
  id INTEGER PRIMARY KEY,
  quote TEXT NOT NULL,
  said_by VARCHAR(255) NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE movies (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL UNIQUE
);

ALTER TABLE quotes ADD COLUMN movie_id INTEGER REFERENCES movies(id);
ALTER TABLE quotes ADD COLUMN another_movie_id INTEGER REFERENCES movies(id);

I can't fetch another_movie entity from graphQL. By the way, it's a real case scenario, table names were changed on purpose

Tried finding a problem by myself but haven't got a clue where to start

[bacebu4]

Ok, I found out the line that can be fixed

https://github.com/platformatic/platformatic/blob/main/packages/sql-graphql/lib/relationship.js#L26

It should probably rely on relation.column_name

The more harder topic – how should we determine how we should call that relation? It's easy if it's called some_entity_id (we can simply cut out the _id part)
But what is someone not following this guideline? I suppose this framework doesn't want to insist on that

So there could be a numerous solutions but I have no idea which one better suits this framework

Also would be glad to help if needed :)

[bacebu4]

Inverse side of the relation is also gonna be broken in that case

movies {
    id
    quotes {
      id
    }
  }

quotes will only look for another_movie_id references

[mcollina]

A PR would be awesome, thanks!

As for naming, I would recommend using the same logic of the other properties.

[bacebu4]

A PR would be awesome, thanks!

As for naming, I would recommend using the same logic of the other properties.

Got you, I'll let you know if I'm gonna get stuck again