Our Acoustic export has relied on some pretty messy work on the dev side to test. I think Elliott had a way of getting it to work & this was my way - https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/tools/+/673176 (Elliott said he also used the civicrm docker service for testing so possibly similar).
Without Elliott we need someone else to be able to work on review so it might be work cleaning this up a bit.
Some work has been done on a docker image here https://gitlab.wikimedia.org/repos/releng/dev-images/-/merge_requests/29 - although it stalled & that is a fairly ambitious piece.
Things we need
- a service, being it our civicrm one or a new one running python-3 & tox - ie
apt update apt install python3-pip apt install tox
- ideally also run pip3 install -r /srv/tools/requirements.txt on this service
- a datbase called test with an associated user with broad privelleges
. `CREATE database test;`
. `CREATE USER test@%;`
. `GRANT ALL PRIVILEGES ON test.* TO test@%;`
- a database to be created (called silverpop )
Note a BETTER alternative to 3 is to stop having to create test via minimal_schema.mysql and instead interact with the mysql db directly. I'm not too sure what would be involved.... - it is loaded in def run_update_with_fixtures(fixture_path=None, fixture_queries=None):