Class ::xo::db::sql::notification

::xo::db::sql::notification[i] create ...

Class Relations

  • class: ::xo::db::Class[i]
  • superclass: ::xotcl::Object[i]
::xo::db::Class create ::xo::db::sql::notification \
     -superclass ::xotcl::Object

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::notification[i] delete [ -dbn dbn ] \
        -notification_id notification_id 

    Automatically 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[i] 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 ]
    }