pa_get_root_folder_internal (private)

 pa_get_root_folder_internal package_id

Defined in packages/photo-album/tcl/photo-album-procs.tcl

Returns the folder_id of the root folder for an instance of the photo album system. If no root folder exists, as when a new package instance is accessed for the first time, a new root folder is created automatically with appropriate permissions

Parameters:

package_id (required)

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

Testcases:

No testcase defined.

Source code:

    set folder_id [db_string pa_root_folder "select photo_album.get_root_folder(:package_id) from dual"]

    if { $folder_id eq "" } {
    set folder_id [pa_new_root_folder $package_id]
    }
    return $folder_id

Generic XQL file:

packages/photo-album/tcl/photo-album-procs.xql

PostgreSQL XQL file:

<fullquery name="pa_get_root_folder_internal.pa_root_folder">
    <querytext>
      select photo_album__get_root_folder(:package_id) 
      </querytext>
</fullquery>

packages/photo-album/tcl/photo-album-procs-postgresql.xql

Oracle XQL file:

<fullquery name="pa_get_root_folder_internal.pa_root_folder">
    <querytext>
      select photo_album.get_root_folder(:package_id) from dual
      </querytext>
</fullquery>

packages/photo-album/tcl/photo-album-procs-oracle.xql