ok, damn, I. thought I could find a library that does it, but I would have never thought that you wrote that manually. really good job, looks very slick 👍

Thank you so much!

What are you trying to do? @marcno6

I am building an ORM as well, but in Typescript only, and I absolute fall in love with your schema-editor 🙂

I am building an ORM as well, but in Typescript only, and I absolute fall in love with your schema-editor 🙂

Oh, that’s great! Can you send a link to your project?

Sure! I’m currently working on the site, so bear with me. https://beta.deepkit.io/products/orm. I also figured out how you did it using bézier curves and implemented it already, great idea 👍

@marcno6 I’m curios to know if your ORM would run server side on node.js ? Is there a possibility of it running client side (I get this is unlikely I just thought to ask) ?

It actually runs in the browser as well. The link I posted is a VSCode editor where you can play around with it.

Doesn’t that create a whole heap of issues e.g. network latency, requests/responses going awry, security woes ? Or is it all wrapped into an api ?

it uses SQLite in your browser, just for demonstration purposes

you’d use the ORM usually on the server of course 😛

Thanks, didn’t realize one had SQLite browser side. (Forgive my ignorance I don’t wander into the frontend too much).

you are right, you don’t have SQLite in the browser usually. It’s JS (wasm) version of SQLite, see https://github.com/sql-js/sql.js/

you are right, you don’t have SQLite in the browser usually. It’s JS (wasm) version of SQLite, see https://github.com/sql-js/sql.js/

Permanent link to the sql-js/sql.js project you mentioned. (?)

Ah, thanks.

Sure! I’m currently working on the site, so bear with me. https://beta.deepkit.io/products/orm. I also figured out how you did it using bézier curves and implemented it already, great idea 👍

Looking slick! Is there a git repo to this?

Looking slick! Is there a git repo to this?

thanks! Github repo link is on the website🙏

thanks! Github repo link is on the website🙏

