Bug 578067 - Add progress messages to dbmaintenance

Change-Id: Ic5695bfb40c269c9152b74119737fe387cfc2a62
Signed-off-by: Kit Lo <kitlo@us.ibm.com>

classes/export/dbmaintenance_15min.php

diff --git a/classes/export/dbmaintenance_15min.php b/classes/export/dbmaintenance_15min.php
index 23d448a..c114413 100644
--- a/classes/export/dbmaintenance_15min.php
+++ b/classes/export/dbmaintenance_15min.php
@@ -30,11 +30,12 @@
 	$dbc = new DBConnection();
 	$dbh = $dbc->connect();
 
-
-	# refresh the scoreboard -- not every 15 minutes!
+	# refresh scoreboard and file progress -- only periodically!
 	$forceRefresh = strcasecmp(getenv("FORCE_BABEL_REFRESH"), "true");
 	if(rand(1, 100) < 25 || $forceRefresh) {
 		require_once(dirname(__FILE__) . "/../system/scoreboard.class.php");
+		echo date("h:i:sa") . "\n";
+		echo "Start refreshing scoreboard...\n";
 		$sb = new Scoreboard();
 		$sb->refresh($forceRefresh);
 		
@@ -51,8 +52,11 @@
 GROUP BY f.file_id, l.language_id
 HAVING translate_percent > 0";
 		$rs = mysqli_query($dbh, $sql);
+		echo date("h:i:sa") . "\n";
+		echo "Start refreshing file progress...\n";
 		while($myrow = mysqli_fetch_assoc($rs)) {
-			mysqli_query($dbh, "INSERT INTO file_progress (file_id, language_id, pct_complete)
+		    echo "\tRefreshing file_id:" . $myrow['file_id'] . " language_id:" . $myrow['language_id'] . "...\n";
+		    mysqli_query($dbh, "INSERT INTO file_progress (file_id, language_id, pct_complete)
 			VALUES(" . $myrow['file_id'] . ", " . $myrow['language_id'] . ", " . $myrow['translate_percent'] . ")
 			ON DUPLICATE KEY UPDATE pct_complete=" . $myrow['translate_percent']);
 		}
@@ -62,6 +66,8 @@
 	# Update project/version/language progress 
 	$sql = "SELECT * FROM project_progress WHERE is_stale";
 	$rs = mysqli_query($dbh, $sql);
+	echo date("h:i:sa") . "\n";
+	echo "Start refreshing project/version/language progress...\n";
 	while($myrow = mysqli_fetch_assoc($rs)) {
 		mysqli_query($dbh, "LOCK TABLES project_progress WRITE, 
 			project_versions AS v READ, 
@@ -93,6 +99,7 @@
 					        v.project_id = '" . addslashes($myrow['project_id']) . "'
 					        AND v.version = '" . addslashes($myrow['version']) . "'
 					 )";
+		echo "\tRefreshing project_id:" . addslashes($myrow['project_id']) . " version:" . addslashes($myrow['version']) . " language_id:" . $myrow['language_id'] . "...\n";
 		mysqli_query($dbh, $sql);
 		echo mysqli_error($dbh);
 		
@@ -100,4 +107,6 @@
 		mysqli_query($dbh, "UNLOCK TABLES");
 		sleep(2);
 	}
+	echo date("h:i:sa") . "\n";
+	echo "Done\n";
 ?>