/**
* @url DELETE /?documents/$id
*/
function deleteDocument($id = null)
{
$db = new DocumentsDatabase();
$db->deleteDocument($id);
$upload_dir = DIR_RECORD_FILES . '/' . $id;
deleteDirectory($upload_dir);
}
$db->insertDocument(array("id" => null, "title" => "Madame Bovary", "author" => "Flaubert Gustave", "topic_id" => 3, "description" => "Etiam vulputate neque turpis, vel malesuada tellus commodo ut. Proin gravida augue odio,", "file" => "bovary.pdf"));
$db->insertDocument(array("id" => null, "title" => "To be deleted", "author" => "Noone", "file" => "bovary.pdf"));
// list all documents
echo "<h2>ALL DOCUMENTS</h2>";
$rows = $db->listDocuments();
var_dump($rows);
// list all topics
echo "<h2>ALL TOPICS</h2>";
$rows = $db->listTopics();
var_dump($rows);
echo "<h2>DELETE TOPIC</h2>";
$db->deleteTopic(4);
$rows = $db->listTopics();
var_dump($rows);
echo "<h2>DELETED 5th DOCUMENT</h2>";
$db->deleteDocument(5);
$rows = $db->listDocuments();
var_dump($rows);
echo "<h2>GET THIRD DOCUMENT</h2>";
$rows = $db->getDocument(3);
var_dump($rows);
echo "<h2>CHANGE TITLE</h2>";
$db->insertDocument(array("id" => 1, "title" => "The Hitchhikers Guide to the Galaxy (2)", "author" => "Adams, Douglas", "description" => "Aenean varius quam at quam convallis, id porta nulla luctus. Nullam a tincidunt odio, sit amet mollis elit. Pellentesque et tristique enim. Aliquam vel dolor et lectus venenatis varius at aliquam nulla. Integer vehicula nibh justo, aliquet feugiat ex maximus et. Curabitur ex velit, commodo", "keywords" => "scifi fantasy comedy", "topic_id" => 42, "published" => 1979, "language" => "German", "file" => "hitchhiker.pdf"));
$rows = $db->getDocument(1);
var_dump($rows);
echo "<h1>SETTINGS DB</h1>";
$db = new SettingsDatabase();
$db->create();
echo "<h2>GET SETTINGS</h2>";
$rows = $db->getSettings();
var_dump($rows);
