SQLite, How do i know which repo corresponds to each repo file

[jamesmoo2090]

I am doing some cleanup and need to delete some old and unused repos, I have SQLite as the backend so i have 5 active repositories, i deleted 4 repos from the server but the SQL files remain

 

in the DB folder i have 9 SQLite  Rep_xx files (where the xx are numbers)

 

my question is, how do i know to which repository is each Rep_xx file corresponding to?

 

any help is appreciated.

 

thanks

[manu]

Hi James,

 

look, the "cm lrep" command will give you the IDs of your repos, for example:

C:\code>cm lrep
 1 default localhost:8091
 2 code localhost:8091
 4 def-r localhost:8091
 5 elastic localhost:8091

The 1,2,4 and 5 numbers are the IDs, so you will find the rep_1, rep_2, rep_4 and rep_5 databases matching the "default", "code", "def-r" and "elastic" repositories.

 

The missing ones will be the repositories removed.

[jamesmoo2090]

cool thanks

[manu]

You are welcome, of course it works also for the rest of backends, not only for sqlite.