%3 ::xotcl::Object ::xotcl::Object ::xo::db::sql::file_storage ::xo::db::sql::file_storage → copy_file → delete_file → delete_folder → delete_version → get_content_type → get_folder_name → get_package_id → get_parent_id → get_root_folder → get_title → move_file → new_file → new_folder → new_root_folder → new_version → rename_file ::xo::db::sql::file_storage->::xotcl::Object

Class ::xo::db::sql::file_storage

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

Class Relations

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

Methods (to be applied on the object)

  • copy_file (scripted, public)

     xo::db::sql::file_storage[i] copy_file [ -dbn dbn ] -file_id file_id  \
    -target_folder_id target_folder_id  -creation_user creation_user  \
    -creation_ip creation_ip  [ -name name ] [ -title title ]

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -file_id
    (required)
    -target_folder_id
    (required)
    -creation_user
    (required)
    -creation_ip
    (required)
    -name
    (optional)
    -title
    (optional)

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

    Testcases:
    No testcase defined.
    #function_args: {FILE_ID {}} {TARGET_FOLDER_ID {}} {CREATION_USER {}} {CREATION_IP {}} {NAME null} {TITLE null}
foreach var [list FILE_ID TARGET_FOLDER_ID CREATION_USER CREATION_IP NAME TITLE]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select file_storage__copy_file($_FILE_ID, $_TARGET_FOLDER_ID, $_CREATION_USER, $_CREATION_IP, $_NAME, $_TITLE) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • delete_file (scripted, public)

     xo::db::sql::file_storage[i] delete_file [ -dbn dbn ] -file_id file_id

    Automatically generated method

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

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

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

  • delete_folder (scripted, public)

     xo::db::sql::file_storage[i] delete_folder [ -dbn dbn ] \
    -folder_id folder_id  -cascade_p cascade_p

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -folder_id
    (required)
    -cascade_p
    (required)

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

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

  • delete_version (scripted, public)

     xo::db::sql::file_storage[i] delete_version [ -dbn dbn ] \
    -file_id file_id  -version_id version_id

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -file_id
    (required)
    -version_id
    (required)

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

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

  • get_content_type (scripted, public)

     xo::db::sql::file_storage[i] get_content_type [ -dbn dbn ] \
    -file_id file_id

    Automatically generated method

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

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

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

  • get_folder_name (scripted, public)

     xo::db::sql::file_storage[i] get_folder_name [ -dbn dbn ] \
    -folder_id folder_id

    Automatically generated method

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

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

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

  • get_package_id (scripted, public)

     xo::db::sql::file_storage[i] get_package_id [ -dbn dbn ] \
    -item_id item_id

    Automatically generated method

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

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

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

  • get_parent_id (scripted, public)

     xo::db::sql::file_storage[i] get_parent_id [ -dbn dbn ] -item_id item_id

    Automatically generated method

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

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

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

    Automatically generated method

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

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

    Testcases:
    No testcase defined.
    #function_args: {PACKAGE_ID {}}
