/** * Test different commands. */ public function testGetCommand() { // dump all databases $mysql = new MySQLDummy(array('mysql' => array('all_databases' => true, 'db_host' => 'localhost', 'db_port' => 3306, 'database' => 'dizbdd', 'db_user' => 'root', 'db_password' => 'test')), '/var/backup/'); $this->assertEquals($mysql->getCommand(), "mysqldump --host='localhost' --port='3306' --user='******' --password='******' --all-databases > /var/backup/mysql/all-databases.sql"); // dump specified database $mysql = new MySQLDummy(array('mysql' => array('all_databases' => false, 'db_host' => 'localhost', 'db_port' => 3306, 'database' => 'dizbdd', 'db_user' => 'root', 'db_password' => 'test')), '/var/backup/'); $this->assertEquals($mysql->getCommand(), "mysqldump --host='localhost' --port='3306' --user='******' --password='******' dizbdd > /var/backup/mysql/dizbdd.sql"); // dump specified database $mysql = new MySQLDummy(array('mysql' => array('all_databases' => false, 'db_host' => 'somehost', 'db_port' => 2222, 'database' => 'somebdd', 'db_user' => 'mysql', 'db_password' => 'somepwd')), '/var/backup/'); $this->assertEquals($mysql->getCommand(), "mysqldump --host='somehost' --port='2222' --user='******' --password='******' somebdd > /var/backup/mysql/somebdd.sql"); // dump specified database with no auth $mysql = new MySQLDummy(array('mysql' => array('all_databases' => false, 'db_host' => 'somehost', 'db_port' => 2222, 'database' => 'somebdd', 'db_user' => null, 'db_password' => null)), '/var/backup/'); $this->assertEquals($mysql->getCommand(), 'mysqldump somebdd > /var/backup/mysql/somebdd.sql'); // dump all databases with no auth $mysql = new MySQLDummy(array('mysql' => array('all_databases' => true, 'db_host' => 'somehost', 'db_port' => 2222, 'database' => 'somebdd', 'db_user' => null, 'db_password' => null)), '/var/backup/'); $this->assertEquals($mysql->getCommand(), 'mysqldump --all-databases > /var/backup/mysql/all-databases.sql'); }
/** * @test * @expectedException \LogicException */ public function shouldThrowExceptionIfDatabaseIsNotSpecifiedForIgnoredTableDumpingAllDatabases() { $mysql = new MySQLDummy(array('mysql' => array('all_databases' => true, 'db_host' => 'localhost', 'db_port' => 3306, 'database' => null, 'db_user' => 'root', 'db_password' => 'test', 'ignore_tables' => array('table1'))), '/var/backup/'); $mysql->getCommand(); }