and i can't write None

Label(name = line['name'], path = line['html'], parametrs = None, parametrs_ex = None, description=None) ValueError: Attribute Label.parametrs is required

Because str values are automatically stripped by default, to avoid confusion when a user accidently add a space to the end of the value If you want to store spaces as well as empty string, you can declare the attribute as Optional(str, autostrip=False)

Thank you for your advices, but I'm fixing other people's code. It is very buggy incomprehensible program, just in case, I wrote down "Hull" everywhere

can you please create pony orm that support async dorectly

can you please create pony orm that support async dorectly

If we find time and resources to make Pony ORM 2.0, it will support async natively

i will grladly move all my project

because mostly i work an async framework as required in my work

Had to use dead snakes because a lack of 3.11 support. Looks like a real problem...

We will try to make a release during the following week.

Hi everyone, how to count table's elements by one attributes in Pony ORM ? Like I want to count male student in the school table in my db.

Hi everyone, how to count table's elements by one attributes in Pony ORM ? Like I want to count male student in the school table in my db.

You can use one of: Student.select(lambda s: s.gender == "Male").count() select(count(s) for s in Student if s.gender == "Male").fetch() select(count(s.gender == "Male") for s in Student).fetch()

You can use one of: Student.select(lambda s: s.gender == "Male").count() select(count(s) for s in Student if s.gender == "Male").fetch() select(count(s.gender == "Male") for s in Student).fetch()

Thank you 🙏🏿

https://github.com/pgvector/pgvector-python/blob/master/examples/pytorch_image_search.py hello, i am using type [vector] which extended by pgvecror, but i don't know how to use this vector type with pony, please help me, thanks~

https://github.com/pgvector/pgvector-python/blob/master/examples/pytorch_image_search.py hello, i am using type [vector] which extended by pgvecror, but i don't know how to use this vector type with pony, please help me, thanks~

Permanent link to the file examples/pytorch_image_search.py mentioned. (?)

https://github.com/pgvector/pgvector-python/blob/master/examples/pytorch_image_search.py hello, i am using type [vector] which extended by pgvecror, but i don't know how to use this vector type with pony, please help me, thanks~

Hi, I'm not sure it is possible to store vectors with pony right now. You can store them in a separate table and make queries to it using db.execute(SQL)

ok, thank you, this means i can not create table by class xxx(db.Entity) ... ？

ok, thank you, this means i can not create table by class xxx(db.Entity) ... ？

Yes, you need to do it manually

got

Hi folks, a quick question. I noticed that updating a boolean field only works one-way. From false to true works as expected (in Sqlite). Going the other way around doesn't update the field, while the ORM returns a success. I worked around it by switching to an int and enforcing a 0 or 1 from the application. Is this known behaviour?

Hi folks, a quick question. I noticed that updating a boolean field only works one-way. From false to true works as expected (in Sqlite). Going the other way around doesn't update the field, while the ORM returns a success. I worked around it by switching to an int and enforcing a 0 or 1 from the application. Is this known behaviour?

No, it is not a known behavior. Can you provide an example?

I don't have telegram for my desktop yet, so pasting code around is a bit cumbersome. I'll try to reproduce later today with concrete code.

I don't have telegram for my desktop yet, so pasting code around is a bit cumbersome. I'll try to reproduce later today with concrete code.

Thanks!

Thank you for this awesome ORM. I'm really enjoying it so far

hi

Error

for waths?

help me! please!

its my code

its my code

Which version of ponyorm are you using?

pony==0.7.16

pony==0.7.16

https://github.com/ponyorm/pony/issues/443

Not implemented yet

similar, for an solution?

Do one update query per item, in a loop

ok, thanks!

We will try to make a release during the following week.

No luck? Can't w8 anymore =(

hello, my postgresql table defined as follow: class AutoParts(db.Entity): '''auto parts''' code = Optional(str, default='') name = Optional(str, default='') brands = Optional(str, default='') ,and when i execute this query, report error: Column count does not belong to entity AutoParts AutoParts.select_by_sql("SELECT COUNT(*) FROM public.autoparts WHERE brands LIKE '%AAA%' and code like '%BBB%'") plz help

