Add tests for db cookbook

diff --git a/test/integration/db-backup/serverspec/backup_spec.rb b/test/integration/db-backup/serverspec/backup_spec.rb
new file mode 100644 (file)
index 0000000..a620c0a
--- /dev/null
+++ b/test/integration/db-backup/serverspec/backup_spec.rb
@@ -0,0 +1,9 @@
+require "serverspec"
+
+# Required by serverspec
+set :backend, :exec
+
+describe service("backup-db.timer") do
+  it { should be_enabled }
+  it { should be_running }
+end

diff --git a/test/integration/db-base/serverspec/postgresql_spec.rb b/test/integration/db-base/serverspec/postgresql_spec.rb
new file mode 100644 (file)
index 0000000..b6e920c
--- /dev/null
+++ b/test/integration/db-base/serverspec/postgresql_spec.rb
@@ -0,0 +1,17 @@
+require "serverspec"
+
+# Required by serverspec
+set :backend, :exec
+
+describe package("postgresql-9.5") do
+  it { should be_installed }
+end
+
+describe service("postgresql@9.5-main") do
+  it { should be_enabled }
+  it { should be_running }
+end
+
+describe port(5432) do
+  it { should be_listening.with("tcp") }
+end

diff --git a/test/integration/db-master/serverspec/postgresql_spec.rb b/test/integration/db-master/serverspec/postgresql_spec.rb
new file mode 100644 (file)
index 0000000..b6e920c
--- /dev/null
+++ b/test/integration/db-master/serverspec/postgresql_spec.rb
@@ -0,0 +1,17 @@
+require "serverspec"
+
+# Required by serverspec
+set :backend, :exec
+
+describe package("postgresql-9.5") do
+  it { should be_installed }
+end
+
+describe service("postgresql@9.5-main") do
+  it { should be_enabled }
+  it { should be_running }
+end
+
+describe port(5432) do
+  it { should be_listening.with("tcp") }
+end

diff --git a/test/integration/db-slave/serverspec/postgresql_spec.rb b/test/integration/db-slave/serverspec/postgresql_spec.rb
new file mode 100644 (file)
index 0000000..b6e920c
--- /dev/null
+++ b/test/integration/db-slave/serverspec/postgresql_spec.rb
@@ -0,0 +1,17 @@
+require "serverspec"
+
+# Required by serverspec
+set :backend, :exec
+
+describe package("postgresql-9.5") do
+  it { should be_installed }
+end
+
+describe service("postgresql@9.5-main") do
+  it { should be_enabled }
+  it { should be_running }
+end
+
+describe port(5432) do
+  it { should be_listening.with("tcp") }
+end