<?php

if (isset($db))
  return;

class MyDB extends SQLite3 {
  function __construct() {
    parent::__construct('/srv/http/vhosts/eckner.net/colocation.eckner.net/backend/sqlite.db');
  }
  function exec($query) {
    $result = parent::exec($query);
    if (!$result)
      die();
    return $result;
  }
  function query($query) {
    $result = parent::query($query);
    if (!$result)
      die();
    return $result;
  }
  function prepare($query) {
    $result = parent::prepare($query);
    if (!$result)
      die();
    return $result;
  }
  function add_key() {
    $stm = prepare('INSERT INTO keys (key) VALUES (:key)');
    $stm -> bindValue('key', bin2hex(random_bytes(64)));
    $stm -> execute();
    $key_id = $db -> lastInsertRowID();
    $stm -> close();
    return $key_id;
  }
}

$db = new MyDB();
if(!$db) {
  echo $db->lastErrorMsg();
  die();
}