diff options
-rw-r--r-- | import/import.py | 9 |
1 files changed, 9 insertions, 0 deletions
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() |