FilesExpand file tree

 main

/

cakephp-postgres.yml

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

138 lines (118 loc) · 4.76 KB

 main

/

cakephp-postgres.yml

Copy path

Top

File metadata and controls

• Code
• Blame

138 lines (118 loc) · 4.76 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

# GitHub Action for CakePHP with PostgreSQL and Redis

# Tested with https://github.com/cakephp/app

name: Testing CakePHP with PostgreSQL

on: [push, pull_request]

jobs:

tests:

strategy:

matrix:

php-versions: ['7.4', '8.0', '8.1']

runs-on: ubuntu-latest

# Docs: https://docs.github.com/en/actions/using-containerized-services

services:

postgres:

image: postgres:latest

env:

POSTGRES_USER: postgres

POSTGRES_PASSWORD: postgres

POSTGRES_DB: postgres

ports:

- 5432/tcp

options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 3

redis:

image: redis

ports:

- 6379/tcp

options: --health-cmd="redis-cli ping" --health-interval=10s --health-timeout=5s --health-retries=3

steps:

- name: Checkout

uses: actions/checkout@v6

# Docs: https://github.com/shivammathur/setup-php

- name: Setup PHP

uses: shivammathur/setup-php@v2

with:

php-version: ${{ matrix.php-versions }}

# You can also use ext-apcu or ext-memcached instead of ext-redis

# Install memcached if using ext-memcached

extensions: mbstring, intl, redis, pdo_pgsql

coverage: pcov

# Local PostgreSQL service in GitHub hosted environments is disabled by default.

# If you are using it instead of service containers, make sure you start it.

# - name: Start postgresql service

# run: sudo systemctl start postgresql.service

- name: Get composer cache directory

id: composer-cache

run: echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT

- name: Cache composer dependencies

uses: actions/cache@v3

with:

path: ${{ steps.composer-cache.outputs.dir }}

# Use composer.json for key, if composer.lock is not committed.

# key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.json') }}

key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}

restore-keys: ${{ runner.os }}-composer-

- name: Install dependencies

run: |

composer install --no-progress --prefer-dist --optimize-autoloader

composer run-script post-install-cmd

# Add a step to run migrations if required

- name: Test with phpunit

run: vendor/bin/phpunit --coverage-text

env:

REDIS_PORT: ${{ job.services.redis.ports['6379'] }}

DB_DSN: postgres://postgres@127.0.0.1:${{ job.services.postgres.ports['5432'] }}/postgres

coding-standard:

name: Coding Standard

runs-on: ubuntu-latest

steps:

- name: Checkout

uses: actions/checkout@v6

# Docs: https://github.com/shivammathur/setup-php

- name: Setup PHP

uses: shivammathur/setup-php@v2

with:

php-version: '8.1'

extensions: mbstring, intl

- name: Get composer cache directory

id: composer-cache

run: echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT

- name: Cache composer dependencies

uses: actions/cache@v3

with:

path: ${{ steps.composer-cache.outputs.dir }}

# Use composer.json for key, if composer.lock is not committed.

# key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.json') }}

key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}

restore-keys: ${{ runner.os }}-composer-

- name: Install dependencies

run: composer install --no-progress --prefer-dist --optimize-autoloader

- name: PHP CodeSniffer

run: composer cs-check

static-analysis:

name: Static Analysis

runs-on: ubuntu-latest

steps:

- name: Checkout

uses: actions/checkout@v6

# Docs: https://github.com/shivammathur/setup-php

- name: Setup PHP

uses: shivammathur/setup-php@v2

with:

php-version: '8.1'

extensions: mbstring, intl

tools: phpstan

- name: Get composer cache directory

id: composer-cache

run: echo "dir=$(composer config cache-files-dir)" >> $GITHUB_OUTPUT

- name: Cache composer dependencies

uses: actions/cache@v3

with:

path: ${{ steps.composer-cache.outputs.dir }}

# Use composer.json for key, if composer.lock is not committed.

# key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.json') }}

key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}

restore-keys: ${{ runner.os }}-composer-

- name: Install dependencies

run: composer install --no-progress --prefer-dist --optimize-autoloader

- name: Static Analysis using PHPStan

run: phpstan analyse --no-progress src/