Fossil

Diff
Login

Diff

Differences From Artifact [856c865bab]:

To Artifact [0d8f47d993]:


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"