23 lines
612 B
Bash
23 lines
612 B
Bash
#!/bin/sh
|
|
|
|
## This script is aimed to generate traffic to the database and simulate
|
|
## simulate multiple Waku nodes connected to the same database.
|
|
|
|
## Install postgresql-client for psql command
|
|
apk --no-cache add postgresql-client
|
|
|
|
## The port numbers and host names are defined in the 'docker-compose.yml' file
|
|
|
|
echo "This is database hammer"
|
|
|
|
export PGPASSWORD=test123
|
|
QUERY_LAST_FIVE_MINUTES=$(echo 'SELECT * FROM messages ORDER BY storedAt DESC LIMIT 100;')
|
|
|
|
while true
|
|
do
|
|
echo "Before making query"
|
|
psql -h postgres -p 5432 -U postgres -U postgres -w -c "${QUERY_LAST_FIVE_MINUTES}"
|
|
|
|
sleep 0.01
|
|
done
|