---

Class Relations

• class: ::nx::EnsembleObject

::nx::EnsembleObject create ::acs::db::nsdb-postgresql::slot::__call::news

Methods (to be applied on the object)

• archive (scripted)

  # Automatically generated method
  # TYPES: integer {timestamp with time zone}
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__archive(CAST(:item_id AS integer),:archive_date)}]
     return [ns_set value $s 0]
  }

• clone (scripted)

  # Automatically generated method
  # TYPES: integer integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__clone(CAST(:old_package_id AS integer),CAST(:new_package_id AS integer))}]
     return [ns_set value $s 0]
  }

• delete (scripted)

  # Automatically generated method
  # TYPES: integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__delete(CAST(:item_id AS integer))}]
     return [ns_set value $s 0]
  }

• make_permanent (scripted)

  # Automatically generated method
  # TYPES: integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__make_permanent(CAST(:item_id AS integer))}]
     return [ns_set value $s 0]
  }

• name (scripted)

  # Automatically generated method
  # TYPES: integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__name(CAST(:news_id AS integer))}]
     return [ns_set value $s 0]
  }

• new (scripted)

  # Automatically generated method
  # TYPES: integer {character varying} {timestamp with time zone} text {character varying} {character varying} {character varying} integer {timestamp with time zone} integer {timestamp with time zone} {character varying} {character varying} {character varying} integer boolean {character varying}
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__new(CAST(:item_id AS integer),:locale,:publish_date,:text,:nls_language,:title,:mime_type,CAST(:package_id AS integer),:archive_date,CAST(:approval_user AS integer),:approval_date,:approval_ip,:relation_tag,:creation_ip,CAST(:creation_user AS integer),:is_live_p,:lead)}]
     return [ns_set value $s 0]
  }

• revision_delete (scripted)

  # Automatically generated method
  # TYPES: integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__revision_delete(CAST(:revision_id AS integer))}]
     return [ns_set value $s 0]
  }

• revision_new (scripted)

  # Automatically generated method
  # TYPES: integer {timestamp with time zone} text {character varying} text {character varying} integer {timestamp with time zone} integer {timestamp with time zone} {character varying} {timestamp with time zone} {character varying} integer boolean {character varying}
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__revision_new(CAST(:item_id AS integer),:publish_date,:text,:title,:description,:mime_type,CAST(:package_id AS integer),:archive_date,CAST(:approval_user AS integer),:approval_date,:approval_ip,:creation_date,:creation_ip,CAST(:creation_user AS integer),:make_active_revision_p,:lead)}]
     return [ns_set value $s 0]
  }

• revision_set_active (scripted)

  # Automatically generated method
  # TYPES: integer
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__revision_set_active(CAST(:revision_id AS integer))}]
     return [ns_set value $s 0]
  }

• set_approve (scripted)

  # Automatically generated method
  # TYPES: integer {character varying} {timestamp with time zone} {timestamp with time zone} integer {timestamp with time zone} {character varying} boolean
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__set_approve(CAST(:revision_id AS integer),:approve_p,:publish_date,:archive_date,CAST(:approval_user AS integer),:approval_date,:approval_ip,:live_revision_p)}]
     return [ns_set value $s 0]
  }

• status (scripted)

  # Automatically generated method
  # TYPES: {timestamp with time zone} {timestamp with time zone}
  db_with_handle -dbn $dbn __DB {
     set s [ns_pg_bind 0or1row $__DB {select news__status(:publish_date,:archive_date)}]
     return [ns_set value $s 0]
  }

---