- Methods: All Methods Documented Methods Hide Methods
- Source: Display Source Hide Source
- Variables: Show Variables Hide Variables
Class ::xo::db::sql::notification
::xo::db::sql::notification create ...
Class Relations
::xo::db::Class create ::xo::db::sql::notification \ -superclass ::xotcl::ObjectMethods (to be applied on the object)
delete (scripted, public)
xo::db::sql::notification delete [ -dbn dbn ] \ -notification_id notification_idAutomatically generated method
- Switches:
- -dbn (optional)
- -notification_id (required)
- Testcases:
- No testcase defined.
#function_args: {NOTIFICATION_ID {}} foreach var [list NOTIFICATION_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select notification__delete($_NOTIFICATION_ID) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }new (scripted, public)
xo::db::sql::notification new [ -dbn dbn ] \ -notification_id notification_id -type_id type_id \ -object_id object_id -notif_date notif_date \ -response_id response_id -notif_user notif_user \ -notif_subject notif_subject -notif_text notif_text \ -notif_html notif_html -file_ids file_ids \ -creation_date creation_date -creation_user creation_user \ -creation_ip creation_ip -context_id context_id \ [ -childof childof ]Automatically generated method
- Switches:
- -dbn (optional)
- -notification_id (required)
- -type_id (required)
- -object_id (required)
- -notif_date (required)
- -response_id (required)
- -notif_user (required)
- -notif_subject (required)
- -notif_text (required)
- -notif_html (required)
- -file_ids (required)
- -creation_date (required)
- -creation_user (required)
- -creation_ip (required)
- -context_id (required)
- -childof (optional)
- Testcases:
- No testcase defined.
#function_args: {NOTIFICATION_ID {}} {TYPE_ID {}} {OBJECT_ID {}} {NOTIF_DATE {}} {RESPONSE_ID {}} {NOTIF_USER {}} {NOTIF_SUBJECT {}} {NOTIF_TEXT {}} {NOTIF_HTML {}} {FILE_IDS {}} {CREATION_DATE {}} {CREATION_USER {}} {CREATION_IP {}} {CONTEXT_ID {}} foreach var [list NOTIFICATION_ID TYPE_ID OBJECT_ID NOTIF_DATE RESPONSE_ID NOTIF_USER NOTIF_SUBJECT NOTIF_TEXT NOTIF_HTML FILE_IDS 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 notification__new($_NOTIFICATION_ID, $_TYPE_ID, $_OBJECT_ID, $_NOTIF_DATE, $_RESPONSE_ID, $_NOTIF_USER, $_NOTIF_SUBJECT, $_NOTIF_TEXT, $_NOTIF_HTML, $_FILE_IDS, $_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