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 (

yatex.org