From d2cb3584d2a238297aa565be3b0c9a09de12c06d Mon Sep 17 00:00:00 2001
From: Pieter Lexis <pieter.lexis@powerdns.com>
Date: Wed, 10 Apr 2019 12:16:03 +0200
Subject: [PATCH] Test postgresql backend

---
 .circleci/config.yml | 38 ++++++++++++++++++++++++++++++++++++--
 1 file changed, 36 insertions(+), 2 deletions(-)

diff --git a/.circleci/config.yml b/.circleci/config.yml
index 440bd678ab..e761edacd7 100644
--- a/.circleci/config.yml
+++ b/.circleci/config.yml
@@ -135,6 +135,7 @@ commands:
           apt-get install -qq -y --no-install-recommends \
             libboost-all-dev \
             liblmdb0 \
+            libpq5 \
             libssl1.1 \
             libsystemd0 \
             default-libmysqlclient-dev \
@@ -156,8 +157,9 @@ commands:
               git \
               libboost-all-dev \
               liblmdb-dev \
-              libssl-dev \
+              libpq-dev \
               libsqlite3-dev \
+              libssl-dev \
               libtool \
               make \
               pkg-config \
@@ -263,7 +265,7 @@ jobs:
             CXXFLAGS="-O1 -Werror=vla" \
             ./configure \
               --disable-lua-records \
-              --with-modules='bind lmdb gmysql gsqlite3 godbc random' \
+              --with-modules='bind lmdb gmysql gsqlite3 gpgsql godbc random' \
               --enable-tools \
               --with-lmdb=/usr \
               --prefix=/opt/pdns-auth
@@ -442,6 +444,35 @@ jobs:
       - auth-regress:
           context: gmysql-nsec3-narrow
 
+  test-auth-regress-gpgsql:
+    docker:
+      - image: debian:stretch
+      - image: circleci/postgres:9
+        environment:
+          POSTGRES_USER: root
+    steps:
+      - auth-regress-setup
+      - run:
+          command: apt-get install -qq -y postgresql-client
+      - run:
+          name: Use TCP for Postgresql connections
+          command: |
+            cat >> ./vars \<<- __EOF__
+            export PGHOST=127.0.0.1
+            export PGPORT=5432
+            __EOF__
+          workdir: ~/project/regression-tests
+      - auth-regress:
+          context: gpgsql-nodnssec-both
+      - auth-regress:
+          context: gpgsql-both
+      - auth-regress:
+          context: gpgsql-nsec3-both
+      - auth-regress:
+          context: gpgsql-nsec3-optout-both
+      - auth-regress:
+          context: gpgsql-nsec3-narrow
+
   test-auth-regress-lmdb:
     docker:
       - image: debian:stretch
@@ -635,6 +666,9 @@ workflows:
       - test-auth-regress-gsqlite3:
           requires:
             - build-auth
+      - test-auth-regress-gpgsql:
+          requires:
+            - build-auth
       - test-auth-regress-lmdb:
           requires:
             - build-auth
-- 
2.47.2