Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix the computation of the percentage of the repo taken up by unversioned files on the /stat page. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | c8b46764b6a913f812b8bac53e5993f2 |
| User & Date: | drh 2017-10-02 02:30:05 |
Context
|
2017-10-02
| ||
| 03:46 | Update the build-in SQLite to the latest 3.21.0 beta that includes the enhance use of co-routines for subqueries. check-in: 75fffb49 user: drh tags: trunk | |
| 02:30 | Fix the computation of the percentage of the repo taken up by unversioned files on the /stat page. check-in: c8b46764 user: drh tags: trunk | |
|
2017-09-30
| ||
| 01:09 | Add [string index] TH1 command check-in: 0c57ba3e user: andygoth tags: trunk | |
Changes
Changes to src/stat.c.
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
...
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
db_finalize(&q);
bigSizeName(sizeof(zBuf), zBuf, t);
@ %d(szAvg) bytes average, %d(szMax) bytes max, %s(zBuf) total
@ </td></tr>
@ <tr><th>Compression Ratio:</th><td>
if( t/fsize < 5 ){
b = 10;
fsize /= 10;
}else{
b = 1;
}
a = t/fsize;
@ %d(a):%d(b)
@ </td></tr>
}
if( db_table_exists("repository","unversioned") ){
Stmt q;
char zStored[100];
db_prepare(&q,
................................................................................
"SELECT count(*), sum(sz), sum(length(content))"
" FROM unversioned"
" WHERE length(hash)>1"
);
if( db_step(&q)==SQLITE_ROW && (n = db_column_int(&q,0))>0 ){
sqlite3_int64 iStored, pct;
iStored = db_column_int64(&q,2);
pct = (iStored*100 + fsize - 1)/fsize;
approxSizeName(sizeof(zStored), zStored, iStored);
@ <tr><th>Unversioned Files:</th><td>
@ %z(href("%R/uvlist"))%d(n) files</a>,
@ %s(zStored) compressed, %d(pct)%% of total repository space
@ </td></tr>
}
db_finalize(&q);
|
|
<
|
>
|
|
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
...
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
db_finalize(&q);
bigSizeName(sizeof(zBuf), zBuf, t);
@ %d(szAvg) bytes average, %d(szMax) bytes max, %s(zBuf) total
@ </td></tr>
@ <tr><th>Compression Ratio:</th><td>
if( t/fsize < 5 ){
b = 10;
a = t/(fsize/10);
}else{
b = 1;
a = t/fsize;
}
@ %d(a):%d(b)
@ </td></tr>
}
if( db_table_exists("repository","unversioned") ){
Stmt q;
char zStored[100];
db_prepare(&q,
................................................................................
"SELECT count(*), sum(sz), sum(length(content))"
" FROM unversioned"
" WHERE length(hash)>1"
);
if( db_step(&q)==SQLITE_ROW && (n = db_column_int(&q,0))>0 ){
sqlite3_int64 iStored, pct;
iStored = db_column_int64(&q,2);
pct = (iStored*100 + fsize/2)/fsize;
approxSizeName(sizeof(zStored), zStored, iStored);
@ <tr><th>Unversioned Files:</th><td>
@ %z(href("%R/uvlist"))%d(n) files</a>,
@ %s(zStored) compressed, %d(pct)%% of total repository space
@ </td></tr>
}
db_finalize(&q);
|