Released this August, unfortunately tightly coupled with SQLAlchemy but people are already wondering about making the backends swappable: https://github.com/tiangolo/sqlmodel/issues/61

hi, good morning, helpme, with its: AttributeError: 'Listaprecios' object has no attribute 'first', referer: https://www.einnovas.com/ventas/000309

pony.orm.core.UnrepeatableReadError: Phantom object Articulo['01000017'] disappeared, helpme please!

pony.orm.core.UnrepeatableReadError: Phantom object Articulo['01000017'] disappeared, helpme please!

Do you use multiple threads?

no

it is the code!

its error!

The error is caused by the line print(articulo.idproveedor) This line is not from the code that you show above Pony tries to load articulo.idproveedor from the database, but cannot find Articulo with this id

If the relationship is there, but I don't know why it doesn't recognize the provider

Yeah, accessing object by id probably not the greatest idea

You should use something like username of uuid instead and check if object exists

the error comes up, when I want to print the supplier code that is related in the database, article ---> supplier

pony.orm.core.UnrepeatableReadError: Phantom object Articulo['01000013'] disappeared

How Articulo class is defined? What is the type of primary key, int or str?

I suspect you have int column in the database, but specify str in Pony, so Pony expects to find an object with primary key "01000013", but the database returns an object with primary key 1000013 instead

This leading zero can be the reason of the error

is "str"

But how it is defined in the database? Can you check the column type in the database?

This is in Pony. But what do you have in the database? Which database do you use? PostgreSQL, MySQL?

Articulo

I mean codigo column in Articulo table

Proveedor

This is in Pony. But what do you have in the database? Which database do you use? PostgreSQL, MySQL?

mysql

after the get, it finds the product, but when I want to capture the supplier's code, there the error appears

Can you check the database, do you really have a row in Articulo table with this primary key: select idproveedor from articulo where idproveedor = '01000013'

if it is in the database, it is with all the products

You are doing some strange things here: existencia = Existencia.get(... codigo=a.codigo ...) ... commit() exis = Existencia[existencia.id] ... __codigo = exis.codigo.codigo if type(exis.codigo.codigo) != str: __codigo = str(exis.codigo.codigo) articulo = Articulo[__codigo]

exis.codigo should have type str, no? What is exis.codigo.codigo then? Why are you converting it to str?

si es str

I can't solve it, I got stuck

in the line red

Before this line, add the following: codigo = articulo.codigo cursor = db.execute("select codigo from articulo where codigo = $codigo") row = cursor.fetchone() print("articulo codigo:", codigo, row) And show me the print result

lo hago ahora, thaks

thanks

Hi all, I'm trying to use djongo module. But after trying to migrate I'm receiving: djongo.exceptions.SQLDecodeError: Keyword: None Sub SQL: None FAILED SQL: ('SELECT "openwisp_users_organizationuser"."created", "openwisp_users_organizationuser"."modified", "openwi sp_users_organizationuser"."is_admin", "openwisp_users_organizationuser"."id", "openwisp_users_organizationuser"."organization_ id", "openwisp_users_organizationuser"."user_id" FROM "openwisp_users_organizationuser" WHERE ("openwisp_users_organizationuser "."is_admin" AND "openwisp_users_organizationuser"."organization_id" = %(0)s) ORDER BY "openwisp_users_organizationuser"."creat ed" ASC LIMIT 1',) Params: ((UUID('ba052935-7bd6-4262-9860-593d33f1934c'),),) Version: 1.3.6 The above exception was the direct cause of the following exception:

Hi, this chat is about PonyORM. For Djongo, please ask in the corresponding group: https://groups.google.com/g/djongo.

Hi, this chat is about PonyORM. For Djongo, please ask in the corresponding group: https://groups.google.com/g/djongo.

10x

Pony not supported with python 3.10

Pony not supported with python 3.10

Not yet :)

Is that a big change from pony?

Yeah, as far as I know 3.10 has some breaking changes for api's which Pony uses

Oh okay

Santosh It's described here in more detail. https://github.com/ponyorm/pony/issues/598

@sashaaero and @metaprogrammer are working on it: https://github.com/ponyorm/pony/commit/8d8360cb4de78fc764c3515478896029c8734410

I'm getting this very weird error but couldnt capture the exact traceback. Any idea what it could be? It looks cursed.

Hi! What database do you use? SQLite?

Postgres

The error only seems to appear when running my function in a celery worker and only if the celery worker is using a gevent threadpool instead or processes

You can edit pony.orm.dbapiprovider file, and in DatetimeConverter class replace sql2py method to something like that: def sql2py(converter, val): import traceback stack = ''.join(traceback.format_stack()) if not isinstance(val, datetime): throw(ValueError, 'Value of unexpected type received from database: instead of datetime got %s: %s. Stack:\n%s' % (type(val), repr(val), stack)) return val It can reveal additional details about the error

hi everyone, I am new to ponyorm but i would like to do things right so I am here to ask to the experts. I have an entity like the following: class Portfolio (db.Entity): id = Required (int) last_date = Required (date) PrimaryKey (id, last_date) I would like to extract from a SQLight DB the wallet for a specific id and date, so I wrote the following query: id = 1 last_date = date (2021,11,10) result = select (p for p in Portfolio if p.id == id and p.data == last_date) Unfortunately, no records are returned to me even though I am sure that there is a portfolio in the db that responds to the query (entered by hand via SqlLightStudio) print (result.first (). id) also returns the error "AttributeError: 'NoneType' object has no attribute 'id'" thanks for the support

I think it's due to the use of a date field because il I comment out: and p.data == last_date it works well ..

> even though I am sure that there is a portfolio in the db that responds to the query (entered by hand via SqlLightStudio) Are you sure that the date entered manually is in correct format? Can you copy and paste an example of date value from the table that you expect to be found by the query?

sometimes a question is the better answer. I made some test and added a record with the orm .. It's selected !! It's the third row in the above image.

these three dates fom me (italian format) are the same ..

many many thanks

Yes, you need to use the last format

I enjoy using this orm, good job!

Thanks

hi guys!

Hey

would I be able to return postgres data in geometric format?

my data has this format...

As far as I know there is no data type for that in pony, but I guess you should be able to do that with string

here

I mean declare this field as string and do data processing inside python itself

is declared as unicode

I need to use this https://leafletjs.com/examples/geojson/

As far as I know there is no data type for that in pony, but I guess you should be able to do that with string

when I declare it as a string it returns this

Yeah, postgres stores geometry data as bytes blob (or something like that)

Maybe there is a way to implement support for that but I'm not sure how it can be done

=(

=(

Can you make queries with that data in postgres?

yes

Well, in that case Pony probably not the best option for you

when I declare it as a string it returns this

I didn't find anything to transform this into the format I need

I understood