Support for left join in Get Query

[janakact]

If a particular optional relation is not present for the entity, the entry is not included in the join result.

crud/src/typeorm/repository-service.class.ts

Line 336 in 69da293

private getJoinType(relationType: string): string {

[icewind]

It would be very nice to have an ability to define join type. Since if we have(and we have :)) nullable relation then entire entry will be missing from result set. We can just override getOne in service but out of the box feature would be more convenient. Thank you.

[michaelyali]

Yeah. Actually, I'm always forgetting about that issue :( Sorry

[Bnaya]

As a workaround
I'm thinking about overriding getJoinType and return left join for one to one.
getJoinType is private, but // @ts-ignore should do the trick

Anyhow, making it configurable would be great.

[Bnaya]

// @ts-ignore
CompetitiveSetsService.prototype.getJoinType = function getJoinType(relationType: string) {
  switch (relationType) {
    case "many-to-one":
      return "innerJoin";

    default:
      return "leftJoin";
  }
};