Method test_not_any

tests/columns/test_array.py:117–131

Make sure rows can be retrieved where the array doesn't contain a certain value.

(self)

    @engines_skip("sqlite")
    def test_not_any(self):
        """
        Make sure rows can be retrieved where the array doesn't contain a
        certain value.
        """
        MyTable(value=[1, 2, 3]).save().run_sync()
        MyTable(value=[4, 5, 6]).save().run_sync()

        # We have to explicitly specify the type, so CockroachDB works.
        self.assertEqual(
            MyTable.select(MyTable.value)
            .where(MyTable.value.not_any(QueryString("{}::INTEGER", 4)))
            .run_sync(),
            [{"value": [1, 2, 3]}],
        )

    @engines_skip("sqlite")
    def test_cat(self):