/**
* Quotes a database value
* @param string $value value to quote
* @return string quoted value
* @throws zibo\library\database\exception\DatabaseException when $value is not a scalar value
*/
public function quoteValue($value)
{
parent::quoteValue($value);
if (is_bool($value)) {
return $value ? 1 : 0;
}
$valueLength = strlen($value);
if (is_numeric($value)) {
return $value;
}
if (is_null($value) || $value === self::VALUE_NULL) {
return self::VALUE_NULL;
}
if (!$this->isConnected()) {
$this->connect();
}
$quotedValue = $this->connection->escapeString($value);
if ($quotedValue === false) {
throw new DatabaseException('Could not quote ' . $value);
}
return self::QUOTE_VALUE . $quotedValue . self::QUOTE_VALUE;
}
/**
* Quotes a database identifier
* @param string $identifier
* @return string quoted identifier
* @throws zibo\library\database\exception\DatabaseException when $identifier is not a scalar value or when $identifier is empty
*/
public function quoteIdentifier($identifier)
{
parent::quoteIdentifier($identifier);
$identifier = str_replace(self::QUOTE_IDENTIFIER, self::QUOTE_IDENTIFIER . self::QUOTE_IDENTIFIER, $identifier);
return self::QUOTE_IDENTIFIER . $identifier . self::QUOTE_IDENTIFIER;
}
