Function generateSeedData

packages/db-collection-e2e/src/fixtures/seed-data.ts:36–210

()

 * - Some soft-deleted records
 */
export function generateSeedData(): SeedDataResult {
  const users: Array<User> = []
  const posts: Array<Post> = []
  const comments: Array<Comment> = []

  const now = new Date()
  const oneDay = 24 * 60 * 60 * 1000
  const oneYear = 365 * oneDay

  // Generate 100 users with varied distributions
  for (let i = 0; i < 100; i++) {
    const id = generateId(`user`, i)

    // Name variations for collation testing
    const names = [
      `Alice ${i}`,
      `bob ${i}`,
      `Charlie ${i}`,
      `DIANA ${i}`,
      `Eve ${i}`,
      `Frank ${i}`,
      `Grace ${i}`,
      `henry ${i}`,
      `Ivy ${i}`,
      `Jack ${i}`,
      `Kate ${i}`,
      `liam ${i}`,
      `Mia ${i}`,
      `Noah ${i}`,
      `Olivia ${i}`,
      `PAUL ${i}`,
      `Quinn ${i}`,
      `Rose ${i}`,
      `sam ${i}`,
      `Tina ${i}`,
      `Ursula ${i}\nNewline`,
    ]
    const name = names[i % names.length]

    // Email: 70% have emails, 30% null
    const email = i % 10 < 7 ? `user${i}@example.com` : null

    // Age distribution: 18-80, with some edge cases
    const age = i === 0 ? 0 : i === 1 ? -5 : i === 2 ? 150 : 18 + (i % 63)

    // IsActive: 80% true, 20% false
    const isActive = i % 5 !== 0

    // CreatedAt: distributed over past year
    const createdAt = new Date(now.getTime() - Math.random() * oneYear)

    // Metadata: 40% have metadata, 60% null
    const metadata =
      i % 5 < 2 ? { score: i * 10, level: Math.floor(i / 10) } : null

    // DeletedAt: 10% soft deleted
    const deletedAt =
      i % 10 === 0