the exception shows up in my console

but in discord is says it worked

Why doesn't the try except work

In Python, context managers inside generator functions cannot catch exceptions which were thrown into a genreator from the outside. If you use an async function, you need to use @db_session as a decorator: https://docs.ponyorm.com/transactions.html#using-db-session-with-generator-functions

In Python, context managers inside generator functions cannot catch exceptions which were thrown into a genreator from the outside. If you use an async function, you need to use @db_session as a decorator: https://docs.ponyorm.com/transactions.html#using-db-session-with-generator-functions

This document doesn't explains how to work with errors...

In Python, context managers inside generator functions cannot catch exceptions which were thrown into a genreator from the outside. If you use an async function, you need to use @db_session as a decorator: https://docs.ponyorm.com/transactions.html#using-db-session-with-generator-functions

Thanks!

Hi, guys. Is it possible to use desc for lambda expression inside order_by? Like "select((f1.name, f1.price) for f1 in Food).order_by(desc(lambda n, p: n))". Or "...desc(lambda: f1.name)...". The result is the same for both versions. And it differs from "select((f1.name, f1.price) for f1 in Food).order_by(desc(1))". Am I not getting something?

Hi! I recently found similar in the doc on site

Hi! I recently found similar in the doc on site

What I've found that it's valid to use desc inside lambda.

Hi @bassbeast, yes, it is vald to use desc inside lambda, but not the other way around. That is, instead of select((f1.name, f1.price) for f1 in Food).order_by(desc(lambda: f1.name)) you should write select((f1.name, f1.price) for f1 in Food).order_by(lambda: desc(f1.name))

This document doesn't explains how to work with errors...

Maybe we need to add something about exceptions, but if a programmer wrap an async function with @db_session decorator then from the programmer's point of view the handling of errors should look the same as usual, he just need to wrap some lines of code with try..except block. And if somebody tries to write async code using with db_session context manager instead of @db_session decorator, it just will not work, because in Python context managers cannot catch the event of generator suspending.

Hi @bassbeast, yes, it is vald to use desc inside lambda, but not the other way around. That is, instead of select((f1.name, f1.price) for f1 in Food).order_by(desc(lambda: f1.name)) you should write select((f1.name, f1.price) for f1 in Food).order_by(lambda: desc(f1.name))

Hi, Alexander. Thanks for the response and your work. Maybe it's worth to mention that fact somewhere in documentation.

Sure, we need to fix it

questiong!

can i have a function defined inside a class that extends from db.Entity?

(that uses the database)

It is possible to have a method defined inside an entity subclass, but right now it is not possible to use such functions in queries. We plan to fix it

it has any sense if..

i have a class that has an attribute with defaultvalue 0

but i want a class extending the first class

with that defaultvalue to be .... 5

?

i know databases can have asigned default values

i change my question

there is a way to overload __init__ so i can change one of the defaults values of one of the values with default with another value?

def __init__(self, data): *magic* super(Entity, self).__init__(attr1=x, attr2=y)

thanks :D

https://stateofprogress.blog/choose-sql-d017cfc08870#.tx8i11op2 An article on SQL vs NoSQL that references Pony

welp that was dumb of me. I figured it out. I had default=uuid.uuid4() in my entity definitions but couldn't figure out why it was not creating new UUIDs for each time I created a new object

it's been too long of a day :P

Hi i am looking for a ORM to work with sqlite just in readonly mode, i have an existing sqlite db so i want to query it... i see generate_mapping(), i want to know if this will pool and not create tables ?

Hi i am looking for a ORM to work with sqlite just in readonly mode, i have an existing sqlite db so i want to query it... i see generate_mapping(), i want to know if this will pool and not create tables ?

@akozlovsky create_tables defaults to False correct?

@micaiahparker but dont create tables w/ False?

welp that was dumb of me. I figured it out. I had default=uuid.uuid4() in my entity definitions but couldn't figure out why it was not creating new UUIDs for each time I created a new object

Use in it stsouko: def init(self, data): nu=uuid64() super(Entity, self).__init__(u=nu)

By default generate_mapping just check that all necessary tables present in the database and have all necessary columns (without checking column types, etc.) Pony does not support reflexion from the database yet, so you need to define entities as a Python classes. If you want to have entity/attribute name which differs from corresponding table/column name, you can set table/column name explicitly

Use in it stsouko: def init(self, data): nu=uuid64() super(Entity, self).__init__(u=nu)

In that specific case it is easier just to remove parentheses after uuid4

Is it possible to use callable? Good

