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

[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:

{% if server.tags %}

{% for tag in server.tags.split(",") %} 

<strong><span style="background-color: {{ get_tag_color(tag) }};" class="label"> {{tag}} </span></strong>

 {% endfor %} {% endif %}

the problem is that I get just one result of the first tag. do you have any idea what I miss?

Thank you 

[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 the template?

Simon

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/4f9d1bab-479d-47d5-89cf-c305026ec3d7n%40googlegroups.com.

[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 :

<td>
<strong><span style="background-color: #ff830f;" class="label"> LOG  </span></strong>
<strong><span style="background-color: None;" class="label">  EXADATA  </span></strong>
<strong><span style="background-color: None;" class="label">  DMZ_PRIVE  </span></strong>
 </td>

I hope it's clear, 

thank you .

[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 tags?

Simon

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com.

[Abdellah ALAOUI ISMAILI]

yes, all tags have a color... 

Can you suggest me another way to do this, please?  

thank you .

[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

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/9b2f7e44-b2ff-4288-b02b-3fcc9d9bf170n%40googlegroups.com.