Ah. Maybe the @deepkit/* things on the readme should be clickable?

It's all in the same repo under /packages, but good point😅

Oh, I figured they'd be separate repos with that naming.

But then I rarely use npm ^^'

Ah, found it: https://github.com/deepkit/deepkit-framework/tree/feature/orm-browser/packages/orm-browser-gui

Ah, found it: https://github.com/deepkit/deepkit-framework/tree/feature/orm-browser/packages/orm-browser-gui

Permanent link to the file orm-browser/packages/orm-browser-gui mentioned. (?)

Sure! I’m currently working on the site, so bear with me. https://beta.deepkit.io/products/orm. I also figured out how you did it using bézier curves and implemented it already, great idea 👍

great job, Marc!

great job, Marc!

Thanks Alexey!

ponyorm.org Website Certificate seems to be expired? I'm getting a warning today, Firefox 85

same

I have a model field level = Required(int, default=0, size=8, unsigned=True) in a SQLite DB. When I update it with -1 from 0 I would expect it to remain 0, because of the unsigned (min/max) setting.

However, it becomes -1. Any pointers to where my mistake is?

And for which version is "updating multiple objects (bulk update)" planned? (Ref. to https://docs.ponyorm.org/working_with_entity_instances.html#updating-an-object)

I guess, because you cannot close the Database connection while you are possibly still transmitting. https://docs.ponyorm.org/api_reference.html#Database.disconnect

Are you trying to build the @db_session decorator on your own? Or am I misunderstanding your code?

Bottom of this section: https://docs.ponyorm.org/api_reference.html#db_session

i wanna close the connection when i have execute the db

I suspect you have another @db_session which wraps your entire db_access function. You need to remove it

Excuse me, I can't find some information about that Is there any native support of postgres PostGis?

No, Pony does not have native support for PostGis, but probably you can use raw sql queries and raw sql fragments for that

That is really sad(

Thanks for the reply

As an experiment, you can add db.disconnect() before try:. If you will get the same exception on that line, then you somehow have outer db_session

As an experiment, you can add db.disconnect() before try:. If you will get the same exception on that line, then you somehow have outer db_session

ah you are right

However, it becomes -1. Any pointers to where my mistake is?

Thank you for reporting, it was a bug, I fixed it on GitHub

And for which version is "updating multiple objects (bulk update)" planned? (Ref. to https://docs.ponyorm.org/working_with_entity_instances.html#updating-an-object)

We don't have it implemented yet, can't name a specific version

Thank you for reporting, it was a bug, I fixed it on GitHub

Oh cool, thanks!

Hi ! is there a way to dynamically order_by?

Hi ! is there a way to dynamically order_by?

What do you mean by dynamically?

like im sending the order_by params in the url and then put it in the query. example: /api/products?order_by=price then Product.select().order_by(lambda p: p.price)

right now I added a nested if condition to handle the fields that I wanted to sort with

if sort: if sort == 'ratings': order_by = lambda p: desc(p.average_rating) if sort == 'price': order_by = lambda p: desc(p.price) if sort == 'shop': order_by = lambda p: desc(p.category.shop) products = Product.select(filters).order_by(order_by)[offset:10]

wondering if there was a cleaner approach

You can do select and order query next

query = Product.select(filters) if sort == 'ratings': query = query.order_by(desc(p.average_rating))

Something like that

Thanks!

It may be .order_by(lambda p: desc(p.average_rating)) or .order_by(desc(Product.average_rating))

I have a question, for an api I use fastapi / pydantic and pony. I am actually doing a prefetch of all related abjects before returning the response through pydantic models. Is there any other way to not prefetch objects before?

I think it is not necessary to use prefetch if you set up db_session as a middleware, as it will be available through the entire request

i did that as a middleware but the session was ending most of the time prematurely

I don't have a ready answer now, will think about it

thank you 🙂

Any way to order_by with desc using multiple fields ? i.e. I have a Product model that have a Stocks set and a Shop required FK. I'm trying to sort the Product and group each in the same shop while ordering them by Stock (highest to lowest)

query = Product.select(...) # or select(p for p in Product if ...) query1 = query.order_by(desc(Product.field1), desc(Product.field2)) # or, if you want to order by arbitrary expressions: query2 = query.order_by(lambda p: (desc(p.field1), desc(p.field2))) # or in multiple steps: query3 = query.order_by(lambda p: desc(p.field2)) query3 = query3.order_by(lambda p: desc(p.field1)) # note that we first order by field2 and then by field1

thanks!

hi there. how to load cookies in requests session? cookies saved as cookies.pkl with pickle. help me please

Hi. This group is about PonyORM object-relational mapper. It does not work with cookies. Probably is ts better to ask question in a group dedicated to a web framework that you use.

hi there. how to load cookies in requests session? cookies saved as cookies.pkl with pickle. help me please

That is out of scope for this group. Try to ask in @python.

That is out of scope for this group. Try to ask in @python.

sorry

Can someone point me to an explanation, why in models default=datetime.datetime.utcnow works but default=datetime.datetime.utcnow() doesn't? The latter seems to always return the date of DB creation.

default takes a callable or detetime, si if you add () it gives you the datetime of db creation

https://docs.ponyorm.org/api_reference.html#cmdoption-arg-default

I think I'm getting it: utcnow() is called when the db is first created, setting the static datetime as the default on the first read, whereas the "built-in method" utcnow returns the time of the read/compile?

I think I'm getting it: utcnow() is called when the db is first created, setting the static datetime as the default on the first read, whereas the "built-in method" utcnow returns the time of the read/compile?

Yes, if you supply any method it will be called whenever object is to be written to the database

I'm just confused why the method has no () at the end whereas the static value does. What's the logic behind that? I'd have expected it the other way round.

I'm just confused why the method has no () at the end whereas the static value does. What's the logic behind that? I'd have expected it the other way round.

def some_func(): print("I'm getting the current time") return datetime.now() default=some_func

If you were to now call that function directly you would get a result. So you would get the following: default=datetime(year=2020, day=...) Because that's the result of calling daytime.now

some other way to write the wrong case is this: now = datetime.now() class Table(...): date_column = Required(datetime, default=now)

If you instead provides a method it can later call, pony Will do so when storing values to the database. It will then call whatever you specified to default=..., basically default()

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