%3 ::xotcl::Object ::xotcl::Object ::xo::db::sql::pinds_blog_entry ::xo::db::sql::pinds_blog_entry → delete → new → title ::xo::db::sql::pinds_blog_entry->::xotcl::Object

Class ::xo::db::sql::pinds_blog_entry

::xo::db::sql::pinds_blog_entry[i] create ...
Defined in

Class Relations

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

Methods (to be applied on the object)

  • delete (scripted, public)

     xo::db::sql::pinds_blog_entry[i] delete [ -dbn dbn ] -entry_id entry_id

    Automatically generated method

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

    Testcases:
    No testcase defined.
    #function_args: {ENTRY_ID {}}
foreach var [list ENTRY_ID]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select pinds_blog_entry__delete($_ENTRY_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::pinds_blog_entry[i] new [ -dbn dbn ] -entry_id entry_id  \
    -package_id package_id  -title title  -title_url title_url  \
    -category_id category_id  -content content  \
    -content_format content_format  -entry_date entry_date  \
    -draft_p draft_p  -creation_user creation_user  \
    -creation_ip creation_ip  [ -childof childof ]

    Automatically generated method

    Switches:
    -dbn (optional)
    -entry_id (required)
    -package_id (required)
    -title (required)
    -title_url (required)
    -category_id (required)
    -content (required)
    -content_format (required)
    -entry_date (required)
    -draft_p (required)
    -creation_user (required)
    -creation_ip (required)
    -childof (optional)

    Testcases:
    No testcase defined.
    #function_args: {ENTRY_ID {}} {PACKAGE_ID {}} {TITLE {}} {TITLE_URL {}} {CATEGORY_ID {}} {CONTENT {}} {CONTENT_FORMAT {}} {ENTRY_DATE {}} {DRAFT_P {}} {CREATION_USER {}} {CREATION_IP {}}
foreach var [list ENTRY_ID PACKAGE_ID TITLE TITLE_URL CATEGORY_ID CONTENT CONTENT_FORMAT ENTRY_DATE DRAFT_P 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 pinds_blog_entry__new($_ENTRY_ID, $_PACKAGE_ID, $_TITLE, $_TITLE_URL, $_CATEGORY_ID, $_CONTENT, $_CONTENT_FORMAT, $_ENTRY_DATE, $_DRAFT_P, $_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 ]
}

  • title (scripted, public)

     xo::db::sql::pinds_blog_entry[i] title [ -dbn dbn ] -entry_id entry_id

    Automatically generated method

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

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