2 Commits

Author SHA1 Message Date
Rico Berger
74b11075cd Adjust Database Functions (#259)
- Set `search_path` for all database functions, as this is recommended
  by the Supabase security advisor
- Fix `items_delete` functions: The function was never working, which
  caused that we saved to many items for a source, which slowed down our
  performance
- Revoke execution rights for users for the `sources_delete_files` and
  `items_delete` functions
- Add E2E test, to check if users can call the database functions
2025-05-02 21:31:09 +02:00
Rico Berger
7d85dff1f7 Add E2E Test (#258) 2025-05-02 18:26:06 +02:00