SHA1 Hash:	76630dd9f3883c942874d3e1f902a00341bdb15a
Date:	2009-08-28 17:58:10
User:	drh
Comment:	Show the date and time on checkouts in the "info" command.
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/info.c from [10f41cb27f] to [11d48dcc33].

@@ -40,31 +40,45 @@
 */
 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"
                      " WHERE tagxref.rid=%d AND tagxref.tagtype>0"