cr_set_imported_content_live (public)

 cr_set_imported_content_live [ -image_sql image_sql ] \
    [ -other_sql other_sql ] mime_type revision_id

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

Switches:

-image_sql

(optional)

Optional SQL to extend the base image type

-other_sql

(optional)

Optional SQL to extend the base content revision type

Parameters:

mime_type - Mime type of the new revision
revision_id - The revision we're setting live If provided execute the appropriate SQL in the caller's context, then set the given revision live. The idea is to give the caller a clean way of setting the additional information needed for its private type. This is a hack. Executing this SQL can't be done within cr_import_content because the caller can't see the new revision's key...

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

Testcases:

No testcase defined.

Source code:

    if { [cr_registered_type_for_mime_type $mime_type] eq "image" } {
        if { [info exists image_sql] } {
            uplevel 1 [list db_dml dynamic_query $image_sql]
        }
    } elseif { [info exists other_sql] } {
            uplevel 1 [list db_dml dynamic_query $other_sql]
    }
    db_exec_plsql set_live ""

XQL Not present:

Generic

PostgreSQL XQL file:

<fullquery name="cr_set_imported_content_live.set_live">
    <querytext>
          select content_item__set_live_revision(:revision_id)
      </querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="cr_set_imported_content_live.set_live">
    <querytext>
         begin content_item.set_live_revision (revision_id => :revision_id);
         end;
      </querytext>
</fullquery>

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