public function testDevelopSql() { $sql = "SELECT __USER__ FROM `user`"; $tags = ['__USER__' => 'user.*', '__PROFILE__' => 'profile.*']; $expected = "SELECT user.id, user.login FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, false, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT user.id AS 'user.id', user.login AS 'user.login' FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, true, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT `user`.`id` AS 'user.id', `user`.`login` AS 'user.login' FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, true, true, $tags); $this->assertEquals($expected, $result); // ------- $sql = "SELECT user.* FROM `user`"; $tags = []; $expected = "SELECT user.id, user.login FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, false, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT user.id AS 'user.id', user.login AS 'user.login' FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, true, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT `user`.`id` AS 'user.id', `user`.`login` AS 'user.login' FROM `user`"; $result = UtilMySql::developSql($sql, $this->__schema, true, true, $tags); $this->assertEquals($expected, $result); // ------- $sql = "SELECT __USER__, __PROFILE__ FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $tags = ['__USER__' => 'user.*', '__PROFILE__' => 'profile.*']; $expected = "SELECT user.id, user.login, profile.id, profile.age, profile.fk_user_id FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, false, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT user.id AS 'user.id', user.login AS 'user.login', profile.id AS 'profile.id', profile.age AS 'profile.age', profile.fk_user_id AS 'profile.fk_user_id' FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, true, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT `user`.`id` AS 'user.id', `user`.`login` AS 'user.login', `profile`.`id` AS 'profile.id', `profile`.`age` AS 'profile.age', `profile`.`fk_user_id` AS 'profile.fk_user_id' FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, true, true, $tags); $this->assertEquals($expected, $result); // ------- $sql = "SELECT user.*, profile.* FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $tags = []; $expected = "SELECT user.id, user.login, profile.id, profile.age, profile.fk_user_id FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, false, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT user.id AS 'user.id', user.login AS 'user.login', profile.id AS 'profile.id', profile.age AS 'profile.age', profile.fk_user_id AS 'profile.fk_user_id' FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, true, false, $tags); $this->assertEquals($expected, $result); $expected = "SELECT `user`.`id` AS 'user.id', `user`.`login` AS 'user.login', `profile`.`id` AS 'profile.id', `profile`.`age` AS 'profile.age', `profile`.`fk_user_id` AS 'profile.fk_user_id' FROM `user` INNER JOIN `profile` ON user.id=profile.fk_user_id"; $result = UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\Util\\UtilSql\\MySql', 'developSql', $sql, $this->__schema, true, true, $tags); $this->assertEquals($expected, $result); }
public function testProtectedStatic() { $this->assertEquals(30, UtilUnitTest::call_private_or_protected_static_method('\\dbeurive\\UtilTest\\ClassToTest', '_protectedStatic', 10)); }