[PonyORM-list] Problem with iterated linked table

[Matthew Bell]

IMO, the database should be doing the sorting in the query, not sorted()

On 20 November 2014 15:16, Gamesbrainiac <gamesbrainiac at gmail.com> wrote:

> Well, I have set up the following example for you, see if it works for you:
>
> https://gist.github.com/gamesbrainiac/5eacc2a5c1b0fb1cd52f
>
> Hope this helps :)
>
> On Thu, Nov 20, 2014 at 7:08 PM, Pedro Baumann <ondoheer at gmail.com> wrote:
>
>> Precisely! That's my problem.
>> On 20 Nov 2014 02:21, "Gamesbrainiac" <gamesbrainiac at gmail.com> wrote:
>>
>>> I think I get your problem now. Right now, it is ordering by post ID. Do
>>> you want the comments of a particular post to be ordered by ID, or do you
>>> want something like:
>>>
>>> Post 1:
>>>     Comment 1
>>>     Comment 2
>>> Post 2:
>>>    Comment 1
>>>    Comment 2
>>>
>>> ?
>>>
>>> On Thu, Nov 20, 2014 at 12:19 PM, Pedro Baumann <ondoheer at gmail.com>
>>> wrote:
>>>
>>>> Hello Gamebrainiac
>>>>
>>>> Thanks for the link, it seems really interesting.
>>>>
>>>> I have tried both your suggestions and both gave mme the same problem.
>>>>
>>>> They both return the Post object ordered by id, same as my code did.
>>>> The problem is that somehow when I iterate through the posts like soÑ
>>>>
>>>>     {% for post in posts %}
>>>>        {% for comment in post.comments %}
>>>>
>>>>
>>>> the comments come out in any order, and they change with every
>>>> request!!!!
>>>>
>>>> That same thing happens with your suggestions.
>>>> I think this hasn't happend to me with pony before, but somehow it does
>>>> now.  Is there a way to sort the linked table from jinja?
>>>>
>>>> something like post.comments.order_by(id)?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Pedro Baumann Cornejo*
>>>> Psicólogo - Psicoterapeuta - Flores de Bach
>>>> Francisco de Paula Ugarriza 309 dpto. 102 Miraflores.
>>>> Lima
>>>> Perú
>>>>
>>>> On Thu, Nov 20, 2014 at 1:02 AM, Gamesbrainiac <gamesbrainiac at gmail.com
>>>> > wrote:
>>>>
>>>>> In addendum, this is the exact part where I talk about querying:
>>>>> http://nafiulis.me/a-todo-app-with-flask-and-pony.html#id4
>>>>>
>>>>> On Thu, Nov 20, 2014 at 12:01 PM, Gamesbrainiac <
>>>>> gamesbrainiac at gmail.com> wrote:
>>>>>
>>>>>> Try using:
>>>>>>
>>>>>> '"SELECT * FROM "post" ORDER BY "post"."id"'
>>>>>>
>>>>>> If I were you, I'd do the following in pony:
>>>>>>
>>>>>> Post.select().order_by(Post.id)
>>>>>>
>>>>>> Also, my post on Pony might be worth a look ->
>>>>>> http://nafiulis.me/a-todo-app-with-flask-and-pony.html
>>>>>>
>>>>>> On Thu, Nov 20, 2014 at 11:43 AM, Pedro Baumann <ondoheer at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> first of all I want to thank you for creating such an intuitive and
>>>>>>> pythonic ORM, I have enjoyed every minute if used it, it's most intuitive
>>>>>>> and it really heps code readability.
>>>>>>>
>>>>>>> I'm having a small problem with my latest project, I hope you can
>>>>>>> help me.
>>>>>>>
>>>>>>> I'm developing a web app that has a basic "blog like" module.
>>>>>>>
>>>>>>> Post->Comments->Replies
>>>>>>>
>>>>>>> I'm using Flask as a framework.
>>>>>>>
>>>>>>> I'm passing
>>>>>>>
>>>>>>>
>>>>>>> *posts = Post.select_by_sql('SELECT * FROM post ORDER BY id')*
>>>>>>>
>>>>>>> to the template, and then iterating through it to print the comments
>>>>>>> as in
>>>>>>>
>>>>>>> {% for comment in post.comments %}
>>>>>>>   {% if loop.index > numberComments %}{% break %}{% endif %}
>>>>>>>  // code code code (HTML)
>>>>>>> {% endfor %}
>>>>>>>
>>>>>>> the problem is the comments come out in random order, varying on
>>>>>>> each iteration.
>>>>>>>
>>>>>>> I need to be able to print the comments in order for my ajax
>>>>>>> functions that retrieve more comments to work.
>>>>>>>
>>>>>>> I think I am missing something here.
>>>>>>>
>>>>>>> Thanks !
>>>>>>>
>>>>>>> *Pedro Baumann Cornejo*
>>>>>>> Psicólogo - Psicoterapeuta - Flores de Bach
>>>>>>> Francisco de Paula Ugarriza 309 dpto. 102 Miraflores.
>>>>>>> Lima
>>>>>>> Perú
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> ponyorm-list mailing list
>>>>>>> ponyorm-list at ponyorm.com
>>>>>>> /ponyorm-list
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Kind Regards,
>>>>>>
>>>>>> Quazi Nafiul Islam
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Kind Regards,
>>>>>
>>>>> Quazi Nafiul Islam
>>>>>
>>>>> _______________________________________________
>>>>> ponyorm-list mailing list
>>>>> ponyorm-list at ponyorm.com
>>>>> /ponyorm-list
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> ponyorm-list mailing list
>>>> ponyorm-list at ponyorm.com
>>>> /ponyorm-list
>>>>
>>>>
>>>
>>>
>>> --
>>> Kind Regards,
>>>
>>> Quazi Nafiul Islam
>>>
>>> _______________________________________________
>>> ponyorm-list mailing list
>>> ponyorm-list at ponyorm.com
>>> /ponyorm-list
>>>
>>>
>> _______________________________________________
>> ponyorm-list mailing list
>> ponyorm-list at ponyorm.com
>> /ponyorm-list
>>
>>
>
>
> --
> Kind Regards,
>
> Quazi Nafiul Islam
>
> _______________________________________________
> ponyorm-list mailing list
> ponyorm-list at ponyorm.com
> /ponyorm-list
>
>


-- 
Regards,

Matthew Bell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ponyorm-list/attachments/20141120/911a219c/attachment-0001.html>