**TODO**

* `file_path_to_id_map` query returns currently none sanitized paths as keys

* Begin of the insertionusages

* nextcloudEnd of the insertion Begin of the deletion those are used in theEnd of the deletion sync Begin of the insertionservice

End of the insertion Begin of the deletion services, also for comparison

End of the deletion * Begin of the insertionone drive sync service (less then nextcloud)

* file\_path\_to\_id\_map query

* copy\_template\_folder command (nextcloud)

* copy project folder service

* a fair bit of nextcloud queries still working on paths (not harmonized with ##57710)

* End of the insertion This can easily break, if a `/` is forgotten or else

* Create a dedicated class for working with paths which is responsible for comparison and encapsulates all the details.

* Repurpose existing data model `ParentFolder` Begin of the insertion[https://github.com/opf/openproject/blob/011f74ebe40421f9c234b4bb130099481c442ecd/modules/storages/app/common/storages/peripherals/storage\_parent\_folder\_extractor.rb#L33](https://github.com/opf/openproject/blob/011f74ebe40421f9c234b4bb130099481c442ecd/modules/storages/app/common/storages/peripherals/storage_parent_folder_extractor.rb#L33)

End of the insertion Begin of the deletion https://github.com/opf/openproject/blob/011f74ebe40421f9c234b4bb130099481c442ecd/modules/storages/app/common/storages/peripherals/storage\_parent\_folder\_extractor.rb#L33


**NEXT STEPS**

End of the deletion * Begin of the deletion Identify allEnd of the deletion the Begin of the insertionclass should contain non-sanitized path fragments, so that a stable handling ofEnd of the insertion Begin of the deletion places whereEnd of the deletion comparison Begin of the insertionand ecscaping for URL usage is granted (it is also about predictionEnd of the insertion of Begin of the insertionbehaviour)

* internally the class will use `UrlBuilder` to escape

* the class should have a static parsing method to put in any string (raises exceptions if string contains escaped characters)End of the insertion Begin of the deletion urls/path happensEnd of the deletion