Fossil SCM
On the /artifact_stats page, relabel "unknown" artifacts as "unused".
Commit
71e777dd730fa9af3f94aa863ada93efc55d4fdecd87a8c006cd88773f68c2fe
Parent
9fc519408944c3e…
1 file changed
+4
-4
+4
-4
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -630,11 +630,11 @@ | ||
| 630 | 630 | @ WHERE atype IS NULL |
| 631 | 631 | @ AND id IN (SELECT srcid FROM tagxref); |
| 632 | 632 | @ UPDATE artstat SET atype='tag' |
| 633 | 633 | @ WHERE atype IS NULL |
| 634 | 634 | @ AND id IN (SELECT objid FROM event WHERE type='g'); |
| 635 | - @ UPDATE artstat SET atype='unknown' WHERE atype IS NULL; | |
| 635 | + @ UPDATE artstat SET atype='unused' WHERE atype IS NULL; | |
| 636 | 636 | ; |
| 637 | 637 | db_multi_exec("%s", zSql/*safe-for-%s*/); |
| 638 | 638 | if( bWithTypes ){ |
| 639 | 639 | db_multi_exec("%s", zSql2/*safe-for-%s*/); |
| 640 | 640 | } |
| @@ -841,19 +841,19 @@ | ||
| 841 | 841 | sqlite3_free(z); |
| 842 | 842 | } |
| 843 | 843 | @ </tbody></table> |
| 844 | 844 | db_finalize(&q); |
| 845 | 845 | |
| 846 | - if( db_exists("SELECT 1 FROM artstat WHERE atype='unknown'") ){ | |
| 847 | - @ <h1>Unknown Artifacts:</h1> | |
| 846 | + if( db_exists("SELECT 1 FROM artstat WHERE atype='unused'") ){ | |
| 847 | + @ <h1>Unused Artifacts:</h1> | |
| 848 | 848 | db_prepare(&q, |
| 849 | 849 | "SELECT artstat.id, blob.uuid, user.login," |
| 850 | 850 | " datetime(rcvfrom.mtime), rcvfrom.rcvid" |
| 851 | 851 | " FROM artstat JOIN blob ON artstat.id=blob.rid" |
| 852 | 852 | " LEFT JOIN rcvfrom USING(rcvid)" |
| 853 | 853 | " LEFT JOIN user USING(uid)" |
| 854 | - " WHERE atype='unknown'" | |
| 854 | + " WHERE atype='unused'" | |
| 855 | 855 | ); |
| 856 | 856 | @ <table class='sortable' border='1' \ |
| 857 | 857 | @ data-column-types='ntttt' data-init-sort='0'> |
| 858 | 858 | @ <thead><tr> |
| 859 | 859 | @ <th>RecordID</th> |
| 860 | 860 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -630,11 +630,11 @@ | |
| 630 | @ WHERE atype IS NULL |
| 631 | @ AND id IN (SELECT srcid FROM tagxref); |
| 632 | @ UPDATE artstat SET atype='tag' |
| 633 | @ WHERE atype IS NULL |
| 634 | @ AND id IN (SELECT objid FROM event WHERE type='g'); |
| 635 | @ UPDATE artstat SET atype='unknown' WHERE atype IS NULL; |
| 636 | ; |
| 637 | db_multi_exec("%s", zSql/*safe-for-%s*/); |
| 638 | if( bWithTypes ){ |
| 639 | db_multi_exec("%s", zSql2/*safe-for-%s*/); |
| 640 | } |
| @@ -841,19 +841,19 @@ | |
| 841 | sqlite3_free(z); |
| 842 | } |
| 843 | @ </tbody></table> |
| 844 | db_finalize(&q); |
| 845 | |
| 846 | if( db_exists("SELECT 1 FROM artstat WHERE atype='unknown'") ){ |
| 847 | @ <h1>Unknown Artifacts:</h1> |
| 848 | db_prepare(&q, |
| 849 | "SELECT artstat.id, blob.uuid, user.login," |
| 850 | " datetime(rcvfrom.mtime), rcvfrom.rcvid" |
| 851 | " FROM artstat JOIN blob ON artstat.id=blob.rid" |
| 852 | " LEFT JOIN rcvfrom USING(rcvid)" |
| 853 | " LEFT JOIN user USING(uid)" |
| 854 | " WHERE atype='unknown'" |
| 855 | ); |
| 856 | @ <table class='sortable' border='1' \ |
| 857 | @ data-column-types='ntttt' data-init-sort='0'> |
| 858 | @ <thead><tr> |
| 859 | @ <th>RecordID</th> |
| 860 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -630,11 +630,11 @@ | |
| 630 | @ WHERE atype IS NULL |
| 631 | @ AND id IN (SELECT srcid FROM tagxref); |
| 632 | @ UPDATE artstat SET atype='tag' |
| 633 | @ WHERE atype IS NULL |
| 634 | @ AND id IN (SELECT objid FROM event WHERE type='g'); |
| 635 | @ UPDATE artstat SET atype='unused' WHERE atype IS NULL; |
| 636 | ; |
| 637 | db_multi_exec("%s", zSql/*safe-for-%s*/); |
| 638 | if( bWithTypes ){ |
| 639 | db_multi_exec("%s", zSql2/*safe-for-%s*/); |
| 640 | } |
| @@ -841,19 +841,19 @@ | |
| 841 | sqlite3_free(z); |
| 842 | } |
| 843 | @ </tbody></table> |
| 844 | db_finalize(&q); |
| 845 | |
| 846 | if( db_exists("SELECT 1 FROM artstat WHERE atype='unused'") ){ |
| 847 | @ <h1>Unused Artifacts:</h1> |
| 848 | db_prepare(&q, |
| 849 | "SELECT artstat.id, blob.uuid, user.login," |
| 850 | " datetime(rcvfrom.mtime), rcvfrom.rcvid" |
| 851 | " FROM artstat JOIN blob ON artstat.id=blob.rid" |
| 852 | " LEFT JOIN rcvfrom USING(rcvid)" |
| 853 | " LEFT JOIN user USING(uid)" |
| 854 | " WHERE atype='unused'" |
| 855 | ); |
| 856 | @ <table class='sortable' border='1' \ |
| 857 | @ data-column-types='ntttt' data-init-sort='0'> |
| 858 | @ <thead><tr> |
| 859 | @ <th>RecordID</th> |
| 860 |