How to properly specify multiple belongs_to() rules pointing to same table?

[kamakazikamikaze]

I've hit an issue defining a table where a row contains two foreign keys from the same target table.

For example:

class User(Model):
    primary_keys = ["user_id"]
    user_id = Field.int()
    name = Field().string()
    birthday = Field.datetime()
    has_many({"sent": "Whisper.sender_user_id"}, {"received": "Whisper.receiver_user_id"})

class Whisper(Model):
    belongs_to({"sender": "User"}, {"receiver": "User"})
    message = Field.text()
    timestamp = Field.datetime()

Running this will raise an error of psycopg2.error.InvalidForeignKey: foreign key referenced-columns list must not contain duplicates

It seems to stem from something similar to this StackOverflow post. Apparently the foreign keys need to be announced separately instead of all at the same time? Is that something I can do?

[gi0baro]

@kamakazikamikaze the has_many definition seems wrong, should look like this:

has_many({"sent": "Whisper.sender"}, {"received": "Whisper.receiver"})

I also don't really get why you would define a User table with an integer primary key user_id instead of using the default id implementation..

[gi0baro]

@kamakazikamikaze can you please check if #501 fixes your issue?

[kamakazikamikaze]

I'll give it a shot. Stay tuned.

[kamakazikamikaze]

It works! 🎉

[gi0baro]

👍 I'll release a patch version the next week