Enhancement request: How to get an object by primary key when it is a composite key about pony-doc HOT 3 CLOSED

Are you sure you've posted a correct example? The following works for me:

from pony.orm import *

db = Database()

class MyEntity(db.Entity):
    a = Required(str)
    b = Required(str)
    PrimaryKey(a, b)

db.bind(provider='sqlite', filename=':memory:')
db.generate_mapping(create_tables=True)

ent = MyEntity(a='Key1', b='Key2')
commit()

primary_key = ent.get_pk()

>>> MyEntity[primary_key]
MyEntity['Key1','Key2']

from pony-doc.

My fault, sorry.
The tuple returned from get_pk() was getting converted to str to be stored in another table, a simple 'eval' solved it.

from pony.orm import *

db = Database()

class MyEntity(db.Entity):
    a = Required(str)
    b = Required(str)
    PrimaryKey(a, b)

db.bind(provider='sqlite', filename=':memory:')
db.generate_mapping(create_tables=True)

with db_session():
    ent = MyEntity(a='Key1', b='Key2')
    primary_key = str(ent.get_pk())
    ent = MyEntity[eval(primary_key)]

>>> MyEntity[eval(primary_key)]
MyEntity['Key1', 'Key2']

from pony-doc.

First of all I think this issue relates to pony itself, not pony-doc repository.
About composite keys - it was bug in Pony that we've fixed here. And will be released soon in Pony 0.7.7

from pony-doc.