feat: complete data-ml integration for Postgres (#1) #4

	name: validate

	on:
	pull_request:
	push:
	branches: [ main ]

	jobs:
	validate:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: aurekai
	POSTGRES_PASSWORD: aurekai
	POSTGRES_DB: aurekai
	ports:
	- 5432:5432
	options: >-
	--health-cmd "pg_isready -U aurekai -d aurekai"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 10
	env:
	DATABASE_URL: postgresql://aurekai:aurekai@localhost:5432/aurekai
	steps:
	- uses: actions/checkout@v4

	- name: Ensure required files exist
	run: \|
	test -f README.md
	test -f LICENSE
	test -f .release-versions.env
	test -f scripts/init-db.sh
	test -f tests/validate-schemas.sh
	test -f tests/validate-scripts.sh

	- name: Install dependencies
	run: \|
	sudo apt-get update
	sudo apt-get install -y postgresql-client
	python3 -m pip install --upgrade pip
	python3 -m pip install -r requirements.txt

	- name: Validate schemas
	run: bash tests/validate-schemas.sh "$DATABASE_URL"

	- name: Validate scripts
	run: bash tests/validate-scripts.sh "$DATABASE_URL"

Navigation Menu