Mailinglist Archive: zypp-commit (204 mails)

< Previous Next >
[zypp-commit] r5740 - /trunk/libzypp/devel/devel.jkupec/dbqueries.sql
  • From: jkupec@xxxxxxxxxxxxxxxx
  • Date: Wed, 13 Jun 2007 08:03:12 -0000
  • Message-id: <20070613080312.A2F999CCA8@xxxxxxxxxxxxxxxx>
Author: jkupec
Date: Wed Jun 13 10:03:12 2007
New Revision: 5740

URL: http://svn.opensuse.org/viewcvs/zypp?rev=5740&view=rev
Log: (empty)

Modified:
    trunk/libzypp/devel/devel.jkupec/dbqueries.sql

Modified: trunk/libzypp/devel/devel.jkupec/dbqueries.sql
URL: http://svn.opensuse.org/viewcvs/zypp/trunk/libzypp/devel/devel.jkupec/dbqueries.sql?rev=5740&r1=5739&r2=5740&view=diff
==============================================================================
--- trunk/libzypp/devel/devel.jkupec/dbqueries.sql (original)
+++ trunk/libzypp/devel/devel.jkupec/dbqueries.sql Wed Jun 13 10:03:12 2007
@@ -40,4 +40,15 @@
     and c.refers_kind= kt.id
     and c.relation = rt.id
     and c.name_id = n.id
-    and resolvable_id = 2;
+    and c.resolvable_id = 2;
+
+-- print all file dependencies of resolvable with id = 2
+select dt.name "dtype", kt.name "kind", (dname.name || '/' || fname.name) "file"
+  from file_capabilities c, types dt, types kt, files f
+    left outer join file_names fname on fname.id = f.file_name_id
+    left outer join dir_names dname on dname.id = f.dir_name_id
+  where c.dependency_type = dt.id
+    and c.refers_kind= kt.id
+    and c.file_id = f.id
+    and c.resolvable_id = 2;
+

--
To unsubscribe, e-mail: zypp-commit+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: zypp-commit+help@xxxxxxxxxxxx

< Previous Next >
This Thread
  • No further messages