Related to T4305

Needed since package loaders now create release objects instead
of revision objects.

This will make it easier to support indexing from releases in the future,
as it will remove the strong dependency on revision ids in the database
and interfaces.

The existence of the indexer/table  is mostly to deduplicate work between
origins with the same head revision, and we do not use it outside this
context, so this should have no impact.

The DB migration works by dropping both tables and re-indexing from
scratch; which is necessary as we need to replace revision ids with
directory ids.

'local' is a deprecated alias

instead of (soon-to-be-deprecated) swh-core's postgresql_fact one.

We stopped using it as an indexer years ago, so it does not make sense
to keep this class around.

Additionally, replace the weird dict (needed by the indexer interface)
with a CoreSWHID (now possible, as it doesn't need to be JSON-like)

A future commit will significantly change test initialization,
and using fixtures simplifies this.

There is only the origin-intrinsic-metadata indexer for now,
but others will be added in the future

Before this commit, the journal client only created scheduler tasks,
which then run the indexers.

This commit adds support for a new flow: skipping the scheduler,
to run indexers directly.
This new behavior is triggered by adding a new argument on the CLI,
which is the name of the indexer to run (currently, only
`origin-intrinsic-metadata`).

This has the following consequences:

* a crash in an indexer will now hang the whole thing (which is
  arguably good)
* the journal client will probably need to be parallelized to
  keep up with the load
* we can remove an existence check for origins

In term of deployment:

1. stop the old journal client
2. wait for all tasks to finish
3. stop and remove celery workers and queues
4. start the new journal client (it can reuse the group_id to avoid
   re-indexing, but I think it is a good opportunity to reindex because
   of all the temporary failures we had over time)

It will be used in a future commit to run indexers directly from
a journal client.

A future commit will need pytest parametrization

It may have unexpected side-effects

Reformat parametrized test using subTest in unittest

That hook can be frustrating as it can discard a long commit message
if it finds a typo in it so better removing it.

Related to T3922

black is considered stable since release 22.1.0 and the version
we are currently using is quite outdated and not compatible with
click 8.1.0, so it is time to bump it to its latest stable release.

Please note that E501 pycodestyle warning related to line length
is replaced by B950 one from flake8-bugbear as recommended by black.
https://black.readthedocs.io/en/stable/the_black_code_style/current_style.html#line-length

Related to T3922

pytest-postgresql 3.1.3 and pytest-redis 2.4.0 added support for
pytest >= 7 so we can now drop the pytest pinning.

Due to test modules being copied in subdirectories of the
build directory by setuptools, it makes pytest fail by raising
ImportPathMismatchError exceptions when invoked from root
directory of the module.

So ignore the build folder to discover tests.

- add the `get_datastore` function in `swh.indexer`
- add the `get_current_version` method in `IndexerBackend`,
- remove dbversion management from sql init script
- update tests accordingly

To install the new hook:

  $ pre-commit install -t commit-msg

Related to T3916

A future release of swh-model will change its constructor's signature (replace 'offset'
and 'negative_utc_offset' with 'offset_bytes).

Related to T3815

This also:
- drops spurious copyright headers to those files if present.
- drops a no longer relevant type ignore
- add another type ignore (to fix later)

Related to T3812

This fixes error instances [1]

[1] https://sentry.softwareheritage.org/share/issue/a5869f724a244fdab2e1cb0303a12fc1/

This fixes occurrences of [1]

[1] https://sentry.softwareheritage.org/share/issue/4b92519efe2a4ddd9455f0d600a614b9/

It renamed db_name to dbname, which is a breaking change.