Class ::xo::db::sql::bookmark

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

Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::bookmark[i] delete [ -dbn dbn ] -bookmark_id bookmark_id 

    Automatically generated method

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

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

     xo::db::sql::bookmark[i] get_in_closed_p [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__get_in_closed_p() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • get_root_folder (scripted, public)

     xo::db::sql::bookmark[i] get_root_folder [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__get_root_folder() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • initialize_in_closed_p (scripted, public)

     xo::db::sql::bookmark[i] initialize_in_closed_p [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__initialize_in_closed_p() 
        "
    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::bookmark[i] name [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__name() 
        "
    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::bookmark[i] new [ -dbn dbn ] -bookmark_id bookmark_id  \
        -owner_id owner_id  -url_id url_id  -local_title local_title  \
        -folder_p folder_p  -parent_id parent_id  \
        -last_access_date last_access_date  -creation_user creation_user  \
        -creation_ip creation_ip  -context_id context_id  \
        [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -bookmark_id (required)
    -owner_id (required)
    -url_id (required)
    -local_title (required)
    -folder_p (required)
    -parent_id (required)
    -last_access_date (required)
    -creation_user (required)
    -creation_ip (required)
    -context_id (required)
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {BOOKMARK_ID {}} {OWNER_ID {}} {URL_ID {}} {LOCAL_TITLE {}} {FOLDER_P {}} {PARENT_ID {}} {LAST_ACCESS_DATE {}} {CREATION_USER {}} {CREATION_IP {}} {CONTEXT_ID {}}
    foreach var [list BOOKMARK_ID OWNER_ID URL_ID LOCAL_TITLE FOLDER_P PARENT_ID LAST_ACCESS_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 bookmark__new($_BOOKMARK_ID$_OWNER_ID$_URL_ID$_LOCAL_TITLE$_FOLDER_P$_PARENT_ID$_LAST_ACCESS_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 ]
    }
  • new_root_folder (scripted, public)

     xo::db::sql::bookmark[i] new_root_folder [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__new_root_folder() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • private_p (scripted, public)

     xo::db::sql::bookmark[i] private_p [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__private_p() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • toggle_open_close (scripted, public)

     xo::db::sql::bookmark[i] toggle_open_close [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__toggle_open_close() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • toggle_open_close_all (scripted, public)

     xo::db::sql::bookmark[i] toggle_open_close_all [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__toggle_open_close_all() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • update_in_closed_p_all_users (scripted, public)

     xo::db::sql::bookmark[i] update_in_closed_p_all_users [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__update_in_closed_p_all_users() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • update_in_closed_p_one_user (scripted, public)

     xo::db::sql::bookmark[i] update_in_closed_p_one_user [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__update_in_closed_p_one_user() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }
  • update_private_p (scripted, public)

     xo::db::sql::bookmark[i] update_private_p [ -dbn dbn ]

    Automatically generated method

    Switches:
    -dbn (optional)

    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 bookmark__update_private_p() 
        "
    db_with_handle -dbn $dbn db {
      #ns_log notice "--sql=$sql"
      return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
    }