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

@unlink("test.sqlite");

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

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

// test insert
$sql = "INSERT INTO test (id) VALUES ('aaa')";
$res = sql_query($db, $sql);
if ($res === FALSE) {
	echo "Cannot insert!";
	exit(1);
}

// test insert with the same key
$sql = "INSERT INTO test (id) VALUES ('aaa')";
$res = @sql_query($db, $sql);
if ($res !== FALSE) {
	echo "I can do double insert!";
	exit(1);
}

// test delete
$sql = "DELETE FROM test WHERE id = 'aaa'";
$res = sql_query($db, $sql);
if ($res === FALSE) {
	echo "Cannot delete!";
	exit(1);
}

sql_close($db);

@unlink("test.sqlite");

?>