package Ġcom . ust ad mobile . retrie ver . db . dao Ċ Ċ import Ġandroidx . room . Dao Ċ import Ġandroidx . room . Insert Ċ import Ġandroidx . room . Query Ċ import Ġcom . ust ad mobile . door . Door LiveData Ċ import Ġcom . ust ad mobile . door . annotation . Sqlite Only Ċ import Ġcom . ust ad mobile . retrie ver . db . entities . Loc ally Stored File Ċ import Ġcom . ust ad mobile . retrie ver . db . entities . Loc ally Stored File And Download Job Item Ċ Ċ @ Dao Ċ abstract Ġclass ĠLoc ally Stored File Dao Ġ{ ĊĊĠĠĠ Ġ@ Insert ĊĠĠĠ Ġabstract Ġfun Ġinsert List ( stored Files : ĠList < Loc ally Stored File >) ĊĊĠĠĠ Ġ@ Insert ĊĠĠĠ Ġabstract Ġsuspend Ġfun Ġinsert List Async ( stored Files : ĠList < Loc ally Stored File >) ĊĊĠĠĠ Ġ@ Query (""" ĊĠĠĠĠĠĠĠ ĠSELECT Ġ* ĠFROM ĠLoc ally Stored File ĠĊĠĠĠĠĠĠĠĠ ĠWHERE Ġl sf Origin Url Ġ= Ġ: origin Url ĊĠĠĠ Ġ"" ") ĊĠĠĠ Ġabstract Ġfun Ġfind Stored File ( origin Url : ĠString ): ĠLoc ally Stored File ? ĊĊĠĠĠ Ġ@ Query (""" ĊĠĠĠĠĠĠĠ ĠSELECT ĠLoc ally Stored File .* ĊĠĠĠĠĠĠĠĠĠ ĠFROM ĠLoc ally Stored File ĊĠĠĠĠĠĠĠĠ ĠWHERE ĠLoc ally Stored File . ls f Origin Url ĠIN Ġ(: origin Urls ) ĠĠĊĠĠĠ Ġ"" ") ĊĠĠĠ Ġabstract Ġfun Ġfind Loc ally Stored Files By Url List ( origin Urls : ĠList < String >): ĠList < Loc ally Stored File > ĊĊĠĠĠ Ġ@ Query (""" ĊĠĠĠĠĠĠĠ ĠSELECT Ġ* ĠFROM ĠLoc ally Stored File ĊĠĠĠ Ġ"" ") ĊĠĠĠ Ġabstract Ġsuspend Ġfun ĠfindAll Loc ally Stored Files (): ĠList < Loc ally Stored File > ĊĊĠĠĠ Ġ@ Query (""" ĊĠĠĠĠĠĠĠ ĠDELETE ĠFROM ĠLoc ally Stored File ĠWHERE Ġlocally Stored File Uid Ġ= Ġ: uid ĊĠĠĠ Ġ"" ") ĊĠĠĠ Ġabstract Ġsuspend Ġfun Ġremove File ( uid : ĠInt ) ĊĊĊĠĠĠ Ġ@ Query (""" ĊĠĠĠĠĠĠĠ ĠSELECT ĠLoc ally Stored File .*, ĠDownload Job Item .* ĊĠĠĠĠĠĠĠĠĠ ĠFROM ĠDownload Job Item ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠ ĠLEFT ĠJOIN ĠLoc ally Stored File ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ ĠON ĠLoc ally Stored File . ls f Origin Url Ġ= ĠDownload Job Item . d ji Origin Url ĊĠĠĠ Ġ"" ") ĊĠĠĠ Ġ@ Sqlite Only ĊĠĠĠ Ġabstract Ġfun ĠfindAll Available Files Live (): ĠDoor LiveData < List < Loc ally Stored File And Download Job Item >> Ċ Ċ }