<?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()); }