foreach var [list 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 file_storage__get_root_folder($_PACKAGE_ID) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • get_title (scripted, public)

     xo::db::sql::file_storage[i] get_title [ -dbn dbn ] -item_id item_id

    Automatically generated method

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

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

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

  • move_file (scripted, public)

     xo::db::sql::file_storage[i] move_file [ -dbn dbn ] -file_id file_id  \
    -target_folder_id target_folder_id  -creation_user creation_user  \
    -creation_ip creation_ip

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -file_id
    (required)
    -target_folder_id
    (required)
    -creation_user
    (required)
    -creation_ip
    (required)

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

    Testcases:
    No testcase defined.
    #function_args: {FILE_ID {}} {TARGET_FOLDER_ID {}} {CREATION_USER {}} {CREATION_IP {}}
foreach var [list FILE_ID TARGET_FOLDER_ID CREATION_USER CREATION_IP]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select file_storage__move_file($_FILE_ID, $_TARGET_FOLDER_ID, $_CREATION_USER, $_CREATION_IP) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • new_file (scripted, public)

     xo::db::sql::file_storage[i] new_file [ -dbn dbn ] -name name  \
    -folder_id folder_id  -user_id user_id  -creation_ip creation_ip  \
    -indb_p indb_p  -item_id item_id  -package_id package_id

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -name
    (required)
    -folder_id
    (required)
    -user_id
    (required)
    -creation_ip
    (required)
    -indb_p
    (required)
    -item_id
    (required)
    -package_id
    (required)

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

    Testcases:
    No testcase defined.
    #function_args: {NAME {}} {FOLDER_ID {}} {USER_ID {}} {CREATION_IP {}} {INDB_P {}} {ITEM_ID {}} {PACKAGE_ID {}}
foreach var [list NAME FOLDER_ID USER_ID CREATION_IP INDB_P ITEM_ID 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 file_storage__new_file($_NAME, $_FOLDER_ID, $_USER_ID, $_CREATION_IP, $_INDB_P, $_ITEM_ID, $_PACKAGE_ID) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • new_folder (scripted, public)

     xo::db::sql::file_storage[i] new_folder [ -dbn dbn ] -name name  \
    -folder_name folder_name  -parent_id parent_id  \
    -creation_user creation_user  -creation_ip creation_ip

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -name
    (required)
    -folder_name
    (required)
    -parent_id
    (required)
    -creation_user
    (required)
    -creation_ip
    (required)

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

    Testcases:
    No testcase defined.
    #function_args: {NAME {}} {FOLDER_NAME {}} {PARENT_ID {}} {CREATION_USER {}} {CREATION_IP {}}
foreach var [list NAME FOLDER_NAME PARENT_ID CREATION_USER CREATION_IP]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select file_storage__new_folder($_NAME, $_FOLDER_NAME, $_PARENT_ID, $_CREATION_USER, $_CREATION_IP) 
    "
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::file_storage[i] new_root_folder [ -dbn dbn ] \
    -package_id package_id  -folder_name folder_name  -url url  \
    -description description

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -package_id
    (required)
    -folder_name
    (required)
    -url
    (required)
    -description
    (required)

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

    Testcases:
    No testcase defined.
    #function_args: {PACKAGE_ID {}} {FOLDER_NAME {}} {URL {}} {DESCRIPTION {}}
foreach var [list PACKAGE_ID FOLDER_NAME URL DESCRIPTION]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select file_storage__new_root_folder($_PACKAGE_ID, $_FOLDER_NAME, $_URL, $_DESCRIPTION) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • new_version (scripted, public)

     xo::db::sql::file_storage[i] new_version [ -dbn dbn ] -filename filename  \
    -description description  -mime_type mime_type  -item_id item_id  \
    -creation_user creation_user  -creation_ip creation_ip

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -filename
    (required)
    -description
    (required)
    -mime_type
    (required)
    -item_id
    (required)
    -creation_user
    (required)
    -creation_ip
    (required)

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

    Testcases:
    No testcase defined.
    #function_args: {FILENAME {}} {DESCRIPTION {}} {MIME_TYPE {}} {ITEM_ID {}} {CREATION_USER {}} {CREATION_IP {}}
foreach var [list FILENAME DESCRIPTION MIME_TYPE ITEM_ID CREATION_USER CREATION_IP]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select file_storage__new_version($_FILENAME, $_DESCRIPTION, $_MIME_TYPE, $_ITEM_ID, $_CREATION_USER, $_CREATION_IP) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

  • rename_file (scripted, public)

     xo::db::sql::file_storage[i] rename_file [ -dbn dbn ] -file_id file_id  \
    -name name

    Automatically generated method

    Switches:
    -dbn
    (optional)
    -file_id
    (required)
    -name
    (required)

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

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