<div id="readability-page-1" class="page"><div><h2 id="case1">case1</h2>
<pre><code>const pushes = await pushRepo
        .createQueryBuilder('push')
        .select('push.push_id')
        .addSelect('other_profile.user_profile_img')
        .leftJoin('push.other_user', 'other_user')
        .leftJoin('other_user.profile', 'other_profile')
        .where('push.receiver = :receiver', { receiver: userId })
        .orderBy('push.created_at', 'DESC')
        .getMany();</code></pre>
<p><img src="https://media.vlpt.us/images/jeong3320/post/805015a6-a6bf-4e92-9015-c327e92bbddc/Screen%20Shot%202022-01-12%20at%2012.25.13%20PM.png"></p>
<h2 id="case2">case2</h2>
<pre><code>const pushes = await pushRepo
        .createQueryBuilder('push')
        .select('push.push_id')
        .addSelect('other_user.id')  &lt;===
        .addSelect('other_profile.user_profile_img')
        .leftJoin('push.other_user', 'other_user')
        .leftJoin('other_user.profile', 'other_profile')
        .where('push.receiver = :receiver', { receiver: userId })
        .orderBy('push.created_at', 'DESC')
        .getMany();</code></pre>
<p><img src="https://media.vlpt.us/images/jeong3320/post/61aa4cd4-a896-4c65-911f-988ed16c3474/Screen%20Shot%202022-01-12%20at%2012.25.44%20PM.png"></p>
<p>leftJoin시 해당 엔티티의 아이디를 select하지 않으면 해당 엔티티의 다른 값을 가져올 수 없다.</p></div></div>

jeong3320.log

case1
const pushes = await pushRepo
        .createQueryBuilder('push')
        .select('push.push_id')
        .addSelect('other_profile.user_profile_img')
        .leftJoin('push.other_user', 'other_user')
        .leftJoin('other_user.profile', 'other_profile')
        .where('push.receiver = :receiver', { receiver: userId })
        .orderBy('push.created_at', 'DESC')
        .getMany();
case2
const pushes = await pushRepo
        .createQueryBuilder('push')
        .select('push.push_id')
        .addSelect('other_user.id')  <===
        .addSelect('other_profile.user_profile_img')
        .leftJoin('push.other_user', 'other_user')
        .leftJoin('other_user.profile', 'other_profile')
        .where('push.receiver = :receiver', { receiver: userId })
        .orderBy('push.created_at', 'DESC')
        .getMany();
leftJoin시 해당 엔티티의 아이디를 select하지 않으면 해당 엔티티의 다른 값을 가져올 수 없다.

[typeOrm]leftJoin시 주의할점

댓글