# .github/workflows/test.yml
jobs:
  test:
    services:
      postgres:
        image: postgres:16
        env:
          POSTGRES_DB: testdb
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-go@v5
        with:
          go-version: "1.25"
      - run: go install github.com/tomiwa-a/seedling/cmd/seedling@latest
      - run: seedling generate --db postgres://postgres@localhost:5432/testdb
      - run: go test ./...

jobs:
  seedling-replay-e2e:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: postgres:15-alpine
        env:
          POSTGRES_PASSWORD: password
    steps:
      - uses: actions/checkout@v4

      - name: Install Seedling
        run: go install github.com/tomiwa-a/seedling@latest

      - name: Seed deterministic test data
        run: seedling generate --count 1000 --seed 42 \
          --db postgres://postgres:password@postgres:5432/postgres

      - name: Install Replay
        run: go install github.com/replay/replay@latest

      - name: Run E2E workflows
        run: replay run tests/e2e/*.yaml --concurrency 4 --fail-fast
        env:
          POSTGRES_DSN: postgres://postgres:password@postgres:5432/postgres

seedling generate --count 500 --seed 42 \
  --db postgres://localhost:5432/testdb \
  && replay run test.yaml

func TestUserWorkflow(t *testing.T) {
    // Seed with deterministic data
    exec.Command("seedling", "generate",
        "--count", "100",
        "--seed", "42",
        "--db", "postgres://localhost:5432/testdb",
    ).Run()

    // Your test assertions
    users := fetchUsers()
    assert.Len(t, users, 100)
}

# Truncate and regenerate
seedling generate \
  --count 500000 \
  --db postgres://staging:password@staging-host:5432/mydb \
  --truncate \
  --verbose

# Small, fast dataset for dev work
seedling generate \
  --count 50 \
  --seed 1 \
  --output seed.sql

psql -d localdb -f seed.sql

# 10 million rows via COPY protocol for max throughput
seedling generate \
  --count 10000000 \
  --db postgres://localhost:5432/loadtest \
  --copy \
  --batch-size 5000

# Run migration
migrate -database $DATABASE_URL -path migrations up

# Regenerate data against migrated schema
seedling introspect --db $DATABASE_URL --output schema.yaml
seedling generate --count 1000 --db $DATABASE_URL

# CSV for spreadsheet analysis
seedling generate \
  --count 10000 \
  --output data/ \
  --format csv

# JSONL for event streams
seedling generate \
  --count 50000 \
  --output events.jsonl \
  --format jsonl