Kedric Kim
@kedricme
Reviews Written
5
Average Rating
5.0
Posts
Q&A
CachedNetworkImage ๋ก ์ธํ memory leak ๋ฌธ์ ..
์์ฒด ํด๊ฒฐํ์ฌ ๋จ๊น๋๋ค !CachedNetworkImage์ memCacheHeight๋ฅผ grid ํฌ๊ธฐ์ ๋ง๊ฒ ์ ์ธํ์ฌ ํด๊ฒฐํ์์ต๋๋ค๊ฐ์ฌํฉ๋๋ค
- 0
- 2
- 927
Q&A
mysql JOIN UPDATE ๊ด๋ จ ์ง๋ฌธ ๋๋ฆฝ๋๋ค !
์๋ ํ์ธ์ ์ฐ์ ์ํ๋์ ๊ฐ์๋ฅผ ํ ๋๋ก from์ ์์์ subquery๋ ์๋๋ค๋ ์ ์ ํ์ ์ฟผ๋ฆฌ๋ฅผ 2๋ฒ ๋๋ ์ ์คํํ์์ต๋๋ค. (์ฐธ๊ณ ๋ก mysql ๊ธฐ์ค์ ๋๋ค.) ํน์ ๋ค๋ฅธ ๋ฐฉ๋ฒ์ด ์๋ค๋ฉด ๋ต๋ณ ๋ถํ๋๋ฆฝ๋๋ค - ๊ธฐ์กด์์ค @Testpublic void updateSubquery() { Team team = new Team("teamA"); em.persist(team); Member newMember = new Member("user1"); newMember.setTeam(team); em.persist(newMember); QMember subM = new QMember("subM"); QTeam subT = new QTeam("subT"); long result = queryFactory .update(member) .set(member.age, member.age.add(10)) .where(member.id.in( JPAExpressions.select(subM.id) .from(subM) .join(subM.team, subT) .where(subT.name.eq("teamA")) )) .execute(); assertThat(result).isEqualTo(1);} - ์์ ํ ์์ค @Testpublic void updateSubquery() { Team team = new Team("teamA"); em.persist(team); Member newMember = new Member("user1"); newMember.setTeam(team); em.persist(newMember); QMember subM = new QMember("subM"); QTeam subT = new QTeam("subT"); List list = queryFactory .select(subM.id) .from(subM) .join(subM.team, subT) .where(subT.name.eq("teamA")) )).fetch(); long result = queryFactory .update(member) .set(member.age, member.age.add(10)) .where(member.id.in( list )) .execute(); assertThat(result).isEqualTo(1);}
- 1
- 1
- 489




