etp-revert-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="delete_revision">
<querytext>

select content_revision__delete(:revision_id)

</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>
 
<fullquery name="get_revision_count">
<querytext>
    select count(1) as revision_count
    from cr_revisions r, cr_items i
    where r.item_id = i.item_id
    and i.parent_id = etp__get_folder_id(:package_id)
    and i.name = :name
    and r.revision_id > :revision_id
</querytext>
</fullquery>

</queryset>