Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-27 Thread Simon King
I can't see anything obviously wrong with your code. If you turn on debug logs, you'll be able to see the SQL that is being executed, and the rows that are coming back. Paste those logs here and maybe we'll be able to help more. Simon On Tue, Oct 25, 2022 at 2:38 PM Abdellah ALAOUI ISMAILI <

Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-25 Thread Abdellah ALAOUI ISMAILI
yes, all tags have a color... Can you suggest me another way to do this, please? thank you . Le mardi 25 octobre 2022 à 10:52:17 UTC+1, Simon King a écrit : > Turn on debug logs (add echo="debug" to your db connection string) to see > the SQL you are executing and the results you are getting

Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-25 Thread Simon King
Turn on debug logs (add echo="debug" to your db connection string) to see the SQL you are executing and the results you are getting back: https://docs.sqlalchemy.org/en/14/core/engines.html#sqlalchemy.create_engine.params.echo Are you sure that the database actually contains colours for those

Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-22 Thread Abdellah ALAOUI ISMAILI
wheel ... in my template, I get just the first tag color, returned from the function. this is the result of my HTML file source code : LOG EXADATA DMZ_PRIVE I hope it's clear, thank you . Le vendredi 21 octobre 2022 à 09:23:48 UTC+1, Simon King a écrit : > I don't

Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-21 Thread Simon King
I don't understand the question. Are you saying that only one tag is displayed? If so, that's not a problem with SQLAlchemy, it's a problem with your template logic. If that's not what you mean, you need to give us more information. What is the value of "server.tags", and what is the output from

[sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask

2022-10-20 Thread Abdellah ALAOUI ISMAILI
Hello, I call a function in my template that returns sqlalchemy query result, (color value from the name of the tag). this is the query function : *def get_tag_color(name): * *return db.session.query(Tag.tag_color).filter(Tag.tag_name == name).scalar() * and I call it in my template file: * {%