<?php
$INC = "../inc";
require_once($INC . "/keys.inc.php");

@unlink("keys.sqlite");

$db = sql_open("sqlite:keys.sqlite");
if ($db === FALSE) {
	echo "Cannot create a database (" . sql_error() . ")!";
	exit(1);
}

// state table
$sql = "CREATE TABLE state (var TEXT PRIMARY KEY, value TEXT)";
$res = sql_query($db, $sql);
if ($res === FALSE) {
	echo "Cannot create state table!";
	exit(1);
}

// keys table
$sql = "CREATE TABLE keys (key_id INT PRIMARY KEY, itime INT, uid INT, key TEXT)";
$res = sql_query($db, $sql);
if ($res === FALSE) {
	echo "Cannot create keys table!";
	exit(1);
}

// insert a key
$uid = 1;
$key = "aaa'bbb'ccc";
$key_id = keys_add($db, $uid, $key);
if ($key_id === FALSE) {
	echo "Cannot add key!";
	exit(1);
}

// delete a key
$uid = 1;
$key = "aaa'bbb'ccc";
$r = keys_remove($db, $uid, $key_id);
if ($r === FALSE) {
	echo "Cannot remove key (" . keys_error() . ")!";
	exit(1);
}

// test key file generation
$r = keys_regen($db, "afile.txt");
if ($r === FALSE) {
	echo "Cannot regenerate keys (" . keys_error() . ")!";
	exit(1);
}
@unlink("afile.txt");

sql_close($db);

@unlink("keys.sqlite");

?>