content::revision::get_cr_file_path (public)

 content::revision::get_cr_file_path [ -revision_id revision_id ]

Defined in packages/acs-content-repository/tcl/content-revision-procs.tcl

Get the path to content in the filesystem

Switches:

-revision_id (optional)

Returns:

path to filesystem stored revision content

Author:

Dave Bauer <dave@solutiongrove.com>

Created:

2006-08-27

Testcases:

apm_tarballs, fs_upload_a_notmpfile, oacs_dav_put

Source code:

    # the file path is stored in filename column on oracle
    # and content in PostgreSQL, but we alias to filename so it makes
    # sense
    db_1row get_storage_key_and_path {}
    return [cr_fs_path $storage_area_key]${filename}

Generic XQL file:

packages/acs-content-repository/tcl/content-revision-procs.xql

PostgreSQL XQL file:

<fullquery name="content::revision::get_cr_file_path.get_storage_key_and_path">
    <querytext>	
      select storage_area_key, 
        content as filename
      from cr_items ci, 
        cr_revisions cr 
      where cr.item_id=ci.item_id 
        and cr.revision_id=:revision_id
    </querytext>
</fullquery>

packages/acs-content-repository/tcl/content-revision-procs-postgresql.xql

Oracle XQL file:

<fullquery name="content::revision::get_cr_file_path.get_storage_key_and_path">
    <querytext>	
      select storage_area_key, 
          filename
      from cr_items ci, cr_revisions cr 
      where cr.item_id=ci.item_id 
          and cr.revision_id=:revision_id
    </querytext>
</fullquery>

packages/acs-content-repository/tcl/content-revision-procs-oracle.xql