RE: Re: [viewvc-users] rebuild adds parent directory

Hi Mike,

Thanks again for your help.

My repository has thousands of directories, so I cannot use the the same query that you did. Instead I took the first 8 characters of DIR and then grouped them.

Note that the parent directory (named "cvsroot", the one above CVSROOT) *does* appear in my list, unlike yours.


mysql> select count(*), substr(dir, 1, 8) from dirs group by substr(dir, 1, 8);
+----------+-------------------+
| count(*) | substr(dir, 1, 8) |
+----------+-------------------+
|        1 |                   |
|       44 | Authenti          |
|        1 | LAB               |
|        1 | LAB/.set          |
|        1 | LAB/auto          |
|        1 | LAB/buil          |
|        1 | LAB/conf          |
|        3 | LAB/dist          |
|        1 | LAB/exte          |
|        1 | LAB/hist          |
|        2 | LAB/imag          |
|        1 | LAB/lib           |
|        1 | LAB/logs          |
|        1 | LAB/src           |
|       45 | LAB/src/          |
|        1 | LAB/xml/          |
|        1 | CVSROOT           |
|       72 | Database          |
|     1960 | DocGroup          |
|      539 | Fission/A         |
|       40 | Fission/D         |
|        3 | Fission/T         |
|      161 | GPS/Brad          |
|      616 | Install/          |
|        1 | PBandJ            |
|        3 | PBandJ/B          |
|        2 | PBandJ/C          |
|        2 | PBandJ/D          |
|        2 | PBandJ/E          |
|        1 | PBandJ/I          |
|        2 | PBandJ/M          |
|        2 | PBandJ/R          |
|        2 | PBandJ/S          |
|        3 | Project           |
|        1 | QA                |
|      597 | QA/Autom          |
|       28 | QA/RUP T          |
|        7 | QA/Ratio          |
|       81 | QA/WinRu          |
|        1 | Support           |
|      132 | Support/          |
|        1 | Tools/sr          |
|       37 | Translat          |
|      115 | applicat          |
|      888 | automati          |
|       31 | cruiseco          |
|        1 | cvsroot           |
|     7669 | cvsroot/          |
|      964 | indian2k          |
|        1 | poc               |
|        1 | poc/nbpr          |
|       14 | poc/src/          |
|        1 | poc/web           |
|        4 | poc/web/          |
|        1 | sandbox           |
|      188 | sandbox/          |
|        1 | web               |
|        1 | web/.ext          |
|        4 | web/Buil          |
|        1 | web/Depr          |
|        8 | web/Exte          |
|      645 | web/Inte          |
|        1 | web/META          |
|        2 | web/Plug          |
|        1 | web/Shor          |
|        3 | web/Sign          |
|       39 | web/WebP          |
|        1 | web/conf          |
|        1 | web/engl          |
|        1 | web/log           |
|        1 | web/test          |
|        1 | web/thir          |
|        1 | web625            |
|        3 | web625/B          |
|        1 | web625/E          |
|      314 | web625/I          |
|        2 | web625/P          |
|        3 | web625/S          |
|       22 | web625/W          |
|        1 | web625/t          |
+----------+-------------------+
80 rows in set (0.02 sec)

------------------------------------------------------
http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=3068069

To unsubscribe from this discussion, e-mail: [[email protected]].