Thank You

Sure

Merry xmas.

Im trying Pony and was wondering if there's a way to convert entities to some pod like NamedTuple so I can get the data out of a db_session

if there's no such a thing maybe I can build something with _columns_ would that make sense?

another thing is that I tried to make an additional index and seems that this is not supported, I only saw compound index or index through unique

Hi! If you want to specify non-unique index, you can add index=True or index="index_name" to attribute options You can extract attribute values using to_dict() method: https://docs.ponyorm.com/api_reference.html?highlight=to_dict#Entity.to_dict

I will try, thanks

Merry Xmas

Merry Xmas!

Hola

Buenas tardes

Hi

tienen tutoriales en Youtube?

No, just documentation

https://docs.ponyorm.com/

tienen tutoriales en Youtube?

mind to speak in english here from now on (please)

https://docs.ponyorm.com/

Good!

Polls

Happy new year everyone!

Happy new year everyone!

🎉🎄👍😀

Happy New Year! 🎉🎉🎉

Happy New Years !!! May you all get a pony !!!

Pony new year 🎉🎉🎉

feliz navidad a todos

Merry christmas and 🥳

Feliz año nuevo

feliz navidad a todos

De dónde eres?

De dónde eres?

de Cuba

Saludos

Happy New year!!!

happy new year from havana cuba

Frohes Neues! 🎆

Hi! there is any url explaining how migrations work?

https://github.com/ponyorm/pony/blob/orm-migrations/pony/migrate/README.md

https://github.com/ponyorm/pony/blob/orm-migrations/pony/migrate/README.md

Permanent link to the file pony/migrate/README.md mentioned. (?)

aa

thanks

i forgot it was on a branch

https://github.com/ponyorm/pony/blob/orm-migrations/pony/migrate/README.md

Will it support rolling back versions with a backwards function?

It would be nice, but I think it will be added later

Did anyone work with Flask-Admin with Pony. Was there some problems?

Did anyone work with Flask-Admin with Pony. Was there some problems?

?

Someone said he was unable to work with Pony and Flask-Admin together. He didn't bring any details, so I ask if anyone used it.

how to use pony orm whit mongodb

PonyORM only supports relational databases at this moment: PostgreSQL, SQLite, MySQL, Oracle

PonyORM only supports relational databases at this moment: PostgreSQL, SQLite, MySQL, Oracle

thank for answer

uff, when use pymongo module?

sorry by my inglesh

You can use PyMongo to connect to MongoDB from Python, but this is not related to PonyORM. This chat is about PonyORM, not about PyMongo

yes, i question if pony orm suport mongodb

I thought that ORM is about relational database, when mongo isn't one.

I heard that you can do it with some mysql->mongo proxy, but this is not a good idea)

I thought that ORM is about relational database, when mongo isn't one.

ok thank

Ah, ok. I hope PonyORM will support MongoDB eventually, but not in the nearest year or two In principle it is possible to implement such support, because PonyORM itself uses Entity-Relationship model which can be mapped to both relational model and hierarchical model (used in NoSQL databases such as MongoDB). But it requres big internal changes

👍

Ah, ok. I hope PonyORM will support MongoDB eventually, but not in the nearest year or two In principle it is possible to implement such support, because PonyORM itself uses Entity-Relationship model which can be mapped to both relational model and hierarchical model (used in NoSQL databases such as MongoDB). But it requres big internal changes

Sounds like one of those "have nothing else to do" features

We were never at this point

Hey! How can I set default per page value to be used with .page(1) method?

https://docs.ponyorm.com/api_reference.html#Query.page

.page(1, pagesize=20)

@matthewrobertbell sorry, looked twice but didn't see. Thanks!

Doesn't Pony set ON DELETE/UPDATE CASCADE when it adds foreign keys?

No

Probably it should

@metaprogrammer aha! Thanks! I thought I have missed something again

But when Pony deletes object with all its dependent objects, it loads them all in memory in be sure that IdentityMap cache is in valid state and all before_delete / after_delete hooks are processed for all dependent objects

So, as Pony loads all objects into memory before deletion, ON CASCADE option is not useful for Pony. But it may be useful for raw sql delete queries

Maybe useful for delete(bulk=True) ?

But when Pony deletes object with all its dependent objects, it loads them all in memory in be sure that IdentityMap cache is in valid state and all before_delete / after_delete hooks are processed for all dependent objects

Yep, it works that way, but sometimes you have to make some updates directly and I was wondering why I couldn't just delete a row that is referenced from another table

i.e. via psql

Maybe useful for delete(bulk=True) ?

Yes, I think we should specify CASCADE option #todo But after that it will be possible to have object in db_session cache which is already deleted from the database due to cascade deletion from its parent object

Ya, not so easy. Why I'd like to have this enabled by default is because I have create_tables enabled while actively developing and when making many deployments I want to be fully abstract from details

hi. is MyEntity.select()[:] equivalent to MyEntity.select()[None:None] ?

yes

hello everyone, just a noob question... does ponyorm supports MSSQL, and if yes can someone point me to doc/same usage of it...

Hi! At this moment PonyORM does not support MS SQL yet

ohh okkay, thanks for replying quickly, appreciate that @metaprogrammer

Hi! Is there a way to define 'shortcuts' in Pony objects, so it is possible to get the value of the related entity's key directly, like this? class Parend(db.Enitty): val = orm.Optional ('Child' , reverse='par') shortcut = orm.Shortcut('Child', 'pk') class Child(db.Entity): pk = orm.PrimaryKey(str) par = orm.Set('Parent') c1 = Child(pk='bla') p1 = Parent(val=c1) >>> print p1.val >>>Child[u'bla'] >>>print p1.shortcut >>> bla Thanks!