feat: added sql linting and license validation to ci #3

	# SPDX-FileCopyrightText: © 2024 Adrian C. Prelipcean
	#
	# SPDX-License-Identifier: CC0-1.0

	name: CI
	on: [push, pull_request]

	jobs:
	test:
	strategy:
	matrix:
	pg:
	- 16

	name: PostgreSQL ${{ matrix.pg }}
	runs-on: ubuntu-latest
	container: pgxn/pgxn-tools
	steps:
	- name: Start PostgreSQL ${{ matrix.pg }}
	run: pg-start ${{ matrix.pg }}
	- name: Check out the repo
	uses: actions/checkout@v4
	- name: Test on PostgreSQL ${{ matrix.pg }}
	run: pg-build-test

	lint:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version: ["3.10"]
	steps:
	- uses: actions/checkout@v3
	with:
	fetch-depth: 0
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v3
	with:
	python-version: ${{ matrix.python-version }}
	- name: Cache requirements
	uses: actions/cache@v3
	with:
	path: ~/.cache/pip
	key: ${{ runner.os }}-pip-${{ hashFiles('**/requirements.txt') }}
	restore-keys: \|
	${{ runner.os }}-pip-
	- name: Install requirements
	if: steps.cache.outputs.cache-hit != 'true'
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements.txt
	- name: Analysing the SQL code
	run: \|
	sqlfluff lint --dialect postgres ./
	- name: Analysing Licenses
	run: \|
	reuse lint

Provide feedback