Method appendHasOneJoin

orm/join.go:238–290

(fmter QueryFormatter, b []byte, q *Query)

}

func (j *join) appendHasOneJoin(fmter QueryFormatter, b []byte, q *Query) (_ []byte, err error) {
	isSoftDelete := j.JoinModel.Table().SoftDeleteField != nil && !q.hasFlag(allWithDeletedFlag)

	b = append(b, "LEFT JOIN "...)
	b = fmter.FormatQuery(b, string(j.JoinModel.Table().SQLNameForSelects))
	b = append(b, " AS "...)
	b = j.appendAlias(b)

	b = append(b, " ON "...)

	if isSoftDelete {
		b = append(b, '(')
	}

	if len(j.Rel.BaseFKs) > 1 {
		b = append(b, '(')
	}
	for i, baseFK := range j.Rel.BaseFKs {
		if i > 0 {
			b = append(b, " AND "...)
		}
		b = j.appendAlias(b)
		b = append(b, '.')
		b = append(b, j.Rel.JoinFKs[i].Column...)
		b = append(b, " = "...)
		b = j.appendBaseAlias(b)
		b = append(b, '.')
		b = append(b, baseFK.Column...)
	}
	if len(j.Rel.BaseFKs) > 1 {
		b = append(b, ')')
	}

	for _, on := range j.on {
		b = on.AppendSep(b)
		b, err = on.AppendQuery(fmter, b)
		if err != nil {
			return nil, err
		}
	}

	if isSoftDelete {
		b = append(b, ')')
	}

	if isSoftDelete {
		b = append(b, " AND "...)
		b = j.appendAlias(b)
		b = j.appendSoftDelete(b, q.flags)
	}

	return b, nil
}

type hasManyColumnsAppender struct {
	*join