From d79ea82117ff535202172e46a1c810c3ef13b8d8 Mon Sep 17 00:00:00 2001 From: Jonathan Bauer Date: Fri, 29 Apr 2022 14:39:00 +0200 Subject: import.py: import baseSystems --- import/import.py | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/import/import.py b/import/import.py index 2c22363..274c1f4 100644 --- a/import/import.py +++ b/import/import.py @@ -197,6 +197,15 @@ for i in [7, 30, 90]: item['total'] )) + # Add base systems + for item in data[iStr]['baseSystem']: + cursor.execute('INSERT INTO basesystem(report, days, system, count) VALUES (%s, %s, %s, %s)',( + reportId, + i, + item['system'], + item['count'] + )) + db.commit() db.close() -- cgit v1.2.3-55-g7522