Method __insert_detection

aura/output/sqlite.py:206–227

(self, cur, diff_id, detection, status)

            self._db.execute(DETECTION_SCHEMA)

    def __insert_detection(self, cur, diff_id, detection, status):
        assert status in ("new", "removed")

        cur.execute("""
            INSERT into DETECTIONS (
                is_new,
                is_removed,
                signature,
                score,
                type,
                data,
                diff
            ) VALUES (?,?,?,?,?,?,?)
        """, [
            (status == "new"),
            (status == "removed"),
            detection.signature,
            detection.score,
            detection.name,
            json.dumps(detection._asdict(), default=json_encoder),
            diff_id
        ])

    def output_diff(self, diffs_analyzer):
        cur = self._db.cursor()