Class ::xo::db::sql::acs_mail_queue_message

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

Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::acs_mail_queue_message[i] delete [ -dbn dbn ] \
        -message_id message_id 

    Automatically generated method

    Switches:
    -dbn (optional)
    -message_id (required)

    Testcases:
    No testcase defined.
    #function_args: {MESSAGE_ID {}}
    foreach var [list MESSAGE_ID]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select acs_mail_queue_message__delete($_MESSAGE_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::acs_mail_queue_message[i] new [ -dbn dbn ] \
        [ -mail_link_id mail_link_id ] -body_id body_id  \
        [ -context_id context_id ] [ -creation_date creation_date ] \
        [ -creation_user creation_user ] [ -creation_ip creation_ip ] \
        [ -object_type object_type ] [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -mail_link_id (optional)
    -body_id (required)
    -context_id (optional)
    -creation_date (optional, defaults to "now()")
    -creation_user (optional)
    -creation_ip (optional)
    -object_type (optional, defaults to "acs_mail_link")
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {MAIL_LINK_ID null} {BODY_ID {}} {CONTEXT_ID null} {CREATION_DATE now()} {CREATION_USER null} {CREATION_IP null} {OBJECT_TYPE acs_mail_link}
    foreach var [list MAIL_LINK_ID BODY_ID CONTEXT_ID CREATION_DATE CREATION_USER CREATION_IP OBJECT_TYPE]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select acs_mail_queue_message__new($_MAIL_LINK_ID$_BODY_ID$_CONTEXT_ID$_CREATION_DATE$_CREATION_USER$_CREATION_IP$_OBJECT_TYPE) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }