partkeepr

commit 8ae196333b481d8487ce288a919fc0668e07b03d
parent c0a3d3ec91dbc61b0b3035d384fd263989d38c00
Author: Timo A. Hummel <timo@netraver.de>
Date:   Sun, 12 Jun 2011 11:06:48 +0200

Removed fake distributors, migrating old ones from the database

Diffstat:
M
testing/SetupDatabase.php
 | 
23
+++++++++++------------

1 file changed, 11 insertions(+), 12 deletions(-)
diff --git a/testing/SetupDatabase.php b/testing/SetupDatabase.php
@@ -220,14 +220,6 @@ foreach ($data as $mfgname => $logos) {
 	
 	PartDB2::getEM()->persist($manufacturer);
 	$aManufacturers[] = $manufacturer;
-	/* Temporary: Add fake distributors */
-	
-	$distributor = new Distributor();
-	$distributor->setName("Distributor ".$mfgname);
-	
-	PartDB2::getEM()->persist($distributor);
-	
-	$aDistributors[] = $distributor;
 	
 	foreach ($logos as $logo) {
 		$mfglogo = new ManufacturerICLogo();
@@ -240,6 +232,15 @@ foreach ($data as $mfgname => $logos) {
 
 PartDB2::getEM()->flush();
 
+$r = mysql_query("SELECT * FROM suppliers");
+while ($supplier = mysql_fetch_assoc($r)) {
+	$distributor = new Distributor();
+	$distributor->setName($supplier["name"]);
+	
+	PartDB2::getEM()->persist($distributor);
+	$aDistributors[$supplier["id"]] = $distributor;
+}
+
 $r = mysql_query("SELECT * FROM parts");
 
 $aRandomUnitNames = array("Spannung", "Strom", "Leitfähigkeit", "Viskosität", "Nessis");
@@ -260,10 +261,8 @@ while ($part = mysql_fetch_assoc($r)) {
 		$oPart->getManufacturers()->add(new PartManufacturer($oPart, $aManufacturers[$randomManufacturer]));
 	}
 	
-	for ($i=0;$i<rand(0,15);$i++) {
-		$randomDistributor = rand(0, count($aDistributors)-1);
-		$oPart->getDistributors()->add(new PartDistributor($oPart, $aDistributors[$randomDistributor]));
-	}
+	$oPart->getDistributors()->add(new PartDistributor($oPart, $aDistributors[$part["id_supplier"]]));
+	
 	//echo "Migrating part ".sprintf("%-40s", $part["name"])."\r";
 	PartDB2::getEM()->persist($oPart);