Fossil SCM
Fix describe_artifact so that it understands forum posts.
Commit
318b7c5af8c0cf8b0cd7816adffd6e5297c3a2744b65e9f1cfb530e9a6f4e36e
Parent
e2d87cdd76bbbad…
1 file changed
+15
+15
| --- src/name.c | ||
| +++ src/name.c | ||
| @@ -927,10 +927,25 @@ | ||
| 927 | 927 | " WHERE (blob.rid %s)\n" |
| 928 | 928 | " AND blob.rid NOT IN (SELECT rid FROM description)\n" |
| 929 | 929 | " AND blob.uuid=attachment.src", |
| 930 | 930 | zWhere /*safe-for-%s*/ |
| 931 | 931 | ); |
| 932 | + | |
| 933 | + /* Forum posts */ | |
| 934 | + if( db_table_exists("repository","forumpost") ){ | |
| 935 | + db_multi_exec( | |
| 936 | + "INSERT OR IGNORE INTO description(rid,uuid,ctime,type,summary)\n" | |
| 937 | + "SELECT postblob.rid, postblob.uuid, forumpost.fmtime, 'forumpost',\n" | |
| 938 | + " CASE WHEN fpid=froot THEN 'forum-post '\n" | |
| 939 | + " ELSE 'forum-reply-to ' END || substr(rootblob.uuid,1,14)\n" | |
| 940 | + " FROM forumpost, blob AS postblob, blob AS rootblob\n" | |
| 941 | + " WHERE (forumpost.fpid %s)\n" | |
| 942 | + " AND postblob.rid=forumpost.fpid" | |
| 943 | + " AND rootblob.rid=forumpost.froot", | |
| 944 | + zWhere /*safe-for-%s*/ | |
| 945 | + ); | |
| 946 | + } | |
| 932 | 947 | |
| 933 | 948 | /* Everything else */ |
| 934 | 949 | db_multi_exec( |
| 935 | 950 | "INSERT OR IGNORE INTO description(rid,uuid,type,summary)\n" |
| 936 | 951 | "SELECT blob.rid, blob.uuid," |
| 937 | 952 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -927,10 +927,25 @@ | |
| 927 | " WHERE (blob.rid %s)\n" |
| 928 | " AND blob.rid NOT IN (SELECT rid FROM description)\n" |
| 929 | " AND blob.uuid=attachment.src", |
| 930 | zWhere /*safe-for-%s*/ |
| 931 | ); |
| 932 | |
| 933 | /* Everything else */ |
| 934 | db_multi_exec( |
| 935 | "INSERT OR IGNORE INTO description(rid,uuid,type,summary)\n" |
| 936 | "SELECT blob.rid, blob.uuid," |
| 937 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -927,10 +927,25 @@ | |
| 927 | " WHERE (blob.rid %s)\n" |
| 928 | " AND blob.rid NOT IN (SELECT rid FROM description)\n" |
| 929 | " AND blob.uuid=attachment.src", |
| 930 | zWhere /*safe-for-%s*/ |
| 931 | ); |
| 932 | |
| 933 | /* Forum posts */ |
| 934 | if( db_table_exists("repository","forumpost") ){ |
| 935 | db_multi_exec( |
| 936 | "INSERT OR IGNORE INTO description(rid,uuid,ctime,type,summary)\n" |
| 937 | "SELECT postblob.rid, postblob.uuid, forumpost.fmtime, 'forumpost',\n" |
| 938 | " CASE WHEN fpid=froot THEN 'forum-post '\n" |
| 939 | " ELSE 'forum-reply-to ' END || substr(rootblob.uuid,1,14)\n" |
| 940 | " FROM forumpost, blob AS postblob, blob AS rootblob\n" |
| 941 | " WHERE (forumpost.fpid %s)\n" |
| 942 | " AND postblob.rid=forumpost.fpid" |
| 943 | " AND rootblob.rid=forumpost.froot", |
| 944 | zWhere /*safe-for-%s*/ |
| 945 | ); |
| 946 | } |
| 947 | |
| 948 | /* Everything else */ |
| 949 | db_multi_exec( |
| 950 | "INSERT OR IGNORE INTO description(rid,uuid,type,summary)\n" |
| 951 | "SELECT blob.rid, blob.uuid," |
| 952 |