From: Tom Hughes <tom@compton.nu>
Date: Sun, 4 Dec 2022 12:52:19 +0000 (+0000)
Subject: Add tests for db cookbook
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/d4903a8819db374d78487227003f49398611b481

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
index 000000000..a620c0a27
--- /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
index 000000000..b6e920c8f
--- /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
index 000000000..b6e920c8f
--- /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
index 000000000..b6e920c8f
--- /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