https://del.dog/ looks nice

That’s why del.dog has a preview. You don’t even need to press the link . (e.g https://del.dog/pelorriboc.py) Just look at the photo, you can press to big it..that’s pretty cool

An assert in Pony means that the error should not happen, it's like a comment "I'm sure that variable should have this state, or else it is definitely a bug". They are not errors that should be presented to a user

Hi, I have the following problem. I am filtering for an empty cell. Here is the code: class BlzEvent(db.Entity): _table_ = 'blz_events' id = PrimaryKey(int, auto=True) # 0 - hidden ... event_time = Required(datetime) # 4 ... action = Optional(str) # 21 - visible for administrators t_from: datetime = t_from t_to: datetime = t_to select_string: str = '(r.event_time >= $t_from) and (r.event_time <= $t_to) and r.action = '')' with db_session: result = select(r for r in BlzEvent if raw_sql(select_string)) result.fetch() message : wrap_dbapi_exceptions raise OperationalError(e) pony.orm.dbapiprovider.OperationalError: near ")": syntax error r.action is empty (not zero !! but '') this query works without an error message : '(r.event_time >= $t_from) and (r.event_time <= $t_to)' what am I doing wrong ? greeting with db_session: result = select(r for r in BlzEvent if raw_sql(select_string)) result.fetch()

date = Required(datetime, nullable=True) Seems like Required and nullable don't love each other

What table name is in error? Is it a table for some entity?

I think you mean obj.to_dict()

Guys, sorry for insisting, are you planning a new release for the async part soon? I need to know if I can start a new project on fastapi / pony and wait for a release the next month or just go with sql alchemy. Thank you very much for your assistance

I think it is a long road for async release. At this moment it is better to just go with sql alchemy

weird behavior, my after_update and before_update get called many times, without any change. [a stands for AFTER and b for BEFORE]

let's say i have Car.a_property can i do an hook / cause a_property to act like a descriptor? so i can define __get__ and every time i will access Car.a_property so __get__ will be called and will return a value?

Maybe you are assigning attribute values in after_update (which you should not do)

Pony attributes used in Python as well as in queries, and so Pony should be able to translate them to SQL. If you want to add some property with complex logic, it cannot be used in SQL. So you can add additional properties alongside with normal Pony attributes, but you should not completely replace attribute with property. You can do something like: class Person(db.Entity): first_name = Required(str) last_name = Required(str) @property def full_name(self): return self.first_name + ' ' + self.last_name @full_name.setter def full_name(self, value): self.first_name, self.last_name = value.split()

On another matter, if I want to validate some data before putting it into the database? Is class @property getters and setters and making the database columns private members of the db.Entity class (e.g. __member = orm.Required(...) ) the way to go, or is there some better way in Pony?

weird behavior, my after_update and before_update get called many times, without any change. [a stands for AFTER and b for BEFORE]

You can specify py_check function for attribute: def is_valid_email(s): return '@' in s class MyEntity(db.Entity): email = Required(str, py_check=is_valid_email)

You need to do db.generate_mapping() before performing selects

in my Entity, i have the following column where_to_post = Required(IntArray, default=?) by default i want it to contain a list of few ID's which will be taken from another Entity, i.e i have this entity as well: class Channel(database.Entity): id = PrimaryKey(int, min=-10000000000000, size=64) and i want where_to_post to contain a list of Channel.id, like default=list(Channel.select(lambda c: c.id)) is it even possible?

select((u.city, count()) for u in User).order_by(-2)