/** * Apply modifier to single value. * @param mixed * @param string * @return string */ public function formatValue($value, $modifier) { // array processing (with or without modifier) if ($value instanceof Traversable) { $value = iterator_to_array($value); } if (is_array($value)) { $vx = $kx = array(); switch ($modifier) { case 'and': case 'or': // key=val AND key IS NULL AND ... if (empty($value)) { return '1=1'; } foreach ($value as $k => $v) { if (is_string($k)) { $pair = explode('%', $k, 2); // split into identifier & modifier $k = $this->identifiers->{$pair[0]} . ' '; if (!isset($pair[1])) { $v = $this->formatValue($v, FALSE); $vx[] = $k . ($v === 'NULL' ? 'IS ' : '= ') . $v; } elseif ($pair[1] === 'ex') { // TODO: this will be removed $vx[] = $k . $this->formatValue($v, 'ex'); } else { $v = $this->formatValue($v, $pair[1]); $vx[] = $k . ($pair[1] === 'l' || $pair[1] === 'in' ? 'IN ' : ($v === 'NULL' ? 'IS ' : '= ')) . $v; } } else { $vx[] = $this->formatValue($v, 'ex'); } } return '(' . implode(') ' . strtoupper($modifier) . ' (', $vx) . ')'; case 'n': // key, key, ... identifier names foreach ($value as $k => $v) { if (is_string($k)) { $vx[] = $this->identifiers->{$k} . (empty($v) ? '' : ' AS ' . $v); } else { $pair = explode('%', $v, 2); // split into identifier & modifier $vx[] = $this->identifiers->{$pair[0]}; } } return implode(', ', $vx); case 'a': // key=val, key=val, ... foreach ($value as $k => $v) { $pair = explode('%', $k, 2); // split into identifier & modifier $vx[] = $this->identifiers->{$pair[0]} . '=' . $this->formatValue($v, isset($pair[1]) ? $pair[1] : (is_array($v) ? 'ex' : FALSE)); } return implode(', ', $vx); case 'in': // replaces scalar %in modifier! // replaces scalar %in modifier! case 'l': // (val, val, ...) foreach ($value as $k => $v) { $pair = explode('%', $k, 2); // split into identifier & modifier $vx[] = $this->formatValue($v, isset($pair[1]) ? $pair[1] : (is_array($v) ? 'ex' : FALSE)); } return '(' . ($vx || $modifier === 'l' ? implode(', ', $vx) : 'NULL') . ')'; case 'v': // (key, key, ...) VALUES (val, val, ...) foreach ($value as $k => $v) { $pair = explode('%', $k, 2); // split into identifier & modifier $kx[] = $this->identifiers->{$pair[0]}; $vx[] = $this->formatValue($v, isset($pair[1]) ? $pair[1] : (is_array($v) ? 'ex' : FALSE)); } return '(' . implode(', ', $kx) . ') VALUES (' . implode(', ', $vx) . ')'; case 'm': // (key, key, ...) VALUES (val, val, ...), (val, val, ...), ... foreach ($value as $k => $v) { if (is_array($v)) { if (isset($proto)) { if ($proto !== array_keys($v)) { $this->hasError = TRUE; return '**Multi-insert array "' . $k . '" is different.**'; } } else { $proto = array_keys($v); } } else { $this->hasError = TRUE; return '**Unexpected type ' . gettype($v) . '**'; } $pair = explode('%', $k, 2); // split into identifier & modifier $kx[] = $this->identifiers->{$pair[0]}; foreach ($v as $k2 => $v2) { $vx[$k2][] = $this->formatValue($v2, isset($pair[1]) ? $pair[1] : (is_array($v2) ? 'ex' : FALSE)); } } foreach ($vx as $k => $v) { $vx[$k] = '(' . implode(', ', $v) . ')'; } return '(' . implode(', ', $kx) . ') VALUES ' . implode(', ', $vx); case 'by': // key ASC, key DESC foreach ($value as $k => $v) { if (is_array($v)) { $vx[] = $this->formatValue($v, 'ex'); } elseif (is_string($k)) { $v = is_string($v) && strncasecmp($v, 'd', 1) || $v > 0 ? 'ASC' : 'DESC'; $vx[] = $this->identifiers->{$k} . ' ' . $v; } else { $vx[] = $this->identifiers->{$v}; } } return implode(', ', $vx); case 'ex': case 'sql': $translator = new self($this->driver); return $translator->translate($value); default: // value, value, value - all with the same modifier foreach ($value as $v) { $vx[] = $this->formatValue($v, $modifier); } return implode(', ', $vx); } } // with modifier procession if ($modifier) { if ($value !== NULL && !is_scalar($value) && !$value instanceof DateTime) { // array is already processed $this->hasError = TRUE; return '**Unexpected type ' . gettype($value) . '**'; } switch ($modifier) { case 's': // string // string case 'bin': // binary // binary case 'b': // boolean return $value === NULL ? 'NULL' : $this->driver->escape($value, $modifier); case 'sN': // string or NULL // string or NULL case 'sn': return $value == '' ? 'NULL' : $this->driver->escape($value, dibi::TEXT); // notice two equal signs // notice two equal signs case 'iN': // signed int or NULL // signed int or NULL case 'in': // deprecated if ($value == '') { $value = NULL; } // intentionally break omitted // intentionally break omitted case 'i': // signed int // signed int case 'u': // unsigned int, ignored // support for long numbers - keep them unchanged if (is_string($value) && preg_match('#[+-]?\\d++(e\\d+)?$#A', $value)) { return $value; } else { return $value === NULL ? 'NULL' : (string) (int) ($value + 0); } case 'f': // float // support for extreme numbers - keep them unchanged if (is_string($value) && is_numeric($value) && strpos($value, 'x') === FALSE) { return $value; // something like -9E-005 is accepted by SQL, HEX values are not } else { return $value === NULL ? 'NULL' : rtrim(rtrim(number_format($value + 0, 5, '.', ''), '0'), '.'); } case 'd': // date // date case 't': // datetime if ($value === NULL) { return 'NULL'; } else { if (is_numeric($value)) { $value = (int) $value; // timestamp } elseif (is_string($value)) { $value = new DateTime($value); } return $this->driver->escape($value, $modifier); } case 'by': case 'n': // identifier name return $this->identifiers->{$value}; case 'ex': case 'sql': // preserve as dibi-SQL (TODO: leave only %ex) $value = (string) $value; // speed-up - is regexp required? $toSkip = strcspn($value, '`[\'":'); if (strlen($value) !== $toSkip) { $value = substr($value, 0, $toSkip) . preg_replace_callback('/(?=[`[\'":])(?:`(.+?)`|\\[(.+?)\\]|(\')((?:\'\'|[^\'])*)\'|(")((?:""|[^"])*)"|(\'|")|:(\\S*?:)([a-zA-Z0-9._]?))/s', array($this, 'cb'), substr($value, $toSkip)); if (preg_last_error()) { throw new DibiPcreException(); } } return $value; case 'SQL': // preserve as real SQL (TODO: rename to %sql) return (string) $value; case 'like~': // LIKE string% return $this->driver->escapeLike($value, 1); case '~like': // LIKE %string return $this->driver->escapeLike($value, -1); case '~like~': // LIKE %string% return $this->driver->escapeLike($value, 0); case 'and': case 'or': case 'a': case 'l': case 'v': $this->hasError = TRUE; return '**Unexpected type ' . gettype($value) . '**'; default: $this->hasError = TRUE; return "**Unknown or invalid modifier %{$modifier}**"; } } // without modifier procession if (is_string($value)) { return $this->driver->escape($value, dibi::TEXT); } elseif (is_int($value)) { return (string) $value; } elseif (is_float($value)) { return rtrim(rtrim(number_format($value, 5, '.', ''), '0'), '.'); } elseif (is_bool($value)) { return $this->driver->escape($value, dibi::BOOL); } elseif ($value === NULL) { return 'NULL'; } elseif ($value instanceof DateTime) { return $this->driver->escape($value, dibi::DATETIME); } else { $this->hasError = TRUE; return '**Unexpected ' . gettype($value) . '**'; } }