Transfers: implement source selection strategies #3087

Job	Run time
Python type check (Pyright)	6m 44s
Check Python Type Annotations	36s
Add header lint	9s
setup	13s
release-patch-setup	0s
release-patch-test	0s
test (alma9, 3.9, autotest, syntax, 1, false)	14m 57s
test (alma9, 3.9, autotest, docs, false)	6m 2s
test (alma9, 3.9, autotest, client_syntax, false)	7m 32s
test (alma9, 3.9, autotest, client, postgres14)	6m 24s
test (alma9, 3.9, autotest, remote_dbs, oracle, influxdb_elastic)	37m 1s
test (alma9, 3.9, autotest, remote_dbs, mysql8, influxdb_elastic)	40m 49s
test (alma9, 3.9, autotest, remote_dbs, postgres14, influxdb_elastic)	22m 3s
test (alma9, 3.9, autotest, sqlite, sqlite)	27m 38s
test (alma9, 3.9, autotest, multi_vo, postgres14, /opt/rucio/etc/multi_vo/tst)	49m 12s
test (alma9, 3.10, autotest, syntax, 1, false)	18m 6s
test (alma9, 3.10, autotest, client_syntax, false)	12m 13s
test (alma9, 3.10, autotest, client, postgres14)	14m 3s
test (alma9, 3.10, autotest, remote_dbs, oracle, influxdb_elastic)	47m 15s
test (alma9, 3.10, autotest, remote_dbs, mysql8, influxdb_elastic)	44m 2s
test (alma9, 3.10, autotest, remote_dbs, postgres14, influxdb_elastic)	44m 13s
test (alma9, 3.10, autotest, sqlite, sqlite)	36m 21s
test (alma9, 3.10, autotest, multi_vo, postgres14, /opt/rucio/etc/multi_vo/tst)	1h 9m 1s
	8h 24m 34s

Provide feedback