/**
* 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);
}
