I am still struggling to find the solution on this issue, the issue is with
the func, because when I omit the comparison with the the func
sqlachemy function, the outcome is expected. However, I want to ensure that
only items for this month are displayed:
he filter *.filter(func.strftime('%m', func.date(Events.date_of_event) ==
current_month = datetime.today().strftime('%m')))* to get all the events
that happened in the current month is not working. But displays all the
events. Help me figure out the problem. I am using SQLite and sqlalchemy
with Flask to query the db. I have imported the `func` from sqlalchemy as
well as `datetime ` from `datetime` as required.
On Fri, Mar 31, 2023 at 8:22 AM James Paul Chibole <jpchib...@gmail.com>
wrote:
>
> Thank you Philip for your suggestion.
> On Thursday, March 30, 2023 at 9:38:08 PM UTC+3 Philip Semanchuk wrote:
>
>>
>>
>> > On Mar 30, 2023, at 2:32 PM, James Paul Chibole <jpch...@gmail.com>
>> wrote:
>> >
>> > Hi everyone, I am trying to retrieve deceased persons who died in the
>> current month but the output gives no result. Here is my code with query
>> done in Python Flask:
>> > from datetime import datetime from sqlalchemy import func
>> > @app.route('/user/<username>') @login_required def user(username):
>> current_month = datetime.today().date().strftime("%B")
>> monthly_anniversaries =
>> current_user.followed_deaths().filter(Deceased.burial_cremation_dat e
>> <datetime.today().date()).filter(func.strftime('%B',Deceased.date_o
>> f_death== current_month)).order_by(Deceased.timestamp.desc()) return
>> render_template("user.html", monthly_anniversaries =monthly_anniversaries)
>>
>>
>> Flask is an extra layer of complication here that’s getting in the way of
>> what you’re trying to debug. That’s not a knock on Flask (I use it too),
>> it’s just not germane to a SQLAlchemy problem. My suggestion is that you
>> try putting a breakpoint in your flask app so you can play with the query
>> inside the debugger. Ensure that current_month is what you think it is,
>> hardcode query params instead of passing variables to see if that changes
>> results, remove some of the filter clauses to see if the results change the
>> way you expect, etc. And of course having a look at the SQL that’s being
>> sent to the server will give you some clues too, although that can be hard
>> to get to depending on your environment.
>>
>>
>> Hope this helps
>> Philip
>
> --
> 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/f6a17840-cdfd-4f26-bdc5-0a75af82fa91n%40googlegroups.com
> <https://groups.google.com/d/msgid/sqlalchemy/f6a17840-cdfd-4f26-bdc5-0a75af82fa91n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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_2oLnfo%3DD56fkrYGt3sCoK7vPz-BKQAb7cm9VHsdaKwZw%40mail.gmail.com.
