Mikki

And hello to you two too!

Иван

Ahoj

Mikki

Welcome!

Алекс

Hello, thank you!

Rozen

mm i don't get it very well, what's the point of getattr for databases?

Alexey

you are talking about this feature https://docs.ponyorm.com/api_reference.html#getattr, right?

Rozen

yep 😆

Alexey

it gives you more flexibility in writing queries

Alexey

you don't need to hardcode which attribute you extract or compare, but can pass the name of these attributes as a parameter

Alexander

This may be useful when somebody write some generic code for filtering. For example, when the name of the attribute may be received from the frontend as a GET parameter

Mikki

Welcome!

លី រិទធ៍ - Rit

Thank you. The switch to Apache License showed up on my twitter feed. I'm going forward to try it.

លី រិទធ៍ - Rit

looking*

Rozen

(sorry sorry, i got tempted)

Mikki

Welcome!

Mikki

Welcome! :)

Anonymous

Thanks! Never used pony before 'cause of the license, somehow I had the wrong idea it was too restrictive

Anonymous

it really is a beautiful ORM, kudos!

Mikki

Glad to hear that you're liking it! ^.^

Mikki

(note, Im not a dev but just an enthousiastic user :p )

Mikaelo

Same, usually used peewee for small projects, but now license allows to use pony; watching videos on youtube so far, testing, interesting.

Mikki

Nice nice :)

Serge

Hi guys! Great to see Apache 2 license and 4 spaces indentation!:)

Alexey

Hi guys! Great to see Apache 2 license and 4 spaces indentation!:)

Thanks! see more to come;)

Rustam.T

Как мир тесен )))

Serge

Как мир тесен )))

That is not a coincidence:)

Rozen

whut?

Rozen

i don't speak russian, sorry :(

Serge

Как мир тесен )))

Translation: What a small world

Rozen

well yeah, but i don't get the joke this time

Rustam.T

Translation: What a small world

Thanks bro😊👍

Alexander

It seems that several members of this chat know each other for a long time

Serge

well yeah, but i don't get the joke this time

A couple of Russian guys who know each other by professional interests on the same professional chat

Serge

That is what you typically expect to happen, imo

Serge

It seems that several members of this chat know each other for a long time

Yeah! I remember you pitching me PonyORM concept on the job interview:)

Alexander

Yeah :)

Rozen

oh

Rozen

awww

Rozen

sweet

Alexey

Yeah! I remember you pitching me PonyORM concept on the job interview:)

How was it?)

Alexander

It was in Netrika

Alexey

Yeah, I figured

Serge

How was it?)

Interview was great. Though I cannot say the same about the concept

Serge

😉

Alexey

Interview was great. Though I cannot say the same about the concept

What can you say about the concept then?)

Serge

I felt like I don't swing that way

Alexey

I felt like I don't swing that way

Didn't get what you mean

Serge

Didn't get what you mean

I mean it looked like that is not the way I do things

Alexey

I mean it looked like that is not the way I do things

Ah, I see

Serge

There were the second and the third layers of the joke to be honest...:)

Serge

You know me. I'm almost complete jerk in such a jokes

Alexey

hehe)

Lucky

Hello Telegram Group :D

Alexey

Hello Telegram Group :D

Hey Luckydonald, welcome :)

Lucky

Can I bother you guys with helping me write queries?

Alexey

Sure, go ahead

Lucky

https://editor.ponyorm.com/user/luckydonald/RssFeedStuff

Lucky

I am very new to pony and aren't so good with it. I want to retrieve all Messages of a FeedEntry with status "UNREAD"

Lucky

If I modelled correctly, the feed entry can have multible links, each have a own message. And the feed entry has his own message too

Lucky

So the message is either Feed or Link->Feed

Alexey

feed_entry = FeedEntry[1] # instance of Feed Entry select(m for m in Message if m.feed_entry == feed_entry and m.feed_entry.status == 'UNREAD')

Alexey

If I modelled correctly, the feed entry can have multible links, each have a own message. And the feed entry has his own message too

That's correct

Alexey

Oh, we need to check the other relationship in Message too, hold on

Lucky

This is what I came up with. Message is here called AMessage, otherwise is it the same?

Lucky

I assume FeedEntry[1] is the FeedEntry with ID 1?

Alexey

yes

Alexey

I am very new to pony and aren't so good with it. I want to retrieve all Messages of a FeedEntry with status "UNREAD"

feed_entry = FeedEntry[1] select(m for m in Message if (m.feed_entry == feed_entry and m.feed_entry.status == 'UNREAD') or (m.link.feed_entry == feed_entry and m.link.feed_entry.status == 'UNREAD'))

Alexey

here we check both relationships of the Message entity

Lucky

And together with doing that for each feed_entry it would look like this? for m in select( m for m in AMessage if ( m.feed_entry == feed_entry or m.link.feed_entry == feed_entry ) and feed_entry.status == 'UNREAD' for feed_entry in FeedEntry ): do_post(m)

Lucky

Alexey

if you want to use two 'for' this is going to be this way

Alexey

select(m for m in Message for feed_entry in FeedEntry if (m.feed_entry == feed_entry or m.link.feed_entry == feed_entry) and feed_entry.status == 'UNREAD')

Alexey

in the first case: select(m for m in Message if (m.feed_entry == feed_entry and m.feed_entry.status == 'UNREAD') or (m.link.feed_entry == feed_entry and m.link.feed_entry.status == 'UNREAD')) you iterate over the Message entity and check both relationships

Alexey

actually, I think you should use the first case scenario

Lucky

in the first case: select(m for m in Message if (m.feed_entry == feed_entry and m.feed_entry.status == 'UNREAD') or (m.link.feed_entry == feed_entry and m.link.feed_entry.status == 'UNREAD')) you iterate over the Message entity and check both relationships

But with this one I am only addressing a single FeedEntry (feed_entry = FeedEntry[1])?

Alexey

correct if you want to retriewe messages for all of them, you need to remove this condition

Lucky

Right, I want to get all of them.

Alexey

select(m for m in Message if m.feed_entry.status == 'UNREAD' or m.link.feed_entry.status == 'UNREAD')