[tests/repository] use the new connection api (part 2/2) Some notes: * module imports cleanup * the unimplemented `test_transaction_interleaved` is wiped

sql('DROP FUNCTION IF EXISTS _fsopen(bytea)')
sql('DROP FUNCTION IF EXISTS fspath(bigint, text, text)')