0

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',)
zeerock
  • 93
  • 6

0 Answers0