From 688262d611bae71262304d59252123e73c10f341 Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Mon, 16 Aug 2010 19:15:19 +0000
Subject: Add option to use a temporary view instead of a table to reduce WAL
 churn during SqlMerge

---
 gentoobrowse/console/bugassociate.xml  |  2 +-
 gentoobrowse/console/packageimport.xml | 14 +++++++-------
 2 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml
index b026205..626638e 100644
--- a/gentoobrowse/console/bugassociate.xml
+++ b/gentoobrowse/console/bugassociate.xml
@@ -2,7 +2,7 @@
 <bugassoc name="bugassociate" xmlns:xi="http://www.w3.org/2001/XInclude"
 		xmlns:project2="http://project2.randomdan.homeip.net">
 	<xi:include href="../datasources/postgres.xml" />
-	<project2:sqlmerge name="bugbind" datasource="postgres" targettable="package_bugs">
+	<project2:sqlmerge name="bugbind" datasource="postgres" targettable="package_bugs" useview="yes">
 		<sql>
 			SELECT b.bugid, p.packageid
 			FROM bugs b, packages p, categories c
diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml
index 84872ed..12bca02 100644
--- a/gentoobrowse/console/packageimport.xml
+++ b/gentoobrowse/console/packageimport.xml
@@ -3,14 +3,14 @@
 		xmlns:project2="http://project2.randomdan.homeip.net">
 	<xi:include href="../datasources/postgres.xml" />
 
-	<project2:sqlmerge name="categories" datasource="postgres" targettable="categories">
+	<project2:sqlmerge name="categories" datasource="postgres" targettable="categories" useview="yes">
 		<sql>SELECT DISTINCT (REGEXP_MATCHES(filename, '^[^/]+'))[1] AS name FROM files WHERE filetypeid = 1</sql>
 		<columns>
 			<column key="true">name</column>
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="packages" datasource="postgres" targettable="packages">
+	<project2:sqlmerge name="packages" datasource="postgres" targettable="packages" useview="yes">
 		<sql>
 			SELECT c.categoryid, f.name, fc.content AS description FROM (
 				SELECT MAX(fileid) AS fileid,
@@ -30,7 +30,7 @@
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="ebuilds" datasource="postgres" targettable="ebuilds">
+	<project2:sqlmerge name="ebuilds" datasource="postgres" targettable="ebuilds" useview="yes">
 		<sql>
 			SELECT packageid, version, fileid AS ebuildid, ebuildversion_constructor(version) AS versioninst
 			FROM ( SELECT f.fileid,
@@ -51,7 +51,7 @@
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="archs" datasource="postgres" targettable="ebuild_archs">
+	<project2:sqlmerge name="archs" datasource="postgres" targettable="ebuild_archs" useview="yes">
 		<sql>
 			SELECT DISTINCT f.fileid AS ebuildid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS arch
 			FROM filecache fc, files f
@@ -65,7 +65,7 @@
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="uses" datasource="postgres" targettable="ebuild_uses">
+	<project2:sqlmerge name="uses" datasource="postgres" targettable="ebuild_uses" useview="yes">
 		<sql>
 			SELECT DISTINCT fc.fileid AS ebuildid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS use
 			FROM filecache fc, files f
@@ -79,7 +79,7 @@
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="urls" datasource="postgres" targettable="package_urls">
+	<project2:sqlmerge name="urls" datasource="postgres" targettable="package_urls" useview="yes">
 		<sql>
 			SELECT DISTINCT e.packageid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS url
 			FROM filecache fc, ebuilds e, files f
@@ -94,7 +94,7 @@
 		</columns>
 	</project2:sqlmerge>
 
-	<project2:sqlmerge name="deps" datasource="postgres" targettable="ebuild_deps">
+	<project2:sqlmerge name="deps" datasource="postgres" targettable="ebuild_deps" useview="yes">
 		<sql>
 			SELECT fileid AS ebuildid, packageid, COALESCE(slot, '') AS slot, COALESCE(op, '') AS op,
 				COALESCE(versionspec, '') AS versionspec, COALESCE(flags, '') AS flags
-- 
cgit v1.2.3