Class ::xo::db::sql::faq

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

Class Relations

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

Methods (to be applied on the object)

  • clone (scripted, public)

     xo::db::sql::faq[i] clone [ -dbn dbn ] -new_package_id new_package_id  \
        -old_package_id old_package_id 

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -new_package_id
    (required)
    -old_package_id
    (required)

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

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

     xo::db::sql::faq[i] delete_faq [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn
    (optional)

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

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

     xo::db::sql::faq[i] delete_q_and_a [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn
    (optional)

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

    Testcases:
    No testcase defined.
    #function_args: 
    foreach var [list ]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select faq__delete_q_and_a() 
        "
    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::faq[i] name [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn
    (optional)

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

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

     xo::db::sql::faq[i] new_faq [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn
    (optional)

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

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

     xo::db::sql::faq[i] new_q_and_a [ -dbn dbn ] [ -entry_id entry_id ] \
        -faq_id faq_id  -question question  -answer answer  \
        -sort_key sort_key  -object_type object_type  \
        [ -creation_date creation_date ] [ -creation_user creation_user ] \
        [ -creation_ip creation_ip ] [ -context_id context_id ]

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -entry_id
    (optional)
    -faq_id
    (required)
    -question
    (required)
    -answer
    (required)
    -sort_key
    (required)
    -object_type
    (required)
    -creation_date
    (defaults to "current_timestamp") (optional)
    -creation_user
    (optional)
    -creation_ip
    (optional)
    -context_id
    (optional)

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

    Testcases:
    No testcase defined.
    #function_args: {ENTRY_ID null} {FAQ_ID {}} {QUESTION {}} {ANSWER {}} {SORT_KEY {}} {OBJECT_TYPE {}} {CREATION_DATE current_timestamp} {CREATION_USER null} {CREATION_IP null} {CONTEXT_ID null}
    foreach var [list ENTRY_ID FAQ_ID QUESTION ANSWER SORT_KEY OBJECT_TYPE 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 faq__new_q_and_a($_ENTRY_ID$_FAQ_ID$_QUESTION$_ANSWER$_SORT_KEY$_OBJECT_TYPE$_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 ]
    }