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 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 > > On Sat, Oct 22, 2022 at 3:37 PM Abdellah ALAOUI ISMAILI < > [email protected]> wrote: > >> 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 . >> >> Le vendredi 21 octobre 2022 à 09:23:48 UTC+1, Simon King a écrit : >> >>> 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 >>> >>> On Thu, Oct 20, 2022 at 9:05 AM Abdellah ALAOUI ISMAILI < >>> [email protected]> wrote: >>> >>>> 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 >>>> >>>> -- >>>> 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 [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/sqlalchemy/4f9d1bab-479d-47d5-89cf-c305026ec3d7n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/sqlalchemy/4f9d1bab-479d-47d5-89cf-c305026ec3d7n%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 [email protected]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/sqlalchemy/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/sqlalchemy/28c544b5-5445-45f9-ac8e-1dc786984d82n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/9b2f7e44-b2ff-4288-b02b-3fcc9d9bf170n%40googlegroups.com.
