Test overlap filter on integer array field.
(db_array_fields)
| 160 | @requireCapability(dialect="postgres") |
| 161 | @pytest.mark.asyncio |
| 162 | async def test_overlap_ints(db_array_fields): |
| 163 | """Test overlap filter on integer array field.""" |
| 164 | obj1 = await testmodels.ArrayFields.create(array=[1, 2, 3]) |
| 165 | obj2 = await testmodels.ArrayFields.create(array=[2, 3, 4]) |
| 166 | obj3 = await testmodels.ArrayFields.create(array=[3, 4, 5]) |
| 167 | |
| 168 | found = await testmodels.ArrayFields.filter(array__overlap=[1, 2]) |
| 169 | assert found == [obj1, obj2] |
| 170 | |
| 171 | found = await testmodels.ArrayFields.filter(array__overlap=[4]) |
| 172 | assert found == [obj2, obj3] |
| 173 | |
| 174 | found = await testmodels.ArrayFields.filter(array__overlap=[1, 2, 3, 4, 5]) |
| 175 | assert found == [obj1, obj2, obj3] |
| 176 | |
| 177 | |
| 178 | @requireCapability(dialect="postgres") |