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

Partial Call Graph (max 5 caller/called nodes):
%3 test_apm_tarballs apm_tarballs (test acs-tcl) content::revision::get_cr_file_path content::revision::get_cr_file_path test_apm_tarballs->content::revision::get_cr_file_path test_fs_upload_a_notmpfile fs_upload_a_notmpfile (test file-storage) test_fs_upload_a_notmpfile->content::revision::get_cr_file_path test_oacs_dav_put oacs_dav_put (test oacs-dav) test_oacs_dav_put->content::revision::get_cr_file_path cr_fs_path cr_fs_path (private) content::revision::get_cr_file_path->cr_fs_path db_1row db_1row (public) content::revision::get_cr_file_path->db_1row acs_mail_lite::send_immediately acs_mail_lite::send_immediately (private) acs_mail_lite::send_immediately->content::revision::get_cr_file_path content::revision::export_to_filesystem-file content::revision::export_to_filesystem-file (private) content::revision::export_to_filesystem-file->content::revision::get_cr_file_path fs::file_copy fs::file_copy (public) fs::file_copy->content::revision::get_cr_file_path fs::get_object_info fs::get_object_info (public) fs::get_object_info->content::revision::get_cr_file_path fs__datasource fs__datasource (private) fs__datasource->content::revision::get_cr_file_path

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

[ hide source ] | [ make this the default ]
Show another procedure: