/src/php/setup/add_document_counts.php

<?php
/* Copyright 2012 Aditi Muralidharan. See the file "LICENSE" for the full license governing this code. */

include_once '../util.php';
$wordseer_instance = getGetParam('instance');
$path = '../../../instances/'.$wordseer_instance.'/config.php';
include_once $path;

echo "<br> Updating tables to add document counts...<br>";

$sql = "set sql_safe_updates = 0";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "alter table `word` add column			 
(`document_count` int default 0);";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "update word, 
	(select word_id, count(distinct document_id) as count 
	 from sentence_xref_word 
	 group by word_id) as COUNTS
set document_count = COUNTS.count
where word.id = COUNTS.word_id;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "repair table word;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "alter table `dependency_xref_sentence` add column 
(`document_id` int default 0);";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "update dependency_xref_sentence, sentence 
set dependency_xref_sentence.document_id = sentence.document_id
where sentence_id = sentence.id;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "repair table dependency_xref_sentence;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "alter table `sequence_xref_sentence` add column
(`document_id` int default 0);";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "update sequence_xref_sentence, sentence 
set sequence_xref_sentence.document_id = sentence.document_id
where sentence_id = sentence.id;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "repair table sequence_xref_sentence";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "alter table `sequence` add column			 
(`document_count` int default 0);";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "update sequence, 
	(select sequence_id, count(distinct document_id) as count 
	 from sequence_xref_sentence 
	 group by sequence_id) as COUNTS
set document_count = COUNTS.count
where sequence.id = COUNTS.sequence_id;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "repair table sequence;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");


$sql = "drop table `main_metadata_counts_2`;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "alter table `cached_filtered_sent_ids` add column 
(`document_id` int default 0);";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

$sql = "repair table cached_filtered_sent_ids;";
echo "<br>Executing query:<br>$sql<br>";
mysql_query($sql) or die(mysql_error()."<br> on query:<br>$sql<br>");

?>