Testing & Map

I am trying to genericize the map.xml for multiple instances with multiple dbnames (looking for a “use <dbname>” analogue for cayenne config files - or a better idea if you have one)

Details ...

Context:
  cayenne: 4.0.1
  db: mysql 8.0.16
  dbname: “cms" / “cmstest" / "cms_<bunch of others suffixes>” (all referring to the same schema)

Goals:
  - migrate to cicd (gradle, git, jenkins, automated testing,etc)
  - support testing configurations, as well as multiple instances of the same app but with unique dbnames

Prob:
While trying to migrate to fully automated testing (using junit-5) I hit a snag:
  - the cayenne map.xml has the datasource name (“cms” in this instance) embedded in the map.xml config file:

	<property name="defaultSchema" value="cms”/>
	...
	<db-entity name="admin" schema="cms">
		…
	</db-entity>

So the general idea I had was to create a tmp-test database (cmstest), run the junit tests for unit & complex unit testing configured using gradle, then move on to a more complex testing config downstream.   When I deploy it will be to multiple instances (with unique dbnames).

But I cannot figure out how to genericize this map.xml so that I can easily change the datasource name - I could throw sed/awk at it - to change all the schema-name-refs, but I was hoping for something a bit more cayenne-oriented (and less brittle than sed/awk).

Ideally, I am searching for a cayenne-analogue to mysql “use <dbname>” so that I could change the datasource name in one location (vs 25).

Thanks
Joe
PS if you have any other gradle tricks that you rely on, please do send a link