Class ::xo::db::sql::forums_forum

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

Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::forums_forum[i] delete [ -dbn dbn ] -forum_id forum_id 

    Automatically generated method

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

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

     xo::db::sql::forums_forum[i] name [ -dbn dbn ] -forum_id forum_id 

    Automatically generated method

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

    Testcases:
    No testcase defined.
    #function_args: {FORUM_ID {}}
    foreach var [list FORUM_ID]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select forums_forum__name($_FORUM_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::forums_forum[i] new [ -dbn dbn ] -forum_id forum_id  \
        [ -object_type object_type ] -name name  -charter charter  \
        -presentation_type presentation_type  \
        -posting_policy posting_policy  -package_id package_id  \
        -creation_date creation_date  -creation_user creation_user  \
        -creation_ip creation_ip  -context_id context_id  \
        [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -forum_id (required)
    -object_type (optional, defaults to "forums_forum")
    -name (required)
    -charter (required)
    -presentation_type (required)
    -posting_policy (required)
    -package_id (required)
    -creation_date (required)
    -creation_user (required)
    -creation_ip (required)
    -context_id (required)
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {FORUM_ID {}} {OBJECT_TYPE forums_forum} {NAME {}} {CHARTER {}} {PRESENTATION_TYPE {}} {POSTING_POLICY {}} {PACKAGE_ID {}} {CREATION_DATE {}} {CREATION_USER {}} {CREATION_IP {}} {CONTEXT_ID {}}
    foreach var [list FORUM_ID OBJECT_TYPE NAME CHARTER PRESENTATION_TYPE POSTING_POLICY PACKAGE_ID CREATION_DATE CREATION_USER CREATION_IP 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 forums_forum__new($_FORUM_ID$_OBJECT_TYPE$_NAME$_CHARTER$_PRESENTATION_TYPE$_POSTING_POLICY$_PACKAGE_ID$_CREATION_DATE$_CREATION_USER$_CREATION_IP$_CONTEXT_ID) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }