IMPR: split unit/integration test

[yambottle]

Improvement Request

Problem

Currently, datajoint-python pytest runs unit and integration test by default, which requires a DB

pytest --cov-report term-missing --cov=datajoint tests
# trying to connect to a DB, otherwise integration test would fail

so it actually needs runs in docker that comes with a DB container

docker compose --profile test up --quiet-pull --build --exit-code-from djtest djtest

Requirements

N/A

Justification

We should add unit test check in pre-commit locally, and let the CI to run integration test with docker

Alternative Considerations

N/A

Related Errors

N/A

Please include steps to reproduce provided errors as follows:
N/A

Screenshots

N/A

Additional Research and Context

N/A