OK that was quite pieced together in multiple messages, I hope it helps anyway

Hi. Can I import my existing Pony models into the online editor (to get a nice visual overview of them)?

If you using pgadmin, they can do it on the latest docker image

Hi. Can I import my existing Pony models into the online editor (to get a nice visual overview of them)?

game is not a single object, but set of objects

There are several ways, it is hard to say which is better suitable for specific case 1) The simplest way is to add serializable=True option to db_session, but it may be not the most efficient way, as a transaction may need to wait until the previous transaction releases the locks 2) The most granular locks are possible with adding .for_update() to query or performing MyEntity.get_for_update(id=...) for getting an individual object. This will lock individual objects. But you need to understand which objects should be locked. If some transactions lock more than one objects, they need to do it in the same order. If one transaction lock object A then object B, while other transaction locks object B then object A it will lead to a deadlock. If both objects A and B have the same parent object, it may be better to lock that parent object instead. 3) For some objects and some attributes it may be not necessary to do strict optimistic checks. In that case it is possible to mark attribute with optimistic=False to exclude it from optimistic checks, or mark entire db_session with optimistic=False You can probably start with approach (1) and then use approach (2) if you need better performance

Probably .filter(lambda r: exists(relation for relation in r.relations if relation.source in self.user.sources))

the field 'codigo' is varchard type

@metaprogrammer how to query for no primary key for distinct and order by

Juste use coma like positional arg : https://docs.ponyorm.org/api_reference.html#Query.order_by

Hello, I am currently starting to use PonyORM and I struggle at some points. I use flask with the flask-login package for managing user sessions. My class User has a password field, which should be a hashed password. The problem is, I decalred the hash_function inside my user class, so when creating a User object the password field is empty at first, since it should be set later. This raises an error for an empty required value. class User(UserMixin, db.Entity): id = PrimaryKey(int, auto=True) vorname = Required(str) nachname = Required(str) email = Required(str) password_hash = Required(str) role = Required(str) def set_password_hash(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password)```And the user is created like this: ```with db_session: new_user = User( vorname=form.vorname.data, nachname=form.nachname.data, email=form.email.data, role=form.role.data, ) # this throws an error since the password field is empty, on the other hand I can not create the password as long as I did not create a User object new_user.set_password_hash(form.password.data) Is there a way to manage this?

Hello, another question. How does selecting entries with multiple conditions work? So I want to get an eqlivalent to the WHERE x AND y. I currently achieve this using filters afterwards, but I wanted to know wether there is a simpler approach.

Do you mean to have multiple references to the same foreign row?