palestine-datasets/.github/workflows/sqlite-export.yml at main · TechForPalestine/palestine-datasets · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
name: SQLite Export

on:
  workflow_dispatch:
  repository_dispatch:
    types: [sqlite-export]
  push:
    branches:
      - "main"
    paths:
      - "*.json"

permissions:
  contents: write

jobs:
  build:
    runs-on: ubuntu-latest
    timeout-minutes: 15

    steps:
      - uses: actions/checkout@v4

      - uses: oven-sh/setup-bun@v2
        with:
          bun-version: 1.0.22

      - name: Install dependencies
        run: bun install

      - name: Build SQLite
        run: bun run gen-sqlite

      - name: Get date
        id: date
        run: echo "today=$(date -u +'%Y-%m-%d')" >> "$GITHUB_OUTPUT"

      - name: Upload release
        uses: softprops/action-gh-release@v2
        with:
          tag_name: sqlite-latest
          name: "SQLite Export — ${{ steps.date.outputs.today }}"
          body: |
            Daily SQLite export of all palestine-datasets JSON files.
            Built: ${{ steps.date.outputs.today }}

            ### Tables
            | Table | Rows (approx) |
            |-------|---------------|
            | `casualties_daily` | ~900 |
            | `west_bank_daily` | ~900 |
            | `killed_in_gaza` | ~60k |
            | `press_killed_in_gaza` | ~260 |
            | `infrastructure_damaged` | ~730 |
            | `_meta` | 3 |

            ### Download
            curl -L https://github.com/TechForPalestine/palestine-datasets/releases/download/sqlite-latest/palestine-datasets.sqlite -o palestine-datasets.sqlite
          files: dist/palestine-datasets.sqlite
          make_latest: true