fixture

pnpm fixture init

DUMP...
  ✓ Schema dumped from development_master

SYNC to (REMOTE) Fixture DB...
  ✓ Database myapp_fixture created
  ✓ Schema applied

SYNC to (LOCAL) Testing DB...
  ✓ Database myapp_test created
  ✓ Schema applied

Fixture initialization completed!

pnpm fixture import

? Please select entity: (Use arrow keys)
❯ User
  Post
  Comment
  
? Enter record IDs (comma-separated): 1,2,3

Importing fixtures...
  ✓ Imported User #1
  ✓ Imported User #2
  ✓ Imported User #3
  ✓ Imported related records (5 dependencies)

Fixture import completed!

pnpm fixture sync

Syncing fixtures...

Clearing test database...
  ✓ Cleared all tables

Applying fixtures...
  ✓ Applied 3 users
  ✓ Applied 7 posts
  ✓ Applied 12 comments
  ✓ Applied 5 categories

Fixture sync completed!

# 테스트 DB 생성 및 스키마 복사
pnpm fixture init

# User #1, #2, #3 가져오기
pnpm fixture import

# Entity: User
# IDs: 1,2,3

pnpm test

pnpm fixture import

# Entity: Post
# IDs: 1

# 자동으로 포함됨:
# ✓ Post #1
# ✓ User #5 (author)
# ✓ Category #2 (category)

pnpm fixture import

# Entity: Post
# IDs: 1

# 자동으로 포함됨:
# ✓ Post #1
# ✓ post_tags (중간 테이블)
# ✓ Tag #1, #2, #3 (연결된 태그들)

describe("User CRUD", () => {
  beforeEach(async () => {
    // 각 테스트 전에 fixture 재적용
    await FixtureManager.sync();
  });

  test("사용자 생성", async () => {
    const user = await UserModel.create({
      email: "[email protected]",
      name: "신규사용자",
    });
    
    expect(user.id).toBeDefined();
  });

  test("사용자 삭제", async () => {
    await UserModel.deleteById(1);
    
    const user = await UserModel.findById(1);
    expect(user).toBeNull();
  });
});

import { Sonamu } from "sonamu";

test("트랜잭션 테스트", async () => {
  await Sonamu.runScript(async () => {
    // 트랜잭션 내에서 실행
    const user = await UserModel.create({...});
    const post = await PostModel.create({...});
    
    // 테스트 완료 후 자동 롤백
  });
});

describe("Post with Comments", () => {
  beforeAll(async () => {
    // Post #1 (+ User #1, Comments)
    await FixtureManager.sync();
  });

  test("댓글이 있는 Post 조회", async () => {
    const post = await PostModel.findById(1, {
      include: ["comments"],
    });
    
    expect(post.comments).toHaveLength(3);
    expect(post.comments[0].author_id).toBe(2);
  });
});

describe("Premium User Features", () => {
  beforeAll(async () => {
    // Premium user만 import
    await FixtureManager.importFixture("User", [10, 11, 12]);
    await FixtureManager.sync();
  });

  test("프리미엄 기능 접근", async () => {
    const user = await UserModel.findById(10);
    
    expect(user.isPremium).toBe(true);
    expect(await user.canAccessFeature("advanced")).toBe(true);
  });
});

Error: connect ECONNREFUSED

Error: Foreign key constraint violation

# 관련 데이터를 먼저 import
pnpm fixture import
# Entity: User
# IDs: 1,2,3

pnpm fixture import
# Entity: Post
# IDs: 1,2,3  # User 1,2,3을 참조

Error: Duplicate entry '1' for key 'PRIMARY'

# Test DB 초기화
pnpm fixture init

# Fixture 재동기화
pnpm fixture sync

# ❌ 모든 데이터 import
pnpm fixture import
# IDs: 1-1000

# ✅ 필요한 데이터만
pnpm fixture import
# IDs: 1,2,3  # 대표 케이스만

// ✅ 테스트 목적이 명확한 데이터
{
  "id": 1,
  "email": "[email protected]",
  "role": "admin",
  "name": "관리자"
}
{
  "id": 2,
  "email": "[email protected]",
  "role": "user",
  "name": "일반사용자"
}

# Fixture 파일을 Git에 포함
git add src/fixtures/
git commit -m "Update test fixtures"