sample regress test

olirice · darora · commit 51cadedd958a · 2024-08-06T10:17:57.000+08:00
diff --git a/flake.nix b/flake.nix
@@ -369,7 +369,7 @@
           in
           pkgs.runCommand "postgres-${pgpkg.version}-check-harness"
             {
-              nativeBuildInputs = with pkgs; [ coreutils bash pgpkg pg_prove procps ];
+              nativeBuildInputs = with pkgs; [ coreutils bash pgpkg pg_prove pg_regress procps ];
             } ''
             TMPDIR=$(mktemp -d)
             if [ $? -ne 0 ]; then
@@ -417,7 +417,22 @@
             done
             createdb -p 5432 -h localhost testing
             psql -p 5432 -h localhost -d testing -Xaf ${./nix/tests/prime.sql}
-            pg_prove -p 5432 -h localhost -d testing ${sqlTests}/*.sql
+
+
+            #pg_prove -p 5432 -h localhost -d testing ${sqlTests}/*.sql
+
+			mkdir regression_output
+            pg_regress \
+              --use-existing \
+              --dbname=testing \
+              --inputdir=${./nix/tests} \
+              --outputdir=regression_output \
+              $(ls ${./nix/tests/sql} | sed -e 's/\..*$//' | sort )
+			
+
+            mv regression.diffs $PWD
+            mv regression_output $PWD
+
             pg_ctl -D "$PGDATA" stop
             mv $TMPDIR/logfile/postgresql.log $out
             echo ${pgpkg}
diff --git a/nix/tests/expected/select_one.out b/nix/tests/expected/select_one.out
@@ -0,0 +1 @@
+1
diff --git a/nix/tests/sql/select_one.sql b/nix/tests/sql/select_one.sql
@@ -0,0 +1 @@
+select 1;
