Mercurial > hgrepos > hgweb.cgi > 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 wrap: on
line diff
--- a/s4-world.sh Sun Jan 03 09:51:46 2021 +0900 +++ b/s4-world.sh Sun Jan 03 12:33:19 2021 +0900 @@ -106,7 +106,7 @@ esac fi ## num=$(sqlite3 -bail -cmd 'PRAGMA FOREIGN_KEYS=on' $db <<EOF - num=$(query <<EOF + result=$(query <<EOF BEGIN; DElETE FROM main.user WHERE rowid NOT IN (SELECT rowid FROM m.user); INSERT INTO main.user(rowid, name) @@ -123,17 +123,23 @@ EXCEPT SELECT rowid,* FROM main.user_m $SYNCCOND ;} /* SYNC_M closed here */ +SELECT 'OK'; END; - +EOF + ) + err "`gdate +%S.%3N` Update account tables finished with result=[$result]" + test x"$result" = x"OK" && num=$(query <<EOF /* Compare user tables */ WITH master AS ( SELECT p.rowid,* FROM m.user p NATURAL LEFT JOIN m.user_s ${SYNC_M:+ NATURAL LEFT JOIN m.user_m} + $SYNCCOND ), thisworld AS ( SELECT p.rowid,* FROM user p NATURAL LEFT JOIN user_s ${SYNC_M:+ NATURAL LEFT JOIN user_m} + $SYNCCOND ), m_a AS ( SELECT * FROM master EXCEPT SELECT * FROM thisworld ), a_m AS (