Relations with conditions, is it possible ?

[pasichnyk]

Is there a way to put some condition into relations()?

If I have a table: "Table 1", with fields: "user_id", "user_type". And I need to connect "user_id" with table "Doctors" or with "Patients" depending on what contains "user_type".

Thank you.

[FlipEverything]

This question isn't Spot related. You can't do that on the relational database level. You can read more about it here.

[pasichnyk]

I had guessed it's impossible on the relational database level. But maybe Spot has a way to walk over it?

[FlipEverything]

I don't think so. You can define dynamic relations, but you shouldn't really. It would be a mess.

[pasichnyk]

I've understood I need to change structure of the tables. But if I would wanted to make that implementation, do I can get value of the field ?

public static function relations(MapperInterface  $mapper, EntityInterface $entity)
    {
        switch( /* fieldName->value  */ ) //  <- ??
        {
            case "doctor":
                return [
                    "user" => $mapper->belongsTo($entity, "Doctors", "user_id")
                ]
                break;
            case "patient":
                return [
                    "user" => $mapper->belongsTo($entity, "Patients", "user_id")
                ]
                break;
        }
}

[FlipEverything]

In theory you can do that. You must disable foreign key support and have to implement all the things that will ensure database integrity on the application side (and by default is done by the DBMS).

I don't think that's worth it.