protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::$mysql->query(sprintf('TRUNCATE TABLE %stask_queque', self::$mysql->option('prefix', '')));
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
Table::cleanAllStatic();
self::$mysql = \Myfox\Lib\Mysql::instance('default');
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::removeAllNames();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
}
/**
* 各个对象初始化
*
* @access public static
* @return void
*/
public static function init($ini)
{
self::setAutoLoad();
/**
* @配置文件
*/
\Myfox\Lib\Config::register('default', $ini);
$config = \Myfox\Lib\Config::instance('default');
/**
* @数据库
*/
foreach ((array) $config->get('mysql') as $name => $file) {
\Myfox\Lib\Mysql::register($name, $file);
}
/**
* @日志对象
*/
foreach ((array) $config->get('log') as $name => $url) {
\Myfox\Lib\Factory::registerLog($name, $url);
}
/**
* @告警提醒
*/
\Myfox\Lib\Alert::init(__DIR__ . '/../etc/alert.ini');
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::cleanTable('default', 'route_info');
self::cleanTable('default', 'task_queque');
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::removeAllNames();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::$mysql->query(sprintf("DELETE FROM %shost_list WHERE host_name LIKE 'unittest%%'", self::$mysql->option('prefix', '')));
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::$mysql->query(sprintf('DELETE FROM %ssettings WHERE ownname LIKE "unittest%%"', self::$mysql->option('prefix')));
Setting::$queries = 0;
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::$inifile = __DIR__ . '/ini/myfox.ini';
self::cleanTable('default', 'process_locker');
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
self::$mysql = \Myfox\Lib\Mysql::instance('default');
self::$mysql->query(sprintf("DELETE FROM %stable_list WHERE table_name = 'i am not exists'", self::$mysql->option('prefix')));
self::$mysql->query(sprintf("DELETE FROM %ssettings WHERE cfgname IN ('table_route_count', 'table_real_count')", self::$mysql->option('prefix')));
self::cleanTable('default', 'route_info');
Setting::set('last_assign_host', 0);
}
/**
* 获取数据库连接
*
* @access public
* @return object
*/
public function getlink()
{
$this->init();
$id = sprintf('__%s', $this->dbname);
try {
return \Myfox\Lib\Mysql::instance($id);
} catch (\Exception $e) {
\Myfox\Lib\Mysql::register($id, array('persist' => false, 'master' => array(sprintf('mysql://%s:%s@%s:%d', rawurlencode($this->option['write_user']), rawurlencode($this->option('write_pass')), $this->option['conn_host'], $this->option['conn_port'])), 'slave' => array(sprintf('mysql://%s:%s@%s:%d', rawurlencode($this->option['read_user']), rawurlencode($this->option('read_pass')), $this->option['conn_host'], $this->option['conn_port']))));
return \Myfox\Lib\Mysql::instance($id);
}
}
public function test_should_mysql_factory_works_fine()
{
try {
$mysql = Mysql::instance('i_am_not_exists');
$this->assertTrue(false);
} catch (\Exception $e) {
$this->assertTrue($e instanceof \Myfox\Lib\Exception);
$this->assertContains('Undefined mysql instance named as "i_am_not_exists"', $e->getMessage());
}
$mysql = new Mysql('', 'mysql3');
$this->assertEquals(Mysql::instance('MYSQl3'), $mysql);
Mysql::register('test1', array('dbname' => 'test', 'prefix' => 'myfox_'));
$mysql = Mysql::instance('test1');
$this->assertEquals('test', $mysql->option('dbname'));
$this->assertEquals('myfox_', $mysql->option('prefix'));
$this->assertEquals('utf8', $mysql->option('charset'));
}
/**
* 测试表及信息创建
*/
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::removeAllNames();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
$this->mysql = \Myfox\Lib\Mysql::instance('default');
$config = new \Myfox\Lib\Config(__DIR__ . '/ini/mysql.ini');
foreach ($config->get('master') as $host) {
$urlRes = parse_url($host);
$this->infos['host'] = $urlRes['host'];
$this->infos['port'] = array_key_exists('port', $urlRes) ? $urlRes['port'] : 3306;
$this->infos['user'] = array_key_exists('user', $urlRes) ? $urlRes['user'] : '******';
$this->infos['pass'] = array_key_exists('pass', $urlRes) ? $urlRes['pass'] : '';
}
self::cleanTable('default', 'route_info');
$this->table_bak('table_list');
$this->table_bak('host_list');
$this->table_bak('settings');
//插入测试分片表1
$this->mysql->query('CREATE TABLE `test_table_real1` (
`id` int(10) unsigned NOT NULL auto_increment,
`key1` varchar(64) NOT NULL default "",
`key2` int(10) NOT NULL default 0,
PRIMARY KEY (`id`)
)');
//插入测试分片表2
$this->mysql->query('CREATE TABLE `test_table_real2` (
`id` int(10) unsigned NOT NULL auto_increment,
`key1` varchar(64) NOT NULL default "",
`key2` int(10) NOT NULL default 0,
PRIMARY KEY (`id`)
)');
//插入测试分片表3
$this->mysql->query('CREATE TABLE `test_table_real3` (
`id` int(10) unsigned NOT NULL auto_increment,
`key1` varchar(64) NOT NULL default "",
`key2` int(10) NOT NULL default 0,
PRIMARY KEY (`id`)
)');
}
protected function setUp()
{
parent::setUp();
\Myfox\Lib\Mysql::register('default', __DIR__ . '/ini/mysql.ini');
}
