[Yum-devel] [PATCH 2/9] Add three views to make look at history by hand easier

[James Antill]

---
 yum/history.py |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/yum/history.py b/yum/history.py
index 7305a62..358edf1 100644
--- a/yum/history.py
+++ b/yum/history.py
@@ -650,6 +650,31 @@ class YumHistory:
  CREATE TABLE trans_skip_pkgs (
      tid INTEGER NOT NULL REFERENCES trans_beg,
      pkgtupid INTEGER NOT NULL REFERENCES pkgtups);
+''', '''\
+\
+ CREATE VIEW vtrans_data_pkgs AS
+     SELECT tid,name,epoch,version,release,arch,pkgtupid,
+            state,done,
+            name || '-' || epoch || ':' ||
+            version || '-' || release || '.' || arch AS nevra
+     FROM trans_data_pkgs JOIN pkgtups USING(pkgtupid)
+     ORDER BY name;
+''', '''\
+\
+ CREATE VIEW vtrans_with_pkgs AS
+     SELECT tid,name,epoch,version,release,arch,pkgtupid,
+            name || '-' || epoch || ':' ||
+            version || '-' || release || '.' || arch AS nevra
+     FROM trans_with_pkgs JOIN pkgtups USING(pkgtupid)
+     ORDER BY name;
+''', '''\
+\
+ CREATE VIEW vtrans_skip_pkgs AS
+     SELECT tid,name,epoch,version,release,arch,pkgtupid,
+            name || '-' || epoch || ':' ||
+            version || '-' || release || '.' || arch AS nevra
+     FROM trans_skip_pkgs JOIN pkgtups USING(pkgtupid)
+     ORDER BY name;
 ''']
 
     def _update_db_file_2(self):
-- 
1.7.0.1