Skip to content

major correction

major correction #33

Workflow file for this run

name: Create SQLite Database and Release
on:
push:
branches:
- master
paths-ignore: [ '**.md'] # If only these files are edited, skip
workflow_dispatch:
jobs:
release:
runs-on: ubuntu-latest
steps:
- name: Checkout Repository
uses: actions/checkout@v2
- name: Install Dependencies
run: sudo apt-get update && sudo apt-get install -y wget build-essential tcl
- name: Fetch Latest SQLite Version
run: |
# Get the latest version number from the SQLite website
LATEST_VERSION=$(curl -s https://www.sqlite.org/download.html | grep -oP 'sqlite-autoconf-\K[0-9]+(?=\.tar\.gz)' | head -n 1)
echo "Latest version: $LATEST_VERSION"
# Construct the download URL
DOWNLOAD_URL="https://www.sqlite.org/2024/sqlite-autoconf-$LATEST_VERSION.tar.gz"
echo "Download URL: $DOWNLOAD_URL"
echo "LATEST_VERSION=$LATEST_VERSION" >> $GITHUB_ENV
echo "DOWNLOAD_URL=$DOWNLOAD_URL" >> $GITHUB_ENV
- name: Download and Compile SQLite
run: |
wget ${{ env.DOWNLOAD_URL }}
tar xvfz sqlite-autoconf-${{ env.LATEST_VERSION }}.tar.gz
cd sqlite-autoconf-${{ env.LATEST_VERSION }}
./configure
make
sudo make install
- name: Convert Plain-text to SQLite
run: |
sqlite3 piddatabase.db < umskt.db
mv umskt.db piddatabase.sql
- name: Create Release
id: create_release
uses: softprops/action-gh-release@v2
with:
files: |
piddatabase.db
piddatabase.sql
tag_name: v1.0.${{ github.run_number }}
token: ${{ secrets.UPLOAD_KEY }}