%3 ::xotcl::Object ::xotcl::Object ::xo::db::sql::cal_uid ::xo::db::sql::cal_uid → upsert ::xo::db::sql::cal_uid->::xotcl::Object

Class ::xo::db::sql::cal_uid

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

Class Relations

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

Methods (to be applied on the object)

  • upsert (scripted, public)

     xo::db::sql::cal_uid[i] upsert [ -dbn dbn ] -cal_uid cal_uid  \
        -activity_id activity_id  -ical_vars ical_vars 

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -cal_uid
    (required)
    -activity_id
    (required)
    -ical_vars
    (required)

    Partial Call Graph (max 5 caller/called nodes):
    %3 db_with_handle db_with_handle (public) xo::db::sql::cal_uid proc upsert xo::db::sql::cal_uid proc upsert xo::db::sql::cal_uid proc upsert->db_with_handle

    Testcases:
    No testcase defined.
    #function_args: {CAL_UID {}} {ACTIVITY_ID {}} {ICAL_VARS {}}
    foreach var [list CAL_UID ACTIVITY_ID ICAL_VARS]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select cal_uid__upsert($_CAL_UID$_ACTIVITY_ID$_ICAL_VARS) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }