Differences From:

File src/info.c part of check-in [02a584f7f5] - Add the --private option to the "fossil commit" command. This option creates a private branch which is never pushed. by drh on 2009-08-26 18:25:48. [view]

To:

File src/info.c part of check-in [76630dd9f3] - Show the date and time on checkouts in the "info" command. by drh on 2009-08-28 17:58:10. [view]

@@ -41,29 +41,43 @@
 void show_common_info(int rid, const char *zUuidName, int showComment){
   Stmt q;
   char *zComment = 0;
   char *zTags;
-  db_prepare(&q,
-    "SELECT uuid"
-    "  FROM blob WHERE rid=%d", rid
-  );
-  if( db_step(&q)==SQLITE_ROW ){
+  char *zDate;
+  char *zUuid;
+  zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid);
+  if( zUuid ){
+    zDate = db_text("",
+      "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d",
+      rid
+    );
          /* 01234567890123 */
-    printf("%-13s %s\n", zUuidName, db_column_text(&q, 0));
-  }
-  db_finalize(&q);
-  db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON pid=rid "
+    printf("%-13s %s %s\n", zUuidName, zUuid, zDate);
+    free(zUuid);
+    free(zDate);
+  }
+  db_prepare(&q, "SELECT uuid, pid FROM plink JOIN blob ON pid=rid "
                  " WHERE cid=%d", rid);
   while( db_step(&q)==SQLITE_ROW ){
     const char *zUuid = db_column_text(&q, 0);
-    printf("parent:       %s\n", zUuid);
-  }
-  db_finalize(&q);
-  db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON cid=rid "
+    zDate = db_text("",
+      "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d",
+      db_column_int(&q, 1)
+    );
+    printf("parent:       %s %s\n", zUuid, zDate);
+    free(zDate);
+  }
+  db_finalize(&q);
+  db_prepare(&q, "SELECT uuid, cid FROM plink JOIN blob ON cid=rid "
                  " WHERE pid=%d", rid);
   while( db_step(&q)==SQLITE_ROW ){
     const char *zUuid = db_column_text(&q, 0);
-    printf("child:        %s\n", zUuid);
+    zDate = db_text("",
+      "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d",
+      db_column_int(&q, 1)
+    );
+    printf("child:        %s %s\n", zUuid, zDate);
+    free(zDate);
   }
   db_finalize(&q);
   zTags = db_text(0, "SELECT group_concat(substr(tagname, 5), ', ')"
                      "  FROM tagxref, tag"