https://stateofprogress.blog/choose-sql-d017cfc08870#.tx8i11op2 An article on SQL vs NoSQL that references Pony

Nice!

https://m.facebook.com/story.php?story_fbid=1431212776900553&id=100000355343616

Sorry for Russian. Hope Facebook will be able to translate it correctly

Sorry for Russian. Hope Facebook will be able to translate it correctly

Maybe but the last phrase is pretty meaningful.

Maybe but the last phrase is pretty meaningful.

This is a wordplay in Russian around "you understand" and "Pony".

This is hard to translate in any way

This is a wordplay in Russian around "you understand" and "Pony".

Yeah, I know. But the other guys... That's what I'm talking about. Nice post anyway.

i know enough russian to understand the wordplay, but almost nothing else in that post ?

Hmm it looks like the things were more complicated than that, I need to delete this

ok ) It was so long ago that nobody remember all the details already )

ok ) It was so long ago that nobody remember all the details already )

Except that "yet another bicycle ORM", I believe

Sure! :)

Hi guys, I just heard about Pony ORM a few minutes ago. Can anyone tell me how does it compare to SQLAlchemy? Thanks!

Hi guys, I just heard about Pony ORM a few minutes ago. Can anyone tell me how does it compare to SQLAlchemy? Thanks!

It is newer and more Pythonic

Thanks for the reply, can you elaborate on "More Pythonic" if you don't mind :)

Sure!

It takes better advantage of Python features like comprehensions, decorators, and with as part of its core API, whereas SQLalchemy is a straight forward C++ styled API, such as PyQt

(plus it has a really cool editor on the website)

Thanks again! I will check that editor

Np

(plus it has a really cool editor on the website)

But sadly no real import/export feature

I just copy/paste

How is the developement? is it active?

Quite

I see on github that kozlovsky is the only major contributor

I like the idea, I wish it gains more popularity for more active developement

@akozlovsky gets work done haha

@akozlovsky ?

So, I am still new to Python, is there a specific part that I should learn to make Pony easier for me? I know some basics on decorators, map, sum and some other functional programming concepts, but I feel like I need to learn more. Does Pony require a strong functional programming knowledge or will I be fine with just the basics of Python?

For me, understanding list comprehension was that biggest benefit for pony

Because queries become so much simpler

For me, understanding list comprehension was that biggest benefit for pony

Agreed

Yeah, list comprehensions are awesome!

Aye

Questiong!

if i have ... lets say class A(db.Entity) , Class B(A) and Class C(A), there would be a way to when loaded any of them as A, to know if it's really A B or C?

Look up the python docs for isinstance

Basically class A(db.Entity): thing = Required(str) class B(A): pass class C(A): pass >>> b = B(thing='thing') >>> isinstance(b, B) True >>> isinstance(b, C) False >>> isinstance(A(thing='thing'), C) False

Hey, I have a diagram made on the online editor, Now I have invoted someone else. How can he edit stuff? The "save a copy" button says it doesn't work for free users?

But he has no normal "save" button

So, what is the purpose off sharing diagrams with users?

He can't do anything

Or do I need to toggle edit rights for him somewhere?

For reference: https://editor.ponyorm.com/user/luckydonald/pbft

by the way, I know this is probably unimportant but the english text on pony's website is very.. foreign

is there a way to contribute? as in, suggest changes?

example: Here is Pony query example: vs Here is an example of a Pony query:

hey @luckydonald currently there is no way for someone else to edit the diagram, the person that you invite can see it in read-only mode we developed the editor for our internal needs and opened it to public in order to see if it will be useful for someone else when we found that it actually got traction, we decided to add some other features into it. The work is almost done, we have been adding the following features: - abiltiy to download a Pony project as a zip file, with models, settings, mixins files in it - teams - an ability for more than one person to work on a diagram - ability to assign tag names to diagram snapshots - Django tab - an ability to get Django project from a diagram - reflection - an abiltity to build a diagram based on a Pony or Django project

also we've replaced knockout.js with Mobx and ReactJS we tried to use Redux+ReactJS, and found that it is not easy then we moved to Mobx and never looked back

Huh.. Mobx doesn't look much easier than Redux

Oh, that's great, Do you need beta testers?

I think that we deploy the new interface in beta mode in April-May

Oh, that's great, Do you need beta testers?

yes!

Huh.. Mobx doesn't look much easier than Redux

but Mobx is much simpler than Redux in our case

yes!

My body is ready ?

is there a way to contribute? as in, suggest changes?

of course! that would be great, if you could contribute