From 0e64d98056c525b9e355ed5ee11e24c9439e72fb Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Mon, 8 Sep 2025 06:24:36 -0400 Subject: [PATCH] Able to generate database with big user list --- sql/Makefile | 6 ++++-- tools/genpsdusr.sh | 2 +- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/sql/Makefile b/sql/Makefile index 7bb2d20..6e91402 100644 --- a/sql/Makefile +++ b/sql/Makefile @@ -36,7 +36,8 @@ dbmysql : mailleur.mysql CHARACTER SET utf8;"; \ ) | sudo mariadb -q @ cat mailleur.mysql | mariadb -q mailleur; - @ cpp -P -DMYSQL datatest.sql | mariadb -q mailleur; + @ cpp -P -DMYSQL datatest.sql | mariadb -q mailleur; + @ cpp -P -DMYSQL popul.sql | mariadb -q mailleur; @ echo "MYSQL database ready" @@ -57,7 +58,8 @@ dbpostg : mailleur.postg echo " ENCODING='UTF8';"; \ ) | psql -q -U postgres template1 @ cat mailleur.postg | psql -q mailleur; - @ cpp -P -DPOSTGRESQL datatest.sql | psql -q mailleur; + @ cpp -P -DPOSTGRESQL datatest.sql | psql -q mailleur; + @ cpp -P -DPOSTGRESQL popul.sql | psql -q mailleur; @ echo "POSGRESQL database ready" ndbpostg: diff --git a/tools/genpsdusr.sh b/tools/genpsdusr.sh index 1ba1ecb..9e7ad41 100755 --- a/tools/genpsdusr.sh +++ b/tools/genpsdusr.sh @@ -11,6 +11,6 @@ for (( num=0; num<$max; num++ )) do ( fnum=$(printf "%05d\n" "$num") - echo "INSERT INTO emails (email) values ('popusr$fnum');"; + echo "INSERT INTO emails (email) values ('z-popusr$fnum');"; ) done -- 2.47.3