s4
changeset 820:e64d18e78507
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 */