s4

changeset 820:e64d18e78507

find changesets by author, revision, files, or words in the commit message
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 diff
     1.1 --- a/s4-world.sh	Thu Jun 18 08:05:01 2020 +0900
     1.2 +++ b/s4-world.sh	Thu Jun 18 19:30:06 2020 +0900
     1.3 @@ -93,7 +93,12 @@
     1.4  DELETE FROM main.user_m WHERE rowid NOT IN (SELECT rowid FROM m.user_m);
     1.5  REPLACE INTO main.user_m(rowid, name, key, type, val, bin)
     1.6  	SELECT rowid,* FROM m.user_m
     1.7 -	WHERE key NOT LIKE '%cache%';
     1.8 +	WHERE user_m.name	!= m.user_m.name
     1.9 +	   OR user_m.key	!= m.user_m.key
    1.10 +	   OR user_m.type	!= m.user_m.type
    1.11 +	   OR user_m.val	!= m.user_m.val
    1.12 +	   OR length(user_m.bin)!= length(m.user_m.bin)
    1.13 +	;
    1.14  END;
    1.15  
    1.16  /* Compare user tables */