Refactor code, update PHP version and optimize database queries #49

	name: CI

	on:
	push:
	branches:
	- main
	pull_request: ~
	workflow_dispatch: ~

	concurrency:
	group: ${{ github.workflow }}-${{ github.head_ref \|\| github.run_id }}
	cancel-in-progress: true

	jobs:
	lint:
	name: Docker Lint
	runs-on: ubuntu-latest
	steps:
	-
	name: Checkout
	uses: actions/checkout@v3
	-
	name: Lint Dockerfile
	uses: hadolint/[email protected]
	build:
	name: Docker build
	runs-on: ubuntu-latest
	steps:
	- name: Checkout
	uses: actions/checkout@v3
	- name: Check security
	uses: symfonycorp/security-checker-action@v2
	- name: Pull images
	run: make build
	- name: Start services
	run: make up
	- name: Wait for services
	run: \|
	while status="$(docker inspect --format="{{if .Config.Healthcheck}}{{print .State.Health.Status}}{{end}}" "$(docker compose ps -q php)")"; do
	case $status in
	starting) sleep 1;;
	healthy) exit 0;;
	unhealthy) exit 1;;
	esac
	done
	exit 1
	- name: Install dependencies
	run: make install
	- name: Compile assets
	run: make assets
	- name: Check HTTP reachability
	run: curl http://localhost:8080
	- name: Check HTTPS reachability
	run: curl -k https://localhost:8443

Provide feedback