/** * Returns the fragment SQL string * * @param rdbms.DBConnection conn * @return string * @throws rdbms.SQLStateException */ public function asSql(\rdbms\DBConnection $conn) { $s = ''; foreach ($this->projections as $e) { $s .= 0 != strlen($e['alias']) ? $conn->prepare(', %c as %l', $e['projection']->asSql($conn), $e['alias']) : $conn->prepare(', %c', $e['projection']->asSql($conn)); } return substr($s, 1); }
/** * Returns the fragment SQL * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @return string * @throws rdbms.SQLStateException */ public function asSql(\rdbms\DBConnection $conn, \rdbms\Peer $peer) { return $conn->prepare('not (%c)', $this->criterion->asSql($conn, $peer)); }
/** * get the SELECT query * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @param rdbms.join.Joinprocessor jp optional * @return rdbms.ResultSet */ public function getSelectQueryString(DBConnection $conn, Peer $peer, $jp = null) { if ($this->isJoin()) { $jp->setFetchmodes($this->fetchmode); } return $conn->prepare('select %c from %c %c', $this->projections($conn, $peer, $jp), $this->isJoin() ? $jp->getJoinString() : $peer->table, $this->toSQL($conn, $peer, $jp)); }
/** * Returns the fragment SQL * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @return string * @throws rdbms.SQLStateException */ public function asSql(DBConnection $conn) { return $conn->prepare($this->command, $this->field); }
/** * Returns the fragment SQL * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @return string */ public function asSql(DBConnection $conn, Peer $peer) { $lhs = $this->lhs instanceof SQLFragment ? $this->lhs : $peer->column($this->lhs); return $conn->prepare('%c ' . str_replace('?', $lhs->getType(), $this->op), $lhs, $this->value); }
/** * Returns the fragment SQL * * @param rdbms.DBConnection conn * @param rdbms.Peer peer * @return string * @throws rdbms.SQLStateException */ public function asSql(\rdbms\DBConnection $conn, \rdbms\Peer $peer) { $lhs = $this->lhs instanceof \rdbms\SQLFragment ? $this->lhs : $peer->column($this->lhs); return $conn->prepare('%c between ' . $lhs->getType() . ' and ' . $lhs->getType(), $lhs, $this->lo, $this->hi); }