$value = new stdclass();
$response = $storage->set($storageKey, json_encode($value));
//BEGIN: insert oauth record
$authproxyUrl = sprintf('%s/authproxy/api.php', 'http://localhost/~eldridge');
$providerName = 'yahoo.com';
$consumerKey = 'sjdfkjsjdlkfjl';
$consumerSecret = 'jljsldjfjsldjfljsjdf';
$callbackUrl = 'http://example.com';
$params = array('action' => 'insert', 'hash' => sha1($users[$userId] . $userId), 'userId' => $userId, 'type' => 'oauth', 'providerName' => $providerName, 'consumerKey' => $consumerKey, 'consumerSecret' => $consumerSecret, 'callbackUrl' => $callbackUrl);
$response = json_decode($curl->post($authproxyUrl, $params)->body);
assert('success' == $response->status);
assert(isset($response->recordId) && !empty($response->recordId));
//audit service record in db
$recordId = $response->recordId;
$storageKey = sprintf('authproxy-services-%s-%s', $userId, $recordId);
$response = $storage->get($storageKey);
$value = json_decode($response);
assert($value->providerName == $providerName);
assert($value->consumerKey == $consumerKey);
assert($value->consumerSecret == $consumerSecret);
assert($value->callbackUrl == $callbackUrl);
//audit user record in db
$storageKey = sprintf('authproxy-users-%s', $userId);
$response = $storage->get($storageKey);
$value = json_decode($response);
assert(in_array($recordId, $value->recordIds));
//END: insert oauth record
//get oauth record
$url = sprintf('%s/authproxy/api.php', 'http://localhost/~eldridge');
$params = array('hash' => sha1($users[$userId] . $userId), 'userId' => $userId, 'type' => 'oauth', 'recordId' => $recordId);
$response = json_decode($curl->get($url, $params)->body);
<?php
require '../interface.php';
require 'sqlite.php';
$tableName = 'footable';
$store = new SQLiteStore($tableName);
//set up
//$store->db->query("DROP TABLE $tableName");
$store->db->query("CREATE TABLE {$tableName} (key varchar(100) PRIMARY KEY, value varchar(1000), created timestamp(20))", $error);
//get non-existent key
$key = 'asd123';
$value = $store->get($key);
assert(false === $value);
//test insertion
$value = 'bar';
$store->set($key, $value);
$result = $store->get($key);
assert($value == $result);
//test replace
$value = 'baz';
$store->set($key, $value);
$result = $store->get($key);
assert($value == $result);
//test json insertion
$obj = new stdclass();
$obj->arr = array('this' => 'that');
$value = json_encode($obj);
$store->set($key, $value);
$result = $store->get($key);
assert($value == $result);
//clean up
