Mercurial > hgrepos > hgweb.cgi > s4

changeset 820:e64d18e78507

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Copy user_m table only when values differ
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 18 Jun 2020 19:30:06 +0900
parents b64e18808bb6
children 2465fff63ad9
files s4-world.sh
diffstat 1 files changed, 6 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-world.sh	Thu Jun 18 08:05:01 2020 +0900
+++ b/s4-world.sh	Thu Jun 18 19:30:06 2020 +0900
@@ -93,7 +93,12 @@
 DELETE FROM main.user_m WHERE rowid NOT IN (SELECT rowid FROM m.user_m);
 REPLACE INTO main.user_m(rowid, name, key, type, val, bin)
 	SELECT rowid,* FROM m.user_m
-	WHERE key NOT LIKE '%cache%';
+	WHERE user_m.name	!= m.user_m.name
+	   OR user_m.key	!= m.user_m.key
+	   OR user_m.type	!= m.user_m.type
+	   OR user_m.val	!= m.user_m.val
+	   OR length(user_m.bin)!= length(m.user_m.bin)
+	;
 END;
 
 /* Compare user tables */

yatex.org