package Ġcom . val hall ag ame . val h alla . inventory services erver . repository Ċ Ċ import Ġcom . val hall ag ame . val h alla . inventory services erver . model . Inventory Item Ċ import Ġorg . springframework . data . jpa . repository . Jpa Repository Ċ import Ġorg . springframework . data . jpa . repository . Modify ing Ċ import Ġorg . springframework . data . jpa . repository . Query Ċ import Ġorg . springframework . data . repository . query . Param Ċ import Ġjavax . transaction . Transactional Ċ Ċ interface ĠInventory Item Repository : ĠJ pa Repository < Inventory Item , ĠLong > Ġ{ ĊĠĠĠ Ġ@ Modify ing ĊĠĠĠ Ġ@ Transactional ĊĠĠĠ Ġfun Ġdelete Inventory Item By Character Name ( character Name : ĠString ): ĠInt ĊĊĠĠĠ Ġ@ Modify ing ĊĠĠĠ Ġ@ Transactional ĊĠĠĠ Ġ@ Query ( value Ġ= Ġ" DELETE ĠFROM Ġinventory _ item ĠWHERE Ġcharacter _ name Ġ= Ġ: character Name ĠAND Ġposition _ x Ġ= Ġ: position X ĠAND Ġposition _ y Ġ= Ġ: position Y ", Ġnative Query Ġ= Ġtrue ) ĊĠĠĠ Ġfun Ġdelete Inventory Item By Position (@ Param (" character Name ") Ġcharacter Name : ĠString , Ġ@ Param (" position X ") Ġposition X : ĠInt , Ġ@ Param (" position Y ") Ġposition Y : ĠInt ): ĠInt ĊĊĠĠĠ Ġfun Ġget Inventory Items By Character Name ( character Name : ĠString ): ĠList < Inventory Item > Ċ }