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');
}
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();
$config = new Config(__DIR__ . '/ini/mysql_test.ini');
$logurl = parse_url($config->get('logurl', ''));
$this->logfile = $logurl['path'];
Mysql::removeAllNames();
self::$mysql = new Mysql(__DIR__ . '/ini/mysql.ini');
self::$mysql->query('DROP TABLE IF EXISTS only_for_test');
self::$mysql->query('CREATE TABLE `only_for_test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8');
@unlink($this->logfile);
}
/**
* 测试表及信息创建
*/
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`)
)');
}