s4
changeset 903:d81dd0ed2d6d
Add performance check logging.
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Sun, 03 Jan 2021 12:33:19 +0900 |
| parents | d9ecb727edcd |
| children | 0352ff0fb37f |
| files | s4-world.sh |
| diffstat | 1 files changed, 8 insertions(+), 2 deletions(-) [+] |
line diff
1.1 --- a/s4-world.sh Sun Jan 03 09:51:46 2021 +0900 1.2 +++ b/s4-world.sh Sun Jan 03 12:33:19 2021 +0900 1.3 @@ -106,7 +106,7 @@ 1.4 esac 1.5 fi 1.6 ## num=$(sqlite3 -bail -cmd 'PRAGMA FOREIGN_KEYS=on' $db <<EOF 1.7 - num=$(query <<EOF 1.8 + result=$(query <<EOF 1.9 BEGIN; 1.10 DElETE FROM main.user WHERE rowid NOT IN (SELECT rowid FROM m.user); 1.11 INSERT INTO main.user(rowid, name) 1.12 @@ -123,17 +123,23 @@ 1.13 EXCEPT 1.14 SELECT rowid,* FROM main.user_m $SYNCCOND 1.15 ;} /* SYNC_M closed here */ 1.16 +SELECT 'OK'; 1.17 END; 1.18 - 1.19 +EOF 1.20 + ) 1.21 + err "`gdate +%S.%3N` Update account tables finished with result=[$result]" 1.22 + test x"$result" = x"OK" && num=$(query <<EOF 1.23 /* Compare user tables */ 1.24 WITH master AS ( 1.25 SELECT p.rowid,* FROM m.user p 1.26 NATURAL LEFT JOIN m.user_s 1.27 ${SYNC_M:+ NATURAL LEFT JOIN m.user_m} 1.28 + $SYNCCOND 1.29 ), thisworld AS ( 1.30 SELECT p.rowid,* FROM user p 1.31 NATURAL LEFT JOIN user_s 1.32 ${SYNC_M:+ NATURAL LEFT JOIN user_m} 1.33 + $SYNCCOND 1.34 ), m_a AS ( 1.35 SELECT * FROM master EXCEPT SELECT * FROM thisworld 1.36 ), a_m AS (