Compare two lists (with intersections).
model:
['2022-07-04', '2022-07-05', '2022-07-06', '2022-07-07']
filter:
How to embed, put filtering
#
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