- Methods: All Methods Documented Methods Hide Methods
- Source: Display Source Hide Source
- Variables: Show Variables Hide Variables
Class ::xo::db::sql::faq
::xo::db::sql::faq create ...
Class Relations
::xo::db::Class create ::xo::db::sql::faq \ -superclass ::xotcl::ObjectMethods (to be applied on the object)
clone (scripted, public)
xo::db::sql::faq clone [ -dbn dbn ] -new_package_id new_package_id \ -old_package_id old_package_idAutomatically generated method
- Switches:
- -dbn
(optional)- -new_package_id
(required)- -old_package_id
(required)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: {NEW_PACKAGE_ID {}} {OLD_PACKAGE_ID {}} foreach var [list NEW_PACKAGE_ID OLD_PACKAGE_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__clone($_NEW_PACKAGE_ID, $_OLD_PACKAGE_ID) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }delete_faq (scripted, public)
xo::db::sql::faq delete_faq [ -dbn dbn ]Automatically generated method
- Switches:
- -dbn
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: foreach var [list ] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__delete_faq() " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }delete_q_and_a (scripted, public)
xo::db::sql::faq delete_q_and_a [ -dbn dbn ]Automatically generated method
- Switches:
- -dbn
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: foreach var [list ] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__delete_q_and_a() " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }name (scripted, public)
xo::db::sql::faq name [ -dbn dbn ]Automatically generated method
- Switches:
- -dbn
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: foreach var [list ] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__name() " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }new_faq (scripted, public)
xo::db::sql::faq new_faq [ -dbn dbn ]Automatically generated method
- Switches:
- -dbn
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: foreach var [list ] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__new_faq() " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }new_q_and_a (scripted, public)
xo::db::sql::faq new_q_and_a [ -dbn dbn ] [ -entry_id entry_id ] \ -faq_id faq_id -question question -answer answer \ -sort_key sort_key -object_type object_type \ [ -creation_date creation_date ] [ -creation_user creation_user ] \ [ -creation_ip creation_ip ] [ -context_id context_id ]Automatically generated method
- Switches:
- -dbn
(optional)- -entry_id
(optional)- -faq_id
(required)- -question
(required)- -answer
(required)- -sort_key
(required)- -object_type
(required)- -creation_date
(defaults to"current_timestamp"
) (optional)- -creation_user
(optional)- -creation_ip
(optional)- -context_id
(optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: {ENTRY_ID null} {FAQ_ID {}} {QUESTION {}} {ANSWER {}} {SORT_KEY {}} {OBJECT_TYPE {}} {CREATION_DATE current_timestamp} {CREATION_USER null} {CREATION_IP null} {CONTEXT_ID null} foreach var [list ENTRY_ID FAQ_ID QUESTION ANSWER SORT_KEY OBJECT_TYPE CREATION_DATE CREATION_USER CREATION_IP CONTEXT_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select faq__new_q_and_a($_ENTRY_ID, $_FAQ_ID, $_QUESTION, $_ANSWER, $_SORT_KEY, $_OBJECT_TYPE, $_CREATION_DATE, $_CREATION_USER, $_CREATION_IP, $_CONTEXT_ID) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }
- Methods: All Methods Documented Methods Hide Methods
- Source: Display Source Hide Source
- Variables: Show Variables Hide Variables