Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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 <
my.alaoui...@gmail.com> wrote:
> 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 <
>> my.ala...@gmail.com> 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 :
>>>
>>>
>>> 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 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 <
my.ala...@gmail.com> 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(",") %} *
> * class="label"> {{tag}} *
> * {% 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 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
>
> .
>
--
>>> 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/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com
>>>
>>> .
>>>
>> --
> 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/9b2f7e44-b2ff-4288-b02b-3fcc9d9bf170n%40googlegroups.com
>
> .
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete,
Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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 <
> my.ala...@gmail.com> 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 :
>>
>>
>> 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 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 <
>>> my.ala...@gmail.com> 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(",") %} *
* >>> class="label"> {{tag}} *
* {% 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 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
.
>>> --
>> 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/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com
>>
>>
>> .
>>
>
--
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/9b2f7e44-b2ff-4288-b02b-3fcc9d9bf170n%40googlegroups.com.
Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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 <
my.alaoui...@gmail.com> 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 :
>
>
> 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 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 <
>> my.ala...@gmail.com> 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(",") %} *
>>> * >> class="label"> {{tag}} *
>>> * {% 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 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
>>>
>>> .
>>>
>> --
> 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/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com
>
> .
>
--
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/CAFHwexexdt23MLpk%3DSjAWSufgDzrjfgJxVwiAX%2B5JwbUsYisPQ%40mail.gmail.com.
Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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 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 <
> my.ala...@gmail.com> 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(",") %} *
>> * > class="label"> {{tag}} *
>> * {% 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 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
>>
>>
>> .
>>
>
--
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/28c544b5-5445-45f9-ac8e-1dc786984d82n%40googlegroups.com.
Re: [sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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 <
my.alaoui...@gmail.com> 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(",") %} *
> * class="label"> {{tag}} *
> * {% 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 sqlalchemy+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/4f9d1bab-479d-47d5-89cf-c305026ec3d7n%40googlegroups.com
>
> .
>
--
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/CAFHwexfk_Y_OeYFMxwyCS0n5xCQaSBQo_iShsT%3DLJm0cQX5b7w%40mail.gmail.com.
[sqlalchemy] iterate sqlalchemy query over for loop in my template python-flask
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(",") %} *
* {{tag}} *
* {% 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 sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/4f9d1bab-479d-47d5-89cf-c305026ec3d7n%40googlegroups.com.
