public function testQualifyFieldsNames() { // Without database name $this->assertCount(0, array_diff(['user.id'], UtilMySql::qualifyFieldsNames(['id'], 'user'))); $this->assertCount(0, array_diff(['user.id', 'user.login'], UtilMySql::qualifyFieldsNames(['id', 'login'], 'user'))); $this->assertCount(0, array_diff(['user.id', 'user.login'], UtilMySql::qualifyFieldsNames(['user.id', 'login'], 'user'))); $this->assertCount(0, array_diff(['db.user.id', 'user.login'], UtilMySql::qualifyFieldsNames(['db.user.id', 'login'], 'user'))); // With database name $this->assertCount(0, array_diff(['prod.user.id'], UtilMySql::qualifyFieldsNames(['id'], 'user', 'prod'))); $this->assertCount(0, array_diff(['prod.user.id', 'prod.user.login'], UtilMySql::qualifyFieldsNames(['id', 'login'], 'user', 'prod'))); $this->assertCount(0, array_diff(['prod.user.id', 'prod.user.login'], UtilMySql::qualifyFieldsNames(['user.id', 'login'], 'user', 'prod'))); $this->assertCount(0, array_diff(['prod.user.id', 'prod.user.login'], UtilMySql::qualifyFieldsNames(['prod.user.id', 'login'], 'user', 'prod'))); }
/** * Create the SQL request from the request's template. * @return string The method returns a string that represents the SQL request. */ private function __sql() { return UtilMySql::developSql($this->__sql, $this->getDatabaseSchema(), true, true); }
/** * Create the SQL request from the request's template. * @return string The method returns a string that represents the SQL request. */ private function __sql() { $sql = UtilMySql::developSql($this->__sql, $this->getDatabaseSchema(), true, true); return str_replace('__V__', OutputValues::OUTPUT_VALUE_IS_AUTHENTICATED, $sql); }