~aksel

cool boi


#93 Dependencies between sources 2 years ago

Ticket created by ~aksel on ~olly/yoyo

Is there a way for a migration to depend on a migration from a different folder?

I'm trying to structure a project in a way that makes sense to my mental model.

I have a folder structure something like the following:

src/
  db/
    main/
      0000__create_schema.sql
      0001__create_some_tables.sql
    cool_feature/
      0000__create_some_cool_feature.sql
      0001__alter_some_cool_feature.sql

Migrations in cool_feature depend on the fundamental stuff from main. I can get yoyo to apply migrations from both, by specifying multiple sources, or by globbing, but I can't seem to get cross-source dependencies to work.

Alternatively, if you think I'm doing something incredibly silly, I'm all ears. Any suggestions on a different project structure, I'm all ears. Because I can't for the life of me find anything on this, on how to make a purely-PostgreSQL project comprehensible from a structural standpoint! ;_;