libeufin

commit 5539fcd15818bad1a4ac4fb5c6ad149ed9347b24
parent 4e64f78f9111eead565aca9c69c7014c41a20195
Author: MS <ms@taler.net>
Date:   Fri, 24 Nov 2023 21:35:57 +0100

monitor test

populating the bank_stats table via the
stats_register_payment procedure.

Diffstat:
M
contrib/populate-stats.sh
 | 
21
+++++++++++++++++----

1 file changed, 17 insertions(+), 4 deletions(-)
diff --git a/contrib/populate-stats.sh b/contrib/populate-stats.sh
@@ -23,6 +23,17 @@ rnd () {
   shuf -i $1-$2 -n1
 }
 
+insert_stat () {
+  echo "
+    SET search_path TO libeufin_bank;
+    CALL libeufin_bank.stats_register_payment (
+      'taler_out'::text
+      ,TO_TIMESTAMP($1)::timestamp
+      ,($(rnd 0 99999999), $(rnd 0 99999999))::taler_amount
+      ,($(rnd 0 99999999), $(rnd 0 99999999))::taler_amount
+      );"
+}
+
 # $1 == timestamp
 insert_cmd () {
   echo "
@@ -41,7 +52,7 @@ insert_cmd () {
       ,cashout_fiat_volume
       ) VALUES (
         'hour'
-        ,TO_TIMESTAMP($1)
+	,date_trunc('hour', TO_TIMESTAMP($1))
         ,$(rnd 1 3000)
         ,($(rnd 1 1000000), $(rnd 0 99999999))
         ,$(rnd 1 3000)
@@ -54,9 +65,11 @@ insert_cmd () {
         ,($(rnd 1 1000000), $(rnd 0 99999999))
     );"
 }
-
-for n_hour_ago in `seq 1 100`; do
+ 
+for n_hour_ago in `seq 1 5`; do
+# for n_hour_ago in `seq 1 100`; do
   echo -n .
   TIMESTAMP=$(date --date="${n_hour_ago} hour ago" +%s)
-  psql $DB_NAME -c "$(insert_cmd ${TIMESTAMP})" > /dev/null
+  # psql $DB_NAME -c "$(insert_cmd ${TIMESTAMP})" > /dev/null
+  psql $DB_NAME -c "$(insert_stat ${TIMESTAMP})" > /dev/null
 done