Thanks for the help =)

No problem :)

Do you know of an SQLite group?

Which is why I wanted to use a string io file. The problem being pony uses a filename, not a file object.

Yeah had a similar issue too, and tried to use the filename operator: See https://github.com/ponyorm/pony/issues/260

TIL There even is a PR for that

@luckydonald nice doggo btw

Is from @get_happiness Edit This one: https://t.me/get_happiness/586

Hello. I have a one to one relationship. Following the doc example : How do I create a default "Passeport" automaticaly each time I create a new "Person" ? Maybe in the init or Person or anything else ?

def before_insert(self): # make Passport object here

that method is for Person

damn !! that one should not have been asked. sorry and thanks

No problem :)

I have found some weird behaviour in Pony I think

If I have a list of objects:

mappings = [X[1], X[2], X[3]]

if I then do:

for x in mappings: print len(x.y)

(where y is a Set)

Pony will issue one big query at the start of the loop, with an in statement, for all mappings objects

so the first query is slow, then the others are very fast

is this intentional?

Nevermind, was working around a problem which turned out to be a missing index on a foreign key :)

@akozlovsky Is it possible to use GraphQL together with PonyORM or are their plans to support it?

Vitalii Abetkin wrote the initial version of Pony GraphQL API some time ago, you can find it here: https://github.com/abetkin/pony_graphql If I remember correctly, it does not fully provide GraphQL cursor API Currently there are no plans to officially support GraphQL with PonyORM

Vitalii Abetkin wrote the initial version of Pony GraphQL API some time ago, you can find it here: https://github.com/abetkin/pony_graphql If I remember correctly, it does not fully provide GraphQL cursor API Currently there are no plans to officially support GraphQL with PonyORM

Permanent link to the abetkin/pony_graphql project you mentioned. (?)

Thanks!

Hi there! ?

You are welcome!

Does pony support asyncio?

Not yet. Maybe later we will add support of it. But it is possible to work with database synchronously even when using asyncio. For simple queries, like, retrieve object by primary key, it will be even faster

Does pony support asyncio?

Can't you call normal functions with `await` from an async function?

I'm new to async, so I really don't know. Tried async yesterday for the first time

Not yet. Maybe later we will add support of it. But it is possible to work with database synchronously even when using asyncio. For simple queries, like, retrieve object by primary key, it will be even faster

Thanks

Can't you call normal functions with `await` from an async function?

Nope, you can’t await func ? rtm If you need to call non-aio func - just call it ?

i use pony with asyncio

i use pony with asyncio

I can use sync usage with async too ?

Hello, what's the usual way to deal with pictures, vidéo, pdf with pony ? Just a string with path to file ?

Yes, it is typically better to store them outside of database. Pony does not have specific "filename" datatype, so you can use str datatype instead

ok thanks

I upgraded to postgres 10, and no problems with pony

FYI

Thanks, cool

If I have a query like result = select(article for article in Article  for author in article.author  if self.user in author.followers) Makes it sense to simplify it to result = select(article for article in Article  if self.user in article.author.followers) Or is this not an optimization?

I think the latter is fine

use sql_debug and see what sql is generated

I think it should be about equivalent. Currently Pony translates in to SQL subquery with in. For MySQL it may be more efficient to use join instead of subquery with in. You can suggest Pony to use join by using the following syntax: result = select(article for article in Article for author in article.author if JOIN(self.user in author.followers)) or result = select(article for article in Article if JOIN(self.user in article.author.followers))

JOIN is just a hint which may be ignored by Pony for some complex queries

I use PostgresQL.

Then it is not necessary

And SQLite for testing.

Thanks. So I will use the simplified form.

I think the simplest form is result = Article.select(lambda a: self.user in a.author.followers)

It is the same query

I will try.

@akozlovsky The whole query looks like def query(self): result = select(article for article in Article if self.user in article.author.followers) result = result.sort_by(desc(Article.created_at)) if self.limit: result = result.limit(self.limit, offset=self.offset) return result[:]Is your proposal here possible?

absolutely def query(self): result = Article.select(lambda a: self.user in a.author.followers) result = result.sort_by(desc(Article.created_at)) if self.limit: result = result.limit(self.limit, offset=self.offset) return result[:]

Great! Tests are passing...

?

Hi, I have a TransactionIntegrityError on a flask view with Pony, when a record is created with a unique constraint, and the user submits two requests in parallel

Should I be setting SERIALIZABLE?

If there's a conflict, the record exists, so I want to return my success message

Could I catch an explicity commit() in a try / except block?