delete (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__delete(CAST(:message_id AS integer))}]
return [ns_set value $s 0]
}
delete_extlink (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__delete_extlink(CAST(:extlink_id AS integer))}]
return [ns_set value $s 0]
}
delete_file (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__delete_file(CAST(:file_id AS integer))}]
return [ns_set value $s 0]
}
delete_image (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__delete_image(CAST(:image_id AS integer))}]
return [ns_set value $s 0]
}
edit (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__edit(CAST(:message_id AS integer),:title,:description,:mime_type,:text,CAST(:data AS integer),:creation_date,CAST(:creation_user AS integer),:creation_ip,:is_live)}]
return [ns_set value $s 0]
}
edit_extlink (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__edit_extlink(CAST(:extlink_id AS integer),:url,:label,:description)}]
return [ns_set value $s 0]
}
edit_file (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__edit_file(CAST(:file_id AS integer),:title,:description,:mime_type,CAST(:data AS integer),:creation_date,CAST(:creation_user AS integer),:creation_ip,:is_live)}]
return [ns_set value $s 0]
}
edit_image (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__edit_image(CAST(:image_id AS integer),:title,:description,:mime_type,CAST(:data AS integer),CAST(:width AS integer),CAST(:height AS integer),:creation_date,CAST(:creation_user AS integer),:creation_ip,:is_live)}]
return [ns_set value $s 0]
}
first_ancestor (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__first_ancestor(CAST(:message_id AS integer))}]
return [ns_set value $s 0]
}
message_p (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__message_p(CAST(:message_id AS integer))}]
return [ns_set value $s 0]
}
name (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__name(CAST(:message_id AS integer))}]
return [ns_set value $s 0]
}
new (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__new(CAST(:message_id AS integer),CAST(:reply_to AS integer),:sent_date,CAST(:sender AS integer),:rfc822_id,:title,:description,:mime_type,:text,CAST(:data AS integer),CAST(:parent_id AS integer),CAST(:context_id AS integer),CAST(:creation_user AS integer),:creation_ip,:object_type,:is_live,CAST(:package_id AS integer))}]
return [ns_set value $s 0]
}
new_file (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__new_file(CAST(:message_id AS integer),CAST(:file_id AS integer),:file_name,:title,:description,:mime_type,CAST(:data AS integer),:creation_date,CAST(:creation_user AS integer),:creation_ip,:is_live,:storage_type,CAST(:package_id AS integer))}]
return [ns_set value $s 0]
}
new_image (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__new_image(CAST(:message_id AS integer),CAST(:image_id AS integer),:file_name,:title,:description,:mime_type,CAST(:data AS integer),CAST(:width AS integer),CAST(:height AS integer),:creation_date,CAST(:creation_user AS integer),:creation_ip,:is_live,:storage_type,CAST(:package_id AS integer))}]
return [ns_set value $s 0]
}
send (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select acs_message__send(CAST(:message_id AS integer),:recipient_id,CAST(:grouping_id AS integer),:wait_until)}]
return [ns_set value $s 0]
}