Fossil SCM
Show the date and time on checkouts in the "info" command.
Commit
76630dd9f3883c942874d3e1f902a00341bdb15a
Parent
9aa91e549e663a4…
1 file changed
+25
-11
+25
-11
| --- src/info.c | ||
| +++ src/info.c | ||
| @@ -40,31 +40,45 @@ | ||
| 40 | 40 | */ |
| 41 | 41 | void show_common_info(int rid, const char *zUuidName, int showComment){ |
| 42 | 42 | Stmt q; |
| 43 | 43 | char *zComment = 0; |
| 44 | 44 | char *zTags; |
| 45 | - db_prepare(&q, | |
| 46 | - "SELECT uuid" | |
| 47 | - " FROM blob WHERE rid=%d", rid | |
| 48 | - ); | |
| 49 | - if( db_step(&q)==SQLITE_ROW ){ | |
| 45 | + char *zDate; | |
| 46 | + char *zUuid; | |
| 47 | + zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid); | |
| 48 | + if( zUuid ){ | |
| 49 | + zDate = db_text("", | |
| 50 | + "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", | |
| 51 | + rid | |
| 52 | + ); | |
| 50 | 53 | /* 01234567890123 */ |
| 51 | - printf("%-13s %s\n", zUuidName, db_column_text(&q, 0)); | |
| 54 | + printf("%-13s %s %s\n", zUuidName, zUuid, zDate); | |
| 55 | + free(zUuid); | |
| 56 | + free(zDate); | |
| 52 | 57 | } |
| 53 | - db_finalize(&q); | |
| 54 | - db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON pid=rid " | |
| 58 | + db_prepare(&q, "SELECT uuid, pid FROM plink JOIN blob ON pid=rid " | |
| 55 | 59 | " WHERE cid=%d", rid); |
| 56 | 60 | while( db_step(&q)==SQLITE_ROW ){ |
| 57 | 61 | const char *zUuid = db_column_text(&q, 0); |
| 58 | - printf("parent: %s\n", zUuid); | |
| 62 | + zDate = db_text("", | |
| 63 | + "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", | |
| 64 | + db_column_int(&q, 1) | |
| 65 | + ); | |
| 66 | + printf("parent: %s %s\n", zUuid, zDate); | |
| 67 | + free(zDate); | |
| 59 | 68 | } |
| 60 | 69 | db_finalize(&q); |
| 61 | - db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON cid=rid " | |
| 70 | + db_prepare(&q, "SELECT uuid, cid FROM plink JOIN blob ON cid=rid " | |
| 62 | 71 | " WHERE pid=%d", rid); |
| 63 | 72 | while( db_step(&q)==SQLITE_ROW ){ |
| 64 | 73 | const char *zUuid = db_column_text(&q, 0); |
| 65 | - printf("child: %s\n", zUuid); | |
| 74 | + zDate = db_text("", | |
| 75 | + "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", | |
| 76 | + db_column_int(&q, 1) | |
| 77 | + ); | |
| 78 | + printf("child: %s %s\n", zUuid, zDate); | |
| 79 | + free(zDate); | |
| 66 | 80 | } |
| 67 | 81 | db_finalize(&q); |
| 68 | 82 | zTags = db_text(0, "SELECT group_concat(substr(tagname, 5), ', ')" |
| 69 | 83 | " FROM tagxref, tag" |
| 70 | 84 | " WHERE tagxref.rid=%d AND tagxref.tagtype>0" |
| 71 | 85 |
| --- src/info.c | |
| +++ src/info.c | |
| @@ -40,31 +40,45 @@ | |
| 40 | */ |
| 41 | void show_common_info(int rid, const char *zUuidName, int showComment){ |
| 42 | Stmt q; |
| 43 | char *zComment = 0; |
| 44 | char *zTags; |
| 45 | db_prepare(&q, |
| 46 | "SELECT uuid" |
| 47 | " FROM blob WHERE rid=%d", rid |
| 48 | ); |
| 49 | if( db_step(&q)==SQLITE_ROW ){ |
| 50 | /* 01234567890123 */ |
| 51 | printf("%-13s %s\n", zUuidName, db_column_text(&q, 0)); |
| 52 | } |
| 53 | db_finalize(&q); |
| 54 | db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON pid=rid " |
| 55 | " WHERE cid=%d", rid); |
| 56 | while( db_step(&q)==SQLITE_ROW ){ |
| 57 | const char *zUuid = db_column_text(&q, 0); |
| 58 | printf("parent: %s\n", zUuid); |
| 59 | } |
| 60 | db_finalize(&q); |
| 61 | db_prepare(&q, "SELECT uuid FROM plink JOIN blob ON cid=rid " |
| 62 | " WHERE pid=%d", rid); |
| 63 | while( db_step(&q)==SQLITE_ROW ){ |
| 64 | const char *zUuid = db_column_text(&q, 0); |
| 65 | printf("child: %s\n", zUuid); |
| 66 | } |
| 67 | db_finalize(&q); |
| 68 | zTags = db_text(0, "SELECT group_concat(substr(tagname, 5), ', ')" |
| 69 | " FROM tagxref, tag" |
| 70 | " WHERE tagxref.rid=%d AND tagxref.tagtype>0" |
| 71 |
| --- src/info.c | |
| +++ src/info.c | |
| @@ -40,31 +40,45 @@ | |
| 40 | */ |
| 41 | void show_common_info(int rid, const char *zUuidName, int showComment){ |
| 42 | Stmt q; |
| 43 | char *zComment = 0; |
| 44 | char *zTags; |
| 45 | char *zDate; |
| 46 | char *zUuid; |
| 47 | zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid); |
| 48 | if( zUuid ){ |
| 49 | zDate = db_text("", |
| 50 | "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", |
| 51 | rid |
| 52 | ); |
| 53 | /* 01234567890123 */ |
| 54 | printf("%-13s %s %s\n", zUuidName, zUuid, zDate); |
| 55 | free(zUuid); |
| 56 | free(zDate); |
| 57 | } |
| 58 | db_prepare(&q, "SELECT uuid, pid FROM plink JOIN blob ON pid=rid " |
| 59 | " WHERE cid=%d", rid); |
| 60 | while( db_step(&q)==SQLITE_ROW ){ |
| 61 | const char *zUuid = db_column_text(&q, 0); |
| 62 | zDate = db_text("", |
| 63 | "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", |
| 64 | db_column_int(&q, 1) |
| 65 | ); |
| 66 | printf("parent: %s %s\n", zUuid, zDate); |
| 67 | free(zDate); |
| 68 | } |
| 69 | db_finalize(&q); |
| 70 | db_prepare(&q, "SELECT uuid, cid FROM plink JOIN blob ON cid=rid " |
| 71 | " WHERE pid=%d", rid); |
| 72 | while( db_step(&q)==SQLITE_ROW ){ |
| 73 | const char *zUuid = db_column_text(&q, 0); |
| 74 | zDate = db_text("", |
| 75 | "SELECT datetime(mtime) || ' UTC' FROM event WHERE objid=%d", |
| 76 | db_column_int(&q, 1) |
| 77 | ); |
| 78 | printf("child: %s %s\n", zUuid, zDate); |
| 79 | free(zDate); |
| 80 | } |
| 81 | db_finalize(&q); |
| 82 | zTags = db_text(0, "SELECT group_concat(substr(tagname, 5), ', ')" |
| 83 | " FROM tagxref, tag" |
| 84 | " WHERE tagxref.rid=%d AND tagxref.tagtype>0" |
| 85 |