How to get the Stash repository name from stash home's repository number?

Question

I noticed that in the stash-home/shared/data/repositories directory stores all the repositories that are on stash, but they are numbered.

From a number, how do I find out which repository it corresponds to in Stash? (i.e. the project and repository name in Stash).

SamK · Answer

I found this info in the database:

select repository.name, project.project_key from repository JOIN project ON repository.project_id = project.id  where repository.id='WRITE_THE_ID_HERE';

Mibex_Software · Answer

Stash's REST interface is based on the repository slug, so a lookup with an ID is not easily possible (except you fetch all the repositories and search for the id field in the JSON output).

A short hack would be (if you know the project of the repo) to go to the project's repository list in Stash and execute the following Javascript snippet (and substitute the ID below):

AJS.$('#repositories-table tbody tr a[data-repository-id=11]').closest('tr').children('td,th').css('background-color','#cc0');

This will mark the row of the repository

Balázs Szakmáry · Answer

Not sure how to get from the number to the name, but the other way around is relatively easy: The full path to the folder containing the repo is displayed on the main Settings page of the repo.