album-export.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

<fullquery name="get_photo_info">      
      <querytext>
      select
 pp.caption,
 pp.story,
 cr.title as file_name,
 cr.description,
 i.height as height,
 i.width as width,
 i.image_id as image_id,
 cr.revision_id as live_revision,
 ci.parent_id as album_id
from cr_items ci,
  cr_revisions cr,
  pa_photos pp,
  cr_items ci2,
  cr_child_rels ccr2,
  images i
where cr.revision_id = pp.pa_photo_id
  and ci.live_revision = cr.revision_id
  and ci.item_id = ccr2.parent_id
  and ccr2.child_id = ci2.item_id
  and ccr2.relation_tag = 'base'
  and ci2.live_revision = i.image_id
  and ci.item_id = :photo_id

      </querytext>
</fullquery>

    <fullquery name="select_object_metadata">
        <querytext>
            select cr_items.item_id,
                   cr_items.storage_type,
                   cr_items.storage_area_key,
                   cr_revisions.title
            from  cr_items,
                 cr_revisions
            where cr_revisions.revision_id = :live_revision
            and cr_items.live_revision = cr_revisions.revision_id
        </querytext>
    </fullquery>
 
</queryset>