Entity defination

What version of MySQL are you using?

It's AWS RDS with 5.7.26

Requirement is I have two Json object, I need to filter if just one key from the other json exists

I tried this

But This doesn't meet my condition, if atleast one key exists

So, if current_user.access_permission has several keys, you want to check that at least one key present?

So, if current_user.access_permission has several keys, you want to check that at least one key present?

Yes

This would fail with error JSON has not attribute keys

You need to construct query manually from strings, to use OR, something like: key_list = list(current_user.access_permissions.keys()) users = users.where(" or ".join("key_list[%d] in u.access_permissions" % i for i in range(key_list)))

Oh thanks this has helped a lot

Are migrations something that will come soon?

I hope so. We are working on it, it is hard to tell the exact dates

And then, how do I add a column to an already existing table which I don't want to recreate?

What database do you use?

What database do you use?

SQLite 3

For simple cases you can do alter table mytable add column newcolumn <type>

Note that optional string attributes in Pony are not nullable by default: alter table Person add column middle_name text not null default ''

And what if I already have an existing and unused column that I would like to edit?

At least its name

Hello, is there a similar community in Russian?

No, only in English

ok, thx

I am seeing peculiar issue I have entity as below Class User(db.Entity): Name = Required (str) Id = PrimaryKey (str) Creator = Optional("User", reverse="creator") Updator = Optinal("User", reverse="updstor")

I create data I see all

After some time self reference fields become null

Parobably you assign None to them somewhere in your code

Or, as another option, you delete "creator" or "updator" users

And in this case null will be assigned automatically

I am running code on AWS lambda and have created DB session for each request with optimistic = True

Parobably you assign None to them somewhere in your code

No

Or, as another option, you delete "creator" or "updator" users

No

I am suspect something with DB session and not sure if I have set at right place

If the Db session of previous request is alive and if I get another request I use same db session

Actually, this entity definition looks very strange.The relation creator <-> updator is one to one. The updator meaning looks unclear. If you create a third object and assign the same creator to it, the creator in previous object is set to null automatically, as the relations is 1:1 a = User(Name='A') b = User(Name='B', creator=a) c = User(Name='C', creator=a) # now b.creator is None

Maybe you want something like class User(db.Entity): name = Required (str) id = PrimaryKey (str) creator = Optional("User", reverse="users_created") users_created = Set("User", reverse="creator")

Now multiple users can have the same creator

Hello there guys, is there a way to specify custom name for many-to-many intermediate table?

Yes, class Student(db.Entity): courses = Set("Course", table="table1") class Course(db.Entity): students = Set("Student") It is enough to specify it on one side

Thanks!

Just tested, work like a charm

Pony is hidden gem, probably the best orm I worked so far :)

Thanks :)

Hi how can I store a telegram group id on a database? Int is not working

Whats group_id in telegram looks like?

Whats group_id in telegram looks like?

-1001417677178

try group_id = Required(int, size=64)

try group_id = Required(int, size=64)

It works, thank you :)

No problem, you're welcome

Hi

Is this available ?

Not yet

You can write raw update manually db.execute(""" update mytable set mycolumn = ... where ... """) but be careful, as objects already loaded in current db_session will not see the changes

db.raw_sql won't work?

It works for select, but not for update

Ok, thanks

why return json whit serialization

pony.orm.serialization was an experimental unofficial module, it is not supported

pony.orm.serialization was an experimental unofficial module, it is not supported

ok

create models from an existing db? like ef core db first ?

create models from an existing db? like ef core db first ?

You have to do that manually.

You have to do that manually.

yea i realize

If I itterate over the rows of db.execute, will orm.commit() # send data to database orm.rollback() # clear data from local cache influence that?

Probably you need flush instead of rollback

Hi

is this normal or maybe my fault?

Also parse_value

It is hard to say, it depends in your columns & data. Some types may require conversion between Python and MySQL

I have mutiple intengers type

small, tiny, big, and normal ints

Varchars and Varbinaries

Also dates

In the most accessed table

I think Pony validate methods should not do any complex conversions for these types

I have like 10 relations