<?php
require __DIR__ . '/../vendor/autoload.php';
echo '<h1>MySQL</h1>';
$dbInstance = \Simplon\Db\DbInstance::MySQL('localhost', 'test', 'rootuser', 'rootuser');
$query = 'SELECT * FROM foobar WHERE ekey = :key';
$conds = array('key' => 'BB');
// ############################################
echo '<h3>Straight Shizzle</h3>';
$results = $dbInstance->FetchAll($query, $conds);
var_dump($results);
// ############################################
echo '<h3>SqlManager w/ SqlQueryBuilder</h3>';
$sqlManager = new \Simplon\Db\SqlManager($dbInstance);
// query builder
$sqlQuery = (new \Simplon\Db\SqlQueryBuilder())->setQuery($query)->setConditions($conds);
// query db
$results = $sqlManager->fetchAll($sqlQuery);
var_dump($results);
<?php
require __DIR__ . '/../vendor/autoload.php';
console('======================================');
console('REDIS (c-client phpiredis) testing shizzle');
console('======================================');
// ############################################
$redis = \Simplon\Db\DbInstance::Redis('localhost', 1);
$redisManager = new \Simplon\Db\RedisManager($redis);
$redisManager->getRedisInstance()->dbFlush(TRUE);
$runs = 3;
$sets = 1000;
// ############################################
console('+ Writing <strings> WITHOUT pipeline (runs=' . $runs . ', sets=' . $sets . ')');
$summary = 0;
for ($t = 1; $t <= $runs; $t++) {
$start = microtime(TRUE);
for ($i = 0; $i < $sets; $i++) {
$response = $redisManager->getRedisInstance()->stringSet('string:pipe:OFF:' . $t . '_' . $i, 'hello world ' . $i);
}
$finish = microtime(TRUE);
$timeTaken = $finish - $start;
$summary += $timeTaken;
console('time taken: ' . $timeTaken . ' seconds');
}
$summaryPipeOff = $summary / $runs;
console('avg. time taken: ' . $summaryPipeOff . ' seconds');
console('--------------------------------------');
// ++++++++++++++++++++++++++++++++++++++++++++
console('+ Writing <strings> WITH pipeline (runs=' . $runs . ', sets=' . $sets . ')');
$summary = 0;
* @param $value
*
* @return UserCouchDao
*/
public function setUpdated($value)
{
$this->_setByKey(UserCouchDao::FIELD_UPDATED, $value);
return $this;
}
public function getUpdated()
{
return $this->_getByKey(UserCouchDao::FIELD_UPDATED);
}
}
// ##########################################
$instance = \Simplon\Db\DbInstance::Couchbase('127.0.0.1', '8091', 'rootuser', 'rootuser', 'beatguide');
$manager = new \Simplon\Db\CouchbaseManager($instance);
$userCouchDao = new UserCouchDao($manager);
// fetch
$result = $userCouchDao->fetch('tino');
echo '<pre>';
var_dump($result);
echo '</pre>';
// create
if ($result === FALSE) {
$userCouchDao->setId('tino')->setUsername('fightbulc')->setCreated(time())->setUpdated(time())->save();
var_dump($userCouchDao->export());
} else {
$userCouchDao->setUpdated(time())->save();
var_dump($userCouchDao->export());
}
