Class ::xo::db::sql::application_group

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

Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::application_group[i] delete [ -dbn dbn ] -group_id group_id 

    Automatically generated method

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

    Testcases:
    No testcase defined.
    #function_args: {GROUP_ID {}}
    foreach var [list GROUP_ID]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select application_group__delete($_GROUP_ID) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • group_id_from_package_id (scripted, public)

     xo::db::sql::application_group[i] group_id_from_package_id [ -dbn dbn ] \
        -package_id package_id  [ -no_complain_p no_complain_p ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -package_id (required)
    -no_complain_p (optional, defaults to "f")

    Testcases:
    No testcase defined.
    #function_args: {PACKAGE_ID {}} {NO_COMPLAIN_P f}
    foreach var [list PACKAGE_ID NO_COMPLAIN_P]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select application_group__group_id_from_package_id($_PACKAGE_ID$_NO_COMPLAIN_P) 
        "
    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::application_group[i] new [ -dbn dbn ] -group_id group_id  \
        [ -object_type object_type ] [ -creation_date creation_date ] \
        -creation_user creation_user  -creation_ip creation_ip  \
        -email email  -url url  -group_name group_name  \
        -package_id package_id  -join_policy join_policy  \
        -context_id context_id  [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -group_id (required)
    -object_type (optional, defaults to "application_group")
    -creation_date (optional, defaults to "now()")
    -creation_user (required)
    -creation_ip (required)
    -email (required)
    -url (required)
    -group_name (required)
    -package_id (required)
    -join_policy (required)
    -context_id (required)
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {GROUP_ID {}} {OBJECT_TYPE application_group} {CREATION_DATE now()} {CREATION_USER {}} {CREATION_IP {}} {EMAIL {}} {URL {}} {GROUP_NAME {}} {PACKAGE_ID {}} {JOIN_POLICY {}} {CONTEXT_ID {}}
    foreach var [list GROUP_ID OBJECT_TYPE CREATION_DATE CREATION_USER CREATION_IP EMAIL URL GROUP_NAME PACKAGE_ID JOIN_POLICY 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 application_group__new($_GROUP_ID$_OBJECT_TYPE$_CREATION_DATE$_CREATION_USER$_CREATION_IP$_EMAIL$_URL$_GROUP_NAME$_PACKAGE_ID$_JOIN_POLICY$_CONTEXT_ID) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }