::xo::db::Class ::xo::db::sql::content_item

Class Hierarchy of ::xo::db::sql::content_item

• ::xotcl::Object

  Meta-class:

  ::xotcl::Class

  Methods for instances:

  __api_make_doc, __api_make_forward_doc, __next^C, __timediff, abstract, ad_doc, ad_forward, ad_proc, append^C, array^C, asHTML, autoname^C, check^C, class^C, cleanup^C, configure^C, contains, copy, db_1row^C, debug, defaultmethod, destroy^C, destroy_on_cleanup, eval^C, exists^C, extractConfigureArg, filter^C, filterguard^C, filtersearch^C, forward^C, hasclass, incr^C, info^C, init, instvar^C, invar^C, isclass^C, ismetaclass^C, ismixin^C, isobject^C, istype^C, lappend^C, log, method, mixin^C, mixinguard^C, move, msg, noinit^C, parametercmd^C, proc^C, procsearch^C, qn, requireNamespace^C, self, serialize, set^C, subst^C, trace^C, unset^C, uplevel^C, upvar^C, volatile^C, vwait^C

  Methods to be applied on the class (in addition to the methods provided by the meta-class):

  __exitHandler, getExitHandler, setExitHandler, unsetExitHandler

• ::xo::db::sql::content_item

  Meta-class:

  ::xo::db::Class

  Methods to be applied on the class (in addition to the methods provided by the meta-class):

  copy, copy2, del, edit_name, get_best_revision, get_content_type, get_context, get_id, get_latest_revision, get_live_revision, get_parent_folder, get_path, get_publish_date, get_revision_count, get_root_folder, get_template, get_title, get_virtual_path, is_index_page, is_publishable, is_published, is_subclass, is_valid_child, move, new, register_template, relate, set_live_revision, set_release_period, unregister_template, unrelate, unset_live_revision, write_to_file

Class Relations

• superclass: ::xotcl::Object

::xo::db::Class create ::xo::db::sql::content_item \
     -superclass ::xotcl::Object

Methods

