<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="apm_generate_tarball.create_item"> <querytext> begin :1 := content_item.new(name => :name, creation_ip => :creation_ip, storage_type => 'file' ); end; </querytext> </fullquery> <fullquery name="apm_generate_tarball.create_revision"> <querytext> begin :1 := content_revision.new(title => :title, description => 'gzipped tarfile', text => 'not_important', mime_type => 'text/plain', item_id => :item_id, creation_user => :user_id, creation_ip => :creation_ip ); update cr_items set live_revision = :1 where item_id = :item_id; end; </querytext> </fullquery> <fullquery name="apm_generate_tarball.update_tarball"> <querytext> update cr_revisions set filename = '[set content_file [cr_create_content_file $item_id $revision_id $tmpfile]]' where revision_id = :revision_id </querytext> </fullquery> <fullquery name="apm_generate_tarball.update_content_length"> <querytext> update apm_package_versions set content_length = [cr_file_size $content_file] where version_id = :version_id </querytext> </fullquery> <fullquery name="apm_extract_tarball.distribution_tar_ball_select"> <querytext> select '[cr_fs_path]' || r.filename as content, i.storage_type from cr_revisions r, cr_items i where r.item_id = i.item_id and r.revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions where version_id = :version_id) </querytext> </fullquery> <fullquery name="apm_file_add.apm_file_add"> <querytext> begin :1 := apm_package_version.add_file( file_id => :file_id, version_id => :version_id, path => :path, file_type => :file_type, db_type => :db_type ); end; </querytext> </fullquery> <fullquery name="apm_file_remove.apm_file_remove"> <querytext> begin apm_package_version.remove_file( path => :path, version_id => :version_id ); end; </querytext> </fullquery> </queryset>