Methods:	Source:	Variables:
[All Methods \| Documented Methods \| Hide Methods]	[Display Source \| Hide Source]	[Show Variables \| Hide Variables]

::xo::db::Class ::xo::db::sql::category

Class Hierarchy of ::xo::db::sql::category
::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::category
Meta-class:

::xo::db::Class

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

change_parent, del, edit, name, new, new_translation, phase_in, phase_out
Class Relations

superclass: ::xotcl::Object

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

Methods

proc change_parent (public)

::xo::db::sql::category change_parent [ -dbn dbn ] \
    [ -category_id category_id ] [ -tree_id tree_id ] \
    [ -parent_id parent_id ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)
-tree_id (optional)
-parent_id (optional)

::xo::db::sql::category proc change_parent {{-dbn {}} -category_id -tree_id -parent_id} {
        #function_args: {CATEGORY_ID NULL} {TREE_ID NULL} {PARENT_ID NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID TREE_ID PARENT_ID]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.change_parent($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 del (public)

::xo::db::sql::category del [ -dbn dbn ] [ -category_id category_id ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)

::xo::db::sql::category proc del {{-dbn {}} -category_id} {
        #function_args: {CATEGORY_ID NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.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 (public)

::xo::db::sql::category edit [ -dbn dbn ] [ -category_id category_id ] \
    [ -locale locale ] [ -name name ] [ -description description ] \
    [ -modifying_date modifying_date ] \
    [ -modifying_user modifying_user ] [ -modifying_ip modifying_ip ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)
-locale (optional)
-name (optional)
-description (optional)
-modifying_date (optional)
-modifying_user (optional)
-modifying_ip (optional)

::xo::db::sql::category proc edit {{-dbn {}} -category_id -locale -name -description -modifying_date -modifying_user -modifying_ip} {
        #function_args: {CATEGORY_ID NULL} {LOCALE NULL} {NAME NULL} {DESCRIPTION NULL} {MODIFYING_DATE NULL} {MODIFYING_USER NULL} {MODIFYING_IP NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID LOCALE NAME DESCRIPTION MODIFYING_DATE MODIFYING_USER MODIFYING_IP]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.edit($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 name (public)

::xo::db::sql::category name [ -dbn dbn ] [ -category_id category_id ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)

::xo::db::sql::category proc name {{-dbn {}} -category_id} {
        #function_args: {CATEGORY_ID NULL}
        set sql_args [list]
        foreach var [list CATEGORY_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 := category.name($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 new (public)

::xo::db::sql::category new [ -dbn dbn ] [ -category_id category_id ] \
    [ -tree_id tree_id ] [ -locale locale ] [ -name name ] \
    [ -description description ] [ -parent_id parent_id ] \
    [ -deprecated_p deprecated_p ] [ -object_type object_type ] \
    [ -creation_date creation_date ] [ -creation_user creation_user ] \
    [ -creation_ip creation_ip ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)
-tree_id (optional)
-locale (optional)
-name (optional)
-description (optional)
-parent_id (optional)
-deprecated_p (optional)
-object_type (optional)
-creation_date (optional)
-creation_user (optional)
-creation_ip (optional)

::xo::db::sql::category proc new {{-dbn {}} -category_id -tree_id -locale -name -description -parent_id -deprecated_p -object_type -creation_date -creation_user -creation_ip} {
        #function_args: {CATEGORY_ID NULL} {TREE_ID NULL} {LOCALE NULL} {NAME NULL} {DESCRIPTION NULL} {PARENT_ID NULL} {DEPRECATED_P NULL} {OBJECT_TYPE NULL} {CREATION_DATE NULL} {CREATION_USER NULL} {CREATION_IP NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID TREE_ID LOCALE NAME DESCRIPTION PARENT_ID DEPRECATED_P OBJECT_TYPE CREATION_DATE CREATION_USER CREATION_IP]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN :1 := category.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 new_translation (public)

::xo::db::sql::category new_translation [ -dbn dbn ] \
    [ -category_id category_id ] [ -locale locale ] [ -name name ] \
    [ -description description ] [ -modifying_date modifying_date ] \
    [ -modifying_user modifying_user ] [ -modifying_ip modifying_ip ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)
-locale (optional)
-name (optional)
-description (optional)
-modifying_date (optional)
-modifying_user (optional)
-modifying_ip (optional)

::xo::db::sql::category proc new_translation {{-dbn {}} -category_id -locale -name -description -modifying_date -modifying_user -modifying_ip} {
        #function_args: {CATEGORY_ID NULL} {LOCALE NULL} {NAME NULL} {DESCRIPTION NULL} {MODIFYING_DATE NULL} {MODIFYING_USER NULL} {MODIFYING_IP NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID LOCALE NAME DESCRIPTION MODIFYING_DATE MODIFYING_USER MODIFYING_IP]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.new_translation($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 phase_in (public)

::xo::db::sql::category phase_in [ -dbn dbn ] \
    [ -category_id category_id ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)

::xo::db::sql::category proc phase_in {{-dbn {}} -category_id} {
        #function_args: {CATEGORY_ID NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.phase_in($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 phase_out (public)

::xo::db::sql::category phase_out [ -dbn dbn ] \
    [ -category_id category_id ]

Automatically generated method

Switches:

-dbn (optional)
-category_id (optional)

::xo::db::sql::category proc phase_out {{-dbn {}} -category_id} {
        #function_args: {CATEGORY_ID NULL}
        set sql_args [list]
        foreach var [list CATEGORY_ID]  {
          set varname [string tolower $var]
          if {[info exists $varname]} {
            lappend sql_args "$varname => :$varname"
          } 
        }
        set sql_args [join $sql_args ,]
        set sql "BEGIN category.phase_out($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 ]
        }
      }

Methods:	Source:	Variables:
[All Methods \| Documented Methods \| Hide Methods]	[Display Source \| Hide Source]	[Show Variables \| Hide Variables]