Feature Request - docker testing environments

[divinebovine]

I was able to run the postgres tests by doing the following:

1. Setup a .env file with the following:

POSTGRES_NAME=postgres
POSTGRES_USER=postgres
POSTGRES_PASS=postgres
POSTGRES_HOST=localhost
POSTGRES_PORT=5555

2. Launch postgres with docker
   docker run --rm --name sequelize-auto-postgres-tests -p 5555:5432 -e POSTGRES_USER=postgres -e POSTGRES_DB=postgres -e POSTGRES_PASSWORD=postgres postgres

If you take it a step further and set everything up using docker-compose file(s) it might make the development process a little better. Just a thought.

[steveschmitt]

That would be pretty cool. Setting up the testing environment is the biggest hurdle to contributing, IMHO. If we had a containerized testing environment, that would surely help.

Unfortunately, I'm a complete zero when it comes to docker knowledge, so I'll have to rely on you and others to get this going.

[papb]

Hello! I suggest taking a look at the docker testing environments used within GitHub Actions from our main repository: https://github.com/sequelize/sequelize/blob/v6/.github/workflows/ci.yml

[jsau-]

I won't have a huge amount of time next week, but I'm happy to start looking at this. Should be able to get at least a WIP PR across by this time next week.

[jsau-]

Got the containers setup as part of https://github.com/sequelize/sequelize-auto/pull/502/files.

As part of this I also run the migrations in sample/dbscripts. Getting syntax errors on the mssql part though, which I'll try look at s'more when I get time next week (unless anyone else wants to take a look before then).