Re: [sqlalchemy] Working with func in dates, No response, no error message
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 > 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/') @login_required def user(username): > current_month = datetime.today().date().strftime("%B") > monthly_anniversaries = > current_user.followed_deaths().filter(Deceased.burial_cremation_dat e > 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.
Re: [sqlalchemy] Working with func in dates, No response, no error message
> On Mar 30, 2023, at 2:32 PM, James Paul Chibole 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/')@login_required > def user(username): > current_month = datetime.today().date().strftime("%B") > monthly_anniversaries = > current_user.followed_deaths().filter(Deceased.burial_cremation_dat e > 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.
[sqlalchemy] Working with func in dates, No response, no error message
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/')@login_required def user(username): current_month = datetime.today().date().strftime("%B") monthly_anniversaries = current_user.followed_deaths().filter(Deceased.burial_cremation_dat e 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/3b972e00-e172-402a-983d-30ef7e22aef7n%40googlegroups.com.