[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

sync_schema_props_perms(('State', 'state_of', 'Workflow'), commit=False)
sync_schema_props_perms(('State', 'name', 'String'))