public function formatAction($action, $suffix)
{
if ($this->isDefaultAction($action)) {
return is_null($suffix) ? RouterParameter::DEFAULT_ACTION_METHOD : RouterParameter::DEFAULT_ACTION_NAME_URL . $suffix;
}
return lcfirst(StringUtils::camelize($action)) . $suffix;
}
public function formatController($controller)
{
$className = null;
if (is_null($controller) || $this->isDefaultController($controller)) {
$className = ucfirst(RouterParameter::DEFAULT_CONTROLLER_NAME_URL) . RouterParameter::DEFAULT_CONTROLLER_CLASS_SUFFIX;
} else {
$className = StringUtils::camelize($controller) . RouterParameter::DEFAULT_CONTROLLER_CLASS_SUFFIX;
}
return $className;
}
public function formatLocale($locale)
{
$result = null;
if ($this->isDefaultLocale($locale)) {
$result = RouterParameter::DEFAULT_LOCALE_NAME_URL;
} else {
$result = StringUtils::dehyphenize($locale);
}
return $result;
}
public function testShouldCreateSqlInsertStatementWithParameters()
{
$table = "test";
$value = StringUtils::generateRandomAlphaNumeric(10);
$insert = new InsertStatement($table);
$insert->addParameter('content', $value);
$sql = $insert->toSql();
$this->assertThat(trim($sql), $this->equalTo("INSERT INTO {$table} (content) VALUES (:content)"));
$this->assertThat($insert->hasParameters(), $this->isTrue());
$parameters = $insert->getParameters();
$this->assertThat(array_pop($parameters), $this->equalTo($value));
}
public function testShouldCreateSqlUpdateStatementWithParameters()
{
$table = "test";
$value = StringUtils::generateRandomAlphaNumeric(10);
$update = new UpdateStatement($table);
$update->addParameter("content", $value);
$update->where(Restrictions::eq("id", ':id'));
$update->addParameter(":id", 1001, true);
$sql = $update->toSql();
$this->assertThat(trim($sql), $this->equalTo("UPDATE {$table} SET content=:content WHERE (id = :id)"));
$this->assertThat($update->hasParameters(), $this->isTrue());
$parameters = $update->getParameters();
$this->assertThat(array_shift($parameters), $this->equalTo($value));
$this->assertThat(array_pop($parameters), $this->equalTo(1001));
}
public function build()
{
$query = [$this->select, $this->from, $this->where, $this->group, $this->having, $this->order, $this->limit];
$result = implode(' ', $query);
return StringUtils::removeExtraWhitespace($result);
}
public static function classToTable($classname)
{
$className = is_object($classname) ? get_class($classname) : $classname;
return StringUtils::underscorize(self::getClassSimpleName($className));
}
public function isSqlite()
{
return StringUtils::equals($this->read(ConnectionParameters::DATABASE_DRIVER), DriverType::SQLITE);
}
public function isDelete()
{
return StringUtils::equals($this->getRequestMethod(), RequestType::DELETE);
}
protected function isViewModeXml()
{
return StringUtils::equals($this->viewMode, View::VIEW_MODE_XML);
}
public function hasRoleId($roleId)
{
return StringUtils::equals($this->roleId, $roleId);
}
public function findRuleByRoleAndResource($roleId, $resourceId)
{
foreach ($this->getRules() as $rule) {
$hasRole = StringUtils::equals($rule->getRole()->getRoleId(), $roleId);
$hasResource = StringUtils::equals($rule->getResource()->getResourceId(), $resourceId);
if ($hasRole && $hasResource) {
return $rule;
}
}
return null;
}
