$storage = new SQLiteStore($netdbKey);
// $storage->db->query("DROP TABLE $netdbKey");
// $storage->db->query(sprintf("CREATE TABLE %s (key varchar(100) PRIMARY KEY, value varchar(1000), created timestamp(20))", $netdbKey), $error);
switch ($input['action']) {
case 'insert':
//format for storage
$obj = new stdclass();
$obj->providerName = $input['providerName'];
$obj->consumerKey = $input['consumerKey'];
$obj->consumerSecret = $input['consumerSecret'];
$obj->callbackUrl = $input['callbackUrl'];
$storageValue = json_encode($obj);
$recordId = sha1($storageValue . time());
//add user id to record id just in case
$storageKey = sprintf('authproxy-services-%s-%s', $input['userId'], $recordId);
$response = $storage->set($storageKey, $storageValue);
//add record id to credentials array in meta for user
$storageKey = sprintf('authproxy-users-%s', $input['userId']);
$response = $storage->get($storageKey);
//sanity check
if (!$response) {
$response = array('status' => 'error', 'debug' => 'there is no record for user ' . $input['userId']);
break;
}
$value = json_decode($response);
$value->recordIds[] = $recordId;
try {
$storage->set($storageKey, json_encode($value));
$response = array('status' => 'success', 'recordId' => $recordId, 'debug' => print_r($value, true));
} catch (Exception $e) {
$response = array('status' => 'error', 'debug' => print_r($e, true));
//http://github.com/shuber/curl
require '../curl/curl.php';
$curl = new Curl();
//BEGIN: set up
//set up storage for indipendant auditing
require '../netdb/sdk.php';
require '../kvstore/interface.php';
// require '../kvstore/netbd/netdb.php';
// $storage = new NetDBStore(KeyDB::$netdb_key, KeyDB::$netdb_secret);
require '../kvstore/sqlite/sqlite.php';
$storage = new SQLiteStore($netdbKey);
//create user
$userId = '';
$storageKey = sprintf('authproxy-users-%s', $userId);
$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);
<?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
