Drizzle 쿼리 μ νΈλ¦¬ν°
$count
db.$count()λ count(*)μ μ νΈλ¦¬ν° λνΌλ‘, κ·Έλλ‘ μ¬μ©νκ±°λ μλΈμΏΌλ¦¬λ‘ μ¬μ©ν μ μλ λ§€μ° μ μ°ν μ°μ°μμ
λλ€. μμΈν λ΄μ©μ GitHub ν λ‘ μ μ°Έμ‘°νμΈμ.
const count = await db.$count(users);
// ^? number
const count = await db.$count(users, eq(users.name, "Dan")); // νν°μ ν¨κ» μλselect count(*) from "users";
select count(*) from "users" where "name" = 'Dan';μλΈμΏΌλ¦¬μμ νΉν μ μ©ν©λλ€:
const users = await db.select({
...users,
postsCount: db.$count(posts, eq(posts.authorId, users.id)),
}).from(users);κ΄κ³ν 쿼리μ ν¨κ» μ¬μ©νλ μμ
const users = await db.query.users.findMany({
extras: {
postsCount: db.$count(posts, eq(posts.authorId, users.id)),
},
});