[CS-Project-svn_notify] SF.net SVN: cs-project: [892] trunk/1.2

[<cra...@us...>]

Revision: 892
          http://cs-project.svn.sourceforge.net/cs-project/?rev=892&view=rev
Author:   crazedsanity
Date:     2008-05-12 15:35:11 -0700 (Mon, 12 May 2008)

Log Message:
-----------
Fix issue #143.

Modified Paths:
--------------
    trunk/1.2/upgrade/upgrade.xml

Added Paths:
-----------
    trunk/1.2/docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql
    trunk/1.2/upgrade/upgradeTo1.2.0-ALPHA7.php

Added: trunk/1.2/docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql
===================================================================
--- trunk/1.2/docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql	                        (rev 0)
+++ trunk/1.2/docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql	2008-05-12 22:35:11 UTC (rev 892)
@@ -0,0 +1,11 @@
+--
+-- SVN INFORMATION:::
+-- 
+-- SVN Signature::::::::: $Id$
+-- Last Committted Date:: $Date$
+-- Last Committed Path::: $HeadURL$
+--
+
+
+delete from user_group_table WHERE user_group_id NOT IN (select distinct ON (uid, group_id) user_group_id FROM user_group_table);
+CREATE UNIQUE INDEX user_group_table_uid_group_id_uidx ON user_group_table USING btree (uid, group_id);
\ No newline at end of file


Property changes on: trunk/1.2/docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql
___________________________________________________________________
Name: svn:keywords
   + Id
HeadURL
Date
Revision
Author
Name: svn:eol-style
   + native

Modified: trunk/1.2/upgrade/upgrade.xml
===================================================================
--- trunk/1.2/upgrade/upgrade.xml	2008-05-12 22:18:42 UTC (rev 891)
+++ trunk/1.2/upgrade/upgrade.xml	2008-05-12 22:35:11 UTC (rev 892)
@@ -26,4 +26,12 @@
 			<call_method>run_upgrade</call_method>
 		</v1.2.0-ALPHA3>
 	</matching>
+	<matching>
+		<v1.2.0-ALPHA6>
+			<target_version>1.2.0-ALPHA7</target_version>
+			<script_name>upgradeTo1.2.0-ALPHA7.php</script_name>
+			<class_name>upgrade_to_1_2_0_ALPHA7</class_name>
+			<call_method>run_upgrade</call_method>
+		</v1.2.0-ALPHA6>
+	</matching>
 </upgrade>

Copied: trunk/1.2/upgrade/upgradeTo1.2.0-ALPHA7.php (from rev 888, trunk/1.2/upgrade/upgradeTo1.2.0-ALPHA4.php)
===================================================================
--- trunk/1.2/upgrade/upgradeTo1.2.0-ALPHA7.php	                        (rev 0)
+++ trunk/1.2/upgrade/upgradeTo1.2.0-ALPHA7.php	2008-05-12 22:35:11 UTC (rev 892)
@@ -0,0 +1,54 @@
+<?php
+
+class upgrade_to_1_2_0_ALPHA7 extends dbAbstract {
+	
+	private $logsObj;
+	
+	//=========================================================================
+	public function __construct(cs_phpDB &$db) {
+		if(!$db->is_connected()) {
+			throw new exception(__METHOD__ .": database is not connected");
+		}
+		$this->db = $db;
+		
+		$this->logsObj = new logsClass($this->db, 'Upgrade');
+		
+		$this->gfObj = new cs_globalFunctions;
+		$this->gfObj->debugPrintOpt = 1;
+	}//end __construct()
+	//=========================================================================
+	
+	
+	
+	//=========================================================================
+	public function run_upgrade() {
+		
+		$this->db->beginTrans(__METHOD__);
+		
+		
+		$this->run_schema_changes();
+		
+		
+		$this->db->commitTrans(__METHOD__);
+		
+		return('Upgrade complete');
+	}//end run_upgrade()
+	//=========================================================================
+	
+	
+	
+	//=========================================================================
+	private function run_schema_changes() {
+		
+		$this->gfObj->debug_print(__METHOD__ .": running SQL file...");
+		$this->run_sql_file(dirname(__FILE__) .'/../docs/sql/upgrades/upgradeTo1.2.0-ALPHA7.sql');
+		
+		$details = "Executed SQL file, '". $this->lastSQLFile ."'.  Encoded contents::: ". 
+			base64_encode($this->fsObj->read($this->lastSQLFile));
+		$this->logsObj->log_by_class($details, 'system');
+		
+	}//end run_schema_changes()
+	//=========================================================================
+}
+
+?>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.