_|irddlZddlmZddlmZmZmZddlmZm Z ddl m Z ddl m Z ddlmZedd g Ze e j"e e j$gZej)d ee ee fd efdZej)dee ee fdej,d efdZy)N)List) APIRouterDepends HTTPException)Session joinedload)get_db)GraftCombination)GraftCombinationResponsez /api/graftsgrafts)prefixtags)response_modeldbc|jtjtj tj j jS)N)queryr options _with_plantsorder_bycompatibility_scoredescall)rs G/var/www/acinvestment.org/public_html/aci/backend/app/routers/grafts.py list_graftsrsE !" , "66;;= >  z/compatible/{plant_id}plant_idcJ|jtjtj tj |k(tj |k(zjtjjj}|s tdd|S)zZReturn all graft combinations that involve the given plant (as either rootstock or scion).iz)No compatible grafts found for this plant) status_codedetail) rr rrfilter rootstock_idscion_idrrrrr)rrresultss rcompatible_graftsr%s !" ,   * *h 6((H4 6  "66;;= >   4_`` Nr)uuidtypingrfastapirrrsqlalchemy.ormrr app.databaser app.models.graft_combinationr app.schemas.graft_combinationr router rootstockscionrgetrUUIDr%rrr3s 55.9B -xj 9))*%%& Bt$<=>%foG? $T:R5ST9@ wUr