--
-- xooauth_server_metadata_f/1
--
create or replace function xooauth_server_metadata_f(
  p_new xooauth_server_metadatai
) returns void as $$

             declare
               v_revision_id integer;
             begin

               select content_revision__new(
                                     p_new.title,
                                     p_new.description,
                                     p_new.publish_date,
                                     p_new.mime_type,
                                     p_new.nls_language,
                                     case when p_new.text is null 
                                              then p_new.data 
                                              else p_new.text
                                           end,
                                     content_symlink__resolve(p_new.item_id),
                                     p_new.revision_id,
                                     now(),
                                     p_new.creation_user, 
                                     p_new.creation_ip,
                                     null,                    -- content_length
                                     p_new.object_package_id
                ) into v_revision_id;
                insert into xooauth_server_metadata ( server_metadata_id, temp_credentials_url, authorization_url, token_credentials_url ) values (v_revision_id, p_new.temp_credentials_url, p_new.authorization_url, p_new.token_credentials_url);
    
   return;
   end;$$ language plpgsql;