%3 ::xotcl::Object ::xotcl::Object → getExitHandler → setExitHandler → unsetExitHandler __object_configureparameter __timediff abstract ad_doc ad_forward ad_proc asHTML check class db_0or1row db_1row debug destroy_on_cleanup ds extractConfigureArg filter filtersearch forward hasclass init invar isclass ismetaclass ismixin isobject istype log method mixin mset msg parametercmd proc procsearch qn self serialize set_instance_vars_defaults unknown vwait www-show-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 ...
Defined in

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)

    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 ]
}