Improve database functions, add new assets #25

	name: Deploy API server with database

	on:
	push:
	paths:
	- 'server/**'
	- 'database/**'
	workflow_dispatch:


	env:
	REGISTRY: ghcr.io
	IMAGE_NAME: ${{ github.repository }}/server

	jobs:
	build-and-publish:
	permissions:
	actions: read
	deployments: write
	packages: write

	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v2

	- name: Set up QEMU
	uses: docker/setup-qemu-action@v3

	- name: Set up Docker Buildx
	uses: docker/setup-buildx-action@v3

	- name: Log in to the Container registry
	uses: docker/login-action@65b78e6e13532edd9afa3aa52ac7964289d1a9c1
	with:
	registry: ${{ env.REGISTRY }}
	username: ${{ github.actor }}
	password: ${{ secrets.GITHUB_TOKEN }}

	- name: Extract metadata (tags, labels) for Docker
	id: meta
	uses: docker/metadata-action@9ec57ed1fcdbf14dcef7dfbe97b2010124a938b7
	with:
	images: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: '3.11'
	- name: Install database dependencies
	run: cd database && pip install -r requirements.txt
	- name: Generate SQLite3 database file
	run: \|
	cd database && python3 main.py


	- name: Build and push Docker image
	uses: docker/build-push-action@f2a1d5e99d037542a71f64918e516c093c6f3fc4
	with:
	context: .
	file: server/Dockerfile
	push: true
	tags: ${{ steps.meta.outputs.tags }}
	labels: ${{ steps.meta.outputs.labels }}

Provide feedback