forked from h0x0er/postgres-testing
-
Notifications
You must be signed in to change notification settings - Fork 2
61 lines (55 loc) · 2 KB
/
postgre.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
name: PostgreSQL Service Example
on: [workflow_dispatch]
jobs:
# Label of the runner jobb
runner-job:
# You must use a Linux environment when using service containers or container job
runs-on: ubuntu-latest
# Service containers to run with `runner-job`
services:
# Label used to access the service container
postgres:
# Docker Hub image
image: postgres
# Provide the password for postgres
env:
POSTGRES_PASSWORD: postgres
# Set health checks to wait until postgres has started
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
# --restart always
ports:
# Maps tcp port 5432 on service container to the host
- 5432:5432
steps:
- run: |
cat /etc/docker/daemon.json
docker ps
- run: echo "### hello world" >> $GITHUB_STEP_SUMMARY
- name: Harden Runner
uses: step-security/harden-runner@rc
with:
egress-policy: audit
# allowed-endpoints: >
# postgres:5432 # PostgreSQL service container
# Downloads a copy of the code in your repository before running CI tests
- name: Check out repository code
uses: actions/checkout@v3
# Performs a clean installation of all dependencies in the `package.json` file
# For more information, see https://docs.npmjs.com/cli/ci.html
- name: Install dependencies
run: npm ci
- name: Connect to PostgreSQL
# Runs a script that creates a PostgreSQL table, populates
# the table with data, and then retrieves the data
run: node client.js
# Environment variables used by the `client.js` script to create
# a new PostgreSQL table.
env:
# The hostname used to communicate with the PostgreSQL service container
POSTGRES_HOST: localhost
# The default PostgreSQL port
POSTGRES_PORT: 5432