Figure out, how many directories in the CR are empty, report them optionally or delete them optionally.

Switches:

-max_results (optional, defaults to "5000")

stop after having found so many empty directories

-max_checks (optional, defaults to "10000")

stop after having checked so many directories

-returnlist (optional, boolean)

return the directories as part of the result

-prune (optional, boolean)

delete the found empty directories

Author:

Gustaf Neumann

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Figure out, how many files in the CR are not linked to the revisions in the content repository, and report them optionally.

Switches:

-max_results (optional, defaults to "5000")

stop after having found so many non-referenced files

-max_checks (optional, defaults to "10000")

stop after having checked so many non-referenced files

-returnlist (optional, boolean)

return the non-referenced files as part of the result

Author:

Gustaf Neumann

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-storage_type (required)

-storage_area_key (required)

-data (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

This function cleans-up files AFTER the DB-entry was deleted. If the transaction is aborted, the file will not be executed and the file will survive. Thus function should make cr_check_orphaned_files obsolete, which does not scale.

Switches:

-storage_area_key (required)

-data (required)

See Also:

• cr_check_orphaned_files

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-storage_area_key (required)

-data (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-storage_area_key (required)

-data (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

-storage_type (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

-revision_id_dest (optional)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

-copy_id (optional)

-target_item_id (optional)

-creation_user (optional)

-creation_ip (optional)

Returns:

NUMBER(38)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_revision

Switches:

-revision_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_revision

Export the content of the provided revision to the named file in the filesystem.

Switches:

-revision_id (required)

-storage_type (required)

-filename (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Export the content of the provided revision to the named file in the filesystem.

Switches:

-revision_id (required)

-filename (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Export the content of the provided revision to the named file in the filesystem.

Switches:

-revision_id (required)

-filename (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Export the content of the provided revision to the named file in the filesystem.

Switches:

-revision_id (required)

-filename (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

Returns:

NUMBER(38)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Determine some basic statistics about files in the CR based on a sample. This is useful for large installations with several million of files, where a detailed analysis would take very long.

Switches:

-max (optional, defaults to "10000")

number of revisions with storage-type "file" to check

Author:

Gustaf Neumann

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

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):

Testcases:

apm_tarballs, fs_upload_a_notmpfile, oacs_dav_put

Switches:

-revision_id (required)

Returns:

NUMBER

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Returns the title of a particular 'content_revision'.

Switches:

-revision_id (required)

The 'revision_id' of the object

Returns:

The title of the object (text), or empty if not found.

See Also:

• content::item::get_title
• content::revision::revision_name

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_revision, attachments_name_api

Switches:

-item_id (required)

-revision_id (required)

-doc_id (required)

Returns:

NUMBER(38)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

Returns:

t or f

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_item, content_revision

Switches:

-revision_id (required)

Returns:

t or f

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_item, content_revision

Gets the item_id of the item to which the revision belongs.

Switches:

-revision_id (required)

The revision id

Returns:

The item_id of the item to which this revision belongs

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_revision

Adds a new revision of a content item. If content_type is not passed in, we determine it from the content item. This is needed to find the attributes for the content type.

Switches:

-revision_id (optional)

-item_id (required)

-title (optional)

-description (optional)

-content (optional)

-mime_type (optional)

-publish_date (optional)

-nls_language (optional)

-creation_date (optional)

-content_type (optional)

-creation_user (optional)

-creation_ip (optional)

-package_id (optional)

Package_id content belongs to

-attributes (optional)

A list of lists of pairs of additional attributes and their values to pass to the constructor. Each pair is a list of two elements: key => value such as [list [list attribute value] [list attribute value]]

-is_live (optional, defaults to "f")

True is revision should be set live

-tmp_filename (optional)

file containing content to be added to revision. The caller is responsible for cleaning up the temporary file.

-storage_type (optional)

Returns:

Error:

Author:

Dave Bauer <dave@thedesignexperience.org>

Created:

2004-06-04

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_image, content_revision

Switches:

-item_id (required)

-revision_id (required)

-clob_loc (required)

Returns:

NUMBER

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

-search (required)

-replace (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

Returns:

VARCHAR2

Partial Call Graph (max 5 caller/called nodes):

Testcases:

content_revision

Switches:

-revision_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

DEPRECATED: the db api for this proc was deleted in 2005

See Also:

• https://github.com/openacs/openacs-core/commit/1cf48b17dd5faa0a2cbd988ab28d3127d3e25c61#diff-f580056c1afc98a3c8bda629878b7ea8

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Update content column separately. Oracle does not allow insert into a BLOB. This assumes that if storage type is lob and no file is specified that the content is really text and store it in the text column in PostgreSQL

Switches:

-item_id (required)

-revision_id (required)

Content revision to update

-content (required)

Content to add to resivsion

-storage_type (required)

text, file, or lob

-mime_type (required)

mime type of the content

-tmp_filename (optional)

For storage types except 'text' a filename can be specified instead of 'content'. The caller is responsible for cleaning up the temporary file

Author:

Dave Bauer <dave@thedesignexperience.org>

Created:

2005-02-09

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

-revision_id (required)

-content (required)

-mime_type (required)

-tmp_filename (optional)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

-revision_id (required)

-content (required)

-mime_type (required)

-tmp_filename (optional)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-item_id (required)

-revision_id (required)

-content (required)

-mime_type (required)

-tmp_filename (optional)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Switches:

-revision_id (required)

-clob_loc (required)

Returns:

NUMBER

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.