X-Git-Url: http://git.pjr.cc/?p=goDBhammer.git;a=blobdiff_plain;f=src%2Fdbconnector.go;h=637aa84be802c2fd854b7b16a69521346274cf61;hp=83dc6497bb583043469f98e9af41892691babd14;hb=ff6679f750e301016b3e070d7d6ffa41048004b8;hpb=ea18014aa62ab7de47d63b4d123d52230eb96c53

diff --git a/src/dbconnector.go b/src/dbconnector.go
index 83dc649..637aa84 100644
--- a/src/dbconnector.go
+++ b/src/dbconnector.go
@@ -5,6 +5,7 @@ import (
 	"./dbibridge";
 	"time";
 	"rand";
+	"fmt";
 )
 
 type DBConnector struct {
@@ -77,16 +78,32 @@ func DBSetup(dbtype string, host string, username string, password string, datab
 	        I_NAME CHARACTER(24), \
 	        I_PRICE integer, \
 	        I_DATA CHARACTER(50), \
-	        PRIMARY KEY(I_ID))");		
+	        PRIMARY KEY(I_ID))");
+		whst := fmt.Sprintf("insert into WAREHOUSE values ( %d, '%s', '%s', '%s', '%s', '%s', '%s', %d, %d)", 10, CreateRandomText(9),
+			CreateRandomText(19), CreateRandomText(19), CreateRandomText(19), CreateRandomText(2), CreateRandomText(8), rand.Int()%50, rand.Int()%100);
+	   dbibridge.ExecSQL(Dbconn, whst);
 	}
 	
-	for i := 1; i < 100; i += 10 {
-		time.Sleep(1000000000);
-		comout <- i;
-	}
-	comout <- 100;
 	
-	// now we need to actually create data in the tables...
+	// now we need to actually create data in the tables... this is not how it was meant to be originally, but it'll do
+	// there is dbmult * warehouse
+	// there are 20 districts for each warehosuse
+	// there are 50000 items in each district
+	for i := 0; i < datamult; i++ {
+		whst := fmt.Sprintf("insert into WAREHOUSE values ( %d, '%s', '%s', '%s', '%s', '%s', '%s', %d, %d)", i, CreateRandomText(9),
+			CreateRandomText(19), CreateRandomText(19), CreateRandomText(19), CreateRandomText(2), CreateRandomText(8), rand.Int()%50, rand.Int()%100);
+		dbibridge.ExecSQL(Dbconn, whst); 
+		for j:=0; j < 1; j++ {
+			dtst := fmt.Sprintf("insert into DISTRICT values ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, %d)", j, i, 
+				CreateRandomText(9), CreateRandomText(19), CreateRandomText(19), CreateRandomText(19), CreateRandomText(2), CreateRandomText(8), rand.Int()%50, rand.Int()%100, j+1);
+			dbibridge.ExecSQL(Dbconn, dtst);
+			for k:=0; k<1; k++ {
+				itst := fmt.Sprintf("insert into ITEM values ( %d, %d, '%s', %d, '%s')", i*j*k, rand.Int()%50000, 
+					CreateRandomText(23), rand.Int()%1000000, CreateRandomText(49));
+				dbibridge.ExecSQL(Dbconn, itst);
+			}
+		}
+	}
 	
 
 	dbibridge.DBIDisconnect(Dbconn);