%3 ::xotcl::Object ::xotcl::Object ::xo::db::sql::party_approved_member ::xo::db::sql::party_approved_member → add → add_one → remove → remove_one ::xo::db::sql::party_approved_member->::xotcl::Object

Class ::xo::db::sql::party_approved_member

::xo::db::sql::party_approved_member[i] create ...
Defined in

Class Relations

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

Methods (to be applied on the object)

  • add (scripted, public)

     xo::db::sql::party_approved_member[i] add [ -dbn dbn ] \
    -party_id party_id  -member_id member_id  -rel_id rel_id  \
    -rel_type rel_type

    Automatically generated method

    Switches:
    -dbn (optional)
    -party_id (required)
    -member_id (required)
    -rel_id (required)
    -rel_type (required)

    Testcases:
    No testcase defined.
    #function_args: {PARTY_ID {}} {MEMBER_ID {}} {REL_ID {}} {REL_TYPE {}}
foreach var [list PARTY_ID MEMBER_ID REL_ID REL_TYPE]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select party_approved_member__add($_PARTY_ID, $_MEMBER_ID, $_REL_ID, $_REL_TYPE) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • add_one (scripted, public)

     xo::db::sql::party_approved_member[i] add_one [ -dbn dbn ] \
    -party_id party_id  -member_id member_id  -rel_id rel_id

    Automatically generated method

    Switches:
    -dbn (optional)
    -party_id (required)
    -member_id (required)
    -rel_id (required)

    Testcases:
    No testcase defined.
    #function_args: {PARTY_ID {}} {MEMBER_ID {}} {REL_ID {}}
foreach var [list PARTY_ID MEMBER_ID REL_ID]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select party_approved_member__add_one($_PARTY_ID, $_MEMBER_ID, $_REL_ID) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • remove (scripted, public)

     xo::db::sql::party_approved_member[i] remove [ -dbn dbn ] \
    -party_id party_id  -member_id member_id  -rel_id rel_id  \
    -rel_type rel_type

    Automatically generated method

    Switches:
    -dbn (optional)
    -party_id (required)
    -member_id (required)
    -rel_id (required)
    -rel_type (required)

    Testcases:
    No testcase defined.
    #function_args: {PARTY_ID {}} {MEMBER_ID {}} {REL_ID {}} {REL_TYPE {}}
foreach var [list PARTY_ID MEMBER_ID REL_ID REL_TYPE]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select party_approved_member__remove($_PARTY_ID, $_MEMBER_ID, $_REL_ID, $_REL_TYPE) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • remove_one (scripted, public)

     xo::db::sql::party_approved_member[i] remove_one [ -dbn dbn ] \
    -party_id party_id  -member_id member_id  -rel_id rel_id

    Automatically generated method

    Switches:
    -dbn (optional)
    -party_id (required)
    -member_id (required)
    -rel_id (required)

    Testcases:
    No testcase defined.
    #function_args: {PARTY_ID {}} {MEMBER_ID {}} {REL_ID {}}
foreach var [list PARTY_ID MEMBER_ID REL_ID]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select party_approved_member__remove_one($_PARTY_ID, $_MEMBER_ID, $_REL_ID) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}