• proc copy (public)

  ::xo::db::sql::content_item copy [ -dbn dbn ] [ -item_id item_id ] \
      [ -target_folder_id target_folder_id ] \
      [ -creation_user creation_user ] [ -creation_ip creation_ip ] \
      [ -name name ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -target_folder_id (optional)

  -creation_user (optional)

  -creation_ip (optional)

  -name (optional)

  ::xo::db::sql::content_item proc copy {{-dbn {}} -item_id -target_folder_id -creation_user -creation_ip -name} {
          #function_args: {ITEM_ID NULL} {TARGET_FOLDER_ID NULL} {CREATION_USER NULL} {CREATION_IP NULL} {NAME NULL}
          set sql_args [list]
          foreach var [list ITEM_ID TARGET_FOLDER_ID CREATION_USER CREATION_IP NAME]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.copy($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc copy2 (public)

  ::xo::db::sql::content_item copy2 [ -dbn dbn ] [ -item_id item_id ] \
      [ -target_folder_id target_folder_id ] \
      [ -creation_user creation_user ] [ -creation_ip creation_ip ] \
      [ -name name ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -target_folder_id (optional)

  -creation_user (optional)

  -creation_ip (optional)

  -name (optional)

  ::xo::db::sql::content_item proc copy2 {{-dbn {}} -item_id -target_folder_id -creation_user -creation_ip -name} {
          #function_args: {ITEM_ID NULL} {TARGET_FOLDER_ID NULL} {CREATION_USER NULL} {CREATION_IP NULL} {NAME NULL}
          set sql_args [list]
          foreach var [list ITEM_ID TARGET_FOLDER_ID CREATION_USER CREATION_IP NAME]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.copy2($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc del (public)

  ::xo::db::sql::content_item del [ -dbn dbn ] [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc del {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.del($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc edit_name (public)

  ::xo::db::sql::content_item edit_name [ -dbn dbn ] \
      [ -item_id item_id ] [ -name name ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -name (optional)

  ::xo::db::sql::content_item proc edit_name {{-dbn {}} -item_id -name} {
          #function_args: {ITEM_ID NULL} {NAME NULL}
          set sql_args [list]
          foreach var [list ITEM_ID NAME]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.edit_name($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc get_best_revision (public)

  ::xo::db::sql::content_item get_best_revision [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_best_revision {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_best_revision($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_content_type (public)

  ::xo::db::sql::content_item get_content_type [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_content_type {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_content_type($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_context (public)

  ::xo::db::sql::content_item get_context [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_context {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_context($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_id (public)

  ::xo::db::sql::content_item get_id [ -dbn dbn ] \
      [ -item_path item_path ] [ -root_folder_id root_folder_id ] \
      [ -resolve_index resolve_index ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_path (optional)

  -root_folder_id (optional)

  -resolve_index (optional)

  ::xo::db::sql::content_item proc get_id {{-dbn {}} -item_path -root_folder_id -resolve_index} {
          #function_args: {ITEM_PATH NULL} {ROOT_FOLDER_ID NULL} {RESOLVE_INDEX NULL}
          set sql_args [list]
          foreach var [list ITEM_PATH ROOT_FOLDER_ID RESOLVE_INDEX]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_id($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_latest_revision (public)

  ::xo::db::sql::content_item get_latest_revision [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_latest_revision {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_latest_revision($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_live_revision (public)

  ::xo::db::sql::content_item get_live_revision [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_live_revision {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_live_revision($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_parent_folder (public)

  ::xo::db::sql::content_item get_parent_folder [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_parent_folder {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_parent_folder($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_path (public)

  ::xo::db::sql::content_item get_path [ -dbn dbn ] [ -item_id item_id ] \
      [ -root_folder_id root_folder_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -root_folder_id (optional)

  ::xo::db::sql::content_item proc get_path {{-dbn {}} -item_id -root_folder_id} {
          #function_args: {ITEM_ID NULL} {ROOT_FOLDER_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID ROOT_FOLDER_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_path($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_publish_date (public)

  ::xo::db::sql::content_item get_publish_date [ -dbn dbn ] \
      [ -item_id item_id ] [ -is_live is_live ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -is_live (optional)

  ::xo::db::sql::content_item proc get_publish_date {{-dbn {}} -item_id -is_live} {
          #function_args: {ITEM_ID NULL} {IS_LIVE NULL}
          set sql_args [list]
          foreach var [list ITEM_ID IS_LIVE]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_publish_date($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_revision_count (public)

  ::xo::db::sql::content_item get_revision_count [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_revision_count {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_revision_count($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_root_folder (public)

  ::xo::db::sql::content_item get_root_folder [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc get_root_folder {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_root_folder($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_template (public)

  ::xo::db::sql::content_item get_template [ -dbn dbn ] \
      [ -item_id item_id ] [ -use_context use_context ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -use_context (optional)

  ::xo::db::sql::content_item proc get_template {{-dbn {}} -item_id -use_context} {
          #function_args: {ITEM_ID NULL} {USE_CONTEXT NULL}
          set sql_args [list]
          foreach var [list ITEM_ID USE_CONTEXT]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_template($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_title (public)

  ::xo::db::sql::content_item get_title [ -dbn dbn ] \
      [ -item_id item_id ] [ -is_live is_live ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -is_live (optional)

  ::xo::db::sql::content_item proc get_title {{-dbn {}} -item_id -is_live} {
          #function_args: {ITEM_ID NULL} {IS_LIVE NULL}
          set sql_args [list]
          foreach var [list ITEM_ID IS_LIVE]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_title($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc get_virtual_path (public)

  ::xo::db::sql::content_item get_virtual_path [ -dbn dbn ] \
      [ -item_id item_id ] [ -root_folder_id root_folder_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -root_folder_id (optional)

  ::xo::db::sql::content_item proc get_virtual_path {{-dbn {}} -item_id -root_folder_id} {
          #function_args: {ITEM_ID NULL} {ROOT_FOLDER_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID ROOT_FOLDER_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.get_virtual_path($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc is_index_page (public)

  ::xo::db::sql::content_item is_index_page [ -dbn dbn ] \
      [ -item_id item_id ] [ -folder_id folder_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -folder_id (optional)

  ::xo::db::sql::content_item proc is_index_page {{-dbn {}} -item_id -folder_id} {
          #function_args: {ITEM_ID NULL} {FOLDER_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID FOLDER_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.is_index_page($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc is_publishable (public)

  ::xo::db::sql::content_item is_publishable [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc is_publishable {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.is_publishable($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc is_published (public)

  ::xo::db::sql::content_item is_published [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc is_published {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.is_published($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc is_subclass (public)

  ::xo::db::sql::content_item is_subclass [ -dbn dbn ] \
      [ -object_type object_type ] [ -supertype supertype ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -object_type (optional)

  -supertype (optional)

  ::xo::db::sql::content_item proc is_subclass {{-dbn {}} -object_type -supertype} {
          #function_args: {OBJECT_TYPE NULL} {SUPERTYPE NULL}
          set sql_args [list]
          foreach var [list OBJECT_TYPE SUPERTYPE]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.is_subclass($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc is_valid_child (public)

  ::xo::db::sql::content_item is_valid_child [ -dbn dbn ] \
      [ -item_id item_id ] [ -content_type content_type ] \
      [ -relation_tag relation_tag ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -content_type (optional)

  -relation_tag (optional)

  ::xo::db::sql::content_item proc is_valid_child {{-dbn {}} -item_id -content_type -relation_tag} {
          #function_args: {ITEM_ID NULL} {CONTENT_TYPE NULL} {RELATION_TAG NULL}
          set sql_args [list]
          foreach var [list ITEM_ID CONTENT_TYPE RELATION_TAG]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.is_valid_child($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc move (public)

  ::xo::db::sql::content_item move [ -dbn dbn ] [ -item_id item_id ] \
      [ -target_folder_id target_folder_id ] [ -name name ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -target_folder_id (optional)

  -name (optional)

  ::xo::db::sql::content_item proc move {{-dbn {}} -item_id -target_folder_id -name} {
          #function_args: {ITEM_ID NULL} {TARGET_FOLDER_ID NULL} {NAME NULL}
          set sql_args [list]
          foreach var [list ITEM_ID TARGET_FOLDER_ID NAME]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.move($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc new (public)

  ::xo::db::sql::content_item new [ -dbn dbn ] [ -name name ] \
      [ -parent_id parent_id ] [ -item_id item_id ] [ -locale locale ] \
      [ -creation_date creation_date ] [ -creation_user creation_user ] \
      [ -context_id context_id ] [ -creation_ip creation_ip ] \
      [ -item_subtype item_subtype ] [ -content_type content_type ] \
      [ -title title ] [ -description description ] \
      [ -mime_type mime_type ] [ -nls_language nls_language ] \
      [ -text text ] [ -data data ] [ -relation_tag relation_tag ] \
      [ -is_live is_live ] [ -storage_type storage_type ] \
      [ -security_inherit_p security_inherit_p ] \
      [ -package_id package_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -name (optional)

  -parent_id (optional)

  -item_id (optional)

  -locale (optional)

  -creation_date (optional)

  -creation_user (optional)

  -context_id (optional)

  -creation_ip (optional)

  -item_subtype (optional)

  -content_type (optional)

  -title (optional)

  -description (optional)

  -mime_type (optional)

  -nls_language (optional)

  -text (optional)

  -data (optional)

  -relation_tag (optional)

  -is_live (optional)

  -storage_type (optional)

  -security_inherit_p (optional)

  -package_id (optional)

  ::xo::db::sql::content_item proc new {{-dbn {}} -name -parent_id -item_id -locale -creation_date -creation_user -context_id -creation_ip -item_subtype -content_type -title -description -mime_type -nls_language -text -data -relation_tag -is_live -storage_type -security_inherit_p -package_id} {
          #function_args: {NAME NULL} {PARENT_ID NULL} {ITEM_ID NULL} {LOCALE NULL} {CREATION_DATE NULL} {CREATION_USER NULL} {CONTEXT_ID NULL} {CREATION_IP NULL} {ITEM_SUBTYPE NULL} {CONTENT_TYPE NULL} {TITLE NULL} {DESCRIPTION NULL} {MIME_TYPE NULL} {NLS_LANGUAGE NULL} {TEXT NULL} {DATA NULL} {RELATION_TAG NULL} {IS_LIVE NULL} {STORAGE_TYPE NULL} {SECURITY_INHERIT_P NULL} {PACKAGE_ID NULL}
          set sql_args [list]
          foreach var [list NAME PARENT_ID ITEM_ID LOCALE CREATION_DATE CREATION_USER CONTEXT_ID CREATION_IP ITEM_SUBTYPE CONTENT_TYPE TITLE DESCRIPTION MIME_TYPE NLS_LANGUAGE TEXT DATA RELATION_TAG IS_LIVE STORAGE_TYPE SECURITY_INHERIT_P PACKAGE_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.new($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc register_template (public)

  ::xo::db::sql::content_item register_template [ -dbn dbn ] \
      [ -item_id item_id ] [ -template_id template_id ] \
      [ -use_context use_context ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -template_id (optional)

  -use_context (optional)

  ::xo::db::sql::content_item proc register_template {{-dbn {}} -item_id -template_id -use_context} {
          #function_args: {ITEM_ID NULL} {TEMPLATE_ID NULL} {USE_CONTEXT NULL}
          set sql_args [list]
          foreach var [list ITEM_ID TEMPLATE_ID USE_CONTEXT]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.register_template($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc relate (public)

  ::xo::db::sql::content_item relate [ -dbn dbn ] [ -item_id item_id ] \
      [ -object_id object_id ] [ -relation_tag relation_tag ] \
      [ -order_n order_n ] [ -relation_type relation_type ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -object_id (optional)

  -relation_tag (optional)

  -order_n (optional)

  -relation_type (optional)

  ::xo::db::sql::content_item proc relate {{-dbn {}} -item_id -object_id -relation_tag -order_n -relation_type} {
          #function_args: {ITEM_ID NULL} {OBJECT_ID NULL} {RELATION_TAG NULL} {ORDER_N NULL} {RELATION_TYPE NULL}
          set sql_args [list]
          foreach var [list ITEM_ID OBJECT_ID RELATION_TAG ORDER_N RELATION_TYPE]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN :1 := content_item.relate($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora exec_plsql_bind $db $sql 1 """
            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]
          }
        }

• proc set_live_revision (public)

  ::xo::db::sql::content_item set_live_revision [ -dbn dbn ] \
      [ -revision_id revision_id ] [ -publish_status publish_status ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -revision_id (optional)

  -publish_status (optional)

  ::xo::db::sql::content_item proc set_live_revision {{-dbn {}} -revision_id -publish_status} {
          #function_args: {REVISION_ID NULL} {PUBLISH_STATUS NULL}
          set sql_args [list]
          foreach var [list REVISION_ID PUBLISH_STATUS]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.set_live_revision($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc set_release_period (public)

  ::xo::db::sql::content_item set_release_period [ -dbn dbn ] \
      [ -item_id item_id ] [ -start_when start_when ] \
      [ -end_when end_when ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -start_when (optional)

  -end_when (optional)

  ::xo::db::sql::content_item proc set_release_period {{-dbn {}} -item_id -start_when -end_when} {
          #function_args: {ITEM_ID NULL} {START_WHEN NULL} {END_WHEN NULL}
          set sql_args [list]
          foreach var [list ITEM_ID START_WHEN END_WHEN]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.set_release_period($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc unregister_template (public)

  ::xo::db::sql::content_item unregister_template [ -dbn dbn ] \
      [ -item_id item_id ] [ -template_id template_id ] \
      [ -use_context use_context ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -template_id (optional)

  -use_context (optional)

  ::xo::db::sql::content_item proc unregister_template {{-dbn {}} -item_id -template_id -use_context} {
          #function_args: {ITEM_ID NULL} {TEMPLATE_ID NULL} {USE_CONTEXT NULL}
          set sql_args [list]
          foreach var [list ITEM_ID TEMPLATE_ID USE_CONTEXT]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.unregister_template($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc unrelate (public)

  ::xo::db::sql::content_item unrelate [ -dbn dbn ] [ -rel_id rel_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -rel_id (optional)

  ::xo::db::sql::content_item proc unrelate {{-dbn {}} -rel_id} {
          #function_args: {REL_ID NULL}
          set sql_args [list]
          foreach var [list REL_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.unrelate($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc unset_live_revision (public)

  ::xo::db::sql::content_item unset_live_revision [ -dbn dbn ] \
      [ -item_id item_id ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  ::xo::db::sql::content_item proc unset_live_revision {{-dbn {}} -item_id} {
          #function_args: {ITEM_ID NULL}
          set sql_args [list]
          foreach var [list ITEM_ID]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.unset_live_revision($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }

• proc write_to_file (public)

  ::xo::db::sql::content_item write_to_file [ -dbn dbn ] \
      [ -item_id item_id ] [ -root_path root_path ]

  Automatically generated method

  Switches:

  -dbn (optional)

  -item_id (optional)

  -root_path (optional)

  ::xo::db::sql::content_item proc write_to_file {{-dbn {}} -item_id -root_path} {
          #function_args: {ITEM_ID NULL} {ROOT_PATH NULL}
          set sql_args [list]
          foreach var [list ITEM_ID ROOT_PATH]  {
            set varname [string tolower $var]
            if {[info exists $varname]} {
              lappend sql_args "$varname => :$varname"
            } 
          }
          set sql_args [join $sql_args ,]
          set sql "BEGIN content_item.write_to_file($sql_args); END;"
          db_with_handle -dbn $dbn db {
            #my log "sql=$sql, sql_command=ns_ora dml $db $sql"
            return [ ns_ora dml $db $sql ]
          }
        }