I've written a code whereby as a standalone, it works. However, when I put a function on top of it, it returns empty
Standalone:
r = session.query(Acquaintance).filter_by(frompax='PERSON_04')
list(r)
It will return a list of all PERSON_04 is related to:
[PERSON_04 PERSON_23,
PERSON_04 PERSON_98,
PERSON_04 PERSON_66,
PERSON_04 PERSON_08]
As a Funtion:
def relation(personID):
r = session.query(Acquaintance).filter_by(frompax=personID)
list(r)
This returns the following result:
2022-03-10 20:15:52,999 INFO sqlalchemy.engine.Engine SELECT acquaintance."ID" AS "acquaintance_ID", acquaintance.frompax AS acquaintance_frompax, acquaintance.topax AS acquaintance_topax
FROM acquaintance
WHERE acquaintance.frompax = ?
2022-03-10 20:15:52,999 INFO sqlalchemy.engine.Engine [cached since 1328s ago] ('personID',)