public function testQueryDao()
{
// Use Query DAO to insert a new query.
$dao = new CreateQueryDAO();
if ($dao == null) {
echo "dao is null";
}
$dao->initTransaction();
$queryID = $dao->persistNewQuery('title', 1);
if ($queryID == null) {
echo "queryID is null";
}
$dao->persistQuestion('text');
$dao->persistAnswer('q0', 0);
$dao->persistAnswer('q1', 1);
$dao->persistAnswer('q2', 2);
$dao->endTransaction();
// Check DB contains new query with correct values.
$this->initDBConnection();
$result = $this->doAssertedQuery('SELECT * FROM queries WHERE id=' . $queryID, 1);
$row = mysql_fetch_assoc($result);
if ('title' != $row['title']) {
echo "title is wrong";
}
mysql_free_result($result);
$result = $this->doAssertedQuery('SELECT * FROM question WHERE FK_queries=' . $queryID, 1);
$row = mysql_fetch_assoc($result);
if ('text' != $row['text']) {
echo "text is wrong";
}
$questionID = $row['id'];
mysql_free_result($result);
$result = $this->doAssertedQuery('SELECT * FROM qoption WHERE FK_question=' . $questionID, 3);
$answers = array();
for ($i = 0; $i < 3; $i++) {
$row = mysql_fetch_assoc($result);
$answers[$i] = $row['id'];
if ('q' . $i != $row['text']) {
echo 'q' . $i . " not equals " . $row['text'];
}
if ($i != $row['number']) {
echo $i . " not equals " . $row['number'];
}
}
mysql_free_result($result);
$this->closeDBConnection();
// Delete query using Query DAO
$dao->deleteQueryByID($queryID);
$this->initDBConnection();
// Verify querry has been deleted
$result = $this->doAssertedQuery('SELECT * FROM queries WHERE id=' . $queryID, 0);
mysql_free_result($result);
$this->closeDBConnection();
}
$dao->initTransaction();
$dao->persistNewQuery($queryName, $uid);
for ($i = 0; $i < $qlength; $i++) {
$dao->persistQuestion($_POST['questionname' . $i]);
switch ($_POST['answers' . $i]) {
case 'yesno':
$dao->persistAnswer("Yes", 0);
$dao->persistAnswer("No", 1);
break;
case 'lml':
$dao->persistAnswer("A lot", 0);
$dao->persistAnswer("Medium", 1);
$dao->persistAnswer("Low", 2);
break;
case 'mf':
$dao->persistAnswer("Male", 0);
$dao->persistAnswer("Female", 1);
break;
case 'please':
$dao->persistAnswer("Yes please!", 0);
$dao->persistAnswer("No thanks!", 1);
break;
}
}
for ($i = 0; $i < $filterslength; $i++) {
$cat = $_POST['filtercat' . $i];
$pop = User::indexOfSelectValue($cat, $_POST['filterpop' . $i]);
$dao->persistSegment($cat, $pop);
}
$dao->endTransaction();
header("Location: /Qnet/target/classes/php/qnet/ui/newquery.php?commit=ok");
