# HG changeset patch
# User wenzelm
# Date 1493760660 -7200
# Node ID d1e9155b894caf88c35a4a599e336ac17b3eeea5
# Parent  2229276a1f99cb599edf1cf51b33ef59231a2385
views for full PostgreSQL database;

diff -r 2229276a1f99 -r d1e9155b894c src/Pure/Admin/build_log.scala
--- a/src/Pure/Admin/build_log.scala	Tue May 02 23:21:53 2017 +0200
+++ b/src/Pure/Admin/build_log.scala	Tue May 02 23:31:00 2017 +0200
@@ -897,7 +897,7 @@
     /* full view on build_log data */
 
     // WARNING: This may cause performance problems, e.g. with sqlitebrowser
-    val full_view: SQL.Table =
+    val full_table: SQL.Table =
     {
       val columns =
         Meta_Info.table.columns :::
@@ -914,14 +914,32 @@
     }
 
 
+    /* earliest pull date for repository version */
+
+    val pull_date = SQL.Column.date("pull_date")
+
+    def pull_date_table(column: SQL.Column): SQL.Table =
+      SQL.Table("isabelle_build_log_" + column.name, List(column, pull_date),
+        view = // for PostgreSQL
+          "SELECT " + column.sql + ", min(" + Prop.build_start.sql + ") AS " + pull_date.sql +
+          " FROM " + Meta_Info.table.sql +
+          " WHERE " + column.sql + " IS NOT NULL AND " + Prop.build_start.sql + "IS NOT NULL" +
+          " GROUP BY " + column.sql)
+
+    val isabelle_version_table = pull_date_table(Prop.isabelle_version)
+    val afp_version_table = pull_date_table(Prop.afp_version)
+
+
     /* main operations */
 
-    def update(store: Store, db: SQL.Database, dirs: List[Path],
-      ml_statistics: Boolean = false, full_view: Boolean = false)
+    def update(store: Store, db: SQL.Database, dirs: List[Path], ml_statistics: Boolean = false)
     {
-      val files = Log_File.find_files(dirs)
-      store.write_info(db, files, ml_statistics = ml_statistics)
-      if (full_view) db.create_view(Database.full_view)
+      store.write_info(db, Log_File.find_files(dirs), ml_statistics = ml_statistics)
+
+      if (db.isInstanceOf[PostgreSQL.Database]) {
+        List(full_table, isabelle_version_table, afp_version_table)
+          .foreach(db.create_view(_))
+      }
     }
   }
 }
diff -r 2229276a1f99 -r d1e9155b894c src/Pure/Admin/isabelle_cronjob.scala
--- a/src/Pure/Admin/isabelle_cronjob.scala	Tue May 02 23:21:53 2017 +0200
+++ b/src/Pure/Admin/isabelle_cronjob.scala	Tue May 02 23:31:00 2017 +0200
@@ -149,7 +149,7 @@
   {
     val store = Build_Log.store(options)
     using(store.open_database())(db =>
-      Build_Log.Database.update(store, db, database_dirs, ml_statistics = true, full_view = true))
+      Build_Log.Database.update(store, db, database_dirs, ml_statistics = true))
   }