initium/examples/seed/basic-seed.yaml at main · KitStream/initium · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
database:
  driver: postgres
  url_env: DATABASE_URL
  tracking_table: initium_seed

phases:
  - name: data
    seed_sets:
      - name: departments
        order: 1
        tables:
          - table: departments
            unique_key: [name]
            auto_id:
              column: id
              id_type: integer
            rows:
              - _ref: dept_eng
                name: Engineering
              - _ref: dept_sales
                name: Sales
              - _ref: dept_hr
                name: Human Resources

      - name: employees
        order: 2
        tables:
          - table: employees
            unique_key: [email]
            auto_id:
              column: id
            rows:
              - name: Alice Johnson
                email: alice@example.com
                department_id: "@ref:dept_eng.id"
                role: admin
              - name: Bob Smith
                email: bob@example.com
                department_id: "@ref:dept_sales.id"
                role: user
              - name: Carol Williams
                email: carol@example.com
                department_id: "@ref:dept_hr.id"
                role: user