package Ġcom . int workers . application . repository . school system Ċ Ċ import Ġcom . int workers . application . model . user . Social Worker Ċ import Ġcom . int workers . application . model . user . User Ċ import Ġorg . springframework . data . jpa . repository . Modify ing Ċ import Ġorg . springframework . data . jpa . repository . Query Ċ import Ġorg . springframework . data . repository . Paging And Sorting Repository Ċ Ċ interface ĠSocial Worker Repository : ĠP aging And Sorting Repository < Social Worker , ĠLong > Ġ{ ĊĠĠĠ Ġ@ Modify ing ĊĠĠĠ Ġ@ Query (" INSERT ĠINTO Ġworker _ sch ools Ġ( worker _ id , Ġschool _ id ) ĠVALUES Ġ(: worker Id , Ġ: school Id )", Ġnative Query Ġ= Ġtrue ) ĊĠĠĠ Ġfun Ġassign Worker To School ( worker Id : ĠLong , Ġschool Id : ĠLong ) ĊĊĠĠĠ Ġ@ Modify ing ĊĠĠĠ Ġ@ Query (" DELETE ĠFROM Ġworker _ sch ools ĠWHERE Ġworker _ id Ġ= Ġ: worker Id ĠAND Ġschool _ id Ġ= Ġ: school Id ", Ġnative Query Ġ= Ġtrue ) ĊĠĠĠ Ġfun Ġremove Worker From School ( worker Id : ĠLong , Ġschool Id : ĠLong ) Ċ }