[repoapi] move get_repository function into a new repoapi module This new module aims to host the function of the new API replacing the old DBAPI. `get_repository` is still needed hence moved to the new module. Related to #2503918

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