Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further enhancements to the timeline label for the yw= query parameter. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
b89e74526bc80eddb6e3f4db61b6bdb5 |
| User & Date: | drh 2018-04-26 19:20:38 |
Context
|
2018-04-26
| ||
| 19:23 | Merge in the latest 3.24.0 alpha version of SQLite including the ORDER BY LIMIT performance enhancement. (check-in: 7b159988 user: drh tags: trunk) | |
| 19:20 | Further enhancements to the timeline label for the yw= query parameter. (check-in: b89e7452 user: drh tags: trunk) | |
| 19:02 | Improved handling of the the yw= query parameter on /timeline. (check-in: 881b4646 user: drh tags: trunk) | |
Changes
Changes to src/timeline.c.
1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 |
if( nEntry>0 ) blob_append_sql(&sql, " LIMIT %d", nEntry);
db_multi_exec("%s", blob_sql_text(&sql));
n = db_int(0, "SELECT count(*) FROM timeline WHERE etype!='div' /*scan*/");
if( zYearMonth ){
blob_appendf(&desc, "%s events for %h", zEType, zYearMonth);
}else if( zYearWeek ){
blob_appendf(&desc, "%s events for year/week %h (%h)",
zEType, zYearWeek, zYearWeekStart);
}else if( zDay ){
blob_appendf(&desc, "%s events occurring on %h", zEType, zDay);
}else if( zBefore==0 && zCirca==0 && n>=nEntry && nEntry>0 ){
blob_appendf(&desc, "%d most recent %ss", n, zEType);
}else{
blob_appendf(&desc, "%d %ss", n, zEType);
|
| |
1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 |
if( nEntry>0 ) blob_append_sql(&sql, " LIMIT %d", nEntry);
db_multi_exec("%s", blob_sql_text(&sql));
n = db_int(0, "SELECT count(*) FROM timeline WHERE etype!='div' /*scan*/");
if( zYearMonth ){
blob_appendf(&desc, "%s events for %h", zEType, zYearMonth);
}else if( zYearWeek ){
blob_appendf(&desc, "%s events for week %h (the week starting %h)",
zEType, zYearWeek, zYearWeekStart);
}else if( zDay ){
blob_appendf(&desc, "%s events occurring on %h", zEType, zDay);
}else if( zBefore==0 && zCirca==0 && n>=nEntry && nEntry>0 ){
blob_appendf(&desc, "%d most recent %ss", n, zEType);
}else{
blob_appendf(&desc, "%d %ss", n, zEType);
|