postgresql7.1
select content as file_from_db from cr_revisions
where revision_id = content_item__get_live_revision(:static_page_id)
select coalesce(content_item__get_id(:cumulative_path,:root_folder_id),0)
select static_page__new_folder (
:directory, -- name
:directory, -- label
:parent_folder_id, -- parent_id
'Static pages folder' -- description
);
update cr_revisions set content = :file
where revision_id = content_item__get_live_revisions(:static_page_id)
select static_page__new(
:parent_folder_id, -- folder_id
:file, -- filename
:page_title -- title
);
update cr_revisions set content = :file
where revision_id = content_item__get_live_revisions(:static_page_id)
begin
perform static_page__delete_stale_items(:sync_session_id,:package_id);
-- delete from sp_extant_folders where session_id = :sync_session_id;
--
delete from sp_extant_files where session_id = :sync_session_id;
return null;
end;
select static_page__get_root_folder(:package_id);
update static_pages set show_comments_p = :show_full_comments_p
where static_page_id in (
select static_page_id from static_pages
where folder_id in (
select folder_id from sp_folders where
tree_sortkey like ( select tree_sortkey || '%'
from sp_folders
where folder_id = :root_folder_id)
)
and filename like '%${contained_string}%'
)
begin
for file_row in (
select static_page_id from static_pages
where folder_id in (
select folder_id from sp_folders where
tree_sortkey like ( select tree_sortkey || '%'
from sp_folders
where folder_id = :root_folder_id)
) and
filename like '%${contained_string%'}
) loop
PERFORM acs_permission__${grant_or_revoke}_permission(
file_row.static_page_id,
acs__magic_object_id('the_public'),
'general_comments_create'
);
end loop;
end;
select static_page_id from static_pages
where folder_id in (
select folder_id from sp_folders
where tree_sortkey like
(select tree_sortkey ||'%' from sp_folders
where folder_id = :root_folder_id)
) and filename like '%${contained_string}%'
select '{'||content_item__get_title(:page_id)||'} '||CASE WHEN show_comments_p='t' then '1' else '0' END from static_pages where static_page_id = :page_id
select '{'||content_item__get_title(:page_id)||'} '||CASE WHEN show_comments_p='t' then '1' else '0' END from static_pages where static_page_id = :page_id