Drizzle ORM 심화 — 관계 정의와 마이그레이션

관계 정의

import { relations } from "drizzle-orm";

export const usersRelations = relations(users, ({ many }) => ({
  posts: many(posts),
}));

export const postsRelations = relations(posts, ({ one }) => ({
  author: one(users, {
    fields: [posts.authorId],
    references: [users.id],
  }),
}));

관계 쿼리

const result = await db.query.users.findFirst({
  where: eq(users.id, 1),
  with: { posts: { limit: 10, orderBy: desc(posts.createdAt) } },
});

마이그레이션

npx drizzle-kit generate
npx drizzle-kit migrate