postgresql7.1
select file_storage__new_root_folder(
:package_id,
:pretty_name,
:description
);
select file_storage__get_root_folder(:package_id);
select file_storage__new_folder(
:name,
:pretty_name,
:parent_id,
:creation_user,
:creation_ip
);
select i.item_id as file_id,
i.name as name,
i.live_revision,
r.mime_type as type,
to_char(o.last_modified,'YYYY-MM-DD HH24:MI') as last_modified,
r.content_length as content_size,
1 as ordering_key
from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id), acs_objects o
where i.item_id = o.object_id
and i.parent_id = :folder_id
and acs_permission__permission_p(i.item_id, :user_id, 'read') = 't'
and i.content_type = 'file_storage_object'
UNION
select i.item_id as file_id,
f.label as name,
0,
'Folder',
NULL,
0,
0
from cr_items i, cr_folders f
where i.item_id = f.folder_id
and i.parent_id = :folder_id
and acs_permission__permission_p(f.folder_id, :user_id, 'read') = 't'
order by ordering_key,name
select count(*)
from (
select 1
from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id), acs_objects o
where i.item_id = o.object_id
and i.parent_id = :folder_id
and acs_permission__permission_p(i.item_id, :user_id, 'read') = 't'
and i.content_type = 'file_storage_object'
union
select 1
from cr_items i, cr_folders f
where i.item_id = f.folder_id
and i.parent_id = :folder_id
and acs_permission__permission_p(f.folder_id, :user_id, 'read') = 't'
) foo
select file_storage__get_folder_name(:folder_id);
select count(*)
from cr_items c1, cr_items c2
where c2.item_id = :item_id
and c1.tree_sortkey between c2.tree_sortkey and tree_right(c2.tree_sortkey)
and not acs_permission__permission_p(c1.item_id,:user_id,:privilege)
select c1.item_id as child_item_id
from cr_items c1, cr_items c2
where c2.item_id = :item_id
and c1.tree_sortkey between c2.tree_sortkey and tree_right(c2.tree_sortkey)
order by c1.tree_sortkey
select count(*)
from cr_revisions
where item_id = :child_item_id
and acs_permission__permission_p(revision_id,:user_id,:privilege) = 'f'
select file_storage__get_title(:item_id)
select (case when file_storage__get_content_type(i.item_id) = 'content_folder'
then 'index?folder_id='
else 'file?file_id='
end) || i.item_id,
file_storage__get_title(i.item_id)
from (select tree_ancestor_keys(cr_items_get_tree_sortkey(:start_id)) as tree_sortkey) parents,
(select tree_sortkey from cr_items where item_id = file_storage__get_root_folder([ad_conn package_id])) root,
cr_items i
where i.tree_sortkey = parents.tree_sortkey
and i.tree_sortkey > root.tree_sortkey
order by i.tree_sortkey asc