From b3c81aff7601e50b53b169a76cf3acabf6c3691e Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Mon, 8 Sep 2025 06:11:23 -0400 Subject: [PATCH] Adding tools to generate popul.sql database feed --- sql/.gitignore | 1 + sql/Makefile | 8 ++++++-- tools/genpsdusr.sh | 16 ++++++++++++++++ 3 files changed, 23 insertions(+), 2 deletions(-) create mode 100644 sql/.gitignore create mode 100755 tools/genpsdusr.sh diff --git a/sql/.gitignore b/sql/.gitignore new file mode 100644 index 0000000..79d5f73 --- /dev/null +++ b/sql/.gitignore @@ -0,0 +1 @@ +popul.sql diff --git a/sql/Makefile b/sql/Makefile index 3095b4f..7bb2d20 100644 --- a/sql/Makefile +++ b/sql/Makefile @@ -10,7 +10,7 @@ clean : #-------------------------------------------------------------------- -prepdb : debug deltest newtest +prepdb : newpop debug deltest newtest mailleur.postg \ : mailleur.sql @@ -69,12 +69,16 @@ ndbpostg: ) | psql -q -U postgres template1 #-------------------------------------------------------------------- -#procedure to dele or craate a postgresql test database +#procedure to delete or create a postgresql and mysql test database newtest : dbpostg dbmysql deltest : ndbpostg ndbmysql +newpop : + @ ../tools/genpsdusr.sh 2000 > popul.sql + @ echo "New 'popul' database created" + #-------------------------------------------------------------------- #-------------------------------------------------------------------- .PHONY: deltest diff --git a/tools/genpsdusr.sh b/tools/genpsdusr.sh new file mode 100755 index 0000000..1ba1ecb --- /dev/null +++ b/tools/genpsdusr.sh @@ -0,0 +1,16 @@ +#! /usr/bin/bash +#---------------------------------------------------------- +#procedure to generate an ASCII list of user to +#populate and test database +#---------------------------------------------------------- +max=$1; +if [ -z $1 ] ; then + max=1000; + fi +for (( num=0; num<$max; num++ )) + do + ( + fnum=$(printf "%05d\n" "$num") + echo "INSERT INTO emails (email) values ('popusr$fnum');"; + ) + done -- 2.47.3