oacs-dav-procs.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN" "xql.dtd">
<!-- @author Dave Bauer (dave@thedesignexperience.org) -->
<!-- @creation-date 2003-09-14 -->
<!-- @cvs-id $Id: oacs-dav-procs.xql,v 1.1.1.1.20.2 2022/09/20 12:24:32 antoniop Exp $ -->
<queryset>

  <fullquery name="_oacs-dav__oacs_dav_put.item_exists">
    <querytext>
      select item_id from cr_items where name=:name
      and parent_id=:folder_id
    </querytext>
  </fullquery>

  <fullquery name="_oacs-dav__oacs_dav_put.revision_exists">
    <querytext>
      select revision_id from cr_revisions
      where item_id=:new_item_id
    </querytext>
  </fullquery>

  <fullquery name="_oacs-dav__oacs_dav_put.item_exists">
    <querytext>
      select item_id from cr_items where name=:name
      and parent_id=:folder_id
    </querytext>
  </fullquery>

  <fullquery name="_oacs-dav__oacs_dav_mkcol.get_parent_folder">
    <querytext>
      select folder_id from cr_folders where package_id=:package_id
    </querytext>
  </fullquery>
  
  <fullquery name="_oacs-dav__oacs_dav_mkcol.folder_exists">
    <querytext>
      select item_id
      from cr_items
      where name=:fname
      and content_type='content_folder'
    </querytext>
  </fullquery>

</queryset>