/** * Gets ID for specified sequence name. * * @param ConnectionInterface $con * @param string $name * * @return integer */ public function getId(ConnectionInterface $con, $name = null) { if (null === $name) { throw new InvalidArgumentException("Unable to fetch next sequence ID without sequence name."); } $dataFetcher = $con->query(sprintf('SELECT nextval(%s)', $con->quote($name))); return $dataFetcher->fetchColumn(); }
/** * Gets ID for specified sequence name. * * @param ConnectionInterface $con * @param string $name * * @return integer */ public function getId(ConnectionInterface $con, $name = null) { if ($name === null) { throw new InvalidArgumentException("Unable to fetch next sequence ID without sequence name."); } $stmt = $con->query("SELECT nextval(" . $con->quote($name) . ")"); $row = $stmt->fetch(PDO::FETCH_NUM); return $row[0]; }
/** * Quotes a string for use in a query. * * Places quotes around the input string (if required) and escapes special * characters within the input string, using a quoting style appropriate to * the underlying driver. * * @param string $string The string to be quoted. * @param int $parameter_type Provides a data type hint for drivers that * have alternate quoting styles. * * @return string A quoted string that is theoretically safe to pass into an * SQL statement. Returns FALSE if the driver does not support * quoting in this way. */ public function quote($string, $parameter_type = 2) { return $this->connection->quote($string, $parameter_type); }