etp-delete-oracle.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="revert_to_revision">
<querytext>
begin
  content_item.del(:revision_id)
end;
</querytext>
</fullquery>

<fullquery name="get_title">
<querytext>
  select title
    from cr_revisions r, cr_items i
   where i.parent_id = etp.get_folder_id(:package_id)
     and i.name = :name
     and r.item_id = i.item_id
     and r.revision_id = i.live_revision
</querytext>
</fullquery>

<fullquery name="get_item_id">
<querytext>
  select item_id
    from cr_items
   where parent_id = etp.get_folder_id(:package_id)
     and name = :name
</querytext>
</fullquery>

</queryset>