public function testCacheSchemaMetaData()
{
$stmt = $this->database->prepare('CREATE TABLE "test" ("name" TEXT)');
$result = $stmt->execute();
$cacheFile = sys_get_temp_dir() . '/schema.cache';
$api = new RestApi($this->database, $cacheFile);
$resources = $api->listResources();
$schemaMetaData = '{"test":{"name":"test","pk":null,"columns":["name"]}}';
$this->assertEquals($schemaMetaData, file_get_contents($cacheFile));
// this loads the schema from the cache
$api = new RestApi($this->database, $cacheFile);
$resources = $api->listResources();
}
