Method testUpdateJson

src/Test/TestDb.py:110–122

(self, db)

    def testUpdateJson(self, db):
        f = io.BytesIO()
        f.write("""
            {
                "test": [
                    {"test_id": 1, "title": "Test 1 title", "extra col": "Ignore it"}
                ]
            }
        """.encode())
        f.seek(0)
        assert db.updateJson(db.db_dir + "data.json", f) is True
        assert db.execute("SELECT COUNT(*) AS num FROM test_importfilter").fetchone()["num"] == 1
        assert db.execute("SELECT COUNT(*) AS num FROM test").fetchone()["num"] == 1

    def testUnsafePattern(self, db):
        db.schema["maps"] = {"[A-Za-z.]*": db.schema["maps"]["data.json"]}  # Only repetition of . supported