Hi Lee, thanks for responding.
The code was only part of the entire query, perhaps I needed to provide the
entire query and try to explain and give an explanation a little bit.
Here is the entire code:
monthly_events = current_user.followed_events().filter(Event.event_date <
datetime.today().date()).filter(func.strftime('%m', Event.event_date =
datetime.today().strftime('%m'))).order_by(Event.timestamp.desc())
The section of the query:
current_user.followed_events().filter(Event.event_date
<= datetime.today().date()) gives all upcoming events that are yet to
happen, including those that are due today. This part works correctly.
The section: current_user.followed_events().filter(Event.event_date <
datetime.today().date()).order_by(Event.timestamp.desc()) arranges the
events in dissenting order and this section works currently for all
upcoming events.
However, the part with problems is this one: .filter(func.strftime('%m',
Event.event_date = datetime.today().strftime('%m'))) where the aim to
filter out events that will take place in the current month. This is the
section that I posted, yet I needed to post the entire query for what I am
intending to achieve is understood. Note that I have imported the
following modules from sqlalchemy import func and from datetime import
datetime at the top.
The event_date field in the models.py is stored as a db.DateTime with a default
= datetime.utcnow.
On Wed, Apr 5, 2023 at 9:07 AM Lele Gaifax <l...@metapensiero.it> wrote:
> Nancy Andeyo <nandey...@gmail.com> writes:
>
> > the filter *.filter(func.strftime('%m', func.date(Events.date_of_event)
> ==
> > datetime.today().strftime('%m')))* to get all the events that happened in
> > the current month is not working. But displays all the events.
>
> Read carefully what you have written:
>
> > func.strftime('%m', func.date(Events.date_of_event) ==
> datetime.today().strftime('%m'))
>
> You are passing a boolean value to the strftime() function, and that's
> not what you probably meant/want.
>
> ciao, lele.
> --
> nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
> real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
> l...@metapensiero.it | -- Fortunato Depero, 1929.
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/87ttxueubh.fsf%40metapensiero.it
> .
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/CAJiyv_2aEuJsWOE%2B6cwKFHo_R3zQ6kFF68QzmrQtm4U_pXEPHw%40mail.gmail.com.
