version-dependencies-postgresql.xql
DB Query file
Related Files
- packages/acs-admin/www/apm/version-dependencies.xql
- packages/acs-admin/www/apm/version-dependencies.tcl
- packages/acs-admin/www/apm/version-dependencies-postgresql.xql
- packages/acs-admin/www/apm/version-dependencies-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="apm_package_info_by_version_id"> <querytext> select package_key, pretty_name, version_name, installed_p from apm_package_version_info where version_id = :version_id </querytext> </fullquery> <fullquery name="apm_all_dependencies"> <querytext> select dependency_id, service_uri, service_version from apm_package_dependencies where version_id = :version_id and dependency_type = :dependency_type_prep order by service_uri </querytext> </fullquery> <fullquery name="apm_specific_version_dependencies"> <querytext> select t.pretty_name as dep_pretty_name, v.version_name as dep_version_name, v.version_id as dep_version_id, d.dependency_type as dep_type from apm_package_versions v, apm_package_dependencies d, apm_package_types t where d.service_uri = :service_uri and d.dependency_type in ($other_dependency_in) and d.version_id = v.version_id and t.package_key = v.package_key and apm_package_version__sortable_version_name(d.service_version) $sign apm_package_version__sortable_version_name(:service_version) </querytext> </fullquery> </queryset>