gustafn
committed
on 04 Jul 16
- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)
/tcl/oacs-dav-procs-oracle.xql (+13 -0)
277 277         begin
278 278               content_folder.del(
279 279                       folder_id => :dest_item_id,
280 280                       cascade_p => 't');
281 281         end;
282 282     </querytext>
283 283   </fullquery>
284 284  
285 285   <fullquery name="oacs_dav::impl::content_revision::copy.get_dest_id">
286 286     <querytext>
287 287         select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual
288 288     </querytext>
289 289   </fullquery>
290 290
291 291   <fullquery name="oacs_dav::impl::content_revision::move.get_dest_id">
292 292     <querytext>
293 293         select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual
294 294     </querytext>
295 295   </fullquery>
296 296
  297   <fullquery name="oacs_dav::children_have_permission_p.revision_perms">
  298     <querytext>
  299             select count(*)
  300             from cr_revisions
  301             where item_id = :item_id
  302             and  not  exists (select 1
  303                    from acs_object_party_privilege_map m
  304                    where m.object_id = revision_id
  305                      and m.party_id = :user_id
  306                      and m.privilege = 'delete')
  307     </querytext>
  308   </fullquery>
  309  
297 310 </queryset>