Encode timezone to handle Peace Value (#514) #397

	name: Generate Schemaspy Docs
	on:
	workflow_dispatch:

	# pull_request:
	push:
	branches:
	- main

	jobs:
	generate-schema-spy:
	name: Generate SchemaSpy Documentation
	runs-on: ubuntu-22.04
	services:
	postgres:
	image: postgis/postgis:16-3.4
	env:
	POSTGRES_DB: default
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: default
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	steps:
	- uses: actions/checkout@v4
	- name: Flyway
	uses: docker://flyway/flyway:10
	env:
	FLYWAY_URL: jdbc:postgresql://postgres:5432/default
	FLYWAY_USER: postgres
	FLYWAY_PASSWORD: default
	FLYWAY_LOCATIONS: filesystem:./backend/db/migrations
	FLYWAY_DEFAULT_SCHEMA: "public"
	with:
	args: info migrate info

	- name: Create Output Folder
	run: \|
	mkdir output
	chmod a+rwx -R output
	- name: Run Schemaspy
	run: docker run --network host -v "$PWD/output:/output" schemaspy/schemaspy:6.2.4 -t pgsql11 -db default -host 127.0.0.1 -port 5432 -u postgres -p default -schemas public
	- name: Deploy to Pages
	uses: JamesIves/github-pages-deploy-action@v4
	with:
	folder: output
	target-folder: schemaspy

Provide feedback