main.yml

name: Run steam-to-sqlite

on:
  schedule:
    - cron: "19 * * * *" # every hour

  # Allows running this workflow manually from the Actions tab
  workflow_dispatch:

jobs:
  run:
    runs-on: ubuntu-latest
    if: github.ref == 'refs/heads/main'

    steps:
      - uses: actions/checkout@v4

      - name: Setup Python
        uses: actions/setup-python@v5
        with:
          python-version: "3.12"
          cache: "pip"

      - name: Install
        run: |
          pip install -r requirements.txt
          pip install .

      - name: run the script
        run: |
          wget -qO database.db https://www.dropbox.com/s/i47qt3chrp9lr9e/database.db?dl=1
          alembic upgrade head
          python steam2sqlite/main.py --limit 45
        shell: bash

      - name: upload to dropbox
        run: |
          python scripts/uploader.py database.db /database.db
        env:
          DROPBOX_ACCESS_TOKEN: ${{ secrets.DROPBOX_ACCESS_TOKEN }}
        shell: bash

      - uses: actions/upload-artifact@v4
        if: failure()
        with:
          name: database.db
          path: database.db

      - name: Get flyctl
        uses: superfly/flyctl-actions/setup-flyctl@master

      - name: Deploy Datasette using Fly
        env:
          FLY_API_TOKEN: ${{ secrets.FLY_API_TOKEN }}
        run: |-
          datasette publish fly database.db \
            --install datasette-graphql --install datasette-vega \
            --app steam-to-sqlite \
            --metadata datasette-data/metadata.json \
            --setting sql_time_limit_ms 3500