> On Mar 30, 2023, at 2:32 PM, James Paul Chibole <jpchib...@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/D9E83ABA-9E34-4375-A0AB-E986B96B6794%40americanefficient.com.
