/**
  *
  * @url POST /?password
  */
 function password()
 {
     if (isset($_POST['password'])) {
         $db = new SettingsDatabase();
         $result = $db->updatePassword($_POST['password']);
         return "password updated";
     }
     throw new RestException(400, "No password submitted");
 }
// 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);
echo "<h2>CHANGE SETTINGS</h2>";
$db->updateSettings(array("about_text" => "-", "footer_text" => "Powered By OfflineLibrary.", "logo" => "images/logo.png", "header_color" => 0, "content_color" => 0));
$rows = $db->getSettings();
var_dump($rows);
?>
</body>