tests: adding a database creation with extensions

2 files changed, 16 insertions, 1 deletions

diff --git a/.travis.yml b/.travis.yml
index 7a72289..c424411 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -13,7 +13,7 @@ addons:
 
 install:
   # Install ansible
-  - pip install ansible
+  - pip install ansible docker-py docker
   # Check ansible version
   - ansible --version
   - ansible-galaxy install -r test/requirements.yml -p test/roles/
@@ -21,6 +21,8 @@ install:
 script:
   # Basic role syntax check
   - ansible-playbook test/main.yml -i test/hosts --syntax-check
+  # Run the tests
+  - ansible-playbook test/main.yml -i test/hosts
 
 notifications:
   webhooks: https://galaxy.ansible.com/api/v1/notifications/
diff --git a/test/main.yml b/test/main.yml
index 6258199..bc9d27c 100644
--- a/test/main.yml
+++ b/test/main.yml
@@ -49,12 +49,25 @@
             archive_enabled: True
             barman_directory: "{{ postgres_barman_directory }}"
             users:
+              - username: tester
+                password: tester
               - username: barman
                 password: "secret_cocktail"
                 permissions: 'SUPERUSER'
               - username: replicator
                 password: "secret_repli"
                 permissions: 'REPLICATION'
+            databases:
+              - dbname: test_database
+                owner: tester
+                extensions:
+                  - description: PostGis
+                    apt_deps:
+                      - "postgresql-{{ postgres_version }}-postgis"
+                    names:
+                      - postgis
+                      - postgis_topology
+                      - btree_gist
 
       with_items:
         - postgres_one