hi, good morning guys

how to capture the return of the id after inserting a record?

Hello! You need to do flush or commit to get it

Hello! You need to do flush or commit to get it

How do I do it, do you have an example?

https://docs.ponyorm.org/working_with_entity_instances.html?highlight=flush#saving-objects-in-the-database

https://docs.ponyorm.org/working_with_entity_instances.html?highlight=flush#saving-objects-in-the-database

thanks!

solved, thank you very much!

Hey! it is possible to get a user User.get(email="email@email) with the roles. But that only generates a "select with join"

oi

Hey! it is possible to get a user User.get(email="email@email) with the roles. But that only generates a "select with join"

Hi! Can you explain what do you mean?

What is the problem?

I'm logging in, I would like to recover the user with the roles.

are two separate entities in two tables

I managed to do it in 2 steps, 1- get user 2- get roles, this generates 2 select

I would like to get it with 1 select, using *join*

Hi everyone I got 2 questions and I need your help. 1- Does pony ORM have a Choices field ?? 2- Does pony's Entity class have any method to validate data before it saves them in db ?

there is something like py_check for validations

Hi everyone Just have a question How does pony handle db migrations? Does generate_mappings do it? Suppose I am adding 2 columns to a model will that get changed in the db by pony?

Right now pony does not handle migrations unfortunately. You need to use an external tool like FlywayDB or PonyUp and write alter table commands manually

Ok thanks for the info 👍

hello, sorry for my question but im looking for a way to get the old values of an element in the 'before_update' or after_update methods class ReceiptDetail(db.Entity): _table_ = 'receipt_detail' id = PrimaryKey(uuid.UUID, default=uuid.uuid4) receipt = Required(Receipt) accounting_account = Required( AccountingAccount, column='accounting_account') description = Required(str) amount = (Decimal, precision=14, scale=4) created_at = Optional(datetime) updated_at = Optional(datetime) def before_update(self): #verify if the new amount is greather or lower than the original to do the voucher update # if self.old_values.amount > self.amount: #verify do some stuffs any help is welcome, thanks

the def before_update(self): function its just an example of what im looking for

I think you would need to store the old values explicitly on the object before any updates

Does PonyORM have a GitHub Sponsors section? It could be a good way to help fund development and let people pay a bounty for certain pieces of work. For example: I'd be willing to pay some amount (let me know how much!) to get the Python 3.11 PR #671 completed and merged into a new release. https://github.com/sponsors

I am getting stuck trying to figure out an issue with reverse attributes. I have a "Milestone" class that describes a "start" and "end" period for a milestone. In the details it consists of two attributes "planned" and "actual", which are each of "DateSet" type. It looks like PonyORM doesn't like the reverse attribute for both "panned" and "actual" to be the same, but I don't know what else I would set them to. Any suggestions?

The above results in the exception: pony.orm.core.ERDiagramError: Inconsistent reverse attributes Milestone.actual and DateSet.milestone

Hi, I have this error, why should it be? valueError: invalid literal for int() with base 10: ''

you are trying to cast empty string to integer

How to know which field of the table it is?

the traceback of the error will tell you exact line of code

In this case I am making a query to a table, and it does not tell me which field it is

do you have any try except block around this query? if so, just remove it temporarily, it will show you the traceback

I already found the mistake, thanks!

struggling to find any reference for this issue: ImportError: cannot import name 'PGStrConverter' from 'pony.orm.dbproviders.postgres'

I get that on the bind method I have for cockroach.

db.bind(provider='cockroach', user=os.getenv('CRDB_USER'), password=os.getenv('CRDB_PASSWORD'), host=os.getenv('CRDB_HOST'), database=os.getenv('CRDB_DBHOST'), )

Good morning

How can I test my code, can someone explain it to me or give me an example?

I need to do my unit tests and I don't know how, helpme!

Hi I am using select_by_sql for a join. I am joining with 3 tables. But since we need to specify the entity when we call the function i am only getting attributes of the entity I specify. I want all my attributes. How to make this work