package Ġde . s amb alm ues lie . open event . server . messaging . db Ċ Ċ import Ġde . s amb alm ues lie . open event . server . messaging . api . Message Status Ċ import Ġio . mic ronaut . data . jdbc . annotation . Jdbc Repository Ċ import Ġio . mic ronaut . data . model . Page Ċ import Ġio . mic ronaut . data . model . Page able Ċ import Ġio . mic ronaut . data . model . query . builder . sql . Dialect Ċ import Ġio . mic ronaut . data . repository . Page able Repository Ċ Ċ @ Jdbc Repository ( dialect Ġ= ĠD ialect . POST GRES ) Ċ interface ĠMessage Repository Ġ: ĠPage able Repository < Message Data , ĠLong > Ġ{ Ċ ĉ fun ĠfindBy ItemId ( itemId : ĠLong , Ġpage able : ĠPage able ): ĠPage < Message Data > Ċ ĉ fun ĠfindBy Author Id ( author Id : ĠLong , Ġpage able : ĠPage able ): ĠPage < Message Data > Ċ ĉ fun ĠfindBy Recipient Id ( recipient Id : ĠLong , Ġpage able : ĠPage able ): ĠPage < Message Data > Ċ ĉ fun ĠfindBy Author Id Or Recipient Id ( author Id : ĠLong , Ġrecipient Id : ĠLong , Ġpage able : ĠPage able ): ĠPage < Message Data > ĊĊ ĉ fun Ġcount By Recipient Id And Status ( recipient Id : ĠLong , Ġstatus : ĠMessage Status ): ĠInt Ċ ĉ fun ĠfindBy Recipient Id And Status ( recipient Id : ĠLong , Ġstatus : ĠMessage Status , Ġpage able : ĠPage able ): ĠPage < Message Data > Ċ } Ċ