While connections can be added and removed dynamically during the course of your application
(using Connections::add()), it is most typical to define all connections at once, in
config/bootstrap/connections.php.
The Connections class handles adapter classes efficiently by only loading adapter classes and
creating instances when they are requested (using Connections::get()).
Adapters are usually subclasses of lithium\data\Source.
public function skip() { $isAvailable = ( Connections::get('test', array('config' => true)) && Connections::get('test')->isConnected(array('autoConnect' => true)) ); $this->skipIf(!$isAvailable, "No test connection available"); }
/** * Check request reCAPTCHA validity * This method return `true` or `false` after validation, and set error in * helper. If `true` error is set to null, otherwise `'incorrect-captcha-sol'` * * Example: * {{{ * class YourController extends \lithium\action\Controller { * public function index() { * if ($this->request->data) { * if (!Recaptcha::check($this->request)) { * return; * } * } * } * } * }}} * @param object $request Pass request object to check method * @return boolean * @throws ConfigException * @throws RuntimeException */ public static function check(\lithium\net\http\Request $request) { $config = Libraries::get('li3_recaptcha', 'keys'); if (!$config['private']) { throw new ConfigException('To use reCAPTCHA you must get API key from' . 'https://www.google.com/recaptcha/admin/create'); } if (!$request->env('SERVER_ADDR')) { throw new RuntimeException('For security reasons, you must pass the remote ip to reCAPTCHA'); } $data = array('privatekey' => $config['private'], 'remoteip' => $request->env('SERVER_ADDR'), 'challenge' => null, 'response' => null); if ($request->data) { $data['challenge'] = $request->data['recaptcha_challenge_field']; $data['response'] = $request->data['recaptcha_response_field']; } if (!$data['challenge'] || !$data['response']) { RecaptchaHelper::$error = 'incorrect-captcha-sol'; return false; } $service = Connections::get('recaptcha'); $serviceRespond = explode("\n", $service->post('/recaptcha/api/verify', $data)); if ($serviceRespond[0] == 'true') { RecaptchaHelper::$error = null; return true; } else { RecaptchaHelper::$error = 'incorrect-captcha-sol'; return false; } }
public static function __init(array $options = array()) { parent::__init($options); $self = static::_instance(); $self->_finders['count'] = function ($self, $params, $chain) use(&$query, &$classes) { $db = Connections::get($self::meta('connection')); $records = $db->read('SELECT count(*) as count FROM posts', array('return' => 'array')); return $records[0]['count']; }; Post::applyFilter('save', function ($self, $params, $chain) { $post = $params['record']; if (!$post->id) { $post->created = date('Y-m-d H:i:s'); } else { $post->modified = date('Y-m-d H:i:s'); } $params['record'] = $post; return $chain->next($self, $params, $chain); }); Validator::add('isUniqueTitle', function ($value, $format, $options) { $conditions = array('title' => $value); // If editing the post, skip the current psot if (isset($options['values']['id'])) { $conditions[] = 'id != ' . $options['values']['id']; } // Lookup for posts with same title return !Post::find('first', array('conditions' => $conditions)); }); }
/** * Skip the test if a Sqlite adapter configuration is unavailable. * * @return void * @todo Tie into the Environment class to ensure that the test database is being used. */ public function skip() { $this->_dbConfig = Connections::get('sqlite3', array('config' => true)); $hasDb = isset($this->_dbConfig['adapter']) && $this->_dbConfig['adapter'] == 'Sqlite3'; $message = 'Test database is either unavailable, or not using a Sqlite adapter'; $this->skipIf(!$hasDb, $message); }
public function testStreamConnection() { $config = array('socket' => 'Stream', 'host' => 'localhost', 'login' => 'root', 'password' => '', 'port' => '80'); Connections::add('stream-test', 'Http', $config); $result = Connections::get('stream-test'); $this->assertTrue($result instanceof \lithium\data\source\Http); }
public function testBasicGet() { $topsy = Connections::get('test-topsy'); $headers = array('Content-Type' => 'application/json'); $results = json_decode($topsy->connection->get('authorinfo.json?url=http://twitter.com/mehlah', array(), compact('headers'))); $this->assertEqual('Mehdi Lahmam B.', $results->response->name); }
/** * Skip the test if no `test` CouchDb connection available. * * @return void */ public function skip() { $isAvailable = Connections::get('test', array('config' => true)) && Connections::get('test')->isConnected(array('autoConnect' => true)); $this->skipIf(!$isAvailable, "No test connection available"); $couchConnection = strpos(get_class(Connections::get('test')), 'CouchDb'); $this->skipIf(!$couchConnection, "Test connection is not CouchDb"); }
/** * Skip the test if no test database connection available. */ public function skip() { $dbConfig = Connections::get($this->_connection, ['config' => true]); $isAvailable = $dbConfig && Connections::get($this->_connection)->isConnected(['autoConnect' => true]); $this->skipIf(!$isAvailable, "No {$this->_connection} connection available."); $db = Connections::get($this->_connection); $this->skipIf(!$db instanceof Database, "The {$this->_connection} connection is not a relational database."); }
public function tearDown() { $connection = Connections::get('default'); $mongo = $connection->connection; foreach ($mongo->listCollections() as $collection) { $collection->drop(); } }
/** * Skip the test if a MySQL adapter configuration is unavailable. * * @return void * @todo Tie into the Environment class to ensure that the test database is being used. */ public function skip() { $this->skipIf(!MySql::enabled(), 'MySQL Extension is not loaded'); $this->_dbConfig = Connections::get('test', array('config' => true)); $hasDb = isset($this->_dbConfig['adapter']) && $this->_dbConfig['adapter'] == 'MySql'; $message = 'Test database is either unavailable, or not using a MySQL adapter'; $this->skipIf(!$hasDb, $message); }
public function skip() { $connection = $this->_connection; $this->_dbConfig = Connections::get($this->_connection, array('config' => true)); $this->skipIf(!$this->with(array('Sqlite3'))); $this->_db = new MockSqlite3($this->_dbConfig); $isConnected = $this->_db->isConnected(array('autoConnect' => true)); $this->skipIf(!$isConnected, "No {$connection} connection available."); }
/** * Tests Collection accessors (getters/setters). */ public function testAccessorMethods() { Connections::config(array('mock-source' => array('type' => 'lithium\\tests\\mocks\\data\\MockSource'))); $model = $this->_model; $model::config(array('connection' => false, 'key' => 'id')); $collection = new DocumentSet(compact('model')); $this->assertEqual($model, $collection->model()); $this->assertEqual(compact('model'), $collection->meta()); }
public function connect($connection, $options = array()) { $options += array('autoConnect' => true); $this->_dbConfig = Connections::get($connection, array('config' => true)); $db = $this->_db = Connections::get($connection); $this->skipIf(!$db, "The `{$connection}` connection is not correctly configured."); $this->skipIf(!$db::enabled(), 'Extension is not loaded.'); $this->skipIf(!$db->isConnected($options), "No `{$connection}` connection available."); }
public function testIssuesRead() { $gh = Connections::get('test-gh'); $query = new Query(array('model' => $this->_models['issues'])); $results = $gh->read($query); $expected = 'octocat'; $result = $results->first(); $this->assertEqual($expected, $result->user->login); }
public function skip() { $connection = 'lithium_mysql_test'; $this->_dbConfig = Connections::get($connection, array('config' => true)); $isAvailable = $this->_dbConfig && Connections::get($connection)->isConnected(array('autoConnect' => true)); $this->skipIf(!$isAvailable, "No {$connection} connection available."); $this->db = Connections::get($connection); $this->skipIf(!$this->db instanceof Database, "The {$connection} connection is not a relational database."); }
/** * Skip the test if a MySQL adapter configuration is unavailable. * * @return void * @todo Tie into the Environment class to ensure that the test database is being used. */ public function skip() { $message = 'MySQLi extension is not available for testing the adapter.'; $hasClass = class_exists('\\mysqli'); $this->skipIf(!$hasClass, $message); $this->_dbConfig = Connections::get('MySQLi-tests', array('config' => true)); $hasDb = isset($this->_dbConfig['adapter']) && $this->_dbConfig['adapter'] == 'MySQLi'; $message = 'Test database is either unavailable, or not using a MySQLi adapter'; $this->skipIf(!$hasDb, $message); }
public function setUp() { $this->_backup['cwd'] = getcwd(); $this->_backup['_SERVER'] = $_SERVER; $_SERVER['argv'] = array(); Libraries::add('create_test', array('path' => $this->_testPath . '/create_test')); $this->request = new Request(array('input' => fopen('php://temp', 'w+'))); $this->request->params = array('library' => 'create_test', 'action' => null); Connections::add('default', array('type' => null, 'adapter' => 'lithium\\tests\\mocks\\data\\model\\MockDatabase')); }
public function tearDown() { Connections::remove('mockconn'); MockQueryPost::reset(); MockQueryComment::reset(); MockGallery::reset(); MockImage::reset(); MockImageTag::reset(); MockTag::reset(); }
/** * Skip the test if no test database connection available. */ public function skip() { $connection = 'lithium_couch_test'; $config = Connections::get($connection, array('config' => true)); $isAvailable = $config && Connections::get($connection)->isConnected(array('autoConnect' => true)); $this->skipIf(!$isAvailable, "No {$connection} connection available."); $this->_key = Companies::key(); $this->_database = $config['database']; $this->_connection = Connections::get($connection); }
public function testConnectWithWrongPassword() { $config = $this->_dbConfig; $config['login'] = '******'; $config['password'] = '******'; $connection = 'wrong_passord'; Connections::add($connection, $config); $this->expectException('/Host connected, but could not access database/'); Connections::get($connection)->connect(); }
/** * Skip the test if a Sqlite adapter configuration is unavailable. * * @return void * @todo Tie into the Environment class to ensure that the test database is being used. */ public function skip() { $this->skipIf(!Sqlite3::enabled(), 'Sqlite3 adapter is not enabled.'); $this->_dbConfig = Connections::get('test', array('config' => true)); $hasDb = isset($this->_dbConfig['adapter']) && $this->_dbConfig['adapter'] == 'Sqlite3'; $message = 'Test database is either unavailable, or not using a Sqlite3 adapter'; $this->skipIf(!$hasDb, $message); $isMemory = $this->_dbConfig['database'] == ':memory:'; $message = "Test database is not an in-memory database."; $this->skipIf(!$isMemory, $message); }
/** * 添加数据库链接 * @param string $name 名称 * @param array $config 配置 * @param bool $overwrite 是否覆盖已有配置,默认否 * @return array */ public static function add($name, array $config = array(), $overwrite = false) { if ($overwrite) { parent::add($name, $config); } else { if (!isset(static::$_configurations[$name])) { parent::add($name, $config); } } return static::$_configurations[$name]; }
public function testConnectWithWrongPassword() { $this->skipIf(!$this->with('PostgreSql')); $config = $this->_dbConfig; $config['login'] = '******'; $config['password'] = '******'; $config['object'] = null; $connection = 'wrong_passord'; Connections::add($connection, $config); $this->expectException(); Connections::get($connection)->connect(); }
public function tearDown() { Connections::remove('mockconn'); MockDatabasePost::reset(); MockDatabaseComment::reset(); MockDatabaseTagging::reset(); MockDatabasePostRevision::reset(); MockGallery::reset(); MockImage::reset(); MockImageTag::reset(); MockTag::reset(); }
public static function __init(array $options = array()) { parent::__init($options); $self = static::_object(); # $self = static::_instance(__CLASS__); #var_dump($self); $self->_finders['count'] = function ($self, $params, $chain) use(&$query, &$classes) { $db = Connections::get($self::meta('connection')); $records = $db->read('SELECT count(*) as count FROM posts', array('return' => 'array')); return $records[0]['count']; }; }
public function tearDown() { Connections::remove('mocksource'); Connections::remove('mockconn'); MockPost::reset(); MockTag::reset(); MockComment::reset(); MockCreator::reset(); MockSubProduct::reset(); MockProduct::reset(); MockPostForValidates::reset(); }
public function connections() { $data = Connections::get(); $connections = new Collection(compact('data')); if (true || $this->request->is('json')) { $connections->each(function ($name) { $config = Connections::get($name, array('config' => true)); unset($config['object']); return array_merge(compact('name'), Set::flatten($config)); }); } return compact('connections'); }
/** * Skip the test if a MySQL adapter configuration is unavailable. * @todo Tie into the Environment class to ensure that the test database is being used. */ public function skip() { $this->skipIf(!MySql::enabled(), 'MySQL Extension is not loaded'); $this->_dbConfig = Connections::get('test', array('config' => true)); $hasDb = isset($this->_dbConfig['adapter']) && $this->_dbConfig['adapter'] == 'MySql'; $message = 'Test database is either unavailable, or not using a MySQL adapter'; $this->skipIf(!$hasDb, $message); $this->db = new MySql($this->_dbConfig); $lithium = LITHIUM_LIBRARY_PATH . '/lithium'; $sqlFile = $lithium . '/tests/mocks/data/source/database/adapter/mysql_companies.sql'; $sql = file_get_contents($sqlFile); $this->db->read($sql, array('return' => 'resource')); }
public function skip() { $this->_dbConfig = Connections::get('test', array('config' => true)); $isAvailable = $this->_dbConfig && Connections::get('test')->isConnected(array('autoConnect' => true)); $this->skipIf(!$isAvailable, "No test connection available."); $isDatabase = Connections::get('test') instanceof Database; $this->skipIf(!$isDatabase, "The 'test' connection is not a relational database."); $this->db = Connections::get('test'); $mockBase = LITHIUM_LIBRARY_PATH . '/lithium/tests/mocks/data/source/database/adapter/'; $files = array('galleries' => '_galleries.sql', 'images' => '_images.sql'); $files = array_diff_key($files, array_flip($this->db->sources())); foreach ($files as $file) { $sqlFile = $mockBase . strtolower($this->_dbConfig['adapter']) . $file; $this->skipIf(!file_exists($sqlFile), "SQL file {$sqlFile} does not exist."); $sql = file_get_contents($sqlFile); $this->db->read($sql, array('return' => 'resource')); } }
public function index() { $fh = fopen("../resources/primary.csv", "r"); $posts = $groups = 0; $connection = Connections::get('default')->connection; foreach (array('posts', 'groups', 'grants', 'grant_groups') as $collection) { $connection->{$collection}->remove(array()); } while ($data = fgetcsv($fh)) { list($tmp, $postId, $desc, $y2011, $y2010, $y2009) = $data; if (!empty($tmp)) { /** * Keep track of group name */ if (strpos($tmp, "Totalt") === false) { $group = Group::create(); list($number, $name) = explode(" - ", $tmp); $name = str_replace('"', "", trim($name)); $number = trim($number); $group->save(array('name' => $name, 'number' => $number)); $groupId = $group->_id; $groups++; } elseif ($group) { $group->y2011 = (int) ($y2011 / 1000); $group->y2010 = (int) ($y2010 / 1000); $group->y2009 = (int) ($y2009 / 1000); $group->save(); continue; } } /** * Place in previously mentioned group */ if (isset($groupId)) { $post = Post::create(); $post->save(array('post' => (double) $postId, 'desc' => trim($desc), 'y2011' => (int) ($y2011 / 1000), 'y2010' => (int) ($y2010 / 1000), 'y2009' => (int) ($y2009 / 1000), 'groupId' => $groupId)); $posts++; } } // Grants return compact('groups', 'posts') + $this->grants(); }