::xo::db::Class
::xo::db::sql::alf_dotlrn_faculty
Class Hierarchy of ::xo::db::sql::alf_dotlrn_faculty
- ::xotcl::Object
- Meta-class:
- ::xotcl::Class
![[i]](/resources/acs-subsite/ZoomIn16.gif)
- Methods for instances:
- __api_make_doc, __api_make_forward_doc, __nextC, __timediff, abstract, ad_doc, ad_forward, ad_proc, appendC, arrayC, asHTML, autonameC, checkC, classC, cleanupC, configureC, contains, copy, db_1rowC, debug, defaultmethod, destroyC, destroy_on_cleanup, evalC, existsC, extractConfigureArg, filterC, filterguardC, filtersearchC, forwardC, hasclass, incrC, infoC, init, instvarC, invarC, isclassC, ismetaclassC, ismixinC, isobjectC, istypeC, lappendC, log, method, mixinC, mixinguardC, move, msg, noinitC, parametercmdC, procC, procsearchC, qn, requireNamespaceC, self, serialize, setC, substC, traceC, unsetC, uplevelC, upvarC, volatileC, vwaitC
- Methods to be applied on the class (in addition to the methods provided by the meta-class):
- __exitHandler, getExitHandler, setExitHandler, unsetExitHandler
- ::xo::db::sql::alf_dotlrn_faculty
- Meta-class:
- ::xo::db::Class
![[i]](/resources/acs-subsite/ZoomIn16.gif)
- Methods to be applied on the class (in addition to the methods provided by the meta-class):
- del, new
Class Relations
- superclass: ::xotcl::Object
![[i]](/resources/acs-subsite/ZoomIn16.gif)
::xo::db::Class create ::xo::db::sql::alf_dotlrn_faculty \
-superclass ::xotcl::Object
Methods
::xo::db::sql::alf_dotlrn_faculty
del [ -dbn dbn ] \
[ -faculty_id faculty_id ]
Automatically generated method
- Switches:
- -dbn (optional)
- -faculty_id (optional)
::xo::db::sql::alf_dotlrn_faculty proc del {{-dbn {}} -faculty_id} {
#function_args: {FACULTY_ID NULL}
set sql_args [list]
foreach var [list FACULTY_ID] {
set varname [string tolower $var]
if {[info exists $varname]} {
lappend sql_args "$varname => :$varname"
}
}
set sql_args [join $sql_args ,]
set sql "BEGIN alf_dotlrn_faculty.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 ]
}
}
::xo::db::sql::alf_dotlrn_faculty
new [ -dbn dbn ] \
[ -community_id community_id ] \
[ -uned_faculty_id uned_faculty_id ] \
[ -uned_exist_p uned_exist_p ] [ -community_key community_key ] \
[ -pretty_name pretty_name ] [ -description description ] \
[ -package_id package_id ] [ -portal_id portal_id ] \
[ -non_member_portal_id non_member_portal_id ] \
[ -join_policy join_policy ] [ -creation_date creation_date ] \
[ -creation_user creation_user ] [ -creation_ip creation_ip ] \
[ -context_id context_id ]
Automatically generated method
- Switches:
- -dbn (optional)
- -community_id (optional)
- -uned_faculty_id (optional)
- -uned_exist_p (optional)
- -community_key (optional)
- -pretty_name (optional)
- -description (optional)
- -package_id (optional)
- -portal_id (optional)
- -non_member_portal_id (optional)
- -join_policy (optional)
- -creation_date (optional)
- -creation_user (optional)
- -creation_ip (optional)
- -context_id (optional)
::xo::db::sql::alf_dotlrn_faculty proc new {{-dbn {}} -community_id -uned_faculty_id -uned_exist_p -community_key -pretty_name -description -package_id -portal_id -non_member_portal_id -join_policy -creation_date -creation_user -creation_ip -context_id} {
#function_args: {COMMUNITY_ID NULL} {UNED_FACULTY_ID NULL} {UNED_EXIST_P NULL} {COMMUNITY_KEY NULL} {PRETTY_NAME NULL} {DESCRIPTION NULL} {PACKAGE_ID NULL} {PORTAL_ID NULL} {NON_MEMBER_PORTAL_ID NULL} {JOIN_POLICY NULL} {CREATION_DATE NULL} {CREATION_USER NULL} {CREATION_IP NULL} {CONTEXT_ID NULL}
set sql_args [list]
foreach var [list COMMUNITY_ID UNED_FACULTY_ID UNED_EXIST_P COMMUNITY_KEY PRETTY_NAME DESCRIPTION PACKAGE_ID PORTAL_ID NON_MEMBER_PORTAL_ID JOIN_POLICY CREATION_DATE CREATION_USER CREATION_IP CONTEXT_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 := alf_dotlrn_faculty.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 "" ]
}
}