Compare two lists (with intersections).

[wnesbv]

Compare two lists (with intersections).

model:

reserve_period = sa.Column(sa.String, nullable=True)

the format of saving in the database
['2022-07-04', '2022-07-05', '2022-07-06', '2022-07-07']

filter:

async def period_item(
    request
):
    async with async_session() as session:
        rtf = await in_rtf(request)
        reserve = rtf.reserve_period
        result = await session.execute(
            select(Item, Rent)
            .join(
                ReserveTimeFor.something_item,
            )
            .where(Rent.rent_belongs == Item.id)
            .where(
                ReserveTimeFor.reserve_period != reserve # this is temporary
            )
        )
        obj_item = result.scalars().unique()
        return obj_item

    await engine.dispose()

#
How to embed, put filtering
#

period = set(reserve_period) & set(reserve)
if not period:
    return period
return False