790
791
792
793
794
795
796
797
798
799
800
801
802
803
|
** together with the time since the most recent push or pull.
*/
void synclog_cmd(void){
Stmt q;
int cnt;
const int nIndent = 2;
db_find_and_open_repository(0,0);
db_prepare(&q,
"WITH allpull(xfrom,xto,xtime) AS MATERIALIZED (\n"
" SELECT sfrom, sto, max(stime) FROM synclog GROUP BY 1\n"
"),\n"
"pull(level, url, mtime, ex) AS (\n"
" SELECT 0, xfrom, xtime, '|this|' || xfrom || '|'\n"
" FROM allpull WHERE xto='this'\n"
|
>
|
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
|
** together with the time since the most recent push or pull.
*/
void synclog_cmd(void){
Stmt q;
int cnt;
const int nIndent = 2;
db_find_and_open_repository(0,0);
schema_synclog();
db_prepare(&q,
"WITH allpull(xfrom,xto,xtime) AS MATERIALIZED (\n"
" SELECT sfrom, sto, max(stime) FROM synclog GROUP BY 1\n"
"),\n"
"pull(level, url, mtime, ex) AS (\n"
" SELECT 0, xfrom, xtime, '|this|' || xfrom || '|'\n"
" FROM allpull WHERE xto='this'\n"
|