Gull-api

Fix version regex

Support release candidates and add database tests

This commit includes several improvements and additions:
- Update GitHub Actions workflows to support publishing release candidate versions to TestPyPI and Docker with the appropriate tagging.
- Add a new test file, test_db.py, to include unit tests for database operations.
- Modify pyproject.toml to include pytest-asyncio as a development dependency.
- Remove ThreadPoolExecutor from gull_api/main.py as it's not being used.

The ability to support release candidate versions helps in testing pre-releases.
Including tests for database operations enhances the robustness of the application.

**Full Changelog**: https://github.com/mdbecker/gull_api/compare/0.0.11...0.0.12-rc

Try to fix the github actions

Add PyPI publishing action, refactor GitHub Actions, and update pyproject.toml

This commit introduces several enhancements and improvements to the CI/CD workflow and packaging.

- Adds a new GitHub Action for publishing the package to PyPI on release.
- Introduces a reusable test workflow that can be called by other workflows.
- Updates the test workflow trigger to prevent redundant runs.
- Adds a placeholder for the version number in pyproject.toml, which gets replaced during CI/CD.
- Enriches pyproject.toml with additional metadata about the package.

These changes ensure a DRY (Don't Repeat Yourself) approach to workflows and improve packaging metadata.

Change version placeholder to valid semantic version

The version placeholder in pyproject.toml is changed from "VERSION_PLACEHOLDER" to "0.0.0" to ensure that the test workflow doesn't fail due to an invalid version string. The docker-publish.yml and pypi-publish.yml workflows are updated to search for and replace "0.0.0" instead of "VERSION_PLACEHOLDER" during the release process.

Update docker-publish action to set version in pyproject.toml

This commit modifies the .github/workflows/docker-publish.yml GitHub action to automatically update the version string in pyproject.toml to match the GitHub release version. This ensures that the Docker image is built with the correct version information.

Changes:
- Extract release version from GitHub.
- Update version in pyproject.toml for the context of the current action.

Support capturing /llm endpoint requests to external database

This commit includes support for logging all requests and responses made to the /llm endpoint to an external database. It introduces a new file, gull_api/db.py, that handles the database configuration and log creation, and modifies gull_api/main.py to incorporate the new logging mechanism.

Additionally, updates have been made to the Docker configuration to accommodate local SQLite storage when running the container. The Dockerfile now creates a directory for storing the SQLite database, and the README has been updated with instructions for volume mounting this directory. The .dockerignore file has been introduced to exclude unnecessary directories from the Docker build context.

Changes:
- New file gull_api/db.py for handling database interactions.
- Updated gull_api/main.py to log requests/responses to /llm endpoint.
- Dockerfile creates a directory for SQLite database storage.
- Updated README.md for instructions on Docker volume mounting.
- Introduced .dockerignore file.
- Added SQLAlchemy dependency in pyproject.toml.
- Updated tests/test_api.py for additional test cases.

This enhancement will allow for better tracking and debugging of API requests by storing all the request/response data for future reference and analysis.

**Full Changelog**: https://github.com/mdbecker/gull_api/compare/0.0.7...0.0.8