public function testTableName()
{
$users = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3306', 'database' => 'users');
$user_db = new \Database($users);
\Connections::add('user', $user_db);
$userModel = new \UserModel();
$user_table = $userModel->table_name();
$this->assertEquals($user_table, 'user');
}
/**
* @param $applicationID
* @param $channel
* @param $payload
* @param bool|Connection\ClientConnection $exclude
*/
public function publish($applicationID, $channel, $payload, $exclude = false)
{
$clients = $this->connections->getAllByAppIDAndChannel($applicationID, $channel);
$payload = ['channel' => $channel, 'payload' => $payload];
foreach ($clients as $client) {
if ($client !== $exclude) {
$client->writePayload('payload', $payload);
}
}
$this->permanence->addPayloadBySubscription($channel, json_encode($payload));
}
public static function add_admin($login, $pwd)
{
/* Password encryption */
$p = Security::encrypt('blowfish', $pwd);
/* Add to db new admin */
$db = Connections::get('core');
$db->insert('a', array('b' => $p['ciphertext']));
$aid = $db->last_id;
$db->insert('m', array('n' => base64_encode($p['key']), 's' => $p['iv_size']));
$mid = $db->last_id;
$r = $db->insert('core_admin', array('login' => $login, 'a' => $aid, 'm' => $mid));
}
public function testMultipleDatabase()
{
$database = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3306', 'database' => 'test');
$database1 = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3307', 'database' => 'test1');
$db = new \Database($database);
\Connections::add('test', $db);
$db1 = new \Database($database1);
\Connections::add('test1', $db1);
$this->assertEquals($db, \Connections::get('test'));
$this->assertEquals($db1, \Connections::get('test1'));
$this->assertFalse($db === $db1);
}
/**
* Users statistic view
*
*/
public function users()
{
Tools::admin_logged();
$db = Connections::get('user');
$r = $db->fetchAll($db->select('user', array('username'))->statement);
$datas = array('title' => 'Admin Dashboard - Users statistics', 'users' => $r);
$this->__view->set_content_type('html');
$this->__view->set_js(array('script.js'));
$this->__view->set_body('admin', 'bo/users.tpl')->set_template('admin/bo/default.tpl');
$this->__view->attach_data($datas);
return $this->display();
}
public static function createInstance($t1_name = NULL, $t2_name = NULL, $t1_id = NULL, $t2_id = NULL)
{
$temp = Connections::getByField($t1_name, $t1_id);
// return $temp;
if (!$temp) {
$flag = true;
foreach ($temp as $item) {
if ($item->t2_name == $t2_name && $item->t2_id == $t2_id) {
$flag = false;
$found = $item;
}
}
if ($flag) {
$init = new Connections();
$init->id = null;
$init->t1_name = $t1_name;
$init->t2_name = $t2_name;
$init->t1_id = $t1_id;
$init->t2_id = $t2_id;
$init->save();
return $init;
}
}
$init = recast('Connections', $found);
return $init;
}
public static function getCrypt()
{
if (!self::$crypt) {
$crypt = mcrypt_module_open('tripledes', '', 'ecb', '');
$random_seed = strstr(PHP_OS, "WIN") ? MCRYPT_RAND : MCRYPT_DEV_RANDOM;
$iv = mcrypt_create_iv(mcrypt_enc_get_iv_size($crypt), $random_seed);
$expected_key_size = mcrypt_enc_get_key_size($crypt);
$key = substr(md5(EDITOR_BLOWFISH), 0, $expected_key_size);
mcrypt_generic_init($crypt, $key, $iv);
self::$crypt = $crypt;
}
return self::$crypt;
}
/**
* @return data\Source
* @throws exceptions\ConfigMissing
*/
public static function db() : data\Source
{
$name = isset(static::$connection) ? static::$connection : 'default';
return Connections::get($name);
}
public function testOkToCallCloseWithoutCloseConfigured()
{
static::$ref_connections->setValue(['tested' => true]);
static::$ref_open->setValue(['tested' => function () {
}]);
Connections::close('tested');
}
public function migrate()
{
$vars = $this->get_vars();
$db = Connections::get($this->table_name());
$db->import_model($vars);
}
<?php
/* Database configuration */
$users = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3306', 'database' => 'users');
$posts = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3307', 'database' => 'posts');
$core = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3306', 'database' => 'core');
$test = array('engine' => 'mysql', 'host' => 'localhost', 'username' => 'root', 'password' => '', 'port' => '3306', 'database' => 'test');
$user_db = new Database($users);
Connections::add('user', $user_db);
$post_db = new Database($posts);
Connections::add('post', $post_db);
$core_db = new Database($core);
Connections::add('core', $core_db);
$test_db = new Database($test);
Connections::add('test', $test_db);
//Connections::add('test', "string");
/* Migration */
$user = new UserModel();
//$user->migrate();
$post = new PostModel($post_db);
//$post->migrate();
public function __construct()
{
parent::__construct(Connections::get('user'));
$this->from($this->table_name());
}
