/**
*
* @return bool|string
*/
public function queryArticleDownloadESD()
{
if (!method_exists($this, 'getDownloadEsdSelect')) {
return false;
}
$sql = $this->getDownloadEsdSelect();
return $this->db->query($sql);
}
/**
* Writes a brand new Question to the database
*
* @param ? $instructions
* @param ? $question_data
* @param ? $correct_answer
* @param ? $vQuestion
* @return null|Model_Quiz_GeneratedQuestion
*/
public static function fromScratch($instructions, $question_data, $correct_answer, $vQuestion)
{
Model_Shell_Debug::getInstance()->log("Writing question to the database", __METHOD__);
$db = Zend_Registry::get("db");
$sql = "INSERT INTO generated_questions(generated_id,instructions,question_data,correct_answer,question_basequestion_id) VALUES(NULL, " . $db->quote($instructions) . "," . $db->quote($question_data) . "," . $db->quote($correct_answer) . "," . $db->quote($vQuestion->getID()) . ")";
Model_Shell_Debug::getInstance()->log($sql);
$db->beginTransaction();
$db->query($sql);
//Now find the appropriate entry in the database
// A safe (default) assumption for this is a query that looks for everything you just put in.
$last_id = $db->lastInsertId();
$db->commit();
return Model_Quiz_GeneratedQuestion::fromID($last_id);
$sql = "SELECT generated_id FROM generated_questions WHERE instructions=" . $db->quote($instructions) . " AND question_data=" . $db->quote($question_data) . " AND correct_answer=" . $db->quote($correct_answer) . " AND question_basequestion_id=" . $db->quote($vQuestion->getID());
$result = $db->query($sql);
$row = $result->fetch();
if ($row['generated_id'] != null) {
return Model_Quiz_GeneratedQuestion::fromID($row['generated_id']);
} else {
return null;
//Something didn't happen
}
}
