vaje: Še namig za agregcijo podatkov (unwind ...)
완료 조건
rez=mongoDB.naslov.aggregate([{<br><span style="white-space:pre"> </span>"$lookup" : {<br><span style="white-space:pre"> </span>"from" : "pacient",<br><span style="white-space:pre"> </span>"localField" : "naslovID",<br><span style="white-space:pre"> </span>"foreignField" : "naslovID",<br><span style="white-space:pre"> </span>"as" : "pacient"<br><span style="white-space:pre"> </span>}
rez=mongoDB.naslov.aggregate([{<br><span style="white-space:pre"> </span>"$lookup" : {<br><span style="white-space:pre"> </span>"from" : "pacient",<br><span style="white-space:pre"> </span>"localField" : "naslovID",<br><span style="white-space:pre"> </span>"foreignField" : "naslovID",<br><span style="white-space:pre"> </span>"as" : "pacient"<br><span style="white-space:pre"> </span>}
},{<br><span style="white-space:pre"> </span>"$unwind" : {<br><span style="white-space:pre"> </span>"path" : "$pacient"<br><span style="white-space:pre"> </span>}
},{<br><span style="white-space:pre"> </span>"$lookup" : {<br><span style="white-space:pre"> </span>"from" : "kraj",<br><span style="white-space:pre"> </span>"localField" : "posta",<br><span style="white-space:pre"> </span>"foreignField" : "posta",<br><span style="white-space:pre"> </span>"as" : "kraj"<br><span style="white-space:pre"> </span>}
},{<br><span style="white-space:pre"> </span>"$unwind" : {<br><span style="white-space:pre"> </span>"path" : "$kraj"<br><span style="white-space:pre"> </span>}
}
])
for doc in rez :
print(f"\
{doc['pacient']['ime']\t\<br><span style="white-space:pre"> </span>{doc['pacient']['priimek']\t\<br><span style="white-space:pre"> </span>{doc['ulica']\t\<br><span style="white-space:pre"> </span>{doc['hisnastevilka']\t\<br><span style="white-space:pre"> </span>{doc['kraj']['posta']\t\<br><span style="white-space:pre"> </span>{doc['kraj']['kraj']}"
)
자원을 열려면 vaje: Še namig za agregcijo podatkov (unwind ...) 링크를 클릭