Netcross/.github/workflows/cve-update.yml at 900be9cfb60be72281ed29e5b373ae9ae6c683c0 · Mathide-Team/Netcross · 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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
# .github/workflows/cve-update.yml -- CD : mise a jour periodique de la
# base CVE locale (issue #255).
#
# Interroge l'API NVD 2.0 via scripts/import_nvd.py --fetch, puis commit
# la base SQLite mise a jour sur la branche dev (ou une branche dediee
# si la CI tourne sur main).
#
# Declenche :
#   - planifie : tous les lundis a 03:00 UTC (le NVD publie en continu,
#     une frequence hebdomadaire suffit pour couvrir la majorite des
#     nouvelles CVE sans saturer le quota de l'API publique)
#   - manuel : bouton "Run workflow" dans l'onglet Actions

name: Mise a jour CVE

"on":
  schedule:
    - cron: "0 3 * * 1"  # tous les lundis a 03:00 UTC
  workflow_dispatch:
    inputs:
      keyword:
        description: "Mot-cle optionnel (ex: apache, openssh) pour filtrer"
        required: false
        type: string

permissions:
  contents: write  # pour committer la base mise a jour

jobs:
  update-cve:
    name: Import NVD -> base CVE locale
    runs-on: ubuntu-latest

    steps:
      - name: Checkout du depot
        uses: actions/checkout@v7
        with:
          ref: dev
          token: ${{ secrets.GITHUB_TOKEN }}

      - name: Installation de Python
        uses: actions/setup-python@v5
        with:
          python-version: "3.14"

      - name: Installation des dependances
        run: pip install -r requirements.txt

      - name: Import NVD (fetch)
        run: |
          mkdir -p data
          python3 scripts/import_nvd.py \
            --db data/cve.db \
            --fetch \
            ${{ github.event.inputs.keyword && format('--keyword {0}', github.event.inputs.keyword) || '' }}

      - name: Verification de la base
        run: |
          python3 -c "
          import sqlite3
          conn = sqlite3.connect('data/cve.db')
          count = conn.execute('SELECT COUNT(*) FROM cve').fetchone()[0]
          print(f'Base CVE : {count} entrees')
          conn.close()
          "

      - name: Commit de la base mise a jour
        run: |
          git config user.name "github-actions[bot]"
          git config user.email "github-actions[bot]@users.noreply.github.com"
          git add data/cve.db
          if git diff --staged --quiet; then
            echo "Aucune modification de la base CVE -- abandon."
          else
            git commit -m "chore(#255): mise a jour automatique de la base CVE (NVD)"
            git push
          fi