sync-db.yml

basePath: src
execution: sequential
sql:
  # Create objects in dbo schema
  - function/dbo/sum.sql
  - function/dbo/square.sql
  - trigger/dbo/trg_users.sql

  # Create objects in utils schema
  - schema/utils.sql
  - function/utils/product.sql
  - procedure/utils/get_date.sql
  - view/utils/vw_users.sql
  - view/utils/vw_tasks.sql
  - view/utils/vw_user_emails.sql.drop # This view will only be dropped - not synchronized.

  # Create objects in testdata schema
  - schema/testdata.sql
  - procedure/testdata/setup_data.sql

hooks:
  post_sync:
    - scripts/setup.sql

migration:
  directory: migration

injectedConfig:
  vars:
    create_admin: ${CREATE_ADMIN}
    admin_email: 'admin@example.com'
    task_status: ${TASK_STATUS}