Class ::xo::db::sql::acs_content

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

Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::acs_content[i] delete [ -dbn dbn ] -content_id content_id 

    Automatically generated method

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

    Testcases:
    No testcase defined.
    #function_args: {CONTENT_ID {}}
    foreach var [list CONTENT_ID]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select acs_content__delete($_CONTENT_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::acs_content[i] new [ -dbn dbn ] -content_id content_id  \
        -mime_type mime_type  -nls_language nls_language  \
        -searchable_p searchable_p  -content content  [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -content_id (required)
    -mime_type (required)
    -nls_language (required)
    -searchable_p (required)
    -content (required)
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {CONTENT_ID {}} {MIME_TYPE {}} {NLS_LANGUAGE {}} {SEARCHABLE_P {}} {CONTENT {}}
    foreach var [list CONTENT_ID MIME_TYPE NLS_LANGUAGE SEARCHABLE_P CONTENT]  {
      set varname [string tolower $var]
      if {[info exists $varname]} {
        set $var [set $varname]
        set _$var :$var
      } else {
        set _$var null
      }
    }
    set sql "
    select acs_content__new($_CONTENT_ID$_MIME_TYPE$_NLS_LANGUAGE$_SEARCHABLE_P$_CONTENT) 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • update_mime_type (scripted, public)

     xo::db::sql::acs_content[i] update_mime_type [ -dbn dbn ] \
        -content_id content_id  -mime_type mime_type 

    Automatically generated method

    Switches:
    -dbn (optional)
    -content_id (required)
    -mime_type (required)

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

     xo::db::sql::acs_content[i] update_nls_language [ -dbn dbn ] \
        -content_id content_id  -nls_language nls_language 

    Automatically generated method

    Switches:
    -dbn (optional)
    -content_id (required)
    -nls_language (required)

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

     xo::db::sql::acs_content[i] update_searchable_p [ -dbn dbn ] \
        -content_id content_id  -searchable_p searchable_p 

    Automatically generated method

    Switches:
    -dbn (optional)
    -content_id (required)
    -searchable_p